Issue 76407 - vertical text in text box changed to horizontal (Excel import)
Summary: vertical text in text box changed to horizontal (Excel import)
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2
Hardware: PC All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-04-16 14:45 UTC by ecrhc
Modified: 2017-05-20 10:34 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Original Excel file with vertical text in text box. (14.50 KB, text/plain)
2007-04-16 14:46 UTC, ecrhc 		no flags Details
pdf from file when opened in Excel (correct display) (8.41 KB, text/plain)
2007-04-16 14:47 UTC, ecrhc 		no flags Details
pdf from file when openend in OO (text changed to horizontal upon import) (13.31 KB, text/plain)
2007-04-16 14:48 UTC, ecrhc 		no flags Details
patch (9.88 KB, text/plain)
2009-11-13 15:03 UTC, sven.jacobi 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description ecrhc 2007-04-16 14:45:27 UTC 
Hi,
when importing an Excel sheet that contains a text box with vertical text in it
OO changes the text to horizontal.
Here is the original file created in Excel.
http://www2.warwick.ac.uk/fac/soc/economics/staff/faculty/barankay/openofficeproblem.xls
To show what happens this is a pdf file created when opening the file in Excel:
http://www2.warwick.ac.uk/fac/soc/economics/staff/faculty/barankay/verticalfromexcel.pdf
and this is a pdf file created when opening the file in OO:
http://www2.warwick.ac.uk/fac/soc/economics/staff/faculty/barankay/verticalfromOO.pdf

I searched hard but could not see this problem resolved elsewhere. Of course it
is possible to then manually edit the text box so that text is displayed
vertically again but that is not ideal. 
I found this in previous versions but it remains in OOo 2.2.
Thanks for considering this issue.
Comment 1 ecrhc 2007-04-16 14:46:39 UTC 
Created attachment 44452 [details]
Original Excel file with vertical text in text box.
Comment 2 ecrhc 2007-04-16 14:47:16 UTC 
Created attachment 44453 [details]
pdf from file when opened in Excel (correct display)
Comment 3 ecrhc 2007-04-16 14:48:01 UTC 
Created attachment 44454 [details]
pdf from file when openend in OO (text changed to horizontal upon import)
Comment 4 crolidge 2007-04-16 19:43:45 UTC 
Confirmed this error in OO 2.2 in Windows XP.

Indeed if you double-click the text box, the text goes back to vertical, but
obviously this is not the ideal.... It should be vertical from the very beginning.
Comment 5 frank 2007-04-17 11:26:16 UTC 
Hi Daniel,

please have a look at this one. Excel 2007 displays the text outside of the
textframe while Excel2k3 shows it inside. Maybe a hint for an broken shape ?

Frank
Comment 6 Martin Hollmichel 2008-01-22 07:49:44 UTC 
move target from 2.x to 3.0
Comment 7 daniel.rentz 2009-03-31 11:46:00 UTC 
new target
Comment 8 daniel.rentz 2009-10-28 10:12:52 UTC 
dr -> sj: seems to be equal to internal 160798
Comment 9 sven.jacobi 2009-11-13 15:00:58 UTC 
This issue has been fixed now in cws[impress181].
Comment 10 sven.jacobi 2009-11-13 15:03:49 UTC 
Created attachment 66105 [details]
patch
Comment 11 sven.jacobi 2010-01-08 14:17:48 UTC 
sj->oc: this issue is ready to be verified in cws[impress181]
Comment 12 oc 2010-01-21 11:55:28 UTC 
verified in internal build cws_impress181