[Libreoffice-bugs] [Bug 124788] Libre Calc is losing conditional formatting every day

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124788

Gabor Kelemen <kelemeng at ubuntu.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #5 from Gabor Kelemen <kelemeng at ubuntu.com> ---
(In reply to Oliver Brinzing from comment #3)
> steps to reproduce with attached file:
> 
> - Menu Format/Conditional/Manage...
> - select Z4:Z71
> - set Condition1: style "Good"
> - set Condition2: style "Bad"
> - save & reload
> - Menu Format/Conditional/Manage...
> - select Z4:Z71
> -> Condition1 changed: ConditionalStyle_3
> -> Condition2 changed: ConditionalStyle_4

This is not a bug, but a feature. Or: conceptual difference.

Calc uses styles to conditionally format cells. Excel on the other hand uses
direct cell formatting.

On opening an XLSX file Calc takes the direct formatting of conditions and
converts it to ConditionalStyle_N styles.
And on saving it writes these implicit styles content as direct formatting to
XLSX.

So it is normal to see the style "Good" becoming "ConditionalStyle_3" - but
that's only the name: the font color and background color is retained and works
fine after opening in Excel too.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190717/750c4e5e/attachment.html>