Bug 147468 - sheet is not recalculated when value is changed
Summary: sheet is not recalculated when value is changed
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2022-02-16 16:01 UTC by VLB
Modified: 2022-03-03 16:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
sheet isn't recalculated (2.21 MB, application/vnd.oasis.opendocument.spreadsheet)
2022-02-16 16:01 UTC, VLB
Details

Note You need to log in before you can comment on or make changes to this bug.
Description VLB 2022-02-16 16:01:07 UTC
Created attachment 178314 [details]
sheet isn't recalculated

Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 16; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL

step to reproduce

1) open sheet
2) go to cell f19
3) change the cell to 8
4) go to cell v66 + w66 + x 66
5) the cell are didn't calculated correct
6) when do ctrl+sift+F9 the cell are calculate correct
Comment 1 VLB 2022-02-16 16:05:56 UTC
LO 7.2 works correctly
Comment 2 Timur 2022-02-16 21:11:43 UTC
So reporter's is Windows 11. To be checked both in 11 and previous Windows.
Comment 3 VLB 2022-02-17 15:09:00 UTC
I also tested it in windows 10 and the bug is also present.

Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: threaded
Comment 4 raal 2022-02-17 18:27:15 UTC
Tested with Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 8942956e05f2208ffb666a2118f5db092c30ce6a
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
and cannot reproduce.

cell v66 = -6,1

@Xisco, can you retest on Windows, I saw similar report somewhere.
Comment 5 VLB 2022-02-17 18:46:46 UTC
I also tested it in windows 11 in LO7.4 alfa and can't reproduce the bug here.

Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 59ac648a1482d9422b8f279bcb284a214032f5cf
CPU threads: 16; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL
Comment 6 Timur 2022-02-18 07:32:13 UTC
So if bug is gone in master 7.4+, that's WFM.
Comment 7 VLB 2022-02-18 07:39:24 UTC
That means that LO version 7.3 is no longer suitable to use and is unreliable!

Unfortunately
Comment 8 raal 2022-02-18 07:59:45 UTC
(In reply to VLB from comment #7)
> That means that LO version 7.3 is no longer suitable to use and is
> unreliable!
> 
> Unfortunately

Usually it's fixed in minor version 7.3.1, 7.3.2 etc.
Comment 9 Xisco Faulí 2022-02-18 15:19:17 UTC
(In reply to raal from comment #4)
> Tested with Version: 7.4.0.0.alpha0+ / LibreOffice Community
> Build ID: 8942956e05f2208ffb666a2118f5db092c30ce6a
> CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3
> Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
> Calc: threaded
> and cannot reproduce.
> 
> cell v66 = -6,1
> 
> @Xisco, can you retest on Windows, I saw similar report somewhere.

Yes, it's fine in

Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: ccbd2b0c663fa19be5301f0ea8ac74caa055fe47
CPU threads: 16; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded
Comment 10 Xisco Faulí 2022-02-18 15:24:15 UTC
I can't reproduce it in

Version: 7.3.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 229123ccc6f90ebf66b3e659bebbd53f8a9bdd3a
CPU threads: 16; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded

either.
Not sure whether it's a real issue.
@VLB, To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test?
Comment 11 VLB 2022-03-03 16:06:56 UTC
(In reply to Xisco Faulí from comment #10)

> either.
> Not sure whether it's a real issue.
> @VLB, To be certain the reported issue is not related to corruption in the
> user profile, could you please reset your Libreoffice profile (
> https://wiki.documentfoundation.org/UserProfile ) and re-test?

I didn't reset the user profile, but just waited for version lo 7.3.1.3.
The issue is not present in this version.

Version: 7.3.1.3 (x64) / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 16; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL