https://bugs.documentfoundation.org/show_bug.cgi?id=101562
Bug ID: 101562
Summary: Formula referencing a whole column in another sheet
does not update once deleting a line in that sheet
Product: LibreOffice
Version: 5.2.0.4 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: curcio...@gmail.com
Created attachment 126856
--> https://bugs.documentfoundation.org/attachment.cgi?id=126856&action=edit
formula does not update referencing whole column of another sheet
Description:
Sheet1
A B
1 stock
2 search result
3 s1 r1
4 s2 r2
5 s3 r3
Sheet2
A B
1 s2 =INDEX(Sheet1.$B:$B;MATCH(A1;Sheet1.$A:$A;0))
B1 returns r2.
Deleting line 1 of Sheet1, B2 returns r3.
This does not happen if searched/founded range is limited.
F9 does not update only CTRL+SHIFT+F9.
--
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