Created attachment 93801 [details] zip file with the xlsx file containing the chart and two screenshots (Calc and Excel) Problem description: a chart included in an xlsx file, that is correctly displayed in Excel, is empty in Calc; the apparent reason is that the Data range of the chart, as interpreted in LO, is wrong. Steps to reproduce: unfortunately I do not know how the file was generated, because I received it (maybe is it related to a bug already reported?); however, in Excel I removed everything is not relevant to the buggy behavior, so that the attached file is possibly the simplest case to be dealt with. Note that the file was generated with Excel, MS Office Professional Plus 2010, Italian version, Win 7, and (wrongly) opened in Calc, LibreOffice 4.2.0.4, English version, Kubuntu 13.10. Operating System: Debian Version: 4.2.0.4 release
edited summary notes with a clearer description. bug is reproducible (empty chart) under Win7x64 with LibO 4.2.3.3 bug is not reproducible (correct chart) with 4.3.0.0 alpha1+ (*) this means that the bug has been fixed in 4.3.x branch so I can mark this as RESOLVED WORKSFORME (I don't know if the fix will be backported in future 4.2.x releases as well). (*)Version: 4.3.0.0.alpha1+ Build ID: 0b03f7ed575838f90e6b1ebec3538a3a214f81fb TinderBox: Win-x86@42, Branch:master, Time: 2014-04-30_02:30:23
Created attachment 98384 [details] Comparison of test.xlsx opened in onedrive, Office 2013, and LO I tried opening this file in onedrive, Excel 2013, and LO 4.3. Each one created a different range. This suggests that the issue might stem from a corrupted file. @tommy27 The chart is now showing something in 4.3, but the bug has not been fully resolved. As the user described in the summary and test1.png Calc may be incorrectly importing the Data range of the chart. @lucapaolomari What steps did you follow to create this file? What version of word or LO? Is it possible that is was corrupted?
Luke, (In reply to comment #2) > Created attachment 98384 [details] > Comparison of test.xlsx opened in onedrive, Office 2013, and LO The range IS correct on all your openings in your screen clip, you have a chart showing--20--random numbers between 0.0 and 1.0; each itteration of the formula will get a different value--no two charts will ever be the same.
Thanks Stuart. Wasn't expecting a RAND function in a test case file. Sorry I missed that. I'm not sure what issue luca was seeing with the data. The range for Excel is =Sheet1!$A$1:$A$20 and LO is $Sheet1.$A$1:$A$20