Axolot Data

Thanks - that nailed it.

Thanks for the fixes - most of the issues are resolved. However, I still have a problem with formatting dates. I use: FXLS.CmdFormat.BeginEdit(Nil); FXLS.CmdFormat.Number.Format := 'dd mmm yyyy'; FXLS.CmdFormat.Alignment.Horizontal := chaCenter; FXLS.CmdFormat.AddAsDefault('FCDate'); Format_CDate :=...

1. Freezing top rows causes those rows to be displayed twice when the resulting spreadsheet is opened. Scrolling the sheet resolves the issue. If the spreadsheet is saved after the scrolling, it displays correctly on subsequent opens. 2. AutowidthCols doesn't work propery if cells contain non defaul...

5.10.03 seems to have resolved most of the issues. However, attempting to set up a default format for a date doesn't work, example FXLS.CmdFormat.BeginEdit(Nil); FXLS.CmdFormat.Number.Format := 'dd-mmm-yyyy'; FXLS.CmdFormat.Alignment.Horizontal := chaCenter; FXLS.CmdFormat.AddAsDefault('FCDate'); Th...

I have come across a couple where a number format is applied.

'"$"#,##0.00 - for currencies. I don't think the $ symbol is included in the calculation

dd mmm yyyy and dd mmm yyyy hh:mm - for dates. These don't appear to contribute to the width in anyway.

I believe I've followed the sample correctly, but it appears that the last default format saved is the only one returned irrespective of the selection method used.

>Use the XLS.CmdFormat object for formatting cells. Please study the FormatCells sample for more details

I'm having difficulty formatting cells on a worksheet. I'm only trying to set three attributes, viz. . the number format (on floats and dates); . bolding; and . Horizontal alignment. If I attempt to set all cells using the same format (Cell[Col,Row].NumberFormat ....) all is fine (and I can setup as...

While this works, there seems to be a minor bug.

When opening the spreadsheet, the top row is displayed twice. Scrolling the sheet fixes this and, if the workbook is saved, it displays correctly on next open.

I'm probably missing something quite obvious, but I can't see how to freeze the top (&/or left) pane(s).

A clue would be appreciated.

Thanks for 5.10 - it addresses several minor issues I had, importantly the cell format issue. However, on installation I didn't get a copy of AxCompliers.inc (that I could find). Not a major drama, I used the copy I had from 5.01. (From memory I'd also had to modify AxCompilers.inc for Delphi XE3 by...

Have you an anticiated time when the next maintenance release will be available (I downloaded the current one and it appears to be unchanged since December 2013).

I'm particularly after the fix for setting the number format on a per cell basis.