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
