Axolot Data

Hi,

Any news on this subject?

Hello,

With the latest update, 5.20.13, the problem was solved.

Hello larsa,

When I first reported the error I was using version 5.20.11 and I updated to version 5.20.12 and the error continued to occurs.
Now I'll update to version 5.20.13 and see what happens.

Hello, The error occurs on file XLSColumn5.pas, line 328, in the procedure below: procedure TXLSColumn.SetPixelWidth(const AValue: integer); begin SetWidth(Round(Trunc((AValue - 5) / FOwner.FStyles.StdFontWidth * 100 + 0.5) / 100) * 256); end; AValue has a integer value greater than 0 and FOwner.FSt...

Hello, I'm using Delphi 7 and XLSReadWriteII 5.20.11. Code below: sFileName := ExtractFilePath(Application.ExeName) + '\TestXLS.xlsx'; sMsg := ''; Try xlsWorkbook.Clear; xlsWorkbook.Version := xvExcel2007; xlsWorkbook.Filename := sFileName; xlsWorkSheet := xlsWorkbook.Sheets[0]; xlsWorkSheet.AsStrin...

Hello,

I updated to the latest version and got the same error.

Hello,

The latest update solved the problem.

Tks.

Hello,

Any news on this issue?

Hello, You just need to use the code below to reproduce the error: var sMsg : string; sFileName : string; xlsWorkSheet : TXLSWorksheet; begin sFileName := ExtractFilePath(Application.ExeName) + '\TestXLS.xlsx'; sMsg := ''; Try xlsWorkbook.Clear; xlsWorkbook.Version := xvExcel2007; xlsWorkbook.Filena...

Hello,

I tried to delete de cell, even clear the cell, and the error occurs the same way.

And how can I clean the formula?
I put a code just to show you how the error is generated.
In my application I'm opening a Excel file created by other person using Excel.
When I open the file and try to recalculate I get the error "Formula is not compiled".

Best regards,

Adriano Silva

Hello,

The error occurs even if I try to clear cell's content:

xlsWorkSheet.ClearCell(0, 2);
xlsWorkSheet.AsFormula[0, 2] := '';
xlsWorkSheet.AsFloat[0, 2] := 15;
xlsWorkbook.Calculate; // Here occurs the error.

Any news on this?

Best regards,

Adriano Silva

Hello, I found a error when calculating a workbook. If I try to put a value in a cell that was calculated and the formula has a error, I get the message "Formula is not compiled". Here is the code: var sMsg : string; sFileName : string; xlsWorkSheet : TXLSWorksheet; begin sFileName := Extr...

Hello,

Do you have an expected date to when this problem will be solved?

Best regards,

Adriano Silva

Hello,

I tested the XLSReadWriteII5 sample FormatCells for Delphi to test cell protection and found that only works with Version=xvExcel2007.

Best regards,

Adriano Silva