[Libreoffice-bugs] [Bug 128462] New: FILESAVE incorrect value for conditionalformatting srqef?

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128462
           Summary: FILESAVE incorrect value for conditionalformatting
                    srqef?
           Product: LibreOffice
           Version: 5.2.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mark.dufour at gmail.com

for a certain private document, libreoffice saves the following
conditionalformatting:

<conditionalFormatting sqref="I42,G42:G50">

but unfortunately this is rejected by the openpyxl library as being invalid:

https://bitbucket.org/openpyxl/openpyxl/issues/1358/conditionalformatting-issue-libreoffice

I personally can't find any documentation about what the exact format should
be, or what the above value indicates precisely.

the problem goes away when loading and saving the file again, but it would
still be nice to know if this can still occur and that both projects agree on
what is valid.. ^^

-- 
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/20191029/8b642497/attachment.html>