Axolot Data

Hello

With verions 3.0 of the component, install the BDS file under Components->Install package

Lars Arvidsson

Hello

How do you set staring page in Excel?

Lars Arvidsson

Hello

This will be fixed in the next update.

Lars Arvidsson

Hello

This will be fixed in the next update.

Lars Arvidsson

Hello

Sorry, yes. In order to activate this, TSheet.WorkspaceOptions must have the value woFitToPage.
Example:

Code: Select all

XLS.Sheet[0].PrintSettings.FitWidth := 3;
XLS.Sheet[0].WorkspaceOptions := XLS.Sheet[0].WorkspaceOptions + [woFitToPage];

Lars Arvidsson

+ New printer options, FitWidth and FitHeight. + Margins can be set on Text Boxes. + LineColor and FillColor properties for notes and text boxes. + Rotation property for drawing objects. + Copy print settings between sheets. + Check Boxes and Radio Buttons can be used. + AutoRowHeight and AutoRowsHe...

! Time cells formatted with milliseconds where not handled correct. ! Deleted internal names (#REF!A1) caused an exception. ! TInternalName.Definition is changed from string to WideString. This fixes some problems with unicode sheet names in formulas. ! When calculating, functions with empty argumet...

+ New property XLS.Workbook.Date1904. This property is True if the 1904 date system is used.
! Some files with metafile (EMF) pictures could cause an exception.
! Some rare encrypted files could nopt be decrypted.

+ The speed when adding internal names has improved. Both when adding names in the component, and when the file later is opened with excel. When adding many names, put the code that adds name between calls to BeginUpdate and EndUpdate. Example: InternalNames.BeginUpdate; for i:= 1 to 10000 do begin ...

2.02.32 ! Array entered formulas could not be read from a cell.

! Array entered formulas could not be read from a cell.

! SheetByName did not work correctly with Delphi 5.
! Contols with macros, such as buttons, didn't work correctly after an internal name was deleted.
! XLS.Sheets[x].Charts[x].Series[x].SerieName sometimes retuned wrong value.

+ New property XLSReadWriteII.Sheets[x].IsDateTime This property returns True if the cell is formattet as a date or time value.
! Some formulas could cause an exception (bug introduced in 2.02.29).

2.02.29 ! Writing files with array formulas could result in corrupt files.

! Writing files with array formulas could result in corrupt files.

! When the localized time format was AM/PM, the AsDateTime property set wrong cell format.

2.02.27 ! Some files with pictures could cause an exception.

! Some files with pictures could cause an exception.

Axolot Data

Search found 1570 matches

3.00.00

2.02.35

2.02.34

2.02.33

2.02.32

2.02.31

2.02.30

2.02.29

2.02.28

2.02.27