Value of the formula cell cannot be computed

Symptoms

This issue arises when the VLOOKUP formula is used with reference data in a different tab. For example, the sheet containing the formula references data contained in another sheet named "Data":

=VLOOKUP(D2,Data!A:B,2,FALSE)

CODE

If you try to import an Excel file containing this sort of formula, the document will fail to render in Elements Spreadsheet, with "Value of the formula cell cannot be computed" errors in the console.

Resolution

Our implementation of VLOOKUP does not accept column ranges, so you will need to write =VLOOKUP(D2,Data!A1:B10000,2,FALSE) instead of =VLOOKUP(D2,Data!A:B,2,FALSE).