Axolot Data

We also have this problem.
It used to work with older versions of XLSRW (build 21ish I think) with XLS, but it doesn't work with the current version.

More formating woes: The following doesn't work (with strFontName = 'Verdana' and nSize = 8) procedure SetSheetFont(const XLS: TXLSReadWriteII5; const strFontName: String; const nSize, nSheetNo: Integer); begin XLS[nSheetNo].CalcDimensions; XLS.CmdFormat.BeginEdit(XLS[nSheetNo]); try XLS.CmdFormat.F...

Good to here it Lars.
When will .30 be available?

Using version: 5.20.26 If you have multiple different column formatings on a spreadsheet all of the cells that have data in them on the sheet (as opposed to blank cells blank) get set to the LAST columns formating applied, overriding all previous column formating. This completly breaks the formating...

I'm trying to open up XLS 2013 files and this fails with an unknown attribute: shapeID, I am using XLSRW2 version 5.10.28 I had a similar problem before and was advised to set SaveToList on but this doesn't appear to be working. I have the following code and this still raises an error. XLS.Filename ...

two warnings are generated

[DCC Warning] BIFF_ReadII5.pas(1092): W1057 Implicit string cast from 'RawByteString' to 'string'
[DCC Warning] XLSColumn5.pas(873): W1000 Symbol 'AddIfNone' is deprecated: 'Not required anymore'

I have some formula's that have named ranges in them such as the following =IF(D5="", 0,INDEX( TLocationTypeID,MATCH(D5,TLocationType,0), 1)) XLSRW5 doesn't seen to be able to evaluate those formulas, when I call .Calculate all I get is #N/A for these formulas What is even stranger is that...

Just upgraded 4 to 5. Files I can open with V4 fail to open with V5 with the following error E1001: XML read error: "Row 0: Unknown Attribute "xmlns"" Looks like you need to handle this attribute in TCT_Sst.AssignAttributes. An unknown attribute should not prevent opening a file,...