Bug 88388 - CALC is not exporting ODS graphs to XLS, XLT and UOS correctly
Summary: CALC is not exporting ODS graphs to XLS, XLT and UOS correctly
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: UOF
  Show dependency treegraph
 
Reported: 2015-01-14 05:38 UTC by Carlos Roberto
Modified: 2025-11-27 15:33 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Table 1 with graphs (36.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-14 05:38 UTC, Carlos Roberto
Details
Screenshot how I see. (277.10 KB, image/png)
2015-01-14 21:27 UTC, m_a_riosv
Details
Calc ods file with drawing. (15.93 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-11-27 07:36 UTC, Marko
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Carlos Roberto 2015-01-14 05:38:23 UTC
Created attachment 112197 [details]
Table 1 with graphs

How to reproduce:

1- Open attachment Table 1.ods
2- You can see graphs normally.
3- Save as Table 2.xls with LibreOffice 4.2.8
4- Open Table 2.xls in LibreOffice 4.2.8 or Microsoft Office 2010.
5- Graphs are broken.

LibreOffice should export graphs correctly.
Comment 1 raal 2015-01-14 06:44:52 UTC
I can confirm with LO 4.3.5, win7
Comment 2 m_a_riosv 2015-01-14 21:27:36 UTC
Created attachment 112252 [details]
Screenshot how I see.

I can't reproduce with 4.2.8.

Attached screenshot with both ods and xlsx.

Chart has the data table embedded in the chart.

Maybe resetting the user profile can help.
https://wiki.documentfoundation.org/UserProfile#Default_location or http://ask.libreoffice.org/en/question/903/where-are-the-libreoffice-data-profile-files/
Comment 3 Yogesh Bharate 2015-04-20 10:36:36 UTC
I checked this issue on latest Ubuntu build.
Issue cannot reproduce.


Build ID:
Version: 5.0.0.0.alpha1+
Build ID: d68cf40b7a16e20e99c15d310b24c91c2ca89ef6
Locale: en_IN
Comment 4 Carlos Roberto 2016-01-09 01:58:47 UTC
I still reproduce on two computers, one with Windows 7 32-bits and another Windows 10 64-bits.

After saving file as .xls (97-2003) please close Libreoffice 5.0.4.2 and open again with file exported.

No longer happen saving file as .xlsx (2007-2013).
Comment 5 testjava 2016-01-16 18:36:32 UTC
Confirmed with :
Version: 5.0.3.2
Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Locale: it-IT (de_DE)

Windows XP 32 bit
Comment 6 Carlos Roberto 2016-01-17 00:00:31 UTC
Reproducible saving as .XLT and .UOS formats also.
Comment 7 thoskk 2016-02-14 16:29:46 UTC
V. 5.0.4.2, Win7 64-Bit
The result of saving in .uos format will produce empty document when re-opened with LibreOffice and OpenOffice.
Comment 8 Carlos Roberto 2016-04-16 13:59:52 UTC
Set version to "inherited from OOo", reproducible with:

BrOffice 3.3.4 
OOO330m19 (Build:401)
tag libreoffice-3.3.4.1
Comment 9 QA Administrators 2018-09-16 02:48:54 UTC Comment hidden (obsolete)
Comment 10 Carlos Roberto 2018-09-16 06:33:23 UTC
It still happens on XLS, XLT and UOS.

Version: 6.1.1.2 (x64)
Build ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: pt-BR (pt_BR); Calc: group threaded
Comment 11 QA Administrators 2019-09-17 02:47:50 UTC Comment hidden (obsolete)
Comment 12 Carlos Roberto 2019-09-19 12:46:19 UTC
Still persist.

Versão: 6.3.1.2 (x64)
ID de compilação: b79626edf0065ac373bd1df5c28bd630b4424273
Threads da CPU:4; SO:Windows 10.0; Realizador da interface: GL; VCL: win; 
Local: pt-BR (pt_BR); Idioma de IU: pt-BR
Calc: CL
Comment 13 QA Administrators 2021-09-19 03:45:34 UTC Comment hidden (obsolete)
Comment 14 Sophie Sipasseuth 2023-09-18 13:22:25 UTC
I can't reproduce this bug with:

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: df3b95a39472e18ea8acdaae447b7176e37a9256
CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded
Comment 15 ady 2023-09-18 23:13:34 UTC
(In reply to Sophie Sipasseuth from comment #14)
> I can't reproduce this bug with:

I can still repro with:

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 80a24870491385ba145757bf517c5f1cf7939017
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (es_AR); UI: en-US
Calc: CL threaded
Comment 16 QA Administrators 2023-09-20 03:06:26 UTC Comment hidden (obsolete)
Comment 17 Carlos Roberto 2023-09-20 04:19:26 UTC
Hello QA team, I am back.

Yes, It still persist on XLS, XLT and UOS.

Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: pt-BR (pt_BR); UI: pt-BR
Calc: CL threaded
Comment 18 Marko 2025-11-27 07:36:35 UTC
Created attachment 204309 [details]
Calc ods file with drawing.

Opening PDF with LibreOffice Draw, selecting drawing objects, grouping and pasting to LibreOffice Calc, then saving as XLSX incorrectly saves grouped drawing. Saving as ODS works as expected

Try to save attached file as XLSX and open in Excel. Drawing now has reversed Hight/Width.

Version: 25.2.6.2 (X86_64) / LibreOffice Community
Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: hr-HR (hr_HR); UI: en-US
Calc: CL threaded
Comment 19 m_a_riosv 2025-11-27 15:33:55 UTC
Ungrouping the objects, make it works fine, with Excel and with Calc.

But without ungrouping, their appears on Excel rotated and ungrouped.
Opening with Calc, the objects disappear.

Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: threaded