Axolot Data

Posted: **Tue May 27, 2014 8:39 am**

Row insert operation doesn't correct the existing formula in some cases

  XLSReadWriteII51.FileName:='C:\XLSRW.xlsx';
  XLSReadWriteII51.Sheets[0].AsFloat[1, 2]:=10;
  XLSReadWriteII51.Sheets[0].AsFloat[1, 3]:=20;
  XLSReadWriteII51[0].AsFormula[1, 1]:='B3/B4';
  XLSReadWriteII51[0].InsertRows(2, 1);
  XLSReadWriteII51.Formulas.Calculate;
  XLSReadWriteII51.Write;

after inserting row, formula have to change to 'B4/B5', but it's still 'B3/B4'

Posted: **Wed Jun 04, 2014 2:34 pm**

Hello

This is fixed in update 5.20.27

Posted: **Mon Dec 08, 2014 4:19 am**

if formula contains mixed references like this "=IF(K15=0;"";SUM($K$14:K15))" then its copied as "=IF(K15=0;"";SUM($K$14:$K$15))" last reference must be K15 not $K$15.
edit: if using xls format

Axolot Data

Row insert operation doesn't correct formula

Row insert operation doesn't correct formula

Re: Row insert operation doesn't correct formula

Re: Row insert operation doesn't correct formula