Created attachment 147753 [details] .xlsm file to reproduce the problem Steps to reproduce: - open the attached .xlsm file in Calc - go to D6 => you can see that D6=SUM(E6:AJ6)/8 but calc reports '0' as value. This is incorrect. - now copy D5 and paste in D6 => now the correct value is reported, while the formula is the same than before.
Created attachment 147758 [details] .xlsm file to reproduce the problem A more explicit way to reproduce the problem: - open the attached .xlsm file - go to D7 and type =D6 - now go to E6 and type 2 => D6 stays at 0 while it should be 0.25
Thank you for reporting the bug. I can confirm that the bug is present in Version: 6.3.0.0.alpha0+ Build ID: 3c964980da07892a02d5ac721d80558c459532d0 CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45 Locale: en-US (en_US); UI-Language: en-US Calc: threaded
Created attachment 147763 [details] sheet1.xml cell d6 (In reply to Frederic Parrenin from comment #0) please check "Recalculation on File Load" settings in menu Tools/Options.../LibreOffice/Formula. i guess your selection is "Never recalculate". and attached xmls has value "0" stored inside "sheet1.xml". a full hard recalc Ctrl+Shift+F9 will update the D6 to 8,625. IMHO this is not an issue.
Created attachment 147764 [details] excel protected view opening attached file with ms excel 2016 will open in protected view and show "0" too. D6 value will change as soon as i allow editing
Olivier, please see my second comment. The calculation is not updated even if you modify the sheet.
(In reply to Frederic Parrenin from comment #5) > Olivier, please see my second comment. The calculation is not updated even > if you modify the sheet. i can confirm the problem with your second example file. one has to use ctrl+shift+f9 to get the correct result. adding issue to "(Calculate) - [META] Calculate bugs and enhancements" @Xisco: is it possible that someone can take this ?
Hello, I confirmed your reporting both bugs in also macOS Sierra. Version: 6.1.3.2 Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb CPU threads: 4; OS: Mac OS X 10.12.5; UI render: default; Locale: en-US (ja_JP.UTF-8); Calc: group threaded
Reproduced back to Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) but not in LibreOffice 3.5.0 Build ID: d6cde02
Bibisected on Linux with 43all to https://gerrit.libreoffice.org/plugins/gitiles/core/+log/bed0447cefb949fc77cfde7543397d96590082ba..a581d31b227623e09d2970a91214fda398f98eda It has some Calc / xlsx changes, but not sure which could be the cause.
this issue (-> comment #1) is no longer reproducible with: Version: 6.3.0.0.alpha0+ (x64) Build ID: 3140194a85fe4a6ac69c8cddc4d3b019430cd6e8 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: threaded -> D6 and D7 now have value 0.25
Thanks for testing. Eike: was this fixed with the commits towards bug 120013?
That's bug 123736. *** This bug has been marked as a duplicate of bug 123736 ***