Bug 42798 - FORMATTING: Excel2003 charts/error bars not formatted properly in LibreOffice 3.4.3
Summary: FORMATTING: Excel2003 charts/error bars not formatted properly in LibreOffice...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
3.5.1 RC1
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-10 12:52 UTC by smaybo
Modified: 2014-03-27 22:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
ZIp contains example spreadsheet from Excel2003 and screenshots of comparisons of openign the file in Excel vs LibreOffice (395.16 KB, application/x-zip-compressed)
2011-11-10 12:52 UTC, smaybo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description smaybo 2011-11-10 12:52:22 UTC 
Created attachment 53382 [details]
ZIp contains example spreadsheet from Excel2003 and screenshots of comparisons of openign the file in Excel vs LibreOffice

Problem description: Excel2003 spreadsheets with charts and error bars are not properly formatted when opened in LibreOffice 3.4.3

Steps to reproduce:
1. Open the XLS in the attached zip (chart problem 2.xls)
2. See the error bars, y axis and legend titles
3. View the PDF in the attached zip to see Excel vs LO

Current behavior:

The issues on the LibreOffice image are circled in red in the PDF contained in the attached zip and are..

1. the error bars are NOT there at all on the LibreOffice side and the Y axis is drawn to a different max value as a result (Excel is 90 and LibreOffice Calc is 80)
2. the legend item labels of "Series1/Series2" in Excel are ignored in LibreOffice and the column names are used instead (ColumnB/ColumnC)

Expected behavior:

1. Error bars included and y-axis comsistent with Excel2003
2. Proper legend titles

Platform (if different from the browser): 
              
Browser: ANY

Machine: LibreOffice 3.4  340m1(Build:302)
         Ubuntu 10.10, i686
Comment 1 wope 2012-03-03 12:18:16 UTC 
I can confirm this on 3.4.x and 3.5.1rc1, Linux and win
Comment 2 smaybo 2012-03-05 10:02:59 UTC 
Is this bug confirmed in 3.5.1 now.

It's one we hear about frequently from users and does have an impact on the image of LibreOffice and how well it handles some basica features of Excel graphs.
Comment 3 Markus Mohrhard 2014-03-27 22:53:16 UTC 
Fixed some time ago.