SM Software :: News

Formula's parser and compiler modules support references to external workbooks, and named areas from local and external workbooks.
Images of PNG format now can be inserted into sheets.
Reading and writing of cell's validation rules have been added.

05-May-2008

TXLSFile v.4.0.

Formula's parser and compiler modules support references to external workbooks, and named areas from local and external workbooks.
Images of PNG format now can be inserted into sheets.
Reading and writing of cell's validation rules have been added.

30-Mar-2008

OLE XLSFile v.4.0.

Protection methods have been added for sheets, workbooks, and files.
Overall performance has been improved by 50%.

07-Mar-2008

TXLSFile v.4.0.

Workbook's protection methods have been added to TWorkbook class.
File's protection methods have been added to TXLSFile class.

25-Feb-2008

TXLSFile v.4.0.

Sheet's protection methods have been added to TSheet class.
Cells' copy, move, insert methods have been improved.

17-Aug-2007

TXLSFile v.4.0. source code is compatible with Delphi 2007.

01-Feb-2007

TXLSFile v.4.0., OLE XLSFile v.4.0. Minor bugs have been fixed in default cells' formatting.

24-Nov-2006

TXLSFile v.4.0. All limitations have been removed in demo version. You may use a fully-functional demo version with Borland Delphi IDE running.

30-Sep-2006

OLEXLSFile v.4.0. AutoFit methods have been added to fit columns.

07-Sep-2006

TXLSFile v.4.0.

AutoFit methods have been added to fit columns.
Minor bugs have been fixed.

09-Aug-2006

TXLSFile v.4.0. source code is compatible with Delphi 2006 (Win32).

17-Jun-2006

XLS files produced by OLE XLSFile v.4.0 and TXLSFile v.4.0 now may be opened in OpenOffice.

09-May-2006

New version: OLE XLSFile v.4.0 has been released.

Now it is possible to read formulas.
Formatting of substrings in text values has been added.
Now it is possible to set format and font properties directly to Row and Column, while in earlier versions only Cell and Range may be formatted.
Writing of logical functions in formulas has been added.
Writing of cross-sheet references in formulas has been added.

21-Jan-2006

New version: TXLSFile v.4.0 has been released.

Now it is possible to read formulas.
Sheets' names now support Unicode values.
Formatting of substrings in text values has been added.
Product's documentation has been refined.

24-Jul-2005

TXLSFile v.3.1

Now it is possible to set format and font properties directly to Row and Column.
Writing of logical functions in formulas has been added.
Writing of cross-sheet references in formulas has been added.

16-Dec-2004

TXLSFile v.3.1

Reading of custom numeric formats has been added.
Reading of a last saved formula's value has been added.

16-Dec-2004

OLE XLSFile v.3.1

Memory usage has been reduced about 2 times.
Reading of custom numeric formats has been added.
Reading of a last saved formula's value has been added.

31-Oct-2004

TXLSFile v.3.1 Memory usage has been optimized.

26-Jul-2004

TXLSFile v.3.1 Memory consumption has been reduced by 25%.

03-May-2004

OLE XLSFile v.3.1: new features have been added.

Now sheet data may be saved to HTML, TXT file.
Copy and delete methods have been added to sheets collection.
New useful methods have been added to clear, copy, move, delete, insert cells, rows, and columns.

16-Mar-2004

TXLSFile v.3.1: new features have been added.

Now sheet data may be saved to HTML, TXT file or stream.
Copy and delete methods have been added to sheets collection.

25-Jan-2004

TXLSFile v.3.1: new useful methods have been added to clear, copy, move, delete, insert cells, rows, and columns.

07-Jan-2004

New version: OLE XLSFile v.3.1 has been released.

Memory consumption has been reduced. Now reading and writing are even faster.
Unicode values' processing has been improved.
Some memory usage errors have been fixed.

20-Dec-2003

New version: TXLSFile v.3.1 has been released.

Memory consumption has been reduced significantly. Now reading and writing are even faster.
Now you can read and write WideString (Unicode) cell values.
Some memory usage errors have been fixed.

02-Sep-2003

New version: OLE XLSFile v.3.0 has been released. All TXLSFile v.3.0. Delphi library features now available in OLE XLSFile v.3.0 OLE library.
Now you can also read data from Excel files. With v.3.0 you can read the following Excel file elements:

strings (Unicode strings supported), numbers, dates
cell colors, borders, font styles
cell alignment, text rotation
row heights and column widths
cell formats (e.g. #00.00, yy/mm/dd etc.)
merged cells.

22-Jul-2003

TXLSFile v.3.0: rows' and columns' grouping has been added.

12-May-2003

TXLSFile v.3.0: merged cells' reading has been added.

03-Apr-2003

New version: TXLSFile v.3.0 has been released. Now you can also read data from Excel files. With v.3.0 you can:

read strings (Unicode strings supported), numbers, dates
read cell colors, borders, font styles
read cell alignment, text rotation
read row heights and column widths
read cell formats (e.g. #00.00, yy/mm/dd etc.).

12-Feb-2003

TXLSFile v.2.1 now available for Delphi 7

11-Jan-2003

We have a new domain sm-software.com

03-Jan-2003

New version: TXLSFile v.2.1 has been released. New features:

Now you can insert images into Excel workbooks (supported formats are BMP and JPEG).
With sheet window options you can show/hide grids, show/hide row and column headers, show/hide zero values.
You can insert hyperlinks into the worksheet.
A paper size can be specified in page setup options.
A bug with limited count of merged ranges now fixed. You can create so much merged ranges as you need.

30-Dec-2002

We are Borland Technology Partner.

24-Nov-2002

New version: XLSExport v.1.1 has been released. New features:

New XLSExportFile component provides access to Workbook object. Now you can export grids and datasets using XLSExport components, and working with the same workbook using TXLSFile library objects.
OnSaveFooter event has been added to TXLSExportDBGrid, TXLSExportDataSource components. Now you can add totals row after dataset export.
Options property has been added to TXLSExportDBGrid, TXLSExportDataSource components. Now it contains eoptVisibleOnly option, and you can use it to export only visible dataset columns.

25-Sep-2002

New version: OLE XLSFile v.2.0 has been released. Now all new features of TXLSFile v.2.0 also available for OLE XLSFile.

19-Sep-2002

The demo version of TXLSFile v.2.0 and XLSExport v.1.0 now contains demo DCU files. With the demo version you can test all TXLSFile features, but you can not write more than 100 cells on each sheet.

12-Aug-2002

New version: TXLSFile v.2.0 has been released. New features:

You can use ranges for batch cells operations
Now you can specify built-in or create a custom format string (e.g. '#,##0.00') for cells and ranges
You can use A1-cell reference style (e.g. 'A1', 'AA100') when refer a cell in a sheet
You can use PageSetup object to specify page setup options for a sheet and to specify a print area.
Now column's width and row's height can be specified in pixels
Now colors for background, foreground, borders, and font can be specified as RGB colors
You can merge cells to create more attractive reports
You can create named areas
You can use formulas for cells and ranges
Minor bug with borders has been fixed. Now single and outline borders work correctly.