xvExcel2007 sheet2!a1+sheet3!a1 not working

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
alexpirate
Posts: 13
Joined: Sat Aug 20, 2011 9:46 am

xvExcel2007 sheet2!a1+sheet3!a1 not working

Post by alexpirate »

Hi,

when XLSReadWriteII4 is set ot version xvExcel2007 and using

XLSReadWriteII41.Sheet[0].AsFormula[3,1] := 'Sheet2!D1+Sheet3!D1+Sheet4!D1' ;

when you save the file, Cell[3,1] contains only '(Sheet2!$D$1)'

if xvExcel97 all is correct, Cell[3,1] contains 'Sheet2!D1+Sheet3!D1+Sheet4!D1'
Post Reply