| Summary: | FORMATTING: Excel2003 charts/error bars not formatted properly in LibreOffice 3.4.3 | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | smaybo |
| Component: | Chart | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | CC: | smaybo, wope |
| Priority: | medium | ||
| Version: | 3.5.1 RC1 | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=64123 | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | ZIp contains example spreadsheet from Excel2003 and screenshots of comparisons of openign the file in Excel vs LibreOffice | ||
I can confirm this on 3.4.x and 3.5.1rc1, Linux and win 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. Fixed some time ago. |
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