Axolot Data

! Some Excel 5 files could cause an exception when the component was destroyed.

! Formulas where not adjusted correctly when rows and columns where inserted. This bug was introduced in a recent update.

! Fill color didn't work with rectangle shapes.

! CopyColumns didn't copy merged cells when copying on the same sheet.
! CalculateSheet could result in an exception if a formula cell type was changed as a result of the calculation.

! When creating new workbooks, no sheet was selected. This bug was intruduced in 2.02.06 ! Files that had more than one charts on their own sheet before the first worksheet where not written correctly. ! Font color could be wrong if the color palette was changed. ! Files with Word Art graphics could...

! Setting the paper size didn't work.
! Some Excel 2.1 files didn't work.

Hello

Sorry, but unicode characters don't works.


Lars Arvidsson

! Functions that contained functions in the argument list could cause an exception.
! Setting the zoom of a worksheet didn't work.
! Changing the color palette didn't work.

! Release 2.01.03 introduced an error when createing internal names.
! Writing strings in Excel 5 files could result in strange characters.
! Setting the active cell (cursor) did not always work.

! Formulas with unary minus caused an exception on calculations. ! External formulas will now fire a OnFunction event instead of an error. ! Last row and last column where not calculated on new files. ! Error when inserting coulmns. ! 3D cell refs where the sheet name could be parsed as a cell ref d...

! Adjustent of cell referrences in formulas, when inserting/deleting columns/rows is improved.

+ The color palette can now be changed. Property XLSReadWriteII2.Palette[Index: integer]: TColor;
! BMP pictures didn't work.

! Fixed minor memory leak.
! Files with charts on their own sheets, that contained drawing objects could not be read.

! The formula encoder has been rewritten in order to solve various problems with formulas.
! Area names are now adjusted correctly when rows/columns are deleted/inserted or sheets are deleted/inserted.
! Merged cells where not handled correct when inserting/deleting rows/columns.

+ Stacked bar charts can be created. + Columns can be grouped; XLS.Sheets[x].GroupColumns(Col1,Col2,Collapsed); ! Unicode rich strings with far east data caused corrupt files. ! Calculation of functions that used external names caused an exception. It is now replaced with the #NAME! error in the cel...