You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/05/31 11:55:56 UTC
[Bug 119639] New: the chart display incorrectly after save as ods
from xls in AOO3.4
https://issues.apache.org/ooo/show_bug.cgi?id=119639
Priority: P3
Bug ID: 119639
Assignee: ooo-issues@incubator.apache.org
Summary: the chart display incorrectly after save as ods from
xls in AOO3.4
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: bjdujing@gmail.com
Hardware: PC
Status: UNCONFIRMED
Version: AOO340
Component: save-export
Product: spreadsheet
Created attachment 77865
--> https://issues.apache.org/ooo/attachment.cgi?id=77865&action=edit
sample file
build info:AOO3.4_1327774
Steps:
1.open the file in AOO3.4
2.save the file as ods format,and reopen the new file
defect:
the chart display incorrectly.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119639] the chart display incorrectly after save as ods from
xls in AOO3.4
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119639
Li Feng Wang <ph...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |phoenix.wanglf@gmail.com
Ever confirmed|0 |1
--- Comment #1 from Li Feng Wang <ph...@gmail.com> ---
can reproduce on AOO3.4 r1327774
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119639] the chart display incorrectly after save as ods from
xls in AOO3.4
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119639
--- Comment #3 from Clarence GUO <cl...@gmail.com> ---
The chart in the sample is not a standard chart but a composite chart.
Series 1, 2 and 4 are percent stacked columns which were applied to the main Y
axis, while series 3 is normal column which was applied to the secondary Y
axis. So series 3 will cover some part of Series 1, 2 and 4.
MS Office supports such chart. It can set one or more data series to another
chart type. AOO's UI cannot do this. But the chart kernal function supports. So
when open the sample file the chart looks OK. However, the ODF format doesn't
support this, that why after save the sample to ods and reopen, the chart
becomes incorrect(Series 3 occupy 100% space of the percent stacked column).
The reason is AOO defined a style 'ch4' and applied to <chart:plot-area>. In
this style, the chart:percentage attribute was set to true. This attribute
specifies a percentage accumulation of values per category. Because this style
was applied to <chart:plot-area>, then all data series are regarded as percent
columns. And series 3 is a unique data series which applied to the secondary Y
axis. So it occpy the total 100% space so that other data series are all
covered.
If want to fix this defect, must move chart:percentage attribute from the style
which applied to <chart:plot-area> to the style which applied to
<chart:series>. However, for this attribute, ODF 1.2 says "This attribute is
evaluated for chart styles that are applied to a <chart:plot-area> element.".
So my requirement is conflict with the ODF standard.
Then how can I fix this defect? It seems the only way is to change the standard
and change the corresponding filter code. But I know change the standard is not
easy...
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119639] the chart display incorrectly after save as ods from
xls in AOO3.4
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119639
Clarence GUO <cl...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |clarence.guo.bj@gmail.com
--- Comment #2 from Clarence GUO <cl...@gmail.com> ---
Seems the chart isn't a standard chart type but comes from Excel chart
template.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119639] the chart display incorrectly after save as ods from
xls in AOO3.4
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119639
jsc@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |120823
--
You are receiving this mail because:
You are the assignee for the bug.