[Libreoffice-bugs] [Bug 118843] calc incorrectly handles cells with a REF error

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from MD <mike.giftrise at btinternet.com> ---
(In reply to Jean-Baptiste Faure from comment #1)
> ctrl+maj+F9 -> #REF! everywhere in columns C and D.
> 
> Not sure if there is a bug there.
> 
> Best regards. JBF

Like you after ctrl+shift+F9 I get #REF in cols C and D. No need to save sheet
if I do this.

However the fact that column C and D are filled with #REF is wrong .
Many of these cells (row 11 downwards) are valid.

The #REF behaviour is also inconsistent. For example if I only copy the cells
upwards to row 10
 then, as expected row 10 cells contain #REF but if I then insert a column and
use ctrl+shift+F9  then I get #REF in all  column C cells but the column D
cells remain correctly calculated.

-- 
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/20180723/62337892/attachment.html>