- Welcome, Guest. Please Login or Register
MindFusion  
  We have released initial version of MindFusion.Scheduling library for HTML5 & JavaScript.  
  HomeHelpSearchLoginRegister   
     
     
   
 
Page Index Toggle Pages: 1 Send Topic Print  
Spreadsheet for WinForms 1.1
Read 994 times

Forum Admin   Offline
YaBB Administrator
*****
Posts: 505
Gender: male
Rock and Roll


   
     
 
Spreadsheet for WinForms 1.1
Apr 21st, 2014 at 11:01am
 
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:
http://mindfusion.eu/SpreadsheetTrial.zip

Enjoy!
 
 
« Last Edit: Apr 23rd, 2014 at 10:19am by Forum Admin »
  WWW
IP Logged    
 
     
Page Index Toggle Pages: 1 Send Topic Print