https://bz.apache.org/ooo/show_bug.cgi?id=127059
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 CC| |[email protected] Status|UNCONFIRMED |CONFIRMED --- Comment #4 from orcmid <[email protected]> --- (In reply to Brian from comment #0) > Created attachment 85621 [details] > Screenshot. > > When saving as an .xls, then re-loading the .xls, all the rotation and sizes > and position of my drawn arrows and text boxes are messed up. See attached > photo, errors are circled in red. > > I'm running 4.1.2 on Win 7. What's interesting is that Excel and OpenOffice mostly agree on their presentation of the .xls version. I took your Sample, Bugs.ods and opened it directly in Excel 2016 (as .ods). It has the vertical line 180 degrees off. Likewise, the 45 degrees up shows in Excel as 45 degrees down, not up. Finally, the pointing down braces are pointing up. There is definitely an interoperability conflict on the ODF Spreadsheet format with regard to what you did in Calc and how Excel interprets the identical ODF Spreadsheet format. I agree, when saved as .xls by OpenOffice, it is much worse in Excel and OpenOffice. The orientations are just wrong. Here's a question for you. If you have an user who insists on Excel format, why not satisfy the user and be assured of interchange fidelity by using Excel? There have to be shorter-terms solutions that will give you relief. There is not going to be a solution to this using Calc in any practical time frame for you. -- You are receiving this mail because: You are the assignee for the issue.
