https://bugs.documentfoundation.org/show_bug.cgi?id=103532
Michal Kaut <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|WORKSFORME |---
Ever confirmed|0 |1
--- Comment #2 from Michal Kaut <[email protected]> ---
I agree it looks like an updating issue. When I press Ctrl+Shift+F9, the
computed statistics (T10:X18) get updated (the mean is equal to zero as it
should).
However, the values themselves (T19:X1019) are not updated - for example, T19
is still 20.0.
To update this, I have to, for example, add '+1' to the formula (which changes
the value of T19 to 19.7 and then remove it again, to get the correct value.
> Please have a look at menu Tools > Options > LibreOffice Calc > Formula.
> Perhaps the default settings in section "Recalculation on File Load" do not
> work well for you.
The "Recalculation on File Load" section has only items for "Excel 2007 and
newer" and "ODF spreadsheet (not saved by LibreOffice)", neither of which
applies since the file was created in LibreOffice. Anyway, I changed both to
"prompt" and do not get one when I open the file
> And look in menu Data > Calculate. Is AutoCalculate enabled?
Yes, AutoCalculate is enabled.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
