Problem with formula that references multiple sheets
Posted: Thu Nov 02, 2006 10:05 pm
I recomplied a Delphi 7 program, that worked fine with version 2, using version 3 and one of my formulas that references multiple sheets in the same worksheet isn't being written to the cell correctly.
If I do the following:
sTemp := 'AUB!$C$53+MED!C$54+CLE!$C$68+DET!$C$60';
xls.Sheets[0].AsFormula[iCol,iRow] := sTemp;
The program will run and worksheet will open without any errors, but the formula in that cell will only be '=AUB!$C$53'. All the other sheet references after the first one are gone. The above code works fine with version 2.
If I do the following:
sTemp := 'AUB!$C$53+MED!C$54+CLE!$C$68+DET!$C$60';
xls.Sheets[0].AsFormula[iCol,iRow] := sTemp;
The program will run and worksheet will open without any errors, but the formula in that cell will only be '=AUB!$C$53'. All the other sheet references after the first one are gone. The above code works fine with version 2.