Issue 37916

Summary: Chart seems blank on import from excel
Product: General Reporter: sforbes <xslf>
Component: chartAssignee: kla <thomas.klarhoefer>
Status: CLOSED DUPLICATE QA Contact: issues@graphics <issues>
Severity: Trivial    
Priority: P3 CC: alan, issues
Version: 3.3.0 or older (OOo)Keywords: ms_interoperability, oooqa
Target Milestone: ---   
Hardware: All   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
problem file none

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