xvExcel2007 sheet2!a1+sheet3!a1 not working
Posted: Sat Aug 20, 2011 9:56 am
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'
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'