[Libreoffice-bugs] [Bug 112433] New: Recalculate and Autorecalculate

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 112433
           Summary: Recalculate and Autorecalculate
           Product: LibreOffice
           Version: 5.4.1.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jrroyal8 at gmail.com

I just installed version 5.4.1.2 yesterday 9/16/2017 on my 32 bit Windows x86
computer. 

I was ASTONISHED that the calc spreadsheet STILL has a massive bug in which the
sheet is NOT always recalculated when new data is input!  This happens even
when "auto recalculate" is turned on.  
I have to FORCE the page to recalculate by pressing  CTRL SHIFT F9

This is extremely dangerous.  It results in unreliable results, errors, etc.  
Spreadsheets are used in many businesses.   Imagine the disasters of having a
spreadsheet that is producing incorrect results?   EEK!   People could easily
lose their life's savings.. businesses could easily go bankrupt.  

This is NOT a new bug.  I found people complaining about this problem in the
forums for at least a year.  

Even more disturbing.. if such an obvious error exists.. and has not been
fixed.. how is someone supposed to have any confidence in the results of the
spreadsheet's calculations?   Are those random numbers really random?   Are the
trigonometry functions using the right table of values?  

At the very LEAST, there should be a programmable key to recalculate the
spreadsheet.   I would suggest the  = key, or the F9 key, instead of having to
use two hands and 3 keystrokes to press CTRL SHIFT F9

In my case, the error shows up most often when doing subtraction and division

-- 
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/20170916/c62dd5ee/attachment-0001.html>