Bug 161867 - Edit of cell content larger than a cell shows it in the left cell instead centered
Summary: Edit of cell content larger than a cell shows it in the left cell instead cen...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Edit-Mode
  Show dependency tree / graph
 
Reported: 2024-07-02 12:40 UTC by Timur
Modified: 2024-07-06 01:57 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample (19.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-07-02 12:40 UTC, Timur 		Details
sample file (11.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-07-03 07:09 UTC, nobu 		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 Timur 2024-07-02 12:40:37 UTC 
Created attachment 195084 [details]
Sample

Edit of centered cell content larger than a cell shows it covering the left cell (in sample: large A)  instead being centered left-right (in sample: around B). 

Seen from OO to 25.2+. MSO has expected behavior.
Comment 1 m_a_riosv 2024-07-02 22:08:58 UTC 
But it is centered left and right, from A to C. Being larger A, it is centered on the whole space between A and C.
Comment 2 nobu 2024-07-03 07:09:26 UTC 
Created attachment 195097 [details]
sample file

Therefore, if there is a wide column width cell on the right, you may not be able to see the editing state in the cell.

Insert Long Text into [B2} cell.
This happens when the Column [A] is visible.

Developers will say it's not a bug, but I'd like to see it if possible.
Comment 3 Rafael Lima 2024-07-03 12:28:32 UTC 
IMO this is a bug. The contents should be centered on its own cell (which is what MSO and Google Sheets do).

Repro with

Version: 24.8.0.0.beta1+ (X86_64) / LibreOffice Community
Build ID: d681c57ba51b635ba7c85b21e062732110e8293f
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Calc: CL threaded