Problem with formula that references multiple sheets

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
Guest
Posts: 83
Joined: Tue Aug 16, 2005 6:08 pm

Problem with formula that references multiple sheets

Post by Guest »

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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Post by larsa »

Hello

This problem is fixed now.


Lars Arvidsson
Post Reply