Apache OpenOffice (AOO) Bugzilla – Issue 124479
XLSX (MSO2007): custom shape has wrong size and text in custom shape has wrong rotation
Last modified: 2014-04-24 01:32:53 UTC
Created attachment 82942 [details] custom shape rotated, text rotated The attached document contains three custom shapes. The left example has the default settings. The middle example is rotated by 90°, the text remains in the default orientation. The right example is rotated by 90° and in addition the whole text is rotated by 270°, which is one of the settings in Excel. All angle values are those from the UI. I have not looked, whether they are different in file format. The file contains in addition a screenshot from the view in Excel 2010. Open the file. Notice, that the rotated shapes have wrong size and that the 270° rotated text is upside down. For a draw:custom-shape the draw:enhanced-geometry has an attribute draw:text-rotate-angle, which would be responsible for the text rotation. I have not tested yet, whether a similar file in ODF file format would render correctly. LO has problems too, see https://bugs.freedesktop.org/show_bug.cgi?id=76456
Right hand side shape differs from given screenshot. AOO410m14(Build:9760) - Rev. 1573062 2014-03-01_04:11:01 - Rev. 1573123 Debian
Still Reproducible with server installation of "AOO 4.1.0-Beta – English UI / German locale - [AOO410m14(Build:9760) - Rev. 1577236 2014-03-15]" on German WIN7 Home Premium (64bit)", own separate user profile. Already Reproducible with sever installation of "OOo 3.3.0 English UI / German locale [OOO330m20 (Build 9567)]" on WIN7 Home Premium (64bit) DE Any other spreadsheet software has problems here. I tried to find rotation info in the document source, but I failed I think that roots of wrong shape size and wrong text rotations are different, but I don't know. @Regina The rotation angles mentioned in your example above the shapes do not match with common use "counter clockwise = positive values". Did you cite the angles from Excel UI?
@Rainer: Yes, the angle values are those given in Excel 2010 UI.
@Regina: If you have a built version of aw080, maybe you culd take a look; I already corrected some stuff there for which having full transformations really makes thins easier...
@Armin: I've got a aw080 build now :). It worse there. The text area is not rotated. I'll attach sreenshots from trunk revision 1587823 and from aw080 revision 1586329.
Created attachment 83236 [details] How the attached .xlsx document looks in build from trunk r1587823
Created attachment 83237 [details] HOw the attached .xlsx document looks in build from aw080 r1586329
Thanks Regina (and good that you have an aw080 build), I will have a look as soon as possible
The position problem in aw080 is now issue 124728.
Created attachment 83264 [details] Only the case 270° is wrong, case 90° is OK
Created attachment 83265 [details] Same shapes in PowerPoint The shape shows the same wrong text rotation in PowerPoint, but the shape size is correct for the .pptx file. Text rotation has already been handled in issue 119920 (commit 1389432). It seems to me, that the error is not the question, whether to use * -1 in oox/source/drawingml/shape.cxx#487. Where is OOXML 'a:bodyPr rot="vert270"' translated to an angle?