Issue 37916 - Chart seems blank on import from excel
Summary: Chart seems blank on import from excel
Status: CLOSED DUPLICATE of issue 3997
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords: ms_interoperability, oooqa
Depends on:
Blocks:
 
Reported: 2004-11-25 21:42 UTC by sforbes
Modified: 2013-02-24 21:19 UTC (History)
2 users (show)

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

Attachments
problem file (16.50 KB, application/vnd.ms-excel)
2004-11-25 21:43 UTC, sforbes 		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 sforbes 2004-11-25 21:42:49 UTC 
in the attached excel file, in sheet #2, there seems to be a chart with text
labels- the chart incorrectly appears blank.
Comment 1 sforbes 2004-11-25 21:43:31 UTC 
Created attachment 19704 [details]
problem file
Comment 2 frank 2004-11-26 08:03:41 UTC 
Wrong component, I've changed this.

Frank
Comment 3 john.marmion 2004-12-20 16:13:45 UTC 
The problem here is that the chart uses the the data source range $A1:$C3. The
values are stored in Column C and the data label names are stored in Columns B
and A. Excel is capable of supporting chart data label names in more than 1 cell
i.e. A1:B1 while Calc currently only supports one cell. The simple workaround
would be to combine each chart label name in one cell i.e. column B and thus use
a data source range $B1:$C3 until this feature is available in Calc. The other
difference 
is that Calc draws the pie segments in the opposite direction see issue 37823
Comment 4 kla 2004-12-21 10:02:23 UTC 
kla->John: thx
it´s an duplicate

*** This issue has been marked as a duplicate of 3997 ***
Comment 5 kla 2004-12-21 10:02:43 UTC 
closed as duplicate