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: 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: Vertical-Text
  Show dependency treegraph
 
Reported: 2018-08-15 11:52 UTC by Gabor Kelemen
Modified: 2019-11-11 10:59 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
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
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
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
Details
The example file with unrotated contents (83.38 KB, image/png)
2018-08-15 12:04 UTC, Gabor Kelemen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen 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 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 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 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 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