https://bugs.freedesktop.org/show_bug.cgi?id=65371
--- Comment #2 from [email protected] --- Ok, here are the steps to reproduce this. Go to Calc -> Format -> Conditional Formatting -> Manage 1. Add -> Cell value is -> less than -> 84.5 2. Apply Style -> New Style 3. Organizer Tab -> Name -> Format1 4. Numbers Tab -> Category -> Number, Format -> -1,234 (with zero decimal places, Format Code #,##0) 5. Font Effects Tab ->Font Color -> Light Red -> OK 6. Add -> Condition 2 -> Cell value is -> greater than -> 115.5 7. Apply Style -> Format1 8. Range -> A1:A10 -> Click OK in Conditional Formatting Box, then Click OK in Manage Conditional Formatting Box Highlight Column A and center it Go to cell A1 and type in 123.123 Go to cell A2 and type in 123.1234 Go to cell A3 and type in 123 Go to cell A4 and type in 13.123 Go to cell A5 and type in 13 You will see that all the numbers display without decimal places, just like they should, even though they read with the correct decimals in the formula bar. Now save as "test sheet" in .xls format. Close the sheet. Reopen the sheet and you will see that the decimals places are now showing in Column A. Go to Format -> Conditional Formatting -> Manage Highlight Range A1:A10 -> Click Edit Under Condition 1, where it says "Apply Style", the style is no longer "Format 1", it now says "Excel_CondFormat_1_1_1" (which was never an option before) Under Condition 2, the Apply Style has changed to "Excel_CondFormat_1_1_2" Hit the drop down arrow and change the Apply Style back to "Format1" for both Condition 1 and Condition 2, then hit OK twice. The decimals in column A are now gone, as they should be. This time, save as "test sheet" in .ods format. Close the sheet. Reopen the .ods sheet and you will see that the formatting is correct and the "Apply Style" saves as "Format1", as it should. So, it seems that conditional formatting is saved correctly when saved as .ods but not when saved as .xls -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
