Issue 19110 - Excel generated graphs don't convert correctly
Summary: Excel generated graphs don't convert correctly
Status: CLOSED DUPLICATE of issue 15435
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-05 12:37 UTC by jcouillard
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
Spreadsheet with Excel generated Graphs (42.50 KB, application/octet-stream)
2003-09-05 12:39 UTC, jcouillard 		no flags Details
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 jcouillard 2003-09-05 12:37:43 UTC 
Spreadsheet with data and graphs created using MS Excel XP (probably true with
all versions of Excel) do not display the graphs correctly when opened in the
OpenOffice spreadsheet.  I'll attach a sample.
Comment 1 jcouillard 2003-09-05 12:39:44 UTC 
Created attachment 9029 [details]
Spreadsheet with Excel generated Graphs
Comment 2 john.marmion 2003-09-05 16:55:51 UTC 
This looks like a duplicate of issue 15435. The chart will appear if
the  values and label not only have an equal amount of cells but are
also rectangular. Thus the workaround until this is fixed would be to
use different columns for different years i.e. year 2000 $B$3-$B$14;
year 2001 $C$3-$C$14 etc. The other problems associated with this
document is that data series name and the x-axis are not correct. The
workaround for the data series names is to use a cell content rather
than a hard-coded string value. I am still looking at a workaround for
the x-axis interval names. But I will close this. I should add that
new chart module should fix these issues:

http://graphics.openoffice.org/chart/chart.html
http://graphics.openoffice.org/chart/featurewishes.html



*** This issue has been marked as a duplicate of 15435 ***
Comment 3 john.marmion 2003-09-08 08:48:54 UTC 
mark closed