Bug 51806 - Data in named ranges in Chart in XLS spreadsheet not importing? (import from XLSX works)
Summary: Data in named ranges in Chart in XLS spreadsheet not importing? (import from ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2012-07-06 15:42 UTC by skiani
Modified: 2019-08-10 20:33 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Both charts on this spreadsheet come up blank. (1.48 MB, application/vnd.ms-excel)
2012-07-06 15:42 UTC, skiani
Details
Charts in MS Excel 2010 (44.71 KB, image/png)
2014-02-27 16:57 UTC, Alexandr
Details

Note You need to log in before you can comment on or make changes to this bug.
Description skiani 2012-07-06 15:42:45 UTC
Created attachment 63916 [details]
Both charts on this spreadsheet come up blank.

Spreadsheet calculates correctly but charts are blank.
Comment 1 Valek Filippov 2012-07-07 11:50:44 UTC
Confirmed with LO 3.5.3.2 and LO 3.6b2
Comment 2 Alexandr 2014-02-27 16:57:28 UTC
Created attachment 94846 [details]
Charts in MS Excel 2010

Reproducible in LibreOffice 4.2.0.4. I attach a sreenshot in MS Excel 2010 to show how it should be.
Comment 3 Joel Madero 2015-05-02 15:41:48 UTC Comment hidden (obsolete)
Comment 4 Alexandr 2015-05-04 14:50:29 UTC
Reproducible with Libre Office 4.3.3 and 5.0.0.0 alpha1 on Debian.
Comment 5 Robinson Tryon (qubit) 2015-12-09 16:40:39 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2017-01-03 19:41:45 UTC Comment hidden (obsolete)
Comment 7 eisa01 2018-06-16 18:15:18 UTC
This is still present and inherited from OOo

Version: 6.2.0.0.alpha0+
Build ID: b292a27698e85fd9d60c03613c3b0c67835c4dc1
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-06-06_23:25:55
Locale: en-US (en_US.UTF-8); Calc: group threaded
Comment 8 QA Administrators 2019-06-19 02:48:25 UTC Comment hidden (obsolete)
Comment 9 eisa01 2019-08-10 20:33:35 UTC
This is still present.

Seems to use named ranges to refer to the data in the chart, although I can't seem to find the reference even in Excel..

Might be related to bug 83307

Version: 6.4.0.0.alpha0+
Build ID: 54028dc503fc08eb12e287919d5e2850cff05b73
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-07-31_01:48:19
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded