https://bugs.documentfoundation.org/show_bug.cgi?id=124669
--- Comment #6 from b. <newbie...@gmx.de> ---
can confirm comment 5,
funnily in my system the settings to recalculate on load are specialised /
restricted to 'Excel 2007 and newer', and 'ODF spreadsheet (not saved with
LibreOfficeDev', thus normally shouldn't make a difference ... may be right as
we don't know with which program the file was saved,
checked with ver 4.2.... too, with 'recalculate' correct results, without shown
number doesn't fit with formula.
two points:
- it would be nice to have a warning towards the user whenever (s)he's dealing
with files that contain deviations between formula and formerly stored values,
- the comment 'odf spreadsheet (not saved with libreoffice)' looks outdated,
the setting produces different evaluation of the file even after saving it with
a different name from inside calc, thus neither 'excel' nor 'not saved with
libreoffice' are matched ... despite that calc does! do a new calculation of
the values with this option set, and doesn't if not set. someone should check
under which conditions recalc is triggered, check if that's the intended logic,
and either correct the handling of files or the comments in the setting dialog.
reg.
b.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
