Bug 119292 - EDITING: rotated text doesn't respect cell's size if it doesn't fit ( doesn't get hidden )
Summary: EDITING: rotated text doesn't respect cell's size if it doesn't fit ( doesn't...
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Tibor Nagy
URL:
Whiteboard: target:7.2.0
Keywords:
Depends on:
Blocks: Vertical-Text
  Show dependency treegraph
 
Reported: 2018-08-15 11:52 UTC by Gabor Kelemen (allotropia)
Modified: 2021-04-08 06:49 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel (14.43 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-08-15 11:52 UTC, Gabor Kelemen (allotropia)
Details
Screenshot of the file in Excel and Calc side by side (67.99 KB, image/png)
2018-08-15 11:53 UTC, Gabor Kelemen (allotropia)
Details
The same file saved as ODS - no change (12.09 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-08-15 11:59 UTC, Gabor Kelemen (allotropia)
Details
The original file with more unrotated text than cells can display (14.57 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-08-15 12:00 UTC, Gabor Kelemen (allotropia)
Details
The example file with unrotated contents (83.38 KB, image/png)
2018-08-15 12:04 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) 2018-08-15 11:52:38 UTC
Created attachment 144186 [details]
Example file from Excel

In Excel, if there is more text in a cell than what it can display, the beginning of the text is displayed and the end of it is hidden.

In Calc, if there is more text than what can fit, all of the text is displayed with the beginning and end outflowing to neighboring cells.

This can easily result in unreadable cells containing the end of the text in the previous cell and the beginning of the text in the next one as well.

Tested with bibisect-win32-6.2 
Version: 6.2.0.0.alpha0+
Build ID: ea59fc4831b9d2430de51faa8c3e0a24e6d90cd1
CPU threads: 4; OS: Windows 6.3; UI render: default; 
Locale: hu-HU (hu_HU); Calc: CL
Comment 1 Gabor Kelemen (allotropia) 2018-08-15 11:53:02 UTC
Created attachment 144187 [details]
Screenshot of the file in Excel and Calc side by side
Comment 2 Gabor Kelemen (allotropia) 2018-08-15 11:59:07 UTC
Created attachment 144188 [details]
The same file saved as ODS - no change

Worth noting that this happens with 90 degrees rotated text.
Comment 3 Gabor Kelemen (allotropia) 2018-08-15 12:00:58 UTC
Created attachment 144189 [details]
The original file with more unrotated text than cells can display
Comment 4 Gabor Kelemen (allotropia) 2018-08-15 12:04:26 UTC
Created attachment 144190 [details]
The example file with unrotated contents

In case of unrotated text the center part of the text is displayed, but the beginning and end is not overflowing into neighboring cells.
Comment 5 Xisco Faulí 2018-08-15 17:48:22 UTC
Reproduced in

Version: 6.2.0.0.alpha0+
Build ID: 1af7f19224f18e5025352339648db659575eae33
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: threaded

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.10; Render: default; 

Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 6 Xisco Faulí 2018-08-15 17:49:05 UTC
@Eike, I thought you could be interested in this issue...
Comment 7 QA Administrators 2019-10-12 02:46:16 UTC Comment hidden (obsolete)
Comment 8 NISZ LibreOffice Team 2019-11-11 10:59:19 UTC
Still present in 

Version: 6.4.0.0.alpha1+ (x86)
Build ID: 80109586e6cb6d3e2e0a53a9079c3125ec9b8368
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL
Comment 9 Commit Notification 2021-03-26 13:42:12 UTC
Tibor Nagy committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/967e0cc303c7be4a88905b327b9d02ba12f5e375

tdf#119292 sc layout: fix overlapping wrapped cell texts

It will be available in 7.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 10 NISZ LibreOffice Team 2021-04-08 06:49:28 UTC
Verified in: 

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: ea4fb1559f7b99a0bfaf18f26cb3b6972c9cde1c
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded