Apache OpenOffice (AOO) Bugzilla – Issue 4140
Excel chart import: wrong axis color
Last modified: 2013-08-07 15:14:13 UTC
Plot in excell spreadsheets almost always come out totally wrong. Often they come out with no plot points at all. I have attached two MS excell spreadsheets. Try opening them with OO.
Created attachment 1416 [details] example bad graph
Created attachment 1417 [details] bad graph example 2
Sample 1: This kind of combined chart is not supported in the old chart implementation - > waiting for new chart module (see http://graphics.openoffice.org/chart/chart.html). Sample 2: Import filter sets cell range for X axis wrong -> accepted.
.
accepted
target->OOo2.0
raise prio to 3
according to the announcement on releases (http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7503) this issue will be re-targeted to OOo Later.
no, it's planned for 2.0 restored target..
target, finally...
Because of limited resource for OOo2.0, it was decided to shift this tasks to the next milestone. If somebody will be found, who can implement this until OOo2.0, then this tasks will be re-targeted.
When will the famous new chart engine come true?
New chart now planned for OOo 3.0. Setting target (again...)
target
new analysis: File "Book1.xls": * sheet "Chart1": - this is a pivot chart, feature is not available in OOo Calc, see issue 14506. * sheets "HIST2", "HIST3", "HIST4": - series title "Frequency" is a string constant, not supported by OOo, see issue 16241. Workaround is to link the series title to cell B1. - axis color is gray: wrong handling of automatic axis line style, will be fixed. - X axis labels not rotated automatically, see issue 71698. File "Tag2a_fgvar_stat.xls": * all sheets: - axis color is gray: wrong handling of automatic axis line style, will be fixed. * sheets "CHIP#25_tun_bake" ... "CHIP#30_tun_rt": - "Series1" refers to text cells for X values. Excel falls back to automatic numbers 1, 2, 3, ..., but OOo drops this data series, see issue 71686. - manual legend position not supported, see issue 30851. - automatic names of series different in Excel ("Series1", "Series2", ...) and OOo ("Column I", "Column J", ...), see issue 83679. * sheets "CHIP#31_inj_rt" ... "CHIP#37_inj_bake": - some or all series refer to text cells for X values, see above. * sheet "Chart1": - chart sheet converted to chart object on data sheet, see issue 5736. - font sizes wrong (titles, axis labels), will be fixed. - no white background for entire chart object, will be fixed. So, 3 problems remain to be fixed with this issue: 1) Both files, several sheets, axis color is gray: wrong handling of automatic axis line style 2) File "Tag2a_fgvar_stat.xls", sheet "Chart1", font sizes wrong (titles, axis labels) 3) File "Tag2a_fgvar_stat.xls", sheet "Chart1", no white background for entire chart object
1) fixed 2) seems to be some automatism for chart sheets, Excel recalculates font sizes depending on saved vs. current window size, nothing to fix. 3) original chart is transparent too, looks white because it is a chart sheet. Nothing to fix here, it will work correctly when OOo supports chart sheets (issue 5736).
back to QA
verified in internal version cws_dr58
found integrated on master OOHm5 using Linux, Solaris and Windows builds