https://bugs.freedesktop.org/show_bug.cgi?id=59346
Priority: medium
Bug ID: 59346
CC: markus.mohrh...@googlemail.com
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FILESAVE: FILEOPEN: Certain conditional formatting is
broken
Severity: normal
Classification: Unclassified
OS: All
Reporter: mike.h...@onepoyle.net
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.1 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 72994
--> https://bugs.freedesktop.org/attachment.cgi?id=72994&action=edit
Background colour conditional formatting spreadsheet
Conditional formatting setting colour background does not work fully for any
file format.
@Marcus
As follow up of bug 57955 I have retested with 4.0.0RC1 and with Excel 2007. In
my tests nothing works fully in any file format. Here is the new report and as
requested I have copied you.
Summary:
.xls Round trips correctly in LO, but a large number of new styles are created
Opens with a warning in Excel 2007, conditional formatting works, rules
beyond the 3rd lost on save from Excel
Save to .xlsx from Excel - conditional formatting continues to work
Issues:
A warning when saving to .xls with more than three rules would be nice, even
though it works
In any reasonably sized sheet (ours was 500 rows), the multiple styles created
by saving to .xls (5 rules x 500 rows x 2 cells = 5000 styles) the resulting
object is very difficult to use because opening and saving (including auto
save) takes a very long time. Is it possible to create fewer styles.
.ods Opens in Excel 2007, but conditional formatting is lost. Not sure whether
that could be fixed at the LO end
2007/2010 XML 'Save as' from .ods. Close. Reopen. Conditional formatting is
lost (ie does not round trip within LO) - bug
2003 XML Cannot save from .ods - ?? bug
OO XML 'Save as' from .ods. Close. Reopen. Conditional formatting is lost (ie
does not round trip within LO) - bug
Attachment has the conditional formats giving the trouble, with some more
details. If you prefer separate bug reports for any of the above, please let me
know and I can do that. Worth perhaps saying that I've been struggling with
this issue for more than 12 months attempting to find a solution for moving
between LO and Excel. Nothing works except redoing the conditional formatting
every time.
--
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
