[Libreoffice-bugs] [Bug 128038] FILESAVE MSExcel 2007-365 conditional format selected style is lost after closing and reopening on libreoffice-6.3.2.2-snap1

[bugzilla-daemon at bugs.documentfoundation.org]

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

NISZ LibreOffice Team <libreoffice at nisz.hu> changed:

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

--- Comment #4 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201218/912e35e4/attachment.htm>