https://bugs.freedesktop.org/show_bug.cgi?id=86572
--- Comment #6 from vlb <[email protected]> --- (In reply to raal from comment #5) > (In reply to vlb from comment #2) > > Created attachment 109867 [details] > > Issue calculation > > > > Steps to reproduce: > > > > 1) When you open the file the calculation is correct. > > 2) Go to sheet "invoer" cell L19 and change the value to 4 > > 3) Go to the column BQ in sheet "eg" and see in cell BQ9 and BQ10 and some > > other cells are not correct calculation > > changed invoer.L19 = 3 > eg.BQ9 = 9985 > eg.BQ10 = 9830 > > changed invoer.L19 = 4 > eg.BQ9 = 10774 > eg.BQ10 = 10613 > but I need to do hard recalc CTRL+SHIFT+F9. Setting as NEW because hard > recalc needed. > > Is value 10774 and 10613 correct with invoer.L19 = 4? Yes this is correct and i see when you do hard recalc CTRL+SHIFT+F9 the value's are correct. > > > > 4) when you delete the value's in Cell G19:M19 and put the value's in Cell > > G19=5, H19=4, I19=3, J19=3, K19=3, L19=3, M19=1 and go to column BQ in sheet > > "roX0_9" and see in cell BQ11 and BQ12 and BQ13 the value's 0. This isn't > > correct. > > I have values > -1539,51 > -1527,62 > -1515,73 > Doesn't see bug here. When is doesn't do hard recalc CTRL+SHIFT+F9 the value's are wrong. But when you do hard recalc CTRL+SHIFT+F9 the values are in roX0_9 BQ11:BQ13 -1480 -1465 -1456 > > Version: 4.4.0.0.alpha2+ > Build ID: d273a60bfdbf9bb7623bed38667ec0647753157c > TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: > 2014-11-20_03:05:21 When do hard recalc CTRL+SHIFT+F9 the issue 86321 is than already oke. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
