Issues resolved in SpreadsheetGear 2010 include:
- Changed the way some cell formula defined name references are copied when copying entire worksheets to reflect the same change made by Microsoft in Excel 2010.
- Modified the ISheet.Name property setter to enforce Excel's sheet name limitations (see the ISheet.Name documentation for more information).
- Improved compatibility with Excel for what is and is not a legal defined name.
- Fixed converting text to numbers to allow spaces (char == 0x32) as thousands separators when the CultureInfo specifies that the thousands separator is 0xA0 as is the case with the French CultureInfo.
- Fixed a problem with rounding floating point numbers on 64 bit .NET 4.0 which resulted from a bug in the .NET 4.0 just in time compiler generating invalid code in a release build when run with no debugger.
- Fixed a problem with autofitted rows and wrapped text which caused some cells with wrapped text to be ignored.
- Fixed a problem with inserting and deleting rows and columns not properly updating the number of frozen rows and columns.
- Fixed to disable zooming with Ctrl+MouseWheel when in edit mode.
- Fixed IRange.Insert and IRange.Delete to throw exceptions if the worksheet is protected as Excel does.
- Fixed Autofill to allow filling when the cells being filled from are locked, the cells being filled are unlocked, and the worksheet is protected.
- Fixed cell comments in merged cell areas which were not popping up unless hovering over the top-left cell of the merged area.
- Fixed the creation of merged cell areas to properly handle cell comments, data validation and conditional formats in cells which no longer exist after merging.
- Fixed issues which sometimes occurred when frozen panes were combined with data validation list boxes.
- Fixed issue with the sheet tab bar painting incorrectly over the bottom-right corner of the WorkbookView.
- Fixed drop-lines, hi-low lines and up-down bar rendering to use correct order when used on multiple chart groups.
- Fixed Ctrl+Home to work correctly when no visible rows / columns are viewable on screen.
- Fixed NullReferenceException which occurred when reading shape styles for picture shapes in Open XML workbooks.
- Added support for reading shapes which use the oneCellAnchor flag in Open XML workbooks.
- Fixed a problem which caused Excel 2007 to sometimes have problems handling workbooks written by SpreadsheetGear which contain references to cells beyond the Excel 2003 64K row x 256 column limit, including some cases with entire row / column references such as 5:5 or E:E.
- Fixed an issue with individual data label formatting being lost when opening and then saving with SpreadsheetGear and then opening in Excel.
- Fixed a number of Excel 2010 file format compatibility issues due to differences between Excel 2007 and Excel 2010.
- Fixed date / time parsing issues with text such as "5-001" and "05:030" which are no longer parsed as dates and times.
- Fixed a problem which caused Data Validation to not properly honor IgnoreBlanks in some cases.
- Fixed problem with grouped rows / columns sometimes not being scrolled into view when expanding the top row or left column of a group.
- Added ability to undo outline group expanding and collapsing.
- Make actions in validation lists and form controls linked to cell values undoable.
- Fixed inserting and deleting to adjust row and column manual pagebreaks.
- Fixed inserting and deleting entire rows and columns to fix up frozen rows and columns as Excel does.
- Fixed an issue where comments were not being displayed across frozen panes.
- Fixed problems which could cause automatic row height to be incorrect after inserting and deleting cells / rows / columns.
- Fixed issues with line breaks not being written as paragraph elements in the Open XML file format.
- Fixed a problem where cutting a formula such as "=SUM(A1:A4)" from Sheet1!A5 and pasting the formula to Sheet2!A5 incorrectly changed the new formula to "=SUM(Sheet2!A1:A4)" rather than the correct "=SUM(Sheet1!A1:A4)".
- Fixed a problem which caused unhiding rows / columns at the bottom / right edge of frozen panes to scroll up / left into the frozen rows / columns.
- Fixed parsing of times to handle abbreviated times such as "5 p" and "5 a".
- Fixed handling of leading spaces in hard coded validation lists such as "Red, Green, Blue" (two spaces before Blue) to work as Excel does by ignoring spaces for validation and by not displaying the spaces in the dropdown listbox.
- Fixed commands which are not allowed for partial array formulas to also check for data tables.
- Fixed to read Open XML workbooks with streams having an uncompressed size >= 2GB.
- Fixed an exception and disabled CategoryType option in Chart Explorer when used on chart types which do not support it.
- Fixed the ISheet.Visible and ISheet.Name property setters to throw exceptions when the containing workbook is protected.
- Fixed to convert square braces in sheet names to parenthesis upon writing Open XML workbooks as Excel does.
- Fixed ISheet.CopyAfter and ISheet.CopyBefore to trim the length of new sheet names as needed to avoid creating invalid sheet names.
- Fixed hairline cell border rendering to use a 50% hatch pattern fill, similar to Excel.
- Fixed a problem which caused data validation using a list to fail to properly link the listbox to the cell being validated if the workbook set is using ReferenceStyle.R1C1.
- Fixed a problem which caused SpreadsheetGear to write an invalid data validation record to the Excel 97-2003 file format after reading an Open XML workbook with a data validation rule which contained a comma separated list for the criteria.
- Fixed IStyles.Borders[BordersIndex index] to throw an exception if an invalid index is passed.
- Added support for setting IRange.Value to object[,] for a single cell IRange.
- Fixed a problem which caused autofilter dropdowns to not reposition correctly in Excel 2003 after opening a workbook with autofilters saved by SpreadsheetGear 2010 and then resizing a filtered column (6.0.3.106).
- Fixed a problem which caused incorrect formula results to be returned in certain cases where defined name formulas which reference certain functions (such as INDEX) are modified (6.0.3.114).
- Improved XIRR to converge on an answer for wider ranges of inputs (6.0.3.114).
- Fixed a problem which caused autofitting rows to sometimes ignore some cells if there are unformatted cells above them (6.0.3.114).
- Fix a problem with undo after clearing cells which sometimes caused automatic row heights not to be adjusted as needed for text cells with wrapped text (6.0.3.118).
- Fixed autofit rows to work with cells which use wrapped text and HAlign.CenterAcrossSelection (6.0.3.118).
- Fixed HLOOKUP, VLOOKUP, LOOKUP, MATCH, SUMIF, COUNTIF, Database functions and autofilters to handle the nuances of the escape character ('~') as Excel does (some of these escape any character following '~' and some escape only '?' and '*') (6.0.3.128).
- Fixed an exception which occurred when auto-filling and scrolling over hidden rows or columns by dragging the mouse outside of the WorkbookView (6.0.3.128).