[Libreoffice-bugs] [Bug 112783] New: PIVOT CHARTS: Save produces invalid file because of invalid cell address

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 112783
           Summary: PIVOT CHARTS: Save produces invalid file because of
                    invalid cell address
           Product: LibreOffice
           Version: 6.0.0.0.alpha0+ Master
          Hardware: x86 (IA32)
               URL: http://docs.oasis-open.org/office/v1.2/os/OpenDocument
                    -v1.2-os-schema.rng
                OS: Windows (All)
            Status: UNCONFIRMED
          Keywords: filter:odf
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rb.henschel at t-online.de
            Blocks: 107060, 108198

Created attachment 136653
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136653&action=edit
sheet with pivot table and pivot chart

The current solution writes e.g table:cell-range-address="PivotChart" or
"chart:label-cell-address="PT at label 0" or
chart:values-cell-range-address="PT at data 0". But those are not valid, because
they do not fullfil the regex in the schema OpenDocument-v1.2-os-schema.rng

<define name="cellRangeAddress">
                <choice>
                        <data type="string">
                                <param name="pattern">($?([^\.
']+|'([^']|'')+'))?\.$?[A-Z]+$?[0-9]+(:($?([^\.
']+|'([^']|'')+'))?\.$?[A-Z]+$?[0-9]+)?</param>
                        </data>
                        <data type="string">
                                <param name="pattern">($?([^\.
']+|'([^']|'')+'))?\.$?[0-9]+:($?([^\. ']+|'([^']|'')+'))?\.$?[0-9]+</param>
                        </data>
                        <data type="string">
                                <param name="pattern">($?([^\.
']+|'([^']|'')+'))?\.$?[A-Z]+:($?([^\. ']+|'([^']|'')+'))?\.$?[A-Z]+</param>
                        </data>
                </choice>
        </define>

The validator at http://odf-validator.rhcloud.com/ will not find the error,
because it only checks "string" but not the pattern.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107060
[Bug 107060] [META] Pivot chart issues
https://bugs.documentfoundation.org/show_bug.cgi?id=108198
[Bug 108198] [META] ODF export is unsuitable or invalid XML
-- 
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/20170930/c7cc2692/attachment-0001.html>