Bug 164114 - FILEOPEN XLSX: Histogram chart is not imported
Summary: FILEOPEN XLSX: Histogram chart is not imported
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 enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: OOXML-Chart Histogram-Chart
  Show dependency treegraph
 
Reported: 2024-12-01 16:47 UTC by Regina Henschel
Modified: 2025-01-11 17:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Histrogram created with Excel 365 (21.12 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-12-01 16:47 UTC, Regina Henschel
Details
Screenshot of the chart in Excel (6.10 KB, image/png)
2024-12-01 16:47 UTC, Regina Henschel
Details
Screenshot opening with Calc, with a message on the chart. (57.34 KB, image/png)
2024-12-01 22:30 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2024-12-01 16:47:12 UTC
Created attachment 197886 [details]
Histrogram created with Excel 365

Open the attached file in LibreOffice 25.2. Although we now have a chart type "Histogram", the chart is not rendered.
Comment 1 Regina Henschel 2024-12-01 16:47:48 UTC
Created attachment 197887 [details]
Screenshot of the chart in Excel
Comment 2 Marina Latini (SUSE) 2024-12-01 22:11:35 UTC
I can repro on:

Version: 25.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: afc441e65107ed808c399b65f4737d25541cdf77
CPU threads: 20; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 3 m_a_riosv 2024-12-01 22:30:52 UTC
Created attachment 197890 [details]
Screenshot opening with Calc, with a message on the chart.

Reproducible.
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

But there is a message about the chart type not being compatible with the Excel version.
It opens with Excel and looks fine.
Comment 4 Devansh Varshney 2024-12-02 15:42:26 UTC
The reason for the message about the chart type not being compatible is because MSO has introduced an entirely new namespace for the new chart types introduced in MSO2016.

Which is chartex rather than chart namespace 

https://epplussoftware.com/docs/5.7/api/OfficeOpenXml.Drawing.Chart.ChartEx.ExcelChartEx.html

That's why we are seeing this message.
Comment 5 Regina Henschel 2024-12-02 16:50:10 UTC
Actually it is
xmlns:cx1="http://schemas.microsoft.com/office/drawing/2015/9/8/chartex"
But the prefix cx1 is only used in
Requires="cx1"

The chart itself is still
<cx:chart xmlns:cx="http://schemas.microsoft.com/office/drawing/2014/chartex" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" r:id="rId1" />