Bug 164347 - FILEOPEN XLSX Form control overlaps comment in nearby cell
Summary: FILEOPEN XLSX Form control overlaps comment in nearby cell
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2024-12-16 21:29 UTC by Gabor Kelemen (allotropia)
Modified: 2025-01-06 15:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel 2016 (11.88 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-12-16 21:29 UTC, Gabor Kelemen (allotropia)
Details
The example file in Excel and Calc with comment visible (46.59 KB, image/png)
2024-12-16 21:29 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2024-12-16 21:29:08 UTC
Created attachment 198148 [details]
Example file from Excel 2016

This is split off from bug 153950

When a cell next to a form control has a comment, in Excel the comment appears above the form control. In Calc the comment is shown behind the form control, making it unreadable.

1. Open attached document
2. Choose View - Comments or point to the comment indicator of cell B2
-> The comment of cell B2 appears behind the form control in C2:E2, making it unreadable.

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7b9077669541b5685f3758b7a640b7e0d10dbe1b
CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded

Seems to have started in 5.3 when the form control started to be imported as UNO control instead of a white drawing shape rectangle.
Comment 1 Gabor Kelemen (allotropia) 2024-12-16 21:29:34 UTC
Created attachment 198149 [details]
The example file in Excel and Calc with comment visible
Comment 2 raal 2024-12-31 05:48:21 UTC
Confirm with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: cac9c7db6257b27724d90d4a355e52e456ef7e08
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

and Version 4.1.0.0.alpha0+ (Build ID: 847749e975a7111ea306909a29fddb5df13e9a7)

I don't see a regression here.
Comment 3 Gabor Kelemen (allotropia) 2025-01-06 15:12:43 UTC
(In reply to raal from comment #2)
> Confirm with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
> Build ID: cac9c7db6257b27724d90d4a355e52e456ef7e08
> CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
> Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
> Calc: threaded
> 
> and Version 4.1.0.0.alpha0+ (Build ID:
> 847749e975a7111ea306909a29fddb5df13e9a7)
> 
> I don't see a regression here.

Indeed: under Linux it was ~always good, only under Windows looked different. Removing keywords.