Collapse All Expand All

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 == 0x20) 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).
• Fixed 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).
• Fixed autofilters which contain a list of values to ignore leading and trailing spaces when text cells or number formats have leading or trailing spaces (6.0.3.134).
• Fixed autofilters which contain a list of values to ignore case as Excel does (6.0.3.134).
• Fixed autofilter button status to repaint correctly when autofilters are modified using the API (6.0.3.134).
• Added a workaround for shapes in xls workbooks which contain an invalid image fill property (6.0.3.134).
• Fixed a divide by zero exception which occurred when using IRange.Copy where the source range consists entirely of rows hidden by an autofilter (6.0.3.136).
• Fixed an issue with form controls which remained visible when the rows containing them were hidden (6.0.3.138).
• Fixed a problem with writing Excel 97-2003 (.xls) workbooks which caused Excel 2007 and Excel 2010 to sometimes use an incorrect cell format (6.0.3.140).
• Improved color palette matching when converting an RGB color to a color index such as when using one of the ColorIndex properties or when saving to Excel 97-2003 (.xls) workbooks (6.0.3.140).
• Fixed a problem with IWorkbookSet.CalculateFullRebuild which caused problems with circular reference formula cells which could lead to a lack of iteration for circular formulas (6.0.3.142).
• Fixed ISheet.EvaluateRange, EvaluateRanges, EvaluateValue and EvaluateValues to take into account the active cell so that formulas which depend on them (such as formulas which use the ROW() and COLUMN() functions) will work correctly (6.0.3.144).
• Fixed problems which occurred when parsing and unparsing cell references associated with charts and data validation lists when reading and writing the Open XML (.xlsx) file format where a workbook is using the R1C1 cell reference style (6.0.3.144).
• Added a workaround for a problem which caused Excel to ignore some formula cells which result in text values when copying to the clipboard from SpreadsheetGear and pasting to Excel (6.0.3.144).
• Fixed a problem which caused formulas using COUNTBLANK to sometimes not be updated when changes are made to ranges they depend on (6.0.3.144).
• Improved number formatting rounding to be more compatible with Excel (6.0.3.154).
• Fixed issues where the display of formula results in the WorkbookView were sometimes not being updated with worksheets that also contain conditional formats that use formulas (6.0.3.154).
• Fixed a problem which could occur when copying cells within a column after inserting or deleting rows within that column (6.0.3.156).
• Fixed a problem which caused formula cells involved in circular references to sometimes not be calculated as needed after making a change to a workbook (such as inserting, deleting or moving cells) (6.0.3.160).
• Reduced memory usage for some single cell array formulas (6.0.3.160).
• Fixed to throw an exception rather than hanging when trying to read certain workbooks which contain corrupt compound document indexes (6.0.3.162).
• Fixed a performance problem which caused wildcard searches with '*' to run very slowly as the number of sequential '*' characters increased (6.0.3.162).
• Fixed IRange.HasFormulaDefined and IRange.HasArrayDefined to return the correct result when the IRange being checked refers to cells below the last row in a column or beyond the last column in a worksheet (6.0.3.168).
• Fixed a problem with IRange.GoalSeek which caused some solvable cases to fail to converge (6.0.3.168).
• Fixed a problem which caused exceptions to be thrown when cells have formulas with the HYPERLINK function where the argument(s) to the HYPERLINK function have certain expressions involving cell references (6.0.3.170).
• Improved goal seeking to converge in more cases (6.0.3.170).
• Fixed a problem with deleting entire rows or entire columns in a frozen pane which sometimes caused frozen rows or columns to be redisplayed in the non-frozen pane(s) (6.0.3.170).
• Fixed to check for minimum ScrollRow when ungrouping across freeze panes and setting the ScrollRow in order to scroll cells into the viewing area (6.0.3.170).
• Fixed issues when formatting or setting text on individual chart series data labels which caused Excel 2003 to crash when opening XLS files saved from SpreadsheetGear and moving the formatted data labels (6.0.3.170).
• Fixed a problem with undoing deletion of cells which caused the undo to insert entire rows even though only partial rows were deleted (6.0.3.170).
• Added a workaround to read Open XML workbooks written by 3rd party software with invalid named cell style records (6.0.3.172).
• Fixed a problem reading certain shapes and charts written by Excel 2010 (6.0.3.172).
• Fixed a problem with parsing VLOOKUP and HLOOKUP when used in the first argument to the IF function inside of an array formula (6.0.3.174).
• Fixed a problem with autofilters when using AutoFilterOperator.Values with values which start with one of "<>=" to allow a leading "=" as Excel does (6.0.3.174).
• Fixed an exception which occurred when columns were deleted where the worksheet has an autofilter which starts in the column >= the last deleted column + 2 (6.0.3.178).
• Fixed an Excel compatibility problem with reading and writing xls workbooks with formula cells containing string results where the strings are longer than approximately 4100 characters (6.0.3.178).
• Fixed a problem which caused data validation listbox updating to continually interrupt background calculation in some cases which could lead to very long background calculation times (6.0.3.178).
• Added a workaround to read invalid cell formulas written by Apple Numbers (6.0.3.178).
• Fixed an issue with formula cells not rendering correctly after changing a referenced cell when the WorkbookView has multiple frozen panes (6.0.3.184).
• Fixed a scroll position issue which occurred when a one row DisplayReference is used in conjunction with frozen panes at the bottom of that one row (6.0.3.184).
• Fixed some issues with DataValidation and AutoFilter custom dropdown controls when running the Windows Forms WorkbookView in WPF (6.0.3.184).
• Fixed IRange.Copy when using PasteType.Values or PasteType.ValuesAndNumberFormats to honor the IWorkbookSet.Calculation setting (6.0.3.186).
• Fixed a bug with LINEST and LOGEST which caused incorrect results to be returned or exceptions to be thrown when KnownY's are transposed and KnownX's are ommitted and both of the 'const' and 'stats' parameters are true (6.0.3.192).
• Fixed an issue which caused shapes to sometimes be incorrectly positioned after clearing autofilters (6.0.3.192).
• Fixed undoing of cell formatting to no longer incorrectly clear merged cells (6.0.3.192).
• Added a workaround to deal with xls workbooks written by SSRS with incorrect column width information so that Excel 2003 does not revert to default column widths (6.0.3.194).
• Fixed a bug which occurs with the use of certain combinations of using the IF function in an array formula in a complex workbook (6.0.3.196).
• Fixed a problem which caused the OFFSET function to sometimes return incorrect results when used in an array formula or as an argument to a function which expects an array (6.0.3.196).
• Fixed opening Open XML workbooks with data validation lists such as "Red,Green,Blue" to work correctly when opening into a workbook set with an argument seperator which is not a comma (6.0.3.200).
• Fixed a problem writing data validation formulas with 3d relative references to xls files (6.0.3.202).
• Added workaround to read Open XML workbooks written by certain 3rd party software (6.0.3.204).
• Fixed a problem with the SMALL, LARGE, PERCENTILE, QUARTILE, TRIMMEAN, RANK and PERCENTRANK functions which caused formulas containing them to sometimes not be recalculated as needed (6.0.3.206).
• Fixed a problem which caused the QUARTILE and PERCENTILE functions to return incorrect results for certain complex workbooks (6.0.3.208).
• Fixed a problem with some references to external workbooks not updating when the referred to workbook is loaded into a workbook set after the referring workbook (6.0.3.214).
• Fixed deleting of a named cell style which is in use to revert the referring cells to the default named cell style rather than leaving the workbook in an undefined state (6.0.3.216).
• Fixed cases where ROUND function was not compatible with Excel (6.0.3.218).
• Fixed XIRR to solve certain cases which used to return an error (6.0.3.224).
• Fixed a problem with autofilter dropdowns which caused it to sometimes not include all values and / or colors (6.0.3.224).
• Fixed a problem which caused cells which are dependant on What If tables to sometimes not reflect the up to date What If table result when the API is used to get the values of cells without first calling IWorkbookSet.Calculate() (6.0.3.226).
• Fixed a problem which caused reading of an Open XML workbook containing a conditional format with a vertical alignment setting of baseline to change the setting to superscript (6.0.3.230).
• Fixed a calculation problem which caused the IF function to return the wrong result when used in an array formula in some complex workbooks (6.0.3.232).