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 #5 from David Lochrin <[email protected]> ---
(In reply to m.a.riosv from comment #4)
> Please review the option:
> Menu/Tools/Options/LibreOffice calc/General - Expand references when new
> columns/rows are inserted.
You're absolutely correct Miguel, and I apologise for wasting everyone's time.
I thought it was a bit too simple for a bug!
However I do think this option is rather dangerous because it can obviously
lead to incorrect results when a spreadsheet designer is unaware of it and a
function argument then operates on unintended cells. I imagine most would not
be aware of it; I wasn't and I count myself as a knowledgable user.
Should it be set "off" by default, and has the default changed in recent
versions? Though I realise changing defaults is tricky.
In my case the effect arose quite indirectly. I have written macros for adding
& deleting multiple rows and sorting up to two columns of commonly formatted
sheets (with header row(s), a data area, and an end row), and I've been using
them for years.
But recently a calculation located below the data area (i.e. outside the
nominal scope of the macros) generated incorrect results when rows were added
anywhere in the data such that the last row of the new data area extended at
least to the row ("x") immediately before a SUM(x:y) function. The SUM()
function then summed the range (x:y+n) where "n" is the number of rows added.
Thanks for your response.
Regards,
David Lochrin
--
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
