Bug 49225 - FILESAVE: Chart from data table, copied from other file, empty when saved as XLS
Summary: FILESAVE: Chart from data table, copied from other file, empty when saved as XLS
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Keywords: filter:xls
Depends on:
Blocks: XLS
  Show dependency treegraph
Reported: 2012-04-27 07:39 UTC by opensuse.lietuviu.kalba
Modified: 2022-08-23 15:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

ods file with diagrams (312.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-04-27 07:39 UTC, opensuse.lietuviu.kalba
MS Excel xls file (60.50 KB, application/vnd.ms-excel)
2012-04-27 07:40 UTC, opensuse.lietuviu.kalba
MS Excel xlsx file (47.29 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-04-27 07:41 UTC, opensuse.lietuviu.kalba
xls saved in Windows (60.00 KB, application/vnd.ms-excel)
2012-04-27 07:48 UTC, opensuse.lietuviu.kalba
xlsx saved in Windows version of LibreOffice Portable (48.39 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-04-27 07:48 UTC, opensuse.lietuviu.kalba
original OSD with data table and chart for it (12.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-09-24 09:35 UTC, opensuse.lietuviu.kalba
ODS with pasted chart (15.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-09-24 09:38 UTC, opensuse.lietuviu.kalba
XLS with pasted chart (7.00 KB, application/vnd.ms-excel)
2016-09-24 09:42 UTC, opensuse.lietuviu.kalba
re-saved once in XLS in LibreOffice (7.42 KB, image/png)
2017-10-26 15:07 UTC, opensuse.lietuviu.kalba
re-saved twice in XLS in LibreOffice (10.28 KB, image/png)
2017-10-26 15:09 UTC, opensuse.lietuviu.kalba

Note You need to log in before you can comment on or make changes to this bug.
Description opensuse.lietuviu.kalba 2012-04-27 07:39:01 UTC
Created attachment 60681 [details]
ods file with diagrams

Problem description: 
I have LibreOffice Calc document .ods with very similar diagram, made allmost the same way. Then I save it as xls or xlsx format, these diagrams in MS Office file format are empty.

Steps to reproduce:
1. Create diagram with LibreOffice Calc
2. Copy this diagram to new file of LibreOffice Calc
3. Save in LibreOffice format
4. Save as in MS Excel format xls and xlsx
5. Open MS Excel format xls and xlsx files

Current behavior:
Diagrams may be empty

Expected behavior:
Diagrams allways are with data

Platform (if different from the browser): 
openSUSE Linux 12.1 64 bit
Browser: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; .NET4.0C; .NET4.0E; OfficeLiveConnector.1.5; OfficeLivePatch.1.3)
Comment 1 opensuse.lietuviu.kalba 2012-04-27 07:40:35 UTC
Created attachment 60682 [details]
MS Excel xls file
Comment 2 opensuse.lietuviu.kalba 2012-04-27 07:41:15 UTC
Created attachment 60683 [details]
MS Excel xlsx file
Comment 3 opensuse.lietuviu.kalba 2012-04-27 07:47:29 UTC
Tested to save as ODS file in MS Windows (with LibreOffice Portable 3.5.2). The rezult is similar as with Linux: 
in xlsx file "LDK ir ADK santykis (Furje)" sheet has no diagram,
in xls file there is empty images instead of diagrams.
Comment 4 opensuse.lietuviu.kalba 2012-04-27 07:48:12 UTC
Created attachment 60684 [details]
xls saved in Windows
Comment 5 opensuse.lietuviu.kalba 2012-04-27 07:48:57 UTC Comment hidden (obsolete)
Comment 6 bfoman (inactive) 2012-07-17 13:16:43 UTC
Confirmed with:
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

Excel 2010 results:
xls - missing pictures
xlsx - pictures are present, but wrong formatting, legend displacement, scaling, axis titles and other problems, similar as in attached files.
Comment 7 QA Administrators 2015-04-19 03:20:18 UTC Comment hidden (obsolete)
Comment 8 opensuse.lietuviu.kalba 2015-04-19 04:12:58 UTC
BUG still exist in LibreOffice, 
System: openSUSE Linux 13.2 64 bit
LO installed from LibreOffice site RPM packages
Comment 9 QA Administrators 2016-09-20 09:24:39 UTC Comment hidden (obsolete)
Comment 10 opensuse.lietuviu.kalba 2016-09-20 19:45:52 UTC
BUG still exist in LibreOffice
- for XLS – no images
- for XLSX - images exist, but some distortions exist
System: openSUSE Linux 13.2 64 bit
LO installed from LibreOffice site RPM packages
Comment 11 Timur 2016-09-24 09:04:03 UTC
OK, let's get back to basics, so called triaging. 
1. No need for multiple tabs or same diagrams, minimum test case is needed.
2. Xls and Xlsx have different results because they have different filters. Let this one be for XLS only. Added keyword.
3. Those are charts, not diagrams. 
4. "made almost the same way" How was this chart created? In Calc or copied from somewhere or exported? You normally get those when creating a chart without data, and enter data after.
5. Can you write step-by-step how to reproduce with a singe chart created from scratch?
Comment 12 opensuse.lietuviu.kalba 2016-09-24 09:35:35 UTC
Created attachment 127602 [details]
original OSD with data table and chart for it

In this document chart newly created from data, that exist in same sheet.

(P.S. I use Lithuanian interface, were „chart“ is named as international word „diagrama“; and my dictionary says, that meanings of „diagram“ and „chart“ overlap).
Comment 13 opensuse.lietuviu.kalba 2016-09-24 09:38:29 UTC
Created attachment 127603 [details]
ODS with pasted chart

This is new document, I only pasted chart from other ODS (i.e. https://bugs.documentfoundation.org/attachment.cgi?id=127602 ). Chart is OK.
Comment 14 opensuse.lietuviu.kalba 2016-09-24 09:42:23 UTC Comment hidden (obsolete)
Comment 15 opensuse.lietuviu.kalba 2016-09-24 09:44:41 UTC Comment hidden (obsolete)
Comment 16 Timur 2016-09-24 11:14:09 UTC
Please excuse, I had some other bugs, and I wasn't careful to read that you already wrote everything in the first post. Copying to new file. So, the title is now fine.
For the sake of clarity of the bug for other readers, I'll remove last comments. 
For XLSX please search other bugs and if not already reported, submit a new bug, and set See also to this one.
Comment 17 QA Administrators 2017-10-23 14:14:31 UTC Comment hidden (obsolete)
Comment 18 opensuse.lietuviu.kalba 2017-10-26 15:04:05 UTC
I can reproduce bug in LibreOffice
(ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4,
Installed via RPM packages from LibreOffice website
in openSUSE Leap 42.3 64-bit Linux)

Just opening example ODS and re-saving it as XLS file also results into empty graphics
Comment 19 opensuse.lietuviu.kalba 2017-10-26 15:07:12 UTC
Created attachment 137304 [details]
re-saved once in XLS in LibreOffice

example image
Comment 20 opensuse.lietuviu.kalba 2017-10-26 15:09:36 UTC
Created attachment 137306 [details]
re-saved twice in XLS in LibreOffice

re-saving _twice_ results even in more worse scenario
Comment 21 QA Administrators 2018-10-27 02:55:43 UTC Comment hidden (obsolete)
Comment 22 Ove Johan 2018-12-29 16:16:06 UTC
Comment on attachment 60681 [details]
ods file with diagrams

No errors. Simple laptop, Win 10, 4 G memory, processor with 4 cores, SSD-HD
Comment 23 Timur 2018-12-31 12:43:12 UTC
Bug for XLS reproduced in LO 6.3+.
Comment 24 Gabor Kelemen (allotropia) 2019-06-03 17:15:58 UTC
This is about an XLS file, so changing meta bug.
Comment 25 QA Administrators 2021-06-03 03:55:24 UTC Comment hidden (obsolete)
Comment 26 Gerald Pfeifer 2022-08-23 15:55:36 UTC
Still reproduces in Version: / LibreOffice Community
Build ID: 46dc9f3bbac67e9240adc44ab017f905482ef786
CPU threads: 8; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Simple reproducer:

 1. Open ODS file from attachment #127603 [details] (comment #13)
 2. Save in XLS format
 3. Restart LibreOffice and open XLS file saved in step 2
 4. Graph gone (i.e., white)