Axolot Data

! Files with some unusual macros could not be read.

! Reading formulas could result in an exception. This error was intruduced in v. 2.01.01 in an attempt to remove a comiler warning.

+ Rich Text (RTF) files can now be read/written to/from cell notes and text boxes. RichTextLoadFromStream, RichTextLoadFromFile, RichTextSaveToFile and RichTextSaveToStream methods; ! Unary minus before cell ref in formulas resulted in #VALUE error. ! First character where missing in strings in Exce...

+ New function, FindText. FindText will search all string cells for a given text string. Please see the included sample for more information.
! Improved reading of Excel4 files.

+ New property XLSReadWriteII.Sheets[x].SheetProptection. With this proprty sheet protection can be set with the same options as in the Excel menu Tools->Protection->Protect sheet. ! Data validations set to a list of valus didn't work when the source was a sheet area. ! Formulas with unary minus con...

! Some complicated files could cause an exception when the component was freed.
! Setting a sheet name to an identical text caused an exception.
! Sheet names that contained operator symbols (+,-,/, etc) needed single quoutes around them, but quoted names didn't work.

! Creating files with a large ammount of rich text cells could result in corrupt files.

! Hidden rows didn't work.
! Property InternalNames[x].SheetIndex (that didn't give correct values) has been replaced with InternalNames[x].Sheet
! ClearWorksheet could result in corrupt files.
! ClearData could give unexpected result.

! GetDEVMODE has been disabled becasue it could create all kind of strane errors. It was only used for reading the default paper size.

! Hidden sheets where saved as visible.
! Adding cells in formatted rows/columns could result in an exception when the coponent was freed.

! Calculation of macro formulas didn't fire the OnFunction event.
! Hyperlinks with links to disk files could result in corrupt files.

! Large metafile pictures caused error.
! Files with sheet protection could cause error.

! Chart category values didn't work if a series text where assigned.
! Chart X and Y axis labels didn't work.

! Some encrypted files could cause error.
! Files with many strings could cause error.
! Rows added with AddIfNone had the height set to zero.
! Files created with OpenOffice could cause an exception on destruction of the component.

! Formulas with cell refs as argument could result in #VALUE error in the cell. ! Named areas didn't work correct. ! Strings where not written correctly in Excel 5 files. ! ApplyFormat.Format didn't work correct. ! Changing font format of a cell could result in lost formatting. ! Encrypted files wit...