Bug 112785 - svg:desc not suitable for a table cell identifier
Summary: svg:desc not suitable for a table cell identifier
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
3.5.1 release
Hardware: x86 (IA32) All
: lowest enhancement
Assignee: Not Assigned
Depends on:
Blocks: ODF-spec
  Show dependency treegraph
Reported: 2017-09-30 18:13 UTC by Regina Henschel
Modified: 2017-11-02 17:24 UTC (History)
0 users

See Also:
Crash report or crash signature:
Regression By:

sheet with pivot table and pivot chart (18.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-09-30 18:13 UTC, Regina Henschel

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2017-09-30 18:13:23 UTC
Created attachment 136654 [details]
sheet with pivot table and pivot chart

The current solution of pivot charts uses e.g the structure
<table:table-cell office:value-type="float" office:value="NaN">
        <svg:desc>PT@data 0</svg:desc>

to define an identifier for the cell, that will be used in a cell reference.

This structure gives no formal error, but I will surely not support the idea of miss-using a description of a graphical element as identifier for a table-cell.

There exists more suitable solutions.
Currently possible is
attribute xml:id
as part of the entire table the element
<table:named-expressions> with its child element <table:named-range>.

This problem should be solved together with bug 112783.
Comment 1 Regina Henschel 2017-09-30 18:25:00 UTC
I see, that problem has come in earlier and is not specific for pivot charts.
Comment 2 Regina Henschel 2017-10-01 21:04:12 UTC
It is already there in LO 3.5.1, but not in AOO 4.1.2. It is not clear, why it was introduced. LibreOffice can handle the chart without having that elements.
Comment 3 Buovjaga 2017-11-02 17:24:03 UTC
Setting to NEW