https://bugs.documentfoundation.org/show_bug.cgi?id=104392
Bug ID: 104392
Summary: Data Range menu item isn't shown due to a corrupted
ods file
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 129301
--> https://bugs.documentfoundation.org/attachment.cgi?id=129301&action=edit
The attached file contains the corrupted ods file, for which the data range
menu item disappeared
For any strange reason the content of a chart diagram got lost resp. corrupted.
I entered a new datarange to an existing diagram.
After saving and opening the calc sheet again, the diagram was corrupted.
The new curve (data range 'jahr2011') that I added to the diagram was not
available.
I unzipped the calc file ('Test_corrupt.ods') and found the corrupted location
The lost entry is in 'Object 2/content.xml'. There is an empty string in
chart:values-cell-range-address of data range 'jahr2011'
<chart:series chart:style-name="ch11"
chart:values-cell-range-address=" " loext:label-string="jahr2011"
chart:class="chart:line">
<chart:data-point chart:repeated="12"/>
</chart:series>
Unfortunately this leads to loosing the menu item of Chart Wizard - Data Range.
Instead the menu item Chart Wizard - Data Table is shown.
So I can't fix the corrupted data range in LibreOffice Calc.
When I add the correct data range string into content.xml, save the file, zip
it and open the modified file everything works again.
This is the corrected part of content.xml
<chart:series chart:style-name="ch11"
chart:values-cell-range-address="Sheet1.D32:Sheet1.D32 Sheet1.D61:Sheet1.D61
Sheet1.D92:Sheet1.D92 Sheet1.D122:Sheet1.D122 Sheet1.D153:Sheet1.D153
Sheet1.D183:Sheet1.D183 Sheet1.D214:Sheet1.D214 Sheet1.D245:Sheet1.D245
Sheet1.D275:Sheet1.D275 Sheet1.D306:Sheet1.D306 Sheet1.D336:Sheet1.D336
Sheet1.D367:Sheet1.D367" loext:label-string="jahr2011"
chart:class="chart:line">
<chart:data-point chart:repeated="12"/>
</chart:series>
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
