Issue 119280 - X-axis labels in charts turn into "0"
Summary: X-axis labels in charts turn into "0"
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: regression
Depends on:
Reported: 2012-04-24 12:11 UTC by Andrea Pescetti
Modified: 2013-02-24 21:19 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Names are not displayed under the chart (21.45 KB, application/vnd.oasis.opendocument.text)
2012-04-24 12:11 UTC, Andrea Pescetti
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Andrea Pescetti 2012-04-24 12:11:26 UTC
Created attachment 77489 [details]
Names are not displayed under the chart

In some circumstances, labels on the X-axis in charts turn into "0" and the original string is not displayed properly; the string, however, seems to be written correctly to the file, since other programs import it correctly.

Oddly enough, we were able to reproduce it only when the chart is based on a table formatted in a non-default way.

To reproduce:

1) Open the file I'll shortly attach or create a new document in Writer, a table with AutoFormat (we tried with the "Brown" preset), fill it with numbers and use the first column as labels for the X-axis.

2) Save, close and reopen.

3) Look at the X-axis labels.

Expected result: labels are preserved (in the sample file, one should see "Busto Arsizio", Gallarate"... under the chart).

Actual results: upon reloading, labels are lost and replaced by "0".

[Found by Giorgio Gentili during Italian QA tests]
Comment 1 Regina Henschel 2012-04-25 00:10:48 UTC
The error has been introduced with DEV300m99. In DEV300m98 the x-axis labels are correct.
Comment 2 Regina Henschel 2012-04-25 21:36:10 UTC
The document is inconsistent. It has stored e.g.
<table:table-cell table:style-name="Tabella1.A1" office:value-type="float" office:value="0"><text:p text:style-name="P1">Abitanti</text:p>

That means type and value are set the a number format, but the paragraph content in the cell is a text. This could be generated, if the Number Recognition is turned off. You get the correct display, if the document is changed, so that the first column really has text format. You can see the wrong format in the preview in the number format dialog.

But there seem something more needed. When I generate such buggy document with OOo3.2.1 the display is not wrong.