[Libreoffice-bugs] [Bug 131339] New: calc: #REF! error condition not evaluated for dependent cells, needs recalc, autocalculate failure

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131339

            Bug ID: 131339
           Summary: calc: #REF! error condition not evaluated for
                    dependent cells, needs recalc, autocalculate failure
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
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 7.0.0.0.a0+ and tested 6.2.8.2 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: 7.0.0.0.alpha0+ (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
Calc:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200314/f4420a80/attachment.htm>