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)
(earliest affected)
Inherited From OOo
Hardware: Other All
: high major
Assignee: Not Assigned
Depends on:
Blocks: UOF
  Show dependency treegraph
Reported: 2015-01-14 05:38 UTC by Carlos Roberto
Modified: 2023-09-20 04:19 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Table 1 with graphs (36.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-14 05:38 UTC, Carlos Roberto
Screenshot how I see. (277.10 KB, image/png)
2015-01-14 21:27 UTC, m.a.riosv

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:
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 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 :
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., 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-
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: (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: (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: (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: (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: (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