Page 1 of 1

empty decode stack

Posted: Thu Dec 07, 2017 5:21 pm
by 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) 8)