https://bugs.documentfoundation.org/show_bug.cgi?id=106763
David Lochrin <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #7 from David Lochrin <[email protected]> ---
I've attached a sheet containing the AddRow macro which demonstrates the
problem (with DelRow & Sort). This also contains a note describing how to
reproduce it.
Please note that my previous description of the condition which manifests the
problem was not quite accurate, but not in any fundamental way.
As a more philosophical observation, I'd also like to say I think the option
“Expand references when new columns / rows are added” is not consistent with
absolute cell referencing using the "$" syntax.
I'd expect an absolute cell range like $A$5:$A$10 to refer to those particular
cells regardless of what rows or columns were added outside the range. With
this option enabled, however, a user could unintentionally introduce a "bug"
into an existing macro without even being aware that it was a possibility.
In effect the concept of an absolute cell reference should be extended by
adding the words "...providing the option to expand references is not enabled."
DL
--
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
