https://bugs.documentfoundation.org/show_bug.cgi?id=99937
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |[email protected]
| |rg
Resolution|--- |NOTABUG
--- Comment #1 from m.a.riosv <[email protected]> ---
Hi Zarko,
Relative/absolute references have there main meaning for copy.
If you delete a row that is in the middle of a referenced range, it's right the
range is adjusted, the range has one less row and relative/absolute references
has no effect on how this works.
You can solve with OFFSET() function
https://help.libreoffice.org/index.php?title=Calc/Spreadsheet_Functions&Language=en-US&System=WIN&Version=5.1#bm_id3148926
or with INDIRECT()
https://help.libreoffice.org/index.php?title=Calc/Spreadsheet_Functions&Language=en-US&System=WIN&Version=5.1#bm_id3153922
but both are volatile functions, so if they are used intensively can slow down
the calculation.
Another option is take advantage of a limitation with named ranges, for those
relative references are not adapted if you delete a row or a column in the
range.
Please if you have more question about, do it in ask.libreoffice.org
--
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
