You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2016/08/03 06:43:23 UTC
[Issue 127059] New: Saving a xls
https://bz.apache.org/ooo/show_bug.cgi?id=127059
Issue ID: 127059
Issue Type: DEFECT
Summary: Saving a xls
Product: Calc
Version: 4.1.2
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: Major
Priority: P5 (lowest)
Component: save-export
Assignee: issues@openoffice.apache.org
Reporter: brian.guralnick.1@hotmail.com
Created attachment 85621
--> https://bz.apache.org/ooo/attachment.cgi?id=85621&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127059] Saving a xls, then, reloading an .xls messes up the
orientation of numerous graphical arrows and text boxes.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127059
--- Comment #5 from Brian <br...@hotmail.com> ---
Thanks for looking at my example. I have a massive spreadsheet which is part
of a patent application which I'm sending to my Patent agent for proofing &
editing. Both him as well as many other legal firms seem to explicitly demand
Office format for all documents I exchange with them. This is the first time I
will be exchanging documents containing text with graphics & symbols &
drawings.
In a sense, If I could only get a quality transfer of my document with minimal
errors into MS Office, I would would work from there on in, but, we are talking
about 20 pages of text plus 17 pages of spreadsheets with contents like my
example above.
I see I have a few days of editing and correcting to do here. A clean 2 way
compatible solution would have really been nice where I could continue using
Openoffice.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127059] Saving a xls, then, reloading an .xls messes up the
orientation of numerous graphical arrows and text boxes.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127059
orcmid <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
CC| |orcmid@apache.org
Status|UNCONFIRMED |CONFIRMED
--- Comment #4 from orcmid <or...@apache.org> ---
(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.
[Issue 127059] Saving a xls, then, reloading an .xls messes up the
orientation of numerous graphical arrows and text boxes.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127059
--- Comment #1 from Brian <br...@hotmail.com> ---
I've attached a bugs.ods test file. Open this file, then, save it as a .xls.
Close the document, then, open the .xls. Almost every object will be
incorrectly oriented & misaligned.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127059] Saving a xls, then, reloading an .xls messes up the
orientation of numerous graphical arrows and text boxes.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127059
Brian <br...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Saving a xls |Saving a xls, then,
| |reloading an .xls messes up
| |the orientation of numerous
| |graphical arrows and text
| |boxes.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127059] Saving a xls, then, reloading an .xls messes up the
orientation of numerous graphical arrows and text boxes.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127059
--- Comment #3 from Brian <br...@hotmail.com> ---
Does anyone have a solution? I have a major document I need to export to .xls
for publication & all my graphics and charts end up improper orientation and
misaligned.
The users wont accept open office documents.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127059] Saving a xls, then, reloading an .xls messes up the
orientation of numerous graphical arrows and text boxes.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127059
--- Comment #2 from Brian <br...@hotmail.com> ---
Created attachment 85632
--> https://bz.apache.org/ooo/attachment.cgi?id=85632&action=edit
Sampl .ods file to save and load as .xls.
--
You are receiving this mail because:
You are the assignee for the issue.