Aspose.Grid for .NET V2.0.1 New Release Release Notes

We have just released Aspose.Grid v.

What’s changed:


l Supports importing/exporting to Excel2007xlsx file format.

l Supports reading merged cells’ style from excel file.

l Supports Auto RowFilter and Custom RowFilter; adding IgnoreCase and IsStartWithCriteria properties to GridColumn to customize behaviors of auto rowfilter.

l Adds CustomMsgTitle property to Validation to customize the title of MessageBox.

l Adds RecalculateFormulas property whose default value is true; when it is set to false, assigning any value to a cell will not recalculate the formula.

l Adds Width and Height properties to Comment.

l Adds CommentFont property to GridDesktop to set font of Comments.

l Provides new versions for the overloaded list of the Add method for the CommentCollection class to specify Width and Height of Comments.

l Adds IsVisible property to Worksheet.

l Supports reading/writing CustomProperties of Worksheet in excel files, and adding read-only CustomProperties property to Worksheet.

l Supports vlookup function/formula.

l Supports Undo/Redo features when changing values of cells.

l Adds ContextMenuManager property to GridDesktop to manage context menu.

l Adds RowColumnHiddenChanged event.

l Supports multi-selection of rows/columns/regions.

l Supports importing/ exporting frozen Panes from/ to excel files.

l 36 fixes and enhancements.


l 1 enhancement.

Issues Resolved in Aspose.Grid 2.0.1

Issue IDComponentSummary
7942Grid.DesktopSets Single or float types value to cell displays blank.
7970Grid.DesktopThe right-bottom borders that were not shown normally.
7971Grid.DesktopThe black border of the focused cell that was not shown normally.
7972Grid.DesktopDemo Features throws file path exception demonstrating Pictures feature.
7973Grid.DesktopAdds SetSelectedIndex method to ComboBox to avoid recalculating all the formulas.
7974Grid.DesktopPresses a key on ComboBox of a cell would invoke editing.
7975Grid.DesktopFont size bug in Format Cell Dialog.
7976Grid.DesktopThe focused cell had been changed when validation failed.
7977Grid.DesktopPastes cells several times, certain cells’ background color are set to blue.
7982Grid.DesktopData sorting performance issue
7983Grid.DesktopClicks header lines, the row height / column width is changed.
7984Grid.DesktopCan not copy content in input box of a cell via ctrl+c.
7985Grid.DesktopThrows exception when changing a value above the frozen rows.
7986Grid.DesktopUpdates all references of the formulas when inserting or deleting rows or columns.
7987Grid.DesktopChanges a cell’s value,only the relative formulas will be recalculated and not all.
7988Grid.DesktopPerformance issue for Copying/ Pasting/ Deleting a number of cells
7989Grid.DesktopPerformance for calculating array formulas
7990Grid.DesktopCalculates RowsCount / ColumnsCount properties error when accessing Cells / Rows / Columns properties of Worksheet.
7991Grid.DesktopPerformance for ImportDataTable
7992Grid.DesktopChanges the height of hscrollbar and the width of vscrollbar from 20 pixels to 16.
7993Grid.DesktopAdds SetSelectedIndex method to ComboBox to avoid recalculating all the formulas.
7994Grid.DesktopModifies colors of gridlines, header lines & selections.
7995Grid.DesktopCalculates visible width of the drawing text error when a cell extended its text to the right cells.
7996Grid.DesktopPerformance for rendering worksheets
7997Grid.DesktopSetFont & SetFontColor methods of GridRow not work.
7998Grid.DesktopAn invalid cell name in the formula might cause an invalid cell reference
7999Grid.DesktopThe behavior while navigating cells via scrollbars and arrow keys.
8000Grid.DesktopPerformance of copying / pasting large numbers of cells including lots of formulas
8001Grid.DesktopIComparer exception occurs when a column value contained int and string types for auto-filtering data
8003Grid.DesktopUtilizes FormulaError object that now returns value instead of throwing exception
8004Grid.DesktopBoolean value in a cell does not render to string value.
8006Grid.DesktopLocation of focused cell in rows/columns selection mode
8007Grid.DesktopEditing invisible focused cell issue
8020Grid.DesktopThe formula engine calculates the null value into result of empty string.
8085Grid.DesktopUpdates formulas error when deleting rows.
8289Grid.DesktopEnhances formula error messages.
8290Grid.WebPerformance issue for many error formulas.