https://bugs.freedesktop.org/show_bug.cgi?id=57955
mike.h...@onepoyle.net changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
CC| |mike.h...@onepoyle.net
--- Comment #4 from mike.h...@onepoyle.net ---
Can confirm that conditional formatting is broken when opening in Excel.
Have observed this over various versions of LO for at least 12 months. It
remains broken in LO 4.0.0 beta.
My additional example is for setting the colour of a cell depending on cell
content (eg use the first character of a cell to apply formats with the
required background colour set). Set the conditional format on the first cell
in a column and then paste special the format only to the remainder of cells in
the column with data.
The conditional formatting works fine if you only work with LO, but choose to
work with Excel formats.
.xls format supports only up to three rules. If you try to save from Excel to
this format with more than 3 rules, you get a warning. LO should also issue a
warning on saving to this format when a conditional format has more than 3
rules. However that's not the main issue and the errors below apply to .xls
97/2000/XP/2003 format also.
When saved to .xlsx and opened in Excel, the addresses of the cells being
tested are incorrect, in my example all addressing a single cell. LO has also
generated addresses like sheet1!$B$2 in rules which Excel doesn't accept if you
try to edit a rule, even if the addresses point to the same sheet.
If you set up conditional formatting in Excel (ie background colour depends on
cell content) and save to .xlsx, this works fine when opened in LO. However if
you then save the file and reopen in Excel without making any changes to the
formatting, it is again broken when opening in Excel as above.
This is thus a significant incompatibility between LO and MSO where the two
applications do not agree on how to store conditional formatting rules. Since
LO recognises correctly what MSO sets, it seems likely that LO is not saving
the rules correctly. There may also be restrictions because MSO doesn't accept
sheet1!cell references in rules, ie the functionality of LO may exceed that
of MSO. Again, a warning would be nice, but it would be good if the saving of
rules avoided the sheet1!cell reference method when that isn't necessary,
which it shouldn't be when the rules refer only to cells on the current sheet
(all mine did).
--
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
