Fixed an issue which caused a failure to fixup cell references in certain cases where multiple conditional format conditions apply to a cell and the criteria is a complex formula with relative references.
Fixed number formatting to handle cases such as "a"General"b".
Fixed WorkbookView.ContextMenu property to initialize the context menu before returning it in the property getter.
Fixed to allow copying from a partial array formula range.
Improved IRR to no longer favor values between the guess and zero over values closer to the guess.
Fixed hiding and showing of rows and columns to update IRange.ShowDetails as needed.
Fixed issue with changed formula cell in view area not rendering in some cases when scrolling.
Fixed thousands separator parsing and formatting to consider '\u202F' as well as '\u00A0'.
Fixed some painting issues when scrolling past ends of worksheet.
Fixed various issues with Data Validation dropdown.
Fixed a case where we were trying to handle OnPaint when calling Control.Dispose while updating the screen after scrolling (another case of the OLE COM message pump issue).
Fixed a NullReferenceException with cell validation when a modal dialog is displayed after clicking the mouse.
Fixed a performance issue which occurred when there are large numbers of defined names where many of these names refer to names which refer to names, etc...
Fixed a problem which caused an exception to be thrown if identical Unicode text longer than 127 characters is contained in more than 255 cells.
Fixed a problem which caused reading of certain password protected Open XML workbooks to throw an exception.
Fixed a problem which sometimes occurred when copying array formulas to other cells in the same column.
Fixed a problem with copying to the clipboard in some cases when autofilters are applied and the source range has exactly one visible row.
Fixed a problem with EOMONTH which caused it to return an incorrect result when used in a non-array cell formula with arguments including a MATCH function with an array constant for the 'lookup_array' argument.
Fixed a problem with IRange.Copy which occurred when used with PasteType.Values and fewer rows in the source range than the destination range.
Fixed a variety of issues with print black and white.
Fixed an issue which caused a null reference exception to be thrown when copying a worksheet which contains worksheet specific defined names which contain circular references.
Fixed an issue which caused an exception to be thrown in certain cases when pasting cell formulas which reference worksheet scoped defined names on a worksheet in another workbook.
Fixed an issue which caused certain complex conditional formats to not repaint after a workbook set is calculated.
Fixed an issue which caused conditional formats to sometimes not be rendered correctly when they are scrolled into view.
Fixed an issue which caused exceptions to be thrown in cases where multiple unused WorkbookVIew controls are reclaimed by the garbage collector at one time without having had Dispose called on them.
Fixed an issue which caused LINEST, LOGEST, GROWTH and TREND to sometimes return inconsistent results if the number of columns in 'known_xs' is greater than the number of rows in 'known_ys'.
Fixed an issue which caused LINEST, LOGEST, GROWTH and TREND to fail to remove colinear columns in certain cases when there are multiple colinear columns.
Fixed cases where adding a merged cell incorrectly enlarges the current selected range even if the selection contains entire rows or entire columns.
Fixed column width issue which caused large column widths to be truncated with smaller than normal default workbook fonts.
Fixed data validation listboxes to ignore blank entries in criteria specified by hard coded comma separated lists.
Fixed dropdown listboxes to work with a single cell reference for the linked range.
Fixed hyperlinks to handle square braces such as [address]subaddress.
Fixed IFERROR problems with certain complex formulas.
Fixed issue with number formatting and precision as displayed where format == "# ?/?%" and the value is 9E21.
Fixed issues with Hyperlink linked to external workbook reference.
Fixed Outline expanders to work more like Excel when rows or columns are hidden within a grouped range.
Fixed parsing formatted numbers which are both fractions and percent.
Fixed saving of merged cells extending beyond IV65536 to xls workbooks to maintain the partial merged cell as Excel does.
Fixed to be able to read workbooks with table rerferences containing double quotes.
Fixed various issues with data validation listbox not refreshing location when changing selection.
Fixed various issues with TextBox editing on charts and chart sheets.
Fixed WorkbookView OnPaint exception in Windows Forms when closing Workbook Designer with two child workbooks each containing a form control.
Fixed worksheet and chartsheet numbering for new sheets to work like Excel. They each keep their own next sheet number and that number gets reset to 1 when a workbook is opened.
Fixed writing column widths to xls when width is > UInt16.MaxValue.
Improved performance of merging large ranges of cells.