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