Apache OpenOffice (AOO) Bugzilla – Issue 49803
Graph Conversion of Excel Spreadsheet does not work properly
Last modified: 2013-02-24 21:18:38 UTC
When opening an excel spreadsheet containing graphs, the graph horizontal axis labels are not converted properly. For example, in one graph, the horizotal axis is labeled from 1 to 24 (hours of day) in Excel, but when opened in Calc, it shows the word "Row" in each and begins with 2 instead of 1. The graph is a bar graph, with two bars at each data point, each with a different color. In Excel, the Legend shows "Node 1" and "Node 2" by the respective colors while in Calc, it shows "Column H" and "Column S". I would attach a copy of the Excel spread sheet, but don't see a way to attach it to the case. I'm using OO 2.0 beta, release 1.9.104.
Created attachment 26511 [details] Multi-tab Excel spreadsheet containing graphs.
moving to component spreadsheet...
and finally to Chart
Sounds as an duplicate to 3997 *** This issue has been marked as a duplicate of 3997 ***
closed as duplicate