Bug 126897

Summary:	Cell Drawing End of Content Rather than Beginning of Content
Product:	LibreOffice	Reporter:	Freddie O’Connell <tfo>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	6.3.0.4 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Screenshot of Cell in Calc Screenshot of Same Data in Numbers

Description Freddie O’Connell 2019-08-13 21:35:15 UTC

Description:
In Calc, a spreadsheet with too much data for a cell is drawing the end of the content of that cell rather than the beginning, which can be confusing.

Steps to Reproduce:
1. Launch a spreadsheet with lots of content per cell.
2. Look at a specific cell.
3. Wonder how to see the beginning of the content.

Actual Results:
The end of the content instead of the beginning was drawn.

Expected Results:
The beginning of the content should've been drawn.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.0.4
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

Comment 1 Freddie O’Connell 2019-08-13 21:37:16 UTC

Created attachment 153361 [details]
Screenshot of Cell in Calc

Comment 2 Freddie O’Connell 2019-08-13 21:37:59 UTC

Created attachment 153362 [details]
Screenshot of Same Data in Numbers

Comparative screenshot from Numbers for same data.

Comment 3 m_a_riosv 2019-08-13 23:18:45 UTC

Please attach a sample file as little as possible, showing the issue.

Comment 4 Freddie O’Connell 2019-08-14 02:26:10 UTC

I'm confused. The attached screenshots show a cell in Calc, where the text "Selecting 'Close' on Editing a unit..." is not visible in the cell, and a screenshot from Numbers where that text is visible in the cell and the text that is not visible is the end ("... close without saving?").

Basically, for a cell with long text, Calc is showing the end of that text rather than the beginning, which is not expected behavior.

Comment 5 m_a_riosv 2019-08-14 06:53:44 UTC

Sorry but a screenshot doesn't help too much without a sample file with the issue, how to known what it's in detail the cell format.

So I guess cell it's aligned from Bottom to show the end of the text, if cells are aligned from Top the the beginning of the cell it's showed.

Comment 6 Freddie O’Connell 2019-08-16 15:48:57 UTC

As a default behavior, I would personally still rate this as a bug. It’s generally inconsistent with any other spreadsheet application I’ve used.

Comment 7 m_a_riosv 2019-08-16 21:07:01 UTC

What you can do it's request for enhancement changing the second box of 'Importance' modifying the title, and status to unconfirmed.

No working as everyone likes it's not a bug.