https://bugs.freedesktop.org/show_bug.cgi?id=56382
Priority: medium Bug ID: 56382 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Conditional formatting gets lost when opened with LibreOffice. Works with OpenOffice though. Severity: normal Classification: Unclassified OS: Windows (All) Reporter: sponks...@web.de Hardware: x86-64 (AMD64) Status: UNCONFIRMED Version: 3.6.2.2 release Component: Spreadsheet Product: LibreOffice Created attachment 69051 --> https://bugs.freedesktop.org/attachment.cgi?id=69051&action=edit Conditional formatting gets lost when opened. Works with OpenOffice though. A spreadsheet created with LibreOffice 3.6.2.2 loses conditional formatting when re-opened. In the attached (test) file, most cells seem to be affected. In the file I originally found this bug, conditional formatting is only lost in more recent cells (starting at row 699 with made me think the number of conditionally formatted cells might be limited). When I copy the formatting of other cells it works as it should, but only until the file is opened the next time. The problem seems to occur while loading the file, because it is saved correctly - I found the correct formatting in content.xml and if opened in OpenOffice (3.2.0) it works as well. The test file contains one column with random numbers and conditional formatting for three different colors which I repeated for several hundred rows. Then I saved the file and could reproduce the error. If the file is saved again after opening it in LibreOffice (without restoring the formatting manually), conditional formatting is removed completely - also when viewed with OpenOffice. Another test revealed that this bug occurs even with just 15 cells in the speadsheet. Now I realized that the only cell still working was A3 which is the one I manually set the format in the first place and then replicated it by dragging the black corner up and down. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs