https://bugs.documentfoundation.org/show_bug.cgi?id=136518
--- Comment #4 from Uwe Auer <u...@franke-auer.de> ---
No repro using:
Version: 6.0.7.3, Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3;
Locale: de-DE (de_DE.UTF-8); Calc: group
No repro using:
Version: 7.0.1.2, Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US, Calc: threaded
No repro using:
Version: 6.4.6.2,Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5;
Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded
Remark: Sample file uploaded by reporter doesn't use absolute addressing in
VLOOKUP, hence the lookup range shifts due to copy&paste of the formula. It
reads =VLOOKUP(A1;H1:I3;2;0) for the first row while it should use absolute
addressing at least for the row numbers and read =VLOOKUP(A1;H$1:I$3;2;0) to
assure the same lookup array being referred.
--
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
