https://bugs.documentfoundation.org/show_bug.cgi?id=151880
Bug ID: 151880
Summary: CALC inserting new rows into conditional formatted
column creates orphan and non-contiguous cell
references
Product: LibreOffice
Version: 7.4.2.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: that.man.co...@gmail.com
Description:
In an auto-sorted array, where a column has a conditional format of 3 colours,
orphan and non-contiguous array references appear in the format manager when
additional rows are inserted into the array. The formatting is correct but the
manager will show an orphan entry for the inserted cell(s) and the portions of
the array which precede and follow the insert point will have two references
excluding the orphan. Notably, the second portion will appear first followed by
the first portion. Fortunately, the manager will permit the removal of the
orphan and overwriting the non-contiguous references with a single contiguous
reference. Many inserts will result in numerous orphans and "snippets" which do
make a "joined up" chain.
Steps to Reproduce:
1. Create a column with drag-filled dates and then make that an auto-filtered
column
2. Conditionally format the array with three colours - it's fine to accept the
defaults
3. Insert a row about midway and copy paste a cell from another location. It
makes sense to copy a date firly well removed from the insert point
4. Bibisect the array a couple of times and repeat step 3
5. Observe that the FORMAT>CONDITIONAL>MANAGE facility will now list all the
inserted cells as orphans together with a number of small ranges matching the
number of inserts
6. Delete the orphans and edit one contiguous range
7. It doesn't crash anymore but it would be nice if you could fix it for me -
Yesterday ;)
Actual Results:
The impact upon the colour rendition functions normally but following any
number of inserts the process of assessing the range and implementing the
colour rendition must take magnituides of processor cycles to assess "what is
the range requiring this conditional format"
Expected Results:
One contiguous list in the Conditional Format Manager
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.6.2 (x64) / LibreOffice Community
Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
And 7.4.2.3 on one of my other boxes which was specifically installed to test a
related bug on the latest release.
--
You are receiving this mail because:
You are the assignee for the bug.
