Bug 163442 - StarOffice -> XLSX fails to output embedded chart
Summary: StarOffice -> XLSX fails to output embedded chart
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.2.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: OLE-Objects
  Show dependency tree / graph
 
Reported: 2024-10-15 12:05 UTC by dclipsham
Modified: 2025-03-10 15:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description dclipsham 2024-10-15 12:05:38 UTC 
Description:
Using command line conversion to convert the StarOffice Calc file 'example.sdc' found here: https://example-files.online-convert.com/spreadsheet/sdc/:
SDC conversion -> ODS creates an ODS file that retains the embedded chart
SDC conversion -> XLSX creates an XLSX file that is missing the embedded chart

Steps to Reproduce:
1. at command line: 'soffice --convert-to ods --outdir <my_output_directory> <myfile>
2. at command line: 'soffice --convert-to xlsx --outdir <my_output_directory> <myfile>


Actual Results:
Open both files in LibreOffice. The ODS version retains the embedded chart starting around cell A18, whereas it is not present (or at least not visible) in the XLSX version

Expected Results:
The chart should be visible in both output files


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2024-10-15 22:40:43 UTC 
Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Opening the file show the chart, but it is a 'Draw' object, not a chart.
It is not saved then as XLSX, but it is as ODS.

Testing with a blank spreadsheet adding and 'Draw' OLE object, it is not saved as XLSX.

So there is a bug, but it is:
Draw OLE objects are not saved with XLSX format, but it works with DOCX format.

Please, lets me change your initial title.
"StarOffice -> XLSX fails to output embedded chart"
Comment 2 m_a_riosv 2024-10-15 22:48:11 UTC 
It seems to happen since it is possible to save as XLSX.
Also with:
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 3aa81e4735ea895a71852b18ed029ae15e53c7b4
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 3 dclipsham 2025-03-10 15:31:16 UTC 
Sorry I wasn't sure if this needed me to respond, but of course I'm happy to have the subject title updated and have now done so. 

Thank you also for confirming the behavior.

David