https://bugs.documentfoundation.org/show_bug.cgi?id=99956
--- Comment #11 from Howard Brown <howar...@earthlink.net> ---
Oh, the relative range I describe would also change if new lines were added
before the range, too, but the beginning row would be fixed at $B$24, I believe
that only the range's end would move down. However, in my spreadsheet lines
would only be added between the beginning and end of the range, so having the
range expand is exactly what I'm looking for. The issue is that Calce is
changing the named range even though I'm not adding new rows and often the
range reported in the range manager appears to be wrong, as is the case where
the ROWS function with the parameter $B$24:$B35 having a result other than 10.
Sometimes it's less than 10 and others it's greater than 10, but the range
still shows $B$24:$B35. Other times the range shows an entirely different
range, but in all cases I didn't add or remove any lines in or above the named
range area of the spreadsheet that I created the named range with.
--
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
