If I open an xls file that contains a chart, the chart data does not display (the data range is empty). This only seems to occur if the data range is non-contiguous. ===== Steps to reproduce Open LibO Create new spreadsheet (File -> New -> Spreadsheet) Enter the following data: Cell A1: 1 Cell A2: 2 Cell A3: 3 Cell A5: 5 Select cells A1:A3, A5 (click-and-drag A1 to A3, CTRL+Click A5) Insert column chart (Insert -> Chart... -> Finish) Deselect the chart by clicking on any cell (probably not necessary) Save file as... (CTRL+SHIFT+S) From the "Save as type" drop-down select "Microsoft Excel 97/2000/xp (.xls) (*.xls)" Save file (Click on "Save") Close document Open the saved xls document Expected result: File opens and chart is displayed as before Actual result: File opens, but the chart is devoid of data ===== End of reproduction Some remarks: The "Data range" and "Data Series" are not populated. As this happens with a similar file generated from MS Excel 2007, I believe the problem lies in the xls import filter (export filter seems OK). This may be related to: https://bugs.freedesktop.org/show_bug.cgi?id=35015 and/or https://bugs.freedesktop.org/show_bug.cgi?id=38734 Running LibreOfficePortable 3.3.2 (as downloaded from portableapps.com) Windows 7 Professional x64 About: LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2
I can reproduce the bug in LibreOfficePortable 3.3.3 I can reproduce the bug in LibreOfficePortable 3.4.1 Both running on Windows 7 x64 Professional I touched on it in the original post, but I believe the xls export filter is not the problem: if I open the xls file in MS Office 2007 then the data is correctly populated. It seems to be only the import filter that is the problem in this case.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian
Not reproducible in 3.6.1 on Fedora 64 bit with xls format. but some problem with xlsx format exist, separate Bug 55178 created Changing to WFM
Just tried the steps in the original post again; calc did NOT crash. I can confirm that the bug seems to be squashed. Please note that I'm running a different system than in the original post. -- Running LibreOffice 3.6.2.2 (as from Ubuntu 12.10 repo) On Ubuntu 12.10 x64 About: Version 3.6.2.2 (Build ID: 360m1(Build:2))