https://bugs.freedesktop.org/show_bug.cgi?id=34412
--- Comment #28 from mike.h...@onepoyle.net --- I've analysed what is going on in more detail. Here are some simple steps to take to show what a mess we have here: 1 Create 4 lines of data and 4 new styles with different background colours 2 save as .ods 3 close 4 open 5 create conditional formatting separately on A1 and B1 with formulas like left(b1)=”s” - four conditions 6 Save, close 7 open - The 4 new styles remain – everything is still working ok 8 save as .xlsx (XML 2007) - The 4 new styles remain – formulas remain correct 9 close 10 open New styles have gone. There are 8 generated ones. Conditional formatting is garbage 11 replace step 8 by save as .xlsx (XML 2003) Gives error message that conditional formatting can’t be saved 12 replace step 8 by save as .xlsx (LO XML) The 4 new dtyles remain – formulas remain correct 13 close 14 open New styles have gone. There are 8 generated ones. Conditional formatting is garbage – all formulas refer to B1 15 replace step 8 by save as .xls (97/2000/XP/2003/) The 4 new styles remain – formulas remain correct 16 close This shouldn’t work. .xls does not support more than 3 conditions per cell 17 open New styles remain. There are 32 generated styles (4 tests x 8 cells). Conditional formatting retained, using the new styles NB If you create conditional formatting on A1:B1 using formulas like LEFT($B1)=”s” the result of copy and special paste of formats gives garbage values for the tests Will add the .ods spreadsheet so above can be tested -- 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