Axolot Data

Hello Lars,

If you use : and export in Excel97 format, the cell font is not Red but Blue (and of course, if you put clBlue color, you get Red in the cell).
I think the pb is that delphi TColor constants are in BGR format and not in RGB format.

jleg.

Hello, if you execute the code below, you will get an EListError exception. XLS.Version := xvExcel97; XLS.Delete(0); XLS.Add; XLS.FileName := 'C:\Test.xls'; XLS.Write; I think the pb is that in the TXLSWorkBook.Delete method, the FManager.Worksheets.Count is Ok (value = 1) but when you use WritePrep...

Hello,

I initialize the component to xvExcel97 and i call a Clear(0) then the version is changed to xvExcel2007.
After that, XLS is in xvExcel2007 format !

NB: if you use Clear (instead of Clear(0)), there is the same pb.

Hello,
It's ok now in 5.10.17, if i'm right, i had the problem in default format.
Thanks again.

Great, it's ok now.
Thank you very much.

Hello, If you take your FormatCells sample and add the following lines in the btnDefaultFormatClick event, the borders never appear (i use XLS.Version := xvExcel97). // Create second default format. XLS.CmdFormat.BeginEdit(Nil); XLS.CmdFormat.Fill.BackgroundColor.RGB := $FF1010; XLS.CmdFormat.Font.N...

I found the definition of TXSLCellType in the Xc12Utils5 unit in the SrcXLS directory.

Hello, I had the same problem, the definition of the TXLSCellType has changed. So, just add 'x' as prefix. See definition below. type TXLSCellType = (xctNone, //* Undefined cell. xctBlank, //* Blank cell. xctBoolean, //* Boolean cell. xctError, //* Cell with an error value. xctString, //* String cel...

Hello, In v4, we could use the properties BorderLeftStyle, BorderBottomSyle,... to set border's style but in V5, how can i set different styles to the borders of a cell using CmdFormat (FStyle is define protected in the class). I know i can do it if i set the border for a particular cell (ex: XLS[0]...

Hello,

For my 4th question, you answered "Yes" but there were 2 solutions, what is the good one :

4. How to replace by or just by jleg

Hello Lars, As you tell me, i've finally made a new registration. Thanks for your attention. I'm trying to migrate code from v4 to v5 and i've some difficulties because many changes have been made in the component code. The few indications done in the changes.txt file are not enough to migrate. Is t...