https://bugs.freedesktop.org/show_bug.cgi?id=82928
Priority: medium
Bug ID: 82928
Assignee: [email protected]
Summary: VIEWING: Lookup formulae don't update when sheet is
sorted
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.6.2 release
Component: Spreadsheet
Product: LibreOffice
This worked in the 4.1 series and before.
Columns A thru E or F contain data.
Columns F-G or G-H contain lookups to a database page in the currently open
file of the form:
[Col. F]
=IF(D10<100," ",VLOOKUP(D10,$Accounts.$A$1:$B$139,2,0))
[Col. G]
=IF(E10<100," ",VLOOKUP(E10,$Accounts.$A$1:$B$139,2,0))
When columns A thru E (or F on another page; adjust formula to match) are
sorted, even using F9 to refresh the sheet, the lookups are not updated. If I
save/close and reopen the file, the lookups update correctly. When data are
originally entered in columns A thru E (or F), the lookups also update
correctly. Manually changing the contents of the "key" cell also updates
correctly.
Apparently, if "key" references used by the formula are moved while the file is
open, LO 4.2 ignores the change until the file is closed and reopened. Other
times, it updates correctly. This is an error.
This worked OK in 4.1.x with formulae as written; it also worked OK without
explicitly including the final '0' parameter in 3.x - the added parameter
became necessary in 4.x because it no longer treats the default condition in
the Excel fashion.
Operating System: Windows 7
Version: 4.2.6.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
