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

--- Comment #3 from MD <mike.giftr...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to