https://bugs.documentfoundation.org/show_bug.cgi?id=105323
GerardF <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |[email protected]
Resolution|--- |NOTABUG
--- Comment #5 from GerardF <[email protected]> ---
When adding or deleting row(s), references are updated consequently.
But only cell references. Why should we change an integer ?
Imagine that in a cell I have a formula =$A$1*10
deleting a row between 2 and 10 should not change the formula in =$A$1*9.
If you want the formula to change, don't use integer but a function.
In this case, replace the number 14 by COLUMNS($A$1:$N$1)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
