Issue 83679 - Excel X-Y chart with default labels displayed as Row 1, Row 2, Row 3, ....
Summary: Excel X-Y chart with default labels displayed as Row 1, Row 2, Row 3, ....
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords: ms_interoperability
Depends on:
Blocks:
 
Reported: 2007-11-15 21:18 UTC by kyoshida
Modified: 2013-02-24 21:20 UTC (History)
2 users (show)

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

Attachments
propsed patch (SRC680_m236) (910 bytes, patch)
2007-11-15 21:19 UTC, kyoshida 		no flags Details | Diff
sample document (15.00 KB, application/vnd.ms-excel)
2007-11-15 21:25 UTC, kyoshida 		no flags Details
Excel screenshot (26.55 KB, image/png)
2007-11-15 21:26 UTC, kyoshida 		no flags Details
Calc screenshot (SRC680_m236 build) (23.89 KB, image/png)
2007-11-15 21:27 UTC, kyoshida 		no flags Details
Calc screenshot with the patch (30.85 KB, image/png)
2007-11-15 21:27 UTC, kyoshida 		no flags Details
corrected patch (2.67 KB, patch)
2008-07-17 11:46 UTC, IngridvdM 		no flags Details | Diff
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description kyoshida 2007-11-15 21:18:46 UTC 
When importing an Excel document that contains a X-Y chart with default X labels
(i.e. labels are not explicitly defined), Calc imports it as Row 1, Row 2, Row
3, ..., instead of 1, 2, 3, 4, ...  For compatibility with Excel, it is better
to adopt the simple 1, 2, 3, 4, default labeling.
Comment 1 kyoshida 2007-11-15 21:19:32 UTC 
Created attachment 49675 [details]
propsed patch (SRC680_m236)
Comment 2 kyoshida 2007-11-15 21:25:41 UTC 
Created attachment 49676 [details]
sample document
Comment 3 kyoshida 2007-11-15 21:26:24 UTC 
Created attachment 49677 [details]
Excel screenshot
Comment 4 kyoshida 2007-11-15 21:27:05 UTC 
Created attachment 49678 [details]
Calc screenshot (SRC680_m236 build)
Comment 5 kyoshida 2007-11-15 21:27:29 UTC 
Created attachment 49679 [details]
Calc screenshot with the patch
Comment 6 kyoshida 2007-11-15 21:28:29 UTC 
setting interop keyword.
Comment 7 mmeeks 2007-11-16 10:14:51 UTC 
Of course, the problems of having a translated string that can markedly differ
in size between different languages, and alter the layout of the chart implied
in the file format are highly unfortunate anyway IMHO :-) "it looks fine in
en_US", "it looks horrible in de_DE", "in br_PT it looks ok!" etc. etc. :-)

I'd love to see the default changed here; any chance Bjorn ? :-)
Comment 8 bjoern.milcke 2007-12-04 14:28:02 UTC 
There are two places where localized strings are used: 1. for categories and 2.
for series name. 1. is the less problematic part, as the x-axis is able to clip
overlapping labels, however to change from "Row 1", "Row 2", ... or "Column 1",
"Column 2", ... simply to 1, 2, ... makes sense and we should consider this change.

2. is more problematic, as naming the series just 1, 2, ... is not really an
option. Excel uses "Series 1", "Series 2", ... I don't know what happens when
you load such an Excel file with a different locale. There are two options to
avoid changing strings in the UI in this situation: A. store a locale at the
legend, so that the auto-generated labels depend on that one only, or B. store
the labels as fixed strings instead of localized auto-generated ones.
Comment 9 bjoern.milcke 2007-12-04 14:28:38 UTC 
Setting target.
Comment 10 daniel.rentz 2007-12-19 11:56:12 UTC 
DR->BM: You wrote: "Excel uses "Series 1", "Series 2", ... I don't know what
happens when you load such an Excel file with a different locale."
Excel always shows the labels in the current UI language, menas, a German Excel
always shows "Reihe x" in such a case.
Comment 11 IngridvdM 2008-07-03 11:39:33 UTC 
change owner
Comment 12 IngridvdM 2008-07-17 11:45:56 UTC 
@Kohei, your patch has two problems. First it does not work for data from rows
but only for data from columns. And second it changes generated series names
from 'Row X' to 'X'. I will attach a patch that fixes both bugs.
Series names then are not affected by this change and generated categories are
simple indices like within excel.
Comment 13 IngridvdM 2008-07-17 11:46:53 UTC 
Created attachment 55180 [details]
corrected patch
Comment 14 IngridvdM 2008-07-17 15:17:57 UTC 
Fixed in CWS late30bf01.
Comment 15 IngridvdM 2008-07-17 16:04:56 UTC 
@Thomas, please verify in CWS late30bf01.
Comment 16 kla 2008-07-18 11:56:59 UTC 
verified
Comment 17 kla 2008-08-27 12:28:30 UTC 
Seen ok in current master -> closed