Bug 164108 - FILESAVE XLSX: exported histogram chart is not readable by Excel
Summary: FILESAVE XLSX: exported histogram chart is not readable by Excel
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
25.2.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: implementationError
Depends on:
Blocks: Histogram-Chart
  Show dependency tree / graph
 
Reported: 2024-11-30 18:57 UTC by Regina Henschel
Modified: 2024-12-01 16:42 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Data to produce a histogram chart (16.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-11-30 18:57 UTC, Regina Henschel 		Details
View All 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 Regina Henschel 2024-11-30 18:57:48 UTC 
Created attachment 197881 [details]
Data to produce a histogram chart

Open attached document.
Data > select range "myData"
Create chart with chart type "Histogram". Do not make any changes but use the defaults.
Save the document in xlsx-format.

Open the saved document in Excel. Error: Excel cannot read the chart and removes it on repair.

I have tested it with Version: 25.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 44ccd392be12dad23e216fb3eb2c2e5b275eee75
CPU threads: 32; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded

and

Microsoft® Excel® for Microsoft 365 MSO (Version 2410 Build 16.0.18129.20158) 64-bit
Comment 1 Regina Henschel 2024-11-30 19:01:52 UTC 
Open the saved document in LibreOffice. The histogram chart is totally wrong.
Comment 2 m_a_riosv 2024-11-30 21:23:36 UTC 
Saving as xlsx or ods, the chart is malformed reopening with LibreOffice or opening with Excel
Version: 25.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 44ccd392be12dad23e216fb3eb2c2e5b275eee75
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Microsoft® Excel® para Microsoft 365 MSO (versión 2410 compilación 16.0.18129.20158) de 64 bits