summaryrefslogtreecommitdiff
path: root/wizards
diff options
context:
space:
mode:
authorEike Rathke <erack@redhat.com>2021-11-26 18:11:31 +0100
committerEike Rathke <erack@redhat.com>2021-11-26 21:40:10 +0100
commit324e5c3942870749fae0e62c1c11a1400b772584 (patch)
tree6448132a754cbf8259302d1d607707b4a89e8150 /wizards
parent93663a64e1a436eddcbaefd4bb0a8f83a925cdb4 (diff)
Regression Statistics: use cell reference, not fix row to calculate offset
The INDEX() offset was calculated with a fix row number derived from the initial output position, like 35-ROW(). That fails if the range later is moved or rows inserted/deleted. Instead, use a cell reference of the cell's current column and end row, like ROW($A$34)+1-ROW(). 34+1 to not have things shifted if a row is inserted before 35. Change-Id: I11276c4acb35505576daa1a20ad49a4fcdbaba49 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/125914 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
Diffstat (limited to 'wizards')
0 files changed, 0 insertions, 0 deletions