I'm looking to export data from an Excel spreadsheet into QlikView, but the import process doesn't seem to read a formula as a value. For example, I've got a formula =A1+B1+C1+D1 which is read in as blank.
Is there a way to inform the script to read the value of the column rather than the formula? (which is what I assume it's doing)
I just tried to replicate the spreadsheet in excel and it worked fine. The spreadsheet I have to use is protected; does that have any effect on QlikView reading the value of the column that is a formula?
EDIT: When testing the value with IsNull, I get a -1 for each field suggesting that I can't use formula results from a protected sheet.