Bug 57486

Summary:	FORMATTING When moving cells inside conditional formatting range, CF rules breaks apart
Product:	LibreOffice	Reporter:	Mirosław Zalewski <miniopl>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WONTFIX	QA Contact:
Severity:	normal
Priority:	medium	CC:	jounijarvis
Version:	3.6.0.0.alpha1
Hardware:	Other
OS:	All
Whiteboard:
i915 platform:		i915 features:
Attachments:	Test document - one CF range splits apart after moving data

Description Mirosław Zalewski 2012-11-24 15:41:14 UTC

Created attachment 70523 [details]
Test document - one CF range splits apart after moving data

Hi

In attached document, there is conditional formatting applied to cells A1:B17.
Steps to reproduce:
1. Select cells A9:B17
2. Cut them (Ctrl+X)
3. Place cursor in cell A8
4. Paste (Ctrl+V)
5. Go to Format → Conditional formatting → Manage...

You will see that there are two conditional formatting ranges: A1:B7 and A8:B16. Since conditional formatting rules are the same in both cases, this could (and should) be just A1:B16.

If user now decide to modify CF rule, he must modify it in two places instead of just one.

Of course this is simplified case of this bug. On larger datasets a moment of moving data back and forth can create dozens ranges of the same CF rules.

This problem exists since introduction of modified CF dialogs in 3.6.0 and I can still reproduce it in 3.6.4-rc1.

Comment 1 Markus Mohrhard 2012-11-24 16:49:06 UTC

This will not be fixed.


Copying conditional formats will create new conditional formats to prevent increasing the range in case they are not overlapping.
This is important for conditional formats that are not only based on the current cell value but calculate based on the cond format range.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.