empty decode stack

[thefreecat]

Just in case someone is looking for this error message "empty decode stack" : I got it after creating a formula starting with the "=" sign like :

Code: Select all

xls.sheets[0].AsFormula[10,10]:='=SUM(A1:A4)';

Formulas should be written without the equal sign :

Code: Select all

xls.sheets[0].AsFormula[10,10]:='SUM(A1:A4)';

Might be obvious but since I spent some time looking for it, it might help someone else (or me again in a few months/year)