Bug 138080

Summary:	formulas aren't updating when editing amounts. I track my budget in LibreOfficeCalc.
Product:	LibreOffice	Reporter:	Lucy <porkchopbombarger>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.0.2.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	current month from my budget file to show error

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 ***