Download it now!
Bug 131339 - calc: #REF! error condition not evaluated for dependent cells, needs recalc, autocalculate failure
Summary: calc: #REF! error condition not evaluated for dependent cells, needs recalc, ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Calculate
  Show dependency treegraph
Reported: 2020-03-14 17:23 UTC by b.
Modified: 2020-06-09 19:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description b. 2020-03-14 17:23:52 UTC
an error condition injected in the head of a dependecy chain is (sometimes in distinct situations) not evaluated for dependent cells, it needs any recalc to apply to the dependent cells, autocalculate doesn't handle. bug maybe older, i observed it in and tested to be buggy too. 
on a quick check: it looks as if only errors injected above the dependent cells are critical, similar constructions at the left, right or bottom border worked ok. 

Steps to Reproduce:
minimum reproducer: 
0. fresh sheet, 
1. put '=B1' into B2, 
2. observe B2 showing '0' - correct, 
3. copy B2 - ctrl-c, 
4. paste into B1 - ctrl-v, 
5. observe B1 showing #REF! or err:522 - correct, 
6. observe B2 still showing '0' - incorrect, 
7. whenever a cell gets an error condition making it 'uncalculateable' all dependency chains should inherit that and switch to err too, that insn't respected for B2 in this case, 
7a. it is! respected for - at least some - other error conditions, e.g. changing B1 to '=0/0' or deleting row 1 instead of implementing error formulae, 

Actual Results:
dependent cells (B2 in this case) don't inherit #REF! or err:522 error conditions from upstream cells, 

Expected Results:
error condition handed over to dependent cells, 

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64)
Build ID: 9ed75e2c65544b4f71c73e1c51a68d74e31d544b
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Comment 1 Telesto 2020-04-26 21:02:05 UTC
Repro with
Versie: (x64)
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU-threads: 4; Besturingssysteem: Windows 6.3 Build 9600; UI-render: GL; VCL: win; 
Locale: nl-NL (nl_NL); UI-taal: nl-NL
Calc: CL

Also in
Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Locale: nl_NL

but not in
Build ID: 8a35821d8636a03b8bf4e15b48f59794652c68ba

Another observation
1. Type =B1 into B2
2. Enable track changes
3. Copy B2
4. Paste in B1
6. Edit -> Track Changes -> Manage
7. Discard the change (paste)
8. #REF! still around -> Also not in
Comment 2 Buovjaga 2020-06-09 19:40:29 UTC
Bibisected with Linux 44max to!/
Use group-area listeners during copy & paste if we can.

Same blame as bug 128975