Bug 168092 - Column titles overlap when column widths are small
Summary: Column titles overlap when column widths are small
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.0.4 release
Hardware: All All
: low enhancement
Assignee: Heiko Tietze
URL:
Whiteboard: target:26.2.0
Keywords:
Depends on:
Blocks:
 
Reported: 2025-08-24 13:13 UTC by carlos_bgz
Modified: 2025-08-29 15:13 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot showing what I am referring to (166.42 KB, image/png)
2025-08-24 13:16 UTC, carlos_bgz
Details
That's how it looks in other programmes. (28.03 KB, image/png)
2025-08-24 22:47 UTC, carlos_bgz
Details
Screenshot before/after (10.36 KB, image/png)
2025-08-27 08:20 UTC, Heiko Tietze
Details

Note You need to log in before you can comment on or make changes to this bug.
Description carlos_bgz 2025-08-24 13:13:59 UTC
Description:
I'm not sure if this is the right place, but I want to show what happens in Calc when the column width is small.
I've seen this in previous versions and it doesn't cause any problems, but it would be better if it were corrected. 

Steps to Reproduce:
1.Open a spreadsheet
2.Set the column width to 7 points or less
3.Look at the header row starting from column AA

Actual Results:
None

Expected Results:
None


Reproducible: Always


User Profile Reset: No

Additional Info:
A jumble appears in which nothing can be seen.
I took a screenshot, but I don't see where to post it so that it can be seen.
Comment 1 carlos_bgz 2025-08-24 13:16:53 UTC
Created attachment 202492 [details]
Screenshot showing what I am referring to
Comment 2 m_a_riosv 2025-08-24 21:55:44 UTC
Reproducible

Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7f4868348c14b305fcd75744e1e3544d0d3a5d61
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

But better propose something about how to do it.
Comment 3 carlos_bgz 2025-08-24 22:45:36 UTC
If I knew how to fix it, I would have said so.
I'm not a programmer.
In Excel, which I used before, the header displayed a single letter, which made it look less cluttered.
Comment 4 carlos_bgz 2025-08-24 22:47:35 UTC
Created attachment 202495 [details]
That's how it looks in other programmes.
Comment 5 Stéphane Guillou (stragu) 2025-08-26 07:34:02 UTC
Thank you for the report. I changed the summary to be more descriptive.

I agree that it's not ideal, but think it's of low priority.
Let's see what the UX/Design team thinks is the best solution.
Comment 6 carlos_bgz 2025-08-26 09:56:47 UTC
I completely agree that it's not important. It's a matter of aesthetics.
With everything else so tidy, the jumble of letters really stands out.
Comment 7 Heiko Tietze 2025-08-27 06:48:34 UTC
+1
Though shalt not bleed text into adjacent cells.
Comment 8 Heiko Tietze 2025-08-27 08:20:41 UTC
Created attachment 202540 [details]
Screenshot before/after

Enabled clipping for the header. The screenshot compares Calc with the patch on top and old at the bottom.
Comment 9 BogdanB 2025-08-27 10:35:36 UTC
(In reply to Heiko Tietze from comment #8)
> Created attachment 202540 [details]
> Screenshot before/after
> 
> Enabled clipping for the header. The screenshot compares Calc with the patch
> on top and old at the bottom.

X should be visible, not the E, from XEV column or the next ones...
Comment 10 BogdanB 2025-08-27 10:36:57 UTC
I supose they are centered and when is small space is visible just the center of the column header. In the comment 4 image there are AAAAABBBB, so the first letter is visible.
Comment 11 Heiko Tietze 2025-08-27 12:25:23 UTC
(In reply to BogdanB from comment #9)
> X should be visible...
Thought about this but it has zero information. Rather the end letter should be visible, but ultimately it might be more confusing.

(Struggling with RTL sheets for now.)
Comment 12 Commit Notification 2025-08-29 15:12:02 UTC
Heiko Tietze committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/c65eadf2caca9bd7bf92af7448794077d2098f97

Resolves tdf#168092 - Column titles must not overlap

It will be available in 26.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 13 Heiko Tietze 2025-08-29 15:13:47 UTC
(In reply to BogdanB from comment #10)
> I supose they are centered...
Latest patch right aligns the header text so you see the most important information.