[Libreoffice-bugs] [Bug 137784] New: LibreOffice 7.0.2 Not Auto Calulating

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137784
           Summary: LibreOffice 7.0.2 Not Auto Calulating
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: travismbrown at gmail.com

Description:
When I enter a formula in a cell based on another cell... i.e. in e9: =e8+d9
and I enter a new value in d9, that particular cell (e9) will calculate but all
the cells below (same formula copied down the row to keep a running total of
the values entered in column d).  It is as if the auto calculate only goes
across the row but not down the column.  I have verified the auto calulate is
turned on, and even turned on the always calculate options for older file
version (which this is not).  Pressing F9 does force the calculation, but no
matter the auto calculate setting, my sheets do NOT auto calculate.

Steps to Reproduce:
1. enter a formula in a column of cells (i.e. column D) that adds the above
cell total to the value in the cell in the column to the left (i.e. column C)
2. enter values in column C.
3. column d should maintain a running total, but it only does this on the
initial entry into column C.... if I then go to the top and change one of the
column C entries, only that rows column D total updates, the ones below do not.

Actual Results:
Only the total in the same row as the entry was made in Column C did the total
in column D update... the values in the below column D cells did not, and they
should have since this is a running total... cell D formula is =D1+C2 and so
on.  Pressing F9 works.

Expected Results:
The values in column D should total the values above it in column C.  This
worked on the prior version of Libreoffice, and has never been an issue
previously.  It seems like auto calculate is disabled even though it is turned
on.  Pressing F9 works.


Reproducible: Always


User Profile Reset: No



Additional Info:
n/a

-- 
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/20201027/612d95d2/attachment.htm>