Apache OpenOffice (AOO) Bugzilla – Issue 83679
Excel X-Y chart with default labels displayed as Row 1, Row 2, Row 3, ....
Last modified: 2013-02-24 21:20:07 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.
Created attachment 49675 [details] propsed patch (SRC680_m236)
Created attachment 49676 [details] sample document
Created attachment 49677 [details] Excel screenshot
Created attachment 49678 [details] Calc screenshot (SRC680_m236 build)
Created attachment 49679 [details] Calc screenshot with the patch
setting interop keyword.
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 ? :-)
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.
Setting target.
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.
change owner
@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.
Created attachment 55180 [details] corrected patch
Fixed in CWS late30bf01.
@Thomas, please verify in CWS late30bf01.
verified
Seen ok in current master -> closed