[Libreoffice-bugs] [Bug 132986] Redefined #REF! values recovers the last value and fórmula, however it's never updated anymore EDITING the referenced cell

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Jun 15 06:42:43 UTC 2020


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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |109324

--- Comment #6 from b. <newbie-02 at gmx.de> ---
add. info: 

references to cells below affected as well (B2: '=B3'), also 'somewhere in the
sheet' (not restricted to borders), also with some distance between reference
and referencier (D4: '=D7', but does not affect references to cells besides
(B2: '=C2'), 

reference is 'dead' while input number or text into the referenced cell, but
becomes live again on input of formula, e.g. '=3' in the referenced cell will
be respected by the referencing cell, 

at least with below ver. - but from memory it was on other versions too - the
cell doesn't 'cell recovers the last value and fórmula', but recovers the last
formula, and a fresh calculated '0', 

Version: 7.1.0.0.alpha0+
Build ID: 20ba8d8d9f4fcf7d5826fcb3366a9bff0d6a8ca1
CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64 at 86-TDF, Branch:master, Time:
2020-06-10_07:16:41
Calc: threaded


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109324
[Bug 109324] [META] Calculate bugs and enhancements
-- 
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/20200615/5f2831ec/attachment.htm>


More information about the Libreoffice-bugs mailing list