Bug 56687

Summary:	Sometimes Calc lose all conditional formatting rules
Product:	LibreOffice	Reporter:	vimot2
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal
Priority:	medium
Version:	3.6.2.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	One sheet workbook derived from the original workbook

Description vimot2 2012-11-02 17:35:56 UTC

On a multiple-sheet spreadsheet, after upgrading from Ubuntu 12.04 to Ubuntu 12.10, Calc lose conditional formatting rules. (I do not know if it was upgraded Libreoffice too). Now, sometimes Calc has a strange behaviour: applying conditional formatting to a range of cells, say the character color red for negative numbers, green for positive ones and black for zero values, after some opening of the file, the numbers in the cells remain green despite the value and all the three conditional formatting rule disappear.

Comment 1 Markus Mohrhard 2012-11-04 17:18:04 UTC

Can you please attach a test document that shows this problem?

Comment 2 vimot2 2012-11-04 19:10:01 UTC

Created attachment 69528 [details]
One sheet workbook derived from the original workbook

When I received your request for a sample document, I opened the original file that, this time, did not show the issue. But when I copied the sheet with conditional formatting in a blank file (the attached one) the conditional formatting get lost. If you look at the column "AM" you see green numbers (both negative and positive). Opening the conditional- formatting from menu, there are no more conditions.

The original conditions were: green color if number is postive or equal to 0, red color if negative.
(Note: the cells contain formulas but only in the last few rows, because periodically I copy the formula results as pure number to save space)

Comment 3 Markus Mohrhard 2012-11-11 07:26:41 UTC

I need the original file to see what is going wrong. The attached file does not contain any conditional formats any more. I checked with Excel and the file only contains hard formatting.

Comment 4 Markus Mohrhard 2012-11-14 11:15:38 UTC

After direct contact with bug reporter all issues are hopefully already fixed in 3.6.4