Apache OpenOffice (AOO) Bugzilla – Issue 119537
[From Symphony]<Shape><Extrusion>The Extrusion direction of shape can't be saved correctly
Last modified: 2012-12-26 08:37:53 UTC
Created attachment 77745 [details] Sample file 1. Launch AOO3.4 and open the sample file; 2. Save it to a new .xls file. 2. Open the new file and Compare the Extrusion direction of custom shape with the oringnal in MS Office Word 2003 Defect: The Extrusion direction of custom shape was saved incorrectly
I am investigating this issue.
I have tried the 9 kinds of extrusions direction in Excel 2003. Only for the 1,4,8 and 9 extrusion direction, AOO cannot export them successfully. There is no a individual property to express the 9 directions. A direction is described by two property "view point(X,Y,Z)" and "origin(X,Y)". Root cause: when import, AOO does not set a correct view point x/y and origin x/y into to core function. So when export, an incorrect x/y is exported. Excel 2003 cannot recognize them. Solution: When import, set a correct view point x/y and origin x/y into core function for the four(1,4,8 and 9) extrusion directions. For 1 and 4, view point x and origin x is not set(default). For 8 and 9, view point y and origin y is not set(default). When we set those values to core function, need set a correct value for them to prepare a correct value for export. Please check the attachment "root cause.ods". It is a result when import. To compare with the one which can be imported correctly. We can know the default value should be: view point X: 1250000 view point Y: -1250000 origin X: 32768 origin Y:-32768
1250000=3472.2222222222222*360 32768=0.5*65536 "3472.2222222222222" and "0.5" is the result in attachment for root cause. Above the transformation in code for them. From those relations, default value can be obtained.
Update with detail steps 1. Launch AOO3.4 and open the sample file, check the Extrusion direction, the setting and the Shape display both south east which is same as open in MS office. 2. Save it to a new .xls file. 2. Open the new saved file in MS office, check the shape direction setting, The setting lost, There is no value in the setting. Also the shape display is not same as the original file display in MS office, after we select the direction to south east, it display correct. Defect: The Extrusion direction setting of custom shape Lost after saved the file in AOO and open in MS office.
The default value change for "1250000" has been updated by the fix of issue 119554. Here my fix is only for the default value "32768".
Created attachment 78391 [details] Patch for 3D Extrusion direction
Created attachment 78392 [details] UT file for this issue
Created attachment 78406 [details] Root cause for this defect
Comment on attachment 78391 [details] Patch for 3D Extrusion direction Reviewed and commited in SVN revision 1352497.
Setting status to fixed.
I mixed up two patches (there way to many at the moment). SVN revision 1352497 mentioned above belongs to bug 119903. I have checked in the patch for this issue in SVN revision 1352519.
Verify fixed on revision 1374181.
Close this bug