Page Index Toggle Pages: 1 Send TopicPrint
Normal Topic Spreadsheet for WinForms 1.1 (Read 2334 times)
Forum Admin
YaBB Administrator
*****
Offline


Rock and Roll

Posts: 685
Joined: Apr 6th, 2003
Spreadsheet for WinForms 1.1
Apr 21st, 2014 at 10:01am
Print Post  
We have released version 1.1 of MindFusion.Spreadsheet for WinForms. The new version includes:

Export to XLSX (Office Open XML) format
The new ExcelExporter class can be used to export MindFusion.Spreadsheet Workbook objects to Excel. To export a workbook to XLSX, create an instance of the ExcelExporter class and call its Export method, passing the Workbook object as parameter.

Export to ODS (OpenDocument Spreadsheet) format
The new CalcExporter class can be used to export MindFusion.Spreadsheet Workbook objects to the OpenDocument format. To export a workbook, create an instance of the CalcExporter class and call its Export method, passing the Workbook object as parameter.

Moving cell ranges
Cells and cell ranges can be moved programmatically and interactively. To move a cell range programmatically, call one of the MoveTo overloads of a CellRange object representing the range to move and specify the destination. To move a range interactively, select the range, click near the the end of the selection rectangle and drag the rectangle to the desired location. The interactive movement can be disabled through the AllowMoveCells property of the WorkbookView class.

Moving rows and columns
Columns and rows can be moved programmatically and interactively. To move a column/row programmatically, call one of the Move overloads of the ColumnCollection or RowCollection classes respectively, and specify the column/row to move and the desired location. To move columns or rows interactively, select the columns or rows entirely, click on any of the selected column or row headers and drag. The interactive movement can be disabled through the AllowMoveHeaders property of the WorkbookView class. Note that more than one column or row can be moved at a time.

Find and replace
The workbook provides a set of methods for searching and replacing of texts. To search texts, use the Find and FindAll methods. The former searches for the first cell containing a given text, the later returns all cells matching the criteria. To replace texts, use the Replace and ReplaceAll methods. The new FindReplaceForm class (contained in the MindFusion.Spreadsheet.WinForms.StandardForms.dll assembly) can be used to facilitate search and replace operations inside a workbook.

Improved in-place editing
In-place formula editing has been extended with automatic literal, string, cell and cell range coloring and context-sensitive tooltip information for functions. The information for custom functions can be provided through the new ExtendedInformationProvider property of the Workbook class.

Registered customers with an active upgrade subscription can download the licensed version from the clients area on our site.

A trial version is available for download here:
https://mindfusion.eu/SpreadsheetTrial.zip

Enjoy!
« Last Edit: Apr 23rd, 2014 at 9:19am by Forum Admin »  
Back to top
WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send TopicPrint