Bug 160457 - Calculi don't change results when changing the operation.
Summary: Calculi don't change results when changing the operation.
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
24.2.2.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-01 13:38 UTC by audric.viguier
Modified: 2024-04-03 01:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
You can see that the calculus is J8/L8, the numbers 24 and 40 and that the result is 52.5% instead of 60% (3.38 KB, image/png)
2024-04-01 13:38 UTC, audric.viguier
Details

Note You need to log in before you can comment on or make changes to this bug.
Description audric.viguier 2024-04-01 13:38:08 UTC
Created attachment 193422 [details]
You can see that the calculus is J8/L8, the numbers 24 and 40 and that the result is 52.5%  instead of 60%

Hello,
It's only for one page, but it's really inconvenient :

One of my calculi is 21/40 (J8 / L8). The result was 52.5% and it's normal.
Then I changed 21 to 24 (J8) and the result was still 52.5%, whereas usually it recalculates automatically. I tried to copy a similar division with different numbers and it pasted the result from the aforementionned calculus, yet it was still written "=J8/L8"! I tried to shut the software down turn it on again, nothing has changed. The only thing that works is pressing F9 but having to press F9 everytime I change one number is uncomfortable.

I don't know the origin of this problem but I figured I'll let you know.
English is my second language, so I don't know specific terms and I apologize in advance for any error.
Comment 1 m_a_riosv 2024-04-02 01:14:37 UTC
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.

Looks as you have not active Menu/Data/Calculate/Autocalculate

https://help.libreoffice.org/latest/en-US/text/scalc/01/06070000.html?DbPAR=CALC#bm_id3145673
Comment 2 audric.viguier 2024-04-02 17:31:50 UTC
Hello, 
I have updated the software recently, and I didn't think about that. Autocalculate was indeed not active. Works perfectly fine now, thank you!