Axolot Data

Thanks for your quick answer Lars

Hello, I am using the demo from XlsRWII/5 "SampleFormatCells". I try to define a default format : XLS.CmdFormat.BeginEdit(Nil); XLS.CmdFormat.Fill.BackgroundColor.RGB := $7F7F10; XLS.CmdFormat.Font.Name := 'Courier new'; XLS.CmdFormat.AddAsDefault('F1'); ...and then apply that format to ro...

How can I use an alternative ZIP library (like TPAbbrevia for example) ?

Thank you,

Just in case someone is looking for this error message "empty decode stack" : I got it after creating a formula starting with the "=" sign like : xls.sheets[0].AsFormula[10,10]:='=SUM(A1:A4)'; Formulas should be written without the equal sign : xls.sheets[0].AsFormula[10,10]:='SU...

For the integer overflow problem, I just sent an email with a link to the file.

I use Delphi 10 Seattle so I should be able to use a different Zlib-like library ? Do you have a link somewhere on how to do this ? Will I have to re-do the procedure after each XLSrwII6 update ?

Thanks,

Bought XLSrwII6 : same problem. I have opened a new thread in the XLSrwII6 forum.

Following my problems with Integer overflow on XLSrwII5, I bought XLSrwII6. The problem is still there. How can I send you a (private/confidential) 30Mb file ? When I compile my application in 64 bits, I can't read some XLSX files because of a Zlib decompress error. I have tried re-saving the file f...

Hello,

I am trying to load rather large XLSX files but everytime I am getting EIntOverflow

The same files used to work with a previous version of XlsRW2ii5.

I can see the problem with your demo programs : DirectRead and ReadWrite cells.

What can I do ?

Thanks. Upgrading to latest version also helped.

Hello, I'm trying to change the font color of one cell to red. I have given up trying to do it with Cell[y,x].fontcolor : I don't know how to specify the color and it messed up my original XLS file. So I'm now trying, using the example and "Default" formats (I guess this horror is due to E...

Thanks for your answer Lars, will try that.

Is there a way to change the author in the file properties ? One client asked me why all his documents were "authored" by Josef Stalin and was not pleased at all. I downloaded latest version and I hope this is corrected but I'd like to put my clients' name in there.
Thank you,