Bug 158955 - Copy-paste of cells in libreoffice calc don't work correctly: the formulas are correctly updated, not the results
Summary: Copy-paste of cells in libreoffice calc don't work correctly: the formulas ar...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.4.1 release
Hardware: All Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-01-01 04:36 UTC by ilarialexyos
Modified: 2024-01-01 04:51 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
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 ilarialexyos 2024-01-01 04:36:01 UTC 
Description:
I found this anomaly in libreoffice calc:
I copied the first cell that inside has a function and pasted it in the 35 row under in the same column.
The functions are correctly updated for every cells but not the results of the function.

Actual Results:
To have the correct result in every cells I have to delete a single character in the formula of every cell, and rewrite the same character, then press enter and the results are correct.

Expected Results:
Copy and paste a cell with a formula have to update the formula but also the result, and this was the normal behavior until yesterday.


Reproducible: Always


User Profile Reset: No

Additional Info:
Windows 11, libreoffice 7.6.4.1.
Comment 1 Mike Kaganski 2024-01-01 04:42:12 UTC 
Do you have Data->Calculate->AutoCalculate enabled for the file?
Comment 2 ilarialexyos 2024-01-01 04:44:51 UTC 
Where I find that setting?
Comment 3 ilarialexyos 2024-01-01 04:51:49 UTC 
I found it.

I don't understand why and how this setting was changed...

This is really annoing...

The problem is solved.