Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

function wizard causes lockup

the formula

=IF(C3<>"",IF(ISERROR(VLOOKUP(C3,'Item List'.A:Z,2,0)),"New Item",VLOOKUP(C3,'Item List'.A:Z,2,0)),"")

causes a lockup unless there is not an "Item List" tab, or that tab is empty. With any information in the "Item List" tab, even one cell, opening Function Wizard takes a long time and if there is quite a bit of information, it locks up completely.

C3 is a bar code and "Item List" is a large database of bar coded items.

function wizard causes lockup

the formula

=IF(C3<>"",IF(ISERROR(VLOOKUP(C3,'Item List'.A:Z,2,0)),"New Item",VLOOKUP(C3,'Item List'.A:Z,2,0)),"")

causes a lockup unless there is not an "Item List" tab, or that tab is empty. With any information in the "Item List" tab, even one cell, opening Function Wizard takes a long time and if there is quite a bit of information, it locks up completely.

C3 is a bar code and "Item List" is a large database of bar coded items.

File created with Libreoffice 5.0, issue is with v.5.1.4.2. Having same issue with Windows 10 (2 machines) and Linux Mint KDE.