Created attachment 102146 [details]
See attached document.
The document opens OK, everything displays fine.
Save as xlsx, close the file and reopen in LibreOffice.
Cells format is lost, figures are still there but cell format is not good.
Also, figures shown in graph show decimals and format is altered.
Same result when opening in Office form cells format + graphs appear empty.
Seems to be directly related to xlsx export: no issues at all when saving as .ods
Hi Eric, could you attach sreenshot what it's look like within Excel?
I saw different result in 22.214.171.124 and 126.96.36.199 (better) while opening your file.
Looks like issues with format number in chart's axis & label
Created attachment 102601 [details]
Excel display of the example document
188.8.131.52 opens the file OK indeed (great job from the LibreOffice community BTW, compatibility has really improved a lot in the last versions)!
Didn't test yet in 184.108.40.206: we're qualifying 220.127.116.11 before upgrading our users.
I added the requested file in PDF format so you can see how the original document appears in Excel (as you'll see, it looks the same as in LibreOffice 18.104.22.168)
I also added the rendering I get after saving in xlsx format from LibreOffice and reloading it in Calc ou Excel.
Note that the rendering is consistent between Calc (22.214.171.124) and Excel 2010 in both cases, so I just uploaded one file for both.
Created attachment 102604 [details]
Result after saving in xlsx format and reloading the file in Excel ou LibreOffice
Created attachment 102606 [details]
Original file opened in 126.96.36.199
Created attachment 102607 [details]
Original file opened in 188.8.131.52
Eric, please see 2 files I just attached.
184.108.40.206 not opened your original file correctly nor 220.127.116.11. It's different from your original file that was created with Excel 2010 (I saw that in app.xml) :
In 18.104.22.168 differ in:
- Y-axis number format
- all chart label number format
In 22.214.171.124 differ in:
- some chart label number format
*) Indeed we also see another differences, but let we ignore it in this bug report.. :)
I don't know if we can confirm export problem if we see that import problem exist in the file ? Perhaps we better wait for others opinion.
Tested in Ubuntu 12.04 x86
Or..may we just reporting the missing chart data label in 2nd chart while exporting and ignore the number format in this bug report ?
I can confirm the missing chart data label in 2nd (bottom) chart after saving & reopening file. Both with 126.96.36.199 and 188.8.131.52
You're right: there are 2 bugs in this report.
Let's keep this one open but just for the graph format problem.
I'm changing the summary to reflect the graph format problem only and I'm creating a new bug for the cell formats with a test file without graphs.
Ok setting component Chart, change platform All, set status NEW.
(please be noted, according to my languange setting, my screenshots show "." as thousand separator)
Export bug maybe similar to Bug 74112.
I haven't found similar duplicate regarding wrong number format in chart import.
Please retest with master/5.0 and check if that still does not work and add me into CC if that is the case.
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice
(5.1.5 or 5.2.1 https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and
your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
After reading this bug, I don't know what it's about.
"Document not OK" and "graph format altered" and "some number format" are not precise descriptions.
What I see it that was reported as Filesave but then converted to Fileopen. But for what exactly, not clear.
Fileopen differences I see in 6.4+:
- Y-axis number format: MSO opens 4000, LO 4.000? I wouldn't count that a bug.
- all chart label number format: I guess this relates to "précision :..." subtitle part of the 1st chart title; looks like direct formatting not recognized by LO; looks like a (minor) bug here.
- some chart label number format: MSO shows 5292,567890 and LO 5293. Also not a bug to me.
Filesave is another bug. If you agree, I'll report separately.
As noted in bug 127589 I opened for newer missing data regression, chart title is bug 78027.
Let's close this one and wait for bug 127589 after which we need to test filesave.
As I wrote, I don't find other 2 number format differences an issue.
Should someone find something missing, feel free to explain and set back Unconfirmed.