Issue 60556 - Excel Import: legend not correctly set
Summary: Excel Import: legend not correctly set
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 All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: daniel.rentz
QA Contact: issues@graphics
Keywords: oooqa
Depends on:
Reported: 2006-01-15 01:22 UTC by joolsr
Modified: 2013-02-24 21:21 UTC (History)
2 users (show)

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

Test file to show where the legend gets lost on Chart on import to OO from Excel2000 file (90.50 KB, application/
2006-01-15 01:23 UTC, joolsr
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description joolsr 2006-01-15 01:22:08 UTC
In MS excel the attached spreadsheet shows the same Legend Entry on both graphs.
On OO2.0.1. back to 1.1 series, only the first chart shows the legend correctly.
The second graph just refers to Column D and Column E instead.

To maintain better compatibility the chart should also derive the legend label
for the second graph.
This has been confirmed on both Linux and Windows ports.
Comment 1 joolsr 2006-01-15 01:23:48 UTC
Created attachment 33224 [details]
Test file to show where the legend gets lost on Chart on import to OO from Excel2000 file
Comment 2 joolsr 2006-01-15 01:28:27 UTC
We wish to migrate 30 pc's with Excel to OO2. We have approx 1000 XLS files that
have the above problem. It is the one last bug that stops perfect reading of
these files in OpenOffice2.

I hope that we can resolve thsi one quickly. I apologise that I cannot actually
specify the specific cause of the error. But it is always consistant ..
Comment 3 lars 2006-01-15 17:57:29 UTC
confirmed on Windows XP Pro SP2 with OOo 2.0.1; additionally the legends aren't 
displayed at the same position as in Excel and the doument modified flag is 
being set upon opening.
Comment 4 kla 2006-01-30 09:49:05 UTC
Something went wrong with the legend after import.
Comment 5 daniel.rentz 2006-01-31 15:55:27 UTC
second chart uses a complex source range, that is currently not supported. While 
the data is in columns D and E, the series titles (shown in the legend) come from 
columns B and C. In the first chart, both the series title and the values are in the 
same column.

Workaround: Change series titles in the second chart to cell D2 and E2.

Will be fixed in the new chart implementation (currently targeted to OOo 3.0) 
together with correct placement of the legends.

*** This issue has been marked as a duplicate of 3997 ***
Comment 6 daniel.rentz 2006-01-31 15:55:53 UTC