Issue 19110

Summary:

Excel generated graphs don't convert correctly

Product:

Calc

Reporter:

jcouillard <jcouillard>

Component:

code

Assignee:

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 1.1 RC3

Target Milestone:

---

Hardware:

OS:

Windows 2000

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Spreadsheet with Excel generated Graphs	none

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