https://bugs.documentfoundation.org/show_bug.cgi?id=137060
Bug ID: 137060
Summary: VIEWING Cells with formula not correctly updated after
change of source value
Product: LibreOffice
Version: 7.1.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: stefan_lange...@t-online.de
Created attachment 165876
--> https://bugs.documentfoundation.org/attachment.cgi?id=165876&action=edit
zip file with document to reproduce the bug and screenshots
Cells with formula values are not correctly updated when source values are
changed. More precisely: Some (one or few) but not all cells with formula
depending on a source value are updated after a change of the source value.
The cells are update later e.g. when the document is saved or when the cells
are redrawed after roll them out and in.
How to reproduce (2 ways):
First way:
- open document "Test_Formula_(Corona_Statistics).ods" from attached zip file
- select rows with "Deutschland" in column A via autofilter
- change value in cell B7 e.g. by deleting the leading "8" from "83.517.046" to
"3.517.046"
- result: values in cells D42, E42, I42 and J42 are updated but the values in
D59/D76, E59/D76, I59/I76 and J59/J76 remain unchanged -> see screenshots 1 and
2
- scroll downwards that visible rows are rolled out to the top and scroll
upwards to roll in the rows rolled out before
- result: The values in cells D59/D76, E59/D76, I59/I76 and J59/J76 are updated
now -> see screenshot 3
Second way:
- open document "Test_Formula_(Corona_Statistics).ods" from attached zip file
- select the rows from 87 to 103 and insert rows above -> 17 empty rows are
inserted (87...103)
- select rows from 70 to 85 and copy them to the clipboard
- insert clipboard content into the empty rows 87 ... 103 inserted before
- change value in cell B87 - e.g. to the current date
- result: From the cells in column K (set by formula to the value of B87) omly
K88 is updated, all other (visible) cells are unchanged -> see screenshots 4
and 5
- scroll downwards that rows from 87 to 103 are rolled out to the top and
scroll upwards to roll in the rows rolled out before
- result: All values in cells K88 ... K103 are updated now -> see screenshot 7
The bug was found in LOdev 7.1 but earliest version with the bug is 7.0.2 rc1:
Version: 7.0.2.1 (x64)
Build ID: ede20268f3f8777cdf69e0281835d320c41213fc
CPU threads: 4; OS: Windows 10.0 Build 20221; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL
In version 7.0.1 and earlier versions (LO 3 ... LO 6) I cannot reproduce the
bug.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
