https://bugs.freedesktop.org/show_bug.cgi?id=59346
--- Comment #2 from Markus Mohrhard <[email protected]> --- (In reply to comment #0) > Created attachment 72994 [details] > 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 Will not be implemented! There is already the general warning about lost information when saving to xls and xlsx! The number of error/warning messages that we would need to implement for different features is just too large. > 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. Not with some rework and I will not spend unnecessary time in the xls import/export filter. > > .ods Opens in Excel 2007, but conditional formatting is lost. Not sure > whether that could be fixed at the LO end No! Excel 2007 does not support OpenFormula! 2010 does not support it either. They started supporting it with 2013. > > 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 I will not look into that format either. > > OO XML 'Save as' from .ods. Close. Reopen. Conditional formatting is lost > (ie does not round trip within LO) - bug OOXML and 2007/2010 Excel XML are the same for us. Only Excel 2007 can't handle OOXML files! You can try with the new startsWith format in LibO 4 that is equivalent to the corresponding OOXML format. It is saved in an ODF extension and should export to OOXML fine. > > 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. As mentioned I will only care about the problems with ODF and OOXML. -- 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
