Issue 60556

Summary:

Excel Import: legend not correctly set

Product:

General

Reporter:

joolsr <julian.robbins>

Component:

chart

Assignee:

daniel.rentz

Status:

CLOSED DUPLICATE

QA Contact:

issues@graphics <issues>

Severity:

Trivial

Priority:

CC:

issues, lars_o_hansen

Version:

3.3.0 or older (OOo)

Keywords:

oooqa

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Test file to show where the legend gets lost on Chart on import to OO from Excel2000 file	none

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

double->closed