Created attachment 102146 [details] Example file 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 Best Regards, Eric Ficheux
Hi Eric, could you attach sreenshot what it's look like within Excel? I saw different result in 4.3.0.2 and 4.2.5.2 (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
Hi Christian, 4.2.5.2 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 4.3.0.2: we're qualifying 4.2.5.2 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 4.2.5.2) 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 (4.2.5.2) and Excel 2010 in both cases, so I just uploaded one file for both. Best Regards, Eric Ficheux
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 4.2.5.2
Created attachment 102607 [details] Original file opened in 4.3.0.2
Eric, please see 2 files I just attached. 4.2.5.2 not opened your original file correctly nor 4.3.0.2. It's different from your original file that was created with Excel 2010 (I saw that in app.xml) : In 4.2.5.2 differ in: - Y-axis number format - all chart label number format In 4.3.0.2 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 4.2.5.2 and 4.3.0.2
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. Best Regards, Eric Ficheux
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) http://downloadarchive.documentfoundation.org/libreoffice/old/ 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! Warm Regards, QA Team MassPing-UntouchedBug-20160920
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.
Created attachment 192453 [details] tdf#80816 graph background differ Excel 365 vs LO 24.2 (In reply to Timur from comment #15) > Should someone find something missing, feel free to explain > and set back Unconfirmed. Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win Locale: pl-PL (pl_PL); UI: pl-PL Calc: CL threaded What I can see in context of this bug (and Example file (attachment 102146 [details])) is that drawing area of chart has different color than in Excel. In Excel -> white In LO ----> green
Still the case in recent master build: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: https://ban-box.com/ CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
Thank you for submitting this bug. I can confirm that it is still present in Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded as well as Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded