[Libreoffice-bugs] [Bug 125052] Data error risk from not calculating on large spreadsheets

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125052

--- Comment #14 from Vincent Cackowski <vincepc99 at outlook.com> ---
Recently upgraded to 7.0.2.2 and this problem is persisting from previous
version.  Misleading results due to not recalculating.  Only started
encountering this problem fairly recently.  Even forcing recalc doesn't always
get good results.  Am attaching sheet.  Look at column G in Activity sheet. 
Change values in col E and note problem in col G.  Problem doesn't show up upon
opening a clean file, only after manipulating data in various sheets.
Instructions on how to manifest problem in this sheet:
This spreadsheet is used to track carbs and glucose for a diabetic.
Note that yellow background cells (and yellow brown) are input cells.
Go to Sheet "Data"
Enter 2 or 3 values in col B, noting proper range values from col D.
Go to sheet "Activity"
Cells E51-E58 an E63 contain data based on the above input.
copy those values directly to corresponding cells in col F.
Note that E59 did not recalculate.  You can double click that cell and force it
to recalculate.
Go to sheet "Activity"
Enter a value in E14 ( a fraction of an hour)
Note that Col G updates correctly but the rest of col G should also update and
it does not do so correctly.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201023/076dc5fe/attachment.htm>