Bug 138080 - formulas aren't updating when editing amounts. I track my budget in LibreOfficeCalc.
Summary: formulas aren't updating when editing amounts. I track my budget in LibreOff...
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.2.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-09 04:19 UTC by Lucy
Modified: 2020-11-11 08:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
current month from my budget file to show error (25.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-11-09 04:25 UTC, Lucy 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Lucy 2020-11-09 04:19:51 UTC 
Description:
when i edit an amount in a column on the spreadsheet, my final total of actual budget to actual spent does not update until I save the worksheet.  it never did this before.  each month of my budget is a separate sheet within my file and all of the formulas have updated automatically upon changing or adding in a new number.  this is something new for me

Actual Results:
I can't do that without giving you my spreadsheet

Expected Results:
I've had to do the save to update the formula total several times.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.2.2 (x64)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 Lucy 2020-11-09 04:25:01 UTC 
Created attachment 167106 [details]
current month from my budget file to show error
Comment 2 Lucy 2020-11-09 04:27:45 UTC 
Comment on attachment 167106 [details]
current month from my budget file to show error

cell M21 is where the problem is
Comment 3 m_a_riosv 2020-11-11 08:55:07 UTC 

*** This bug has been marked as a duplicate of bug 137248 ***