Bug 39990 - Formatted rotated text misbehaves. It does not always remain in the cell.
Summary: Formatted rotated text misbehaves. It does not always remain in the cell.
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.2 release
Hardware: Other Windows (All)
: medium trivial
Assignee: Not Assigned
Depends on:
Reported: 2011-08-10 20:08 UTC by Joseph Conner
Modified: 2011-12-23 15:38 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Calc spreadsheet illustrating the problem. (9.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-08-10 20:08 UTC, Joseph Conner
Text position riddle, see comment 1 (45.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-08-10 22:40 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description Joseph Conner 2011-08-10 20:08:52 UTC
Created attachment 50109 [details]
Calc spreadsheet illustrating the problem.

Text rotation seems to disregard the placement in a calc cell.  In the submitted .ods file in some cases the text crosses cell boundaries, and in one case it misses the cell entirely.
Comment 1 Rainer Bielefeld Retired 2011-08-10 22:39:44 UTC
I can't see anything wrong.
Please type something like "qwertzuiopüasdfghjklöyxcvbnm" (aligned left) into a cell with 10mm width. You see: 0% rotation, exceeds cell, crosses borderlines. Where is the problem? Why should text not exceed cell?

For me that is a feature I have been using for years. Please also see my riddle "what cell?". That also is unexpected, but not a bug, when you check the border settings, the position is as expected.

So I close this one as INVALID for now

@Joseph Conner:
You attached a sample with the demand "Try to find a bug".
Please feel free to reopen this bug if you find evidence for a real bug.

May I ask you to read  hints on <http://wiki.documentfoundation.org/BugReport> carefully?
Then please:
- Attach screenshots with comments (you can add information using LibO DRAW
  and then attach your screenshot with comments as PDF) if necessary, because
  you can not know what others will see with your sample
- Contribute a step by step instruction containing every key press and every 
  mouse click how to reproduce your problem
- add information 
  -- what exactly is unexpected (not "seems that some text positions are 
     unexpected", but "in 'A1' I expect xxx because of yyy but I see zzz")
  -- and why do you believe it's unexpected (cite Help or Documentation!)
  -- concerning your LibO version and localization (UI language)
  –- Libo settings that might be related to your problems 
  -- how you launch LibO and how you opened the sample document
  –- If you can contribute an OOo Issue that might be useful
  -- everything else crossing your mind after you read a.m. URL

Can you please file Bug reports with status UNCONFIRMED if your are not absolutely sure that you contributed all required background information and that the problem will be reproducible with information you can provide? 

Thank you!
Comment 2 Rainer Bielefeld Retired 2011-08-10 22:40:35 UTC
Created attachment 50110 [details]
Text position riddle, see comment 1
Comment 3 Jeffrey 2011-08-11 18:45:49 UTC
I think that there is evidently a problem because with a non rotated text, you can adjust the boundaries to contain the entire text, while in the rotated version, you cannot. It seems like there is no clear reference point for the rotation of the text. The rotation is a good feature, but I believe, as indicated in the reporter's spreadsheet that it is too difficult to handle and is ridiculous that in some cases the text would be outside the cell entirely. It would be recommended if we can be sure that all cells share a reference point (in the center maybe).

On LibreOffice 3.4  340m1(Build:103) for OpenSuse Linux.
Comment 4 Rainer Bielefeld Retired 2011-08-11 23:25:52 UTC
Please contribute an example for your concerns, I do not understand your general comment " ...  adjust the boundaries ..."
Comment 5 Björn Michaelsen 2011-12-22 05:51:30 UTC