To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102640 Issue #|102640 Summary|False reference edge of rotated text when imported fro |m a XLS file Component|Spreadsheet Version|OOo 3.1 Platform|Unknown URL|http://www.dguv.de/bgia/de/pra/manipulation/index.jsp OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|lendo
------- Additional comments from [email protected] Wed Jun 10 11:32:35 +0000 2009 ------- I downloaded the file "manipulationsanreiz_p1.xls" from the above mentioned URL and noticed that - when viewing wich OOo Calc - the text orientation of rotated text is correct but the lines around the cells are not rotated too. I had to format the cell with Alignment > Text orientation > Reference edge > "Text extension from lower cell border" (option [German] "Textausdehnung nur innerhalb der Zelle" was preselected - I don't know the English string). Then with the new reference edge, the cells were looking like in the original file. This is a general problem of importing XLS data with rotated text with cell borders. I tested it with a new file - Calc imports it with the option [German] "Textausdehnung nur innerhalb der Zelle". With the other option "Text extension from lower cell border" the XLS data would be looking right. (MS Excel sets the vertical text orientation to "below"/"unten" per default. I think this is the counterpart of "Text extension from lower cell border" in calc if there are cell borders. - Setting the Calc option "vertical text alignment" to "below"/"unten" doesn't resolve this issue.) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
