Axolot Data

I have a program where I use the AsFormula function.
This works fine with short formulas and when they references the same sheet.

I have som formulas like this:
(VLookup(D3;Sum!A28:G33;2)*E3)+(VLookup(D3;Sum!A28:G33;3)*F3);

When I compile and run the program, all works fine, but when I execute the function for creating the Excelfile, the resulting formula in the excel file looks like this:
=((VLOOKUP(D3;Sum!A28:G33;2;Sum!A28:G33;3)*F3))

I saw an earlier post about a simulur error that occured when referencing another sheet, in the reply it was said that this was fixed in a later release.
I have updated to the latest release bit I still get this error.

Olle.

Hello

I can confirm this bug. It will be fixed in the next update.


Lars Arvidsson

OK!

Thanks Lars.