Bug 160166 - No automatic recalc
Summary: No automatic recalc
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-12 12:55 UTC by Emanuell Althuis
Modified: 2024-03-28 06:38 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Emanuell Althuis 2024-03-12 12:55:07 UTC
Description:
Once upon a time, LO would recalculate the formulas when a new number was entered,this does not happen,  in fact no recalc takes place at any time. Thus all totals remain as before.

Steps to Reproduce:
1cell a7 has formula






The total cell a7 contains =a3+a6, a6 contains $300.00 entered in a3 is 25 (this is a currency field), 




2.
3.

Actual Results:
No result fields are updated

Expected Results:
The total field did not change


Reproducible: Always


User Profile Reset: No

Additional Info:
Enter 325 in cell A6
Comment 1 ady 2024-03-12 16:14:36 UTC
Try using "Recalculate Hard" ([CTRL]+[SHIFT]+[F9]) _twice_.

Other than that, LO 7.3 will not receive any new patches from TDF. You might want to evaluate whether to update to a newer version (with its own problems).
Comment 2 Stéphane Guillou (stragu) 2024-03-28 06:38:39 UTC
As well as ady's suggestions (update to 24.2 or 7.6; use recalculate), please provide an example document.
Some formulas behave differently regarding when their results are updated.