https://bugs.freedesktop.org/show_bug.cgi?id=59346
--- Comment #7 from [email protected] --- (In reply to comment #6) > Created attachment 74983 [details] > Conditional Formatting - Colour Styles > > @Marcus > Retested with 4.0.0.3. > > Believe there are still 3 issues with OOXML > > Save attachment as OOXML, close and reopen (in LO) > 1) formula in column C does not re-calculate on reopen (bug 60215) > 2) after recalculation, the T() part works differently (text of style is > incorrectly appended to the end of column C) (??new bug) > 3) the conditional colour background styles in columns A & B no longer work > (this bug) After some more delving re these comments: Issue 2) results from the STYLE() function being silently deleted from the formula in column C. The reason for the deletion is evidently that STYLE() has no equivalent function in Excel. Suggest that when this occurs, as a minimum the user should be informed with a warning message about what has been dropped and why. Issue 3) The reason conditional colour background styles aren't working correctly in attachment 74983 is because of the way LO copies and pastes conditional formats. This is leading to inconsistencies in the resulting formulas. If the conditional formatting formulas do not have any inconsistencies, the conditional formatting does indeed transfer to Excel 2007 correctly. I need to do some more work to tie this down more exactly, and it might overlap with another bug. -- 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
