Open a spreadsheet and create two columns of data. Plot the data on a line chart. Annotate chart. Plot is visible and annotations including axis and grid settings are working. Save and close sheet. Re open sheet. When loaded the chart and data and grid and annotations are present but the plot is not visible on the grid. Only one point is visible and is the last data point on the columns of data. Using MS office open and save formats (xlsx in this case). Have not tried native format.
Also picking a file to open from a file explorer list always opens the libra office file behind the file explorer window which is annoying.
Win 7 x64
All updates for win 7 installed.
version 126.96.36.199 just installed.
Created attachment 102886 [details]
test ods file with chart
when I plot a line chart and save as XLSX, the plots are not missing, but the plot color are changed.
Steps to observe:
1. Save the attached ods file to XLSX.
So: please confirm whether the plots are missing, or the plots color are changed (to white?) so that you can not see them.
Open test chart.ods file.
Plot shows diamonds as orange and squares as dark blue.
Save as MS XLSx.
Open xlsx file and plots are rendered in light blue for both plots not
orange and dark blue as before.
Open Test chart.ods file.
Change plot to connect dots.
Save as ms xlsx. Won't let me save. xlsx and other forms not on pick
list. Had to save ods, close ods and reopen then save to xlsx.
Open xlsx file and find no change to plots. Colors as in ods and dots
In my file I am plotting one column of data against another column not
against the cell number as you show in the test file. In my case the
plot is gone except for one dot which is the last data point in the two
columns. I moved the mouse around hoping to hit another data point in
case it was white but no go. Opening the data series format dialog
shows the original dark blue color so it has not changed. There seem to
be several bugs causing multiple but similar behavior.
On 7/15/2014 9:32 PM, firstname.lastname@example.org wrote:
> *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=81396#c1>
> on bug 81396 <https://bugs.freedesktop.org/show_bug.cgi?id=81396> from
> Kevin Suo <mailto:email@example.com> *
> Createdattachment 102886 <attachment.cgi?id=102886> [details] <attachment.cgi?id=102886&action=edit>
> test ods file with chart
> Hi Tom,
> when I plot a line chart and save as XLSX, the plots are not missing, but the
> plot color are changed.
> Steps to observe:
> 1. Save the attached ods file to XLSX.
> So: please confirm whether the plots are missing, or the plots color are
> changed (to white?) so that you can not see them.
> You are receiving this mail because:
> * You reported the bug.
Tom, please attache an (ods) file from which we can reproduce the data series lost issue. I am not able to repro from scratch.
PS. next time you make comments in this bug, please do it directly from the webpage, replying from email will add unwanted information to bugzilla.
(In reply to comment #2)
> Open Test chart.ods file.
> Change plot to connect dots.
> Save as ms xlsx. Won't let me save. xlsx and other forms not on pick
I do not confirm this. XLSX is in the pick list. Are you sure you are saving using libreoffice, not Apache OpenOffice? (AOO do not have xlsx in the list).
Created attachment 103011 [details]
test ods file
Tom has send me a test file. Based on his file, I can now confirm this critical bug.
Steps to reproduce:
1. Save the attached test ods file as xlsx;
2. Reopen the xlsx file in libreoffice.
All plots are not shown, except the one plot which has no formula in it's cell.
A CTRL+SHIFT+F9 will bring all plots back again.
The exported xlsx file opens fine in MSO 2010, so this is an XLSX IMPORT problem.
This affects all chart types.
Version: 188.8.131.52.0+, Build ID: 5536b127a105123de6f64dcf8f53dfa277faef3c, TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-07-16_10:15:31
and 184.108.40.206, Build ID: 5fdddf655fba363e34f755715238d0943a44857e
Windows XP SP3.
The exported xlsx file opens file in Apache OpenOffice 4.2. It's a possible regression.
Created attachment 103012 [details]
the exported XLSX file
(In reply to comment #5)
Tested with attached file,
Also confirm that hard recalc needed in: 220.127.116.11, 18.104.22.168
Not reproduced in: 22.214.171.124 (plot & line still exists, but charts slightly stretched after saving)
IF reproduce from scratch with XY chart,
Hard recalc not resolved the issue in: 126.96.36.199, 188.8.131.52, 184.108.40.206
Issue solved with hard recalc in: 220.127.116.11
Plot & line still exist in 18.104.22.168 with attached file, but missing if reproduce from scratch. Perhaps not a regression.
Tested under Ubuntu 12.04 x86
With 22.214.171.124 changing the option in:
Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file load Excel 2077 and newer to always recalculate, do the job.
Works for me with:
Version: 126.96.36.199.alpha0+ Build ID: 32551a546c83874f08aba9c0adb7a38230fa2e36
TinderBox: Win-x86@39, Branch:master, Time: 2014-07-19_07:47:52
I think this option was implemented to reduce the loading time with large files. Hard recalc is an usual action in calc, in fact some functions need it to be recalculated.
OTH, It's not too much clear for me why this one is in MAB, I think we need to be more strict about that, not the first developer commenting about he doesn't take too much care on MABs.
I think the problem now is how to find the patch to ask the dev for backport at least to 4.3
Yes if we set "Always Recalculate" to Excel 2007 and newer, it works as expected.
Confirmed in 188.8.131.52 and 184.108.40.206
But I think not many users know about this, maybe some notice in release notes or documentation would be helpful to many users.
(In reply to comment #9)
> With 220.127.116.11 changing the option in:
> Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file load
> Excel 2077 and newer to always recalculate, do the job.
Yes this is true, but it's only a workaround.
> Works for me with:
> Version: 18.104.22.168.alpha0+ Build ID: 32551a546c83874f08aba9c0adb7a38230fa2e36
> TinderBox: Win-x86@39, Branch:master, Time: 2014-07-19_07:47:52
I am not sure what you mean by "works for me". Does the chart loaded with all plots shown correctly when you open with 22.214.171.124.alpha0+?
I tried with 126.96.36.199.alpha0+ TinderBox: Win-x86@42, Branch:master, Time: 2014-07-21_06:04:54, it's the same bug behaviour.
> I think this option was implemented to reduce the loading time with large files.
Under "Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file load", it's also set as "Never" for ODS format, but chart loads OK in ODS file.
I think it may be related.
It's OK to implement sth to speedup the loading of xlsx file, but should make sure that what we see are corroct. (For this case, the chart shown is totally wrong!)
> Hard recalc is an usual action in calc, in fact some functions need it to be recalculated.
As a normal user, they should never know this. I even do not know the "CTRL+SHIFT+F9" feature before I come to bugzilla and find it in the bug reports in which someone tells to "Hard Recalc".
Also, Hald Recalc is not on the UI "Tools - Cell Contents". What a normal user may find is to use the "Recalculate" submenu, but that does not solve the problem.
Just like Tom S. who reported this bug, he did not find the reason why his chart is showing only one plot. He must have tried his best to find a solution, but did not find it.
I then got his test file, and spent 2 hours and finally find out the reason.
If his speadsheet has formulas in all the cells, there would be not even one plot shown, which will be even harder to find the reason.
See also this one in our Chinese libreoffice discuss forum:
> I think the problem now is how to find the patch to ask the dev for backport
> at least to 4.3
It's still reproducible in daily builds, so no patch.
(In reply to comment #11)
> > With 188.8.131.52 changing the option in:
> > Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file load
> > Excel 2077 and newer to always recalculate, do the job.
> Yes this is true, but it's only a workaround.
I mean, this "XLSX: always recalculate" option is not selected by default in a fresh user profile.
By defalut, "ODS" is also set to "Never recalculate", but shows correct chart when load.
Created attachment 103297 [details]
Configuration that makes it works. registrymodifications.xcu
Investigating a bit, I have found that with 4.4 works for me with the attached configuration file (in the root profile directory), and with a resetting of the user profile not without change the option or with a hard recalc.
But I'm not able to find which option is different in Menu/Tools/Options with this file, perhaps a hidden option makes the difference.
Maybe someone is able to find what it's the option making the difference with the attached file.
still reproducible under Win8.1 using 184.108.40.206.alpha0+
Build ID: 84a6d8eeaab540e5b2ea3baffd919903dff8c247
TinderBox: Win-x86@39, Branch:master, Time: 2014-11-22_23:41:04
moving to mab4.3 list since 4.2.x is end of life
Most likely the fix in https://gerrit.libreoffice.org/#/c/19568/ is correct. Actually I fixed the same problem in the past already.
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":
the cells need to be imported before we handle charts, tdf#81396
It will be available in 5.1.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Bug fixed with:
Build ID: 229583f298b9de05e1ad1727e233d597995099e3-GL
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-11-22_23:09:05
Locale: fr-FR (fr_FR)
Thanks Markus :)
Migrating Whiteboard tags to Keywords: (possibleRegression)
The content of attachment 103297 [details] has been deleted