https://bugs.freedesktop.org/show_bug.cgi?id=81396
--- Comment #11 from Kevin Suo <suokunl...@gmail.com> --- (In reply to comment #9) > With 4.2.5.2 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: > Win7x64 > Version: 4.4.0.0.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 4.4.0.0.alpha0+? I tried with 4.4.0.0.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: http://libreofficechina.org/thread-173-1-1.html > 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. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
