[Libreoffice-bugs] [Bug 139021] New: FILESAVE XLSX Conditional formatting of “Cell value“ type and condition “contains” or “does not contain” does not get saved

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Dec 18 07:26:12 UTC 2020


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

            Bug ID: 139021
           Summary: FILESAVE XLSX Conditional formatting of “Cell value“
                    type and condition “contains” or “does not contain”
                    does not get saved
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          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 168276
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168276&action=edit
attachment #152829 saved with current master

This is a continuation of bug #122102
Now Calc can import conditions of “contains” or “does not contain” but we still
can not save them to XLSX format.

Steps to reproduce:
    1. Open attachment #152829
    2. Notice the cells are colored in A2:C4
    3. Save as XLSX, reload

Actual results:
Cells are only colored in C2:C4.  Excel reports broken file when opened.

Expected results:
Conditions exported correctly.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64)
Build ID: e97a81e94511b52987a50b7bdb72c922899da588
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; 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/20201218/1c5909cf/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list