[Libreoffice-bugs] [Bug 95295] Calc is fragmenting ranges for conditional formats without need.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=95295

--- Comment #21 from Wolfgang Jäger <jag at psilosoph.de> ---
May I assume that the patch not aimed at minimizing the number of subranges
used to represent the resulting SheetCellRanges for an edited CF?  

An example to clarify what I mean: 
I made a CF for D9:G22.
I copied E12:E18.
I pasted this to the range starting at F20. 

I got the SheetCellRanges D9:G19;D20:E22;G20:G22;F20:F26 [A](4 ranges). 

I might have expected: D9:G22;F23:F26 [B](2 ranges).

Is there a clear concept in what way to describe a connected selection
requiring more than one range to describe it? 

===
Selecting all the celle (in time as [B]describes gives:
D9:E22;F9:E26;G9:G22 [C] (3 ranges).
Changing the order of selection does not change the representation.  
===

Coming from experiences with CurrentSelection and with queryContentCells /
queryEmptyCells I assumed a scheme making the results unambiguous and thus
easily comparable. Using different schemes in different cases may induce new
issues if comparisons are once needed. 

Isn't it feasible to analyze and represent a union created by CF editing in the
same way as the query methods do (type [C]?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180615/09ee86e6/attachment.html>