Issue with formulas referencing other worksheets

Hi Chris,

The "index" function has two syntaxes. I implemented the syntax 1. The "cell" function allows retrieving several types information. I implemented the type of "contents". It's able to solve the formula problems currently.

Please try v1.7.4.2 in attachment.

Thanks

Greetings,



I won’t be able to test it out for a few days.
Taking some time off to get married. :slight_smile: I should be able to get
to it at the end of next week.



Thanks,

Chris Powell


Greetings,

I've finally managed to test out v1.7.4.2. Its working better, but I've run into a minor issue.

=+'Input sheet'!D4

This formula works fine when the value in D4 is a numeric value, but if it is a string, I get a "Wrong Number Value" error. In excel, it returns the string value.

I didn't run into any other formula errors, and I'm crossing my fingers that the client doesn't throw us any more files with other formulas in them.

Thanks,

Chris Powell