Bug 166860 - Chart title and subtitle merging
Summary: Chart title and subtitle merging
Status: RESOLVED DUPLICATE of bug 101322
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
25.2.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-06-04 16:53 UTC by Heiko Rossmann
Modified: 2026-01-27 13:11 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
The problem in the chart (181.75 KB, image/png)
2025-06-04 16:54 UTC, Heiko Rossmann
Details
Title and subtitle fields merged in "Insert Title" window (15.89 KB, image/png)
2025-06-04 16:56 UTC, Heiko Rossmann
Details
Sample (16.49 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-06-05 12:46 UTC, Heiko Rossmann
Details
Screenshot with 25.2.4 (155.20 KB, image/png)
2025-06-05 21:09 UTC, m_a_riosv
Details
Open and edit in safe mode (134.88 KB, image/png)
2025-06-06 13:09 UTC, Heiko Rossmann
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Heiko Rossmann 2025-06-04 16:53:37 UTC
Description:
Chart title and subtitle are automatically merging. A chart is created and formatted. The document is closed and when reopened, the title and subtitle have merged in the title field, often displaying the subtitle offset in the chart.

Steps to Reproduce:
1. Create a chart, and insert title and subtitle.
2. Save and close the document.
3. Open the document.

Actual Results:
Title and subtitle blend together, and often the subtitle is offset in the chart.

Expected Results:
??


Reproducible: Always


User Profile Reset: No

Additional Info:
Should have kept the subtitle text in the subtitle field.
Comment 1 Heiko Rossmann 2025-06-04 16:54:52 UTC
Created attachment 201098 [details]
The problem in the chart
Comment 2 Heiko Rossmann 2025-06-04 16:56:01 UTC
Created attachment 201099 [details]
Title and subtitle fields merged in "Insert Title" window
Comment 3 Heiko Rossmann 2025-06-04 16:56:44 UTC
User Profile Reset: YES (Now)
Comment 4 m_a_riosv 2025-06-05 01:33:40 UTC
Please attach a sample file, reduce the size as much as possible without private information, 
and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 5 Heiko Rossmann 2025-06-05 12:46:29 UTC
Created attachment 201109 [details]
Sample
Comment 6 Heiko Rossmann 2025-06-05 12:47:00 UTC
Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: bbb074479178df812d175f709636b368952c2ce3
CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: pt-BR (pt_BR); UI: pt-BR
Calc: CL threaded
Comment 7 m_a_riosv 2025-06-05 21:09:59 UTC
Created attachment 201116 [details]
Screenshot with 25.2.4

Open fine for me (I think), with MSO 365 and with LibreOffice 
Version: 25.2.4.2 (X86_64) / LibreOffice Community
Build ID: 508ff62361999404a9d3590fe47df713b5888744
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: en-US (es_ES); UI: en-US
Calc: CL threaded

Please test in safe mode, Menu/Help/Restart in Safe Mode
Comment 8 Heiko Rossmann 2025-06-06 13:05:57 UTC
Comment on attachment 201116 [details]
Screenshot with 25.2.4

Yes, the chart displays correctly most of the time. Sometimes the subtitle is offset over the data plot area.

The problem is the combination of the title and subtitle fields, which causes rework when you need to make adjustments to the chart.
Comment 9 Heiko Rossmann 2025-06-06 13:08:46 UTC
(In reply to m_a_riosv from comment #7)
> Created attachment 201116 [details]
> Screenshot with 25.2.4
> 
> Open fine for me (I think), with MSO 365 and with LibreOffice 
> Version: 25.2.4.2 (X86_64) / LibreOffice Community
> Build ID: 508ff62361999404a9d3590fe47df713b5888744
> CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render:
> Skia/Raster; VCL: win
> Locale: en-US (es_ES); UI: en-US
> Calc: CL threaded
> 
> Please test in safe mode, Menu/Help/Restart in Safe Mode

I opened the bug.xlsx file and moved the subtitle to the correct field in safe mode as per your instructions. I closed the file and opened it again. The error persists in safe mode. See the screenshot.

I had also previously restored LibreOffice as a clean install.
Comment 10 Heiko Rossmann 2025-06-06 13:09:30 UTC
Created attachment 201120 [details]
Open and edit in safe mode
Comment 11 QA Administrators 2025-11-25 15:39:12 UTC Comment hidden (obsolete)
Comment 12 Buovjaga 2026-01-27 13:11:05 UTC
It's not a bug, because OOXML does not support subtitles. The merging is a workaround for this lack in XLSX. Please never use XLSX format when working on something, but only use it as an export format.

*** This bug has been marked as a duplicate of bug 101322 ***