https://bugs.documentfoundation.org/show_bug.cgi?id=151638
Bug ID: 151638
Summary: Conditional format not persistent after move
Product: LibreOffice
Version: 7.4.2.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Steps to Reproduce:
Define a colour scale conditional format on continuous cells. For example, put
numbers from 1 to 20 in the first column, then format the column.
Then reorganise your data by moving some cells, rows or columns of them within
the conditional area: press Alt and drag them with the mouse.
Extra steps if you want to test more:
Cancel the move.
Also define a formula based conditional format on other cells and do the same
actions.
Actual Results:
The colours are not preserved in the whole range, as the original data is still
there.
Check the conditional format management: your range is now broken in two
pieces.
Extra steps if you want to test more:
If you cancelled the move, your cells are back at the original place and with
the original colour (the latter is only temporary until you close the file).
But check the conditional format management: your range is still broken in two,
sometimes even in a third piece.
If you defined a formula based conditional format, all these actions will have
no effect on the conditional range.
Expected Results:
Like with formula based conditional format, keep the colour scale range compact
and don’t break it into smaller and smaller pieces, every time you reorganise
the data.
Reproducible: Always
User Profile Reset: No
Additional Info: A test file seems useless to add; it can be created if you
follow the steps.
--
You are receiving this mail because:
You are the assignee for the bug.
