[Libreoffice-bugs] [Bug 139167] New: FILESAVE XLSX Extended conditional styles are saved but should not

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139167
           Summary: FILESAVE XLSX Extended conditional styles are saved
                    but should not
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisected, bisected, filter:xlsx, regression
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nagy.tibor2 at nisz.hu, nemeth at numbertext.org
            Blocks: 113782

Created attachment 168423
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168423&action=edit
attachment #152829 saved by Calc

This is a continuation of bug #122102 

Now Calc started to import a few more condition types, and generates temporary
cell styles for them named ExtConditionalStyle_N. This did not happen before
that fix, as a quick bibisect shows on the 7.2 repo.

Unlike ConditionalStyle_N styles these get written to XLSX format as cell
styles, then upon reopening in Calc a new set of “ExtConditionalStyle_N N”
styles gets generated, which are again written to the file upon a next save,
making the custom cell styles list grow by each save-reload.

Steps to reproduce:
    1. Open attachment #152829 
    2. Save as XLSX, reload

Actual results:
Styles sidebar shows 8 ExtConditionalStyle_N styles, of which 4 has the format
“ExtConditionalStyle_N 1”

Expected results:
Styles sidebar shows 4 ExtConditionalStyle_N styles

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64)
Build ID: e57665ea6f812aff9fc87073ce947f40a8b26e9d
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=113782
[Bug 113782] [META] XLSX (OOXML) conditional formatting bug tracker
-- 
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/20201222/4b5f0d25/attachment.htm>