https://bugs.documentfoundation.org/show_bug.cgi?id=128038
NISZ LibreOffice Team <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|NEW |RESOLVED
--- Comment #4 from NISZ LibreOffice Team <[email protected]> ---
(In reply to stdedos from comment #3)
> I don't completely understand how this bug works, so, I am sorry if my
> description is lacking
>
> On your sample file:
>
> * Remove the '_1' from the name of the style
> * You may validate that the Conditional Style reference name is updated
> * Save, Close, Re-open
> * There will be now 2 styles (one with '_1', one without)
> * You may validate that the Conditional Style reference name is updated to
> the '_1'
This happens because of the different concepts of storing conditional
formatting in ODS and XLSX files.
Calc uses styles to define conditional formatting settings and stores the used
condition+style in ODS files.
Excel on the other hand sets a bunch of direct cell formatting settings and
stores those along the condition.
This is why on opening an XLSX file Calc autogenerates a ConditionalStyle_N
style, to bridge these differences.
If you change the name of this, that's saved as a new cell style but on the
next opening Calc autogenerates another set of ConditionalStyle_N styles
because of the conditional formatting.
Inconvenient as it is, this is not a bug but a difference in file formats and
different applications internal workings. What you see should be the same
regardless.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
