Axolot Data

In the Excel file cell A1 must be the sum of A2:A5, but the result is 0 (zero). And XLSReadWriteII51.Formulas.Calculate doesn't work. Example code: procedure TForm1.BitBtn1Click(Sender: TObject); begin XLSReadWriteII51.FileName:='C:\XLSRW.xlsx'; XLSReadWriteII51.Sheets[0].AsFormula[0, 0]:='SUM(A2:A5...

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); XLSReadW...

var col, row: Integer; begin XLSReadWriteII51.FileName:='C:\XLSRW.xlsx'; XLSReadWriteII51.Add; XLSReadWriteII51.Add; XLSReadWriteII51.Sheets[0].Name:='Before Insert Column'; XLSReadWriteII51.Sheets[1].Name:='After Insert Column'; XLSReadWriteII51.Sheets[2].Name:='Must be'; // Before Insert Column f...

Hello Larsa,
I didn't get any reply to the post I've made.
Is it possible that you take a look, this issue is holding us back.
Thank you.

When you want to insert 1 column, it creates 2 columns instead in an Excel file; Inserted column's contents are inserted up to line 256, all input stays remained after line number 256. var col, row: Integer; begin XLSReadWriteII51.FileName:='C:\XLSRW.xlsx'; for col:=0 to 10 do for row:=0 to 300 do X...

There is a problem in column delete operation in Excel file with unified columns I have unified [B1:C1] and [D1:G1] cells. Then I deleted [D] and columns. After delete operation only [C1:E1] cells were supposed to stay unified but, [B1:C1] and [D1:G1] cells were unified. var col, row: Integer; begi...

Delphi XE3 - Win32

I was using XLSReadWriteII 5 demo
I uninstall it
I've downloaded xlsrwii5_dxe3_reg.exe from the link you send

But still demo, writes demo text in A1