https://bugs.documentfoundation.org/show_bug.cgi?id=151475
Bug ID: 151475
Summary: Libre Office Calc Fails to auto calc cells after
adding new column
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a finance spreadsheet that I use to manage my personal finances. All
data cells are formatted as numbers. Each column represents a paycheck and
starts with a total row followed by category rows and finally a total expense
row and net row.
The first row and each category row are set manually, but the total expense row
should be calculated by the SUM of all category cells in that column, and the
net row should be that column's total - total expense (e.g. A4-A24).
I needed to insert a new column for September, so I did and copied my
formatting and equations from the previous column. Unfortunately, the autocalc
feature does not work on this new column. When I change the values of the
manually entered cells (V4 through V23) the cells that reference them do not
update.
Steps to Reproduce:
1. Create table with dummy data formatted as numbers and a row at the bottom to
sum the data above
2. insert a new column
3.Copy function over to new column and change data in the new column's cells
Actual Results:
The function cells did not register changes to the cells the referenced.
Expected Results:
The autocalc feature should have automatically updated my SUM cell to reflect
changes to my data
Reproducible: Didn't try
User Profile Reset: No
Additional Info:
I tried disabling and re-enabling autocalc for all related cells. It did not
work.
--
You are receiving this mail because:
You are the assignee for the bug.
