Collapse All Expand All

Issues resolved in SpreadsheetGear 2012 include:

• Fixed a UI locking issue when auto filling and scrolling by dragging the mouse past the end of the WorkbookView.
• Fixed OFFSET function to support returning an array of ranges when used in an array formula.
• Fixed to use the default number format for Open XML number formats which cannot be read.
• Fixed to clear undo buffer when IWorkbook.SaveToMemory is called.
• Fixed IStyle.Equals to no longer cause a stack overflow exception.
• Fixed saving Open XML workbooks with external workbook references to no longer prepend "file:///" to paths which do not start with "X:\" where 'X' is a drive letter.
• Fixed the behavior of adjusting the first displayed sheet tab when a worksheet is selected or deleted.
• Fixed to support Locale.ArgumentSeparator when editing formulas in a WorkbookView control.
• Improved IRR to converge on a result in more cases.
• Fixed Workbook Designer freeze panes menu command to not freeze columns when entire row is selected and not freeze rows when entire column is selected.
• Fixed scrollbar thumb and value positions to account for hidden (non-viewable) rows/cols at beginning and end of worksheet.
• Fixed issues with RangeExplorer clearing cell formatting when formatting hyperlinks.
• Changed WorkbookView.OnMouseMove to display a GetLock / ReleaseLock warning only when a debugger is attached.
• Fixed mouse wheel scrolling issue which occurred when using a high-resolution mouse.
• Fixed IRange.Merge to throw an exception if an attempt is made to merge a single cell.
• Fixed chart line markers to no longer render outside of plot area.
• Fixed autofill & data-series APIs to sometimes copy cell formatting (font, interior, etc...) as Excel does.
• Fixed some issues with plotting error and empty type values on area charts that use a date axis.
• Fixed refresh issues with the WorkbookView control when using the Dock / Undock smart tag item in Visual Studio.
• Fixed default TextBox horizontal alignment when reading Open XML document.
• Fixed cell merging to fix up cell borders and formats.
• Fixed reading of Open XML external references such as "/Dir/Book.xlsx" to convert to "C:\Dir\Book1.xlsx" as Excel does, and fixed writing external references such as "C:\Dir\Book1.xlsx" to be written as  "/Dir/Book.xlsx".
• Fixed printing routine to only print visible sheets when printing entire workbook.
• Fixed to no longer include the active cell when using CTRL or SHIFT with MouseDown to point at a range when editing a formula.
• Fixed reading Open XML files to handle xmlns in cases where an exception was being thrown.
• Fixed copying and pasting of an entire row to be smarter about not creating a large number of blank formatted cells.
• Fixed HLOOKUP, VLOOKUP and MATCH to compare numbers as Excel does, no longer considering two numbers equal if they are very close as the "=" operator does.
• Fixed autofilter and data validation drop down controls to choose a more appropriate height to fix the problem where they are not displayed when the default row height is zero.
• Fixed to read and display shapes which hang past the edge of a worksheet.
• Fixed to remove incomplete conditional formats before writing workbooks to avoid writing workbooks which Excel will not read.
• Improved performance when reading Open XML workbooks with a large number of external targets (such as hyperlinks).
• Fixed AutoFill mouse handler to execute FillDown / FillRight when worksheet has autofilters on as Excel does.
• Fixed default print range to work more like Excel regarding blank formatted cells.
• Added Outlines option to LocationToRange / RangeToLocation APIs.
• Fixed theme color picker to not select Transparent color tooltip label for white.
• Fixed undo and redo to handle frozen or split panes correctly.
• Fixed to no longer display two error message boxes when beginning a cell edit on a protected worksheet with the Backspace key.
• Fixed to no longer convert references such as $A5:$A$1048576 to #REF! when inserting rows above the cell containing the reference.
• Fixed picture shape to no longer display visible border upon creation and fixed issues with writing picture line format information in .xls files.
• Fixed UI to invalidate and refresh correctly after visible comments are moved when sorting a range.
• Fixed RangeExplorer issue where merge cells checkbox was not being reset upon command execution failure.
• Fixed issues with automatic row height when wrap text flag is being used in a cell.
• Fixed WorkbookView navigation to skip rows and columns that have very small sizes and are not visible on screen.
• Fixed problem saving Excel 2003-generated WordArt objects which caused saved workbooks to fail in the Office File Validation tool.
• Fixed issues with comments not displaying in the correct location when visible across frozen panes.
• Fixed chart rendering issues with line charts, line markers, and various stock chart features.
• Fixed IPageSetup.PrintArea, PrintTitleRows and PrintTitleColumns to work correctly when IWorkbookSet.ReferenceStyle is set to ReferenceStyle.R1C1.
• Fixed in-cell editor to always choose left alignment when using the Input Method Editor (IME) since the IME only supports left alignment.
• Fixed FormulaBar name box so that it does not list defined names that do not refer to ranges.
• Fixed NullReferenceException which occurred when a WorkbookView tried to display a disposed worksheet.
• Fixed NullReferenceException which occurred when printing with a print title referring to #REF!
• Fixed NullReferenceException which occurred when user scrolls WorkbookView after ActiveWorkbook is closed.
• Fixed cases where auto sizing of row heights caused shape positions to be left in an undetermined state.
• Fixed to write workbooks with custom functions beginning with "_xll." as non-shared formulas as Excel does.
• Fixed an issue which caused an exception after setting certain ThemeColor properties to ColorSchemeIndex.None.
• Fixed cell comments and internal controls used for data validation and autofilters to display property when DisplayDrawingObjects is set to false.
• Fixed an issue which caused autofilter dropdowns to not be removed when frozen panes are removed.
• Fixed an issue which caused an exception to be thrown if sheet protection is turned off while editing a textbox form control.
• Fixed cases where textbox form controls were not rendering fills and lines.
• Fixed an issue which caused cell hyperlink information to be left on the screen when the mouse is moved over row or column headers.
• Fixed data validation dropdown listbox and listbox control to display formatted cell text instead of raw cell values.
• Fixed PrintPreviewDialog to work properly when is displayed as a modal dialog.
• Fixed a calculation problem where references to worksheets which are not loaded into the workbook set caused null reference exceptions.
• Fixed pictures to use no line and no fill by default when reading Open XML files with no formatting information.
• Fixed a problem which caused null reference exceptions when evaluating certain conditional formats and data validation rules.
• Fixed issue loading workbook with Table references to Table columns with names like "1c" or "123" as in "=SUBTOTAL(109,[1c])".
• Fixed a problem which caused four builtin number formats to be incompatible with Excel: ("#,##0_);(#,##0)", "#,##0_);[Red](#,##0)", "#,##0.00_);(#,##0.00)" and "#,##0.00_);[Red](#,##0.00)").
• Fixed printing of a selected range including entire rows and / or columns to trim the size of the range to be printed to cells containing content.
• Fixed an issue which caused a NullRefException when clearing all data linked to a chart date axis.
• Fixed reading .CSV files to support reading 1048576 rows when there is a CRLF after the last row.
• Fixed scrolling to work better in certain cases where touch is used or where the scrollbar thumb is moved a single pixel.
• Fixed a problem which caused invalid numbers to be placed in cells when setting IRange.Value to the System.Decimal value -0.0m (negative 0.0) (7.0.4.110).
• Added an Aero2 theme to the WPF WorkbookView control for improved Windows 8 support  (7.0.4.110).
• Changed WPF WorkbookView mouse handling code to mark MouseUp events as handled only when an action is taken (7.0.4.110).
• Fixed a problem with row and column header text which occurred with some High Contrast Windows 8 themes (7.0.4.110).
• Fixed a problem in IRange.Copy which caused exceptions to be thrown in certain cases (7.0.4.110).
• Fixed problems with some Excel 2007 / 2010 compatible functions which caused #VALUE! to be returned when a single value was expected, but a vector of cells was passed in (such as A:A or 1:1) (7.0.4.110).
• Fixed a problem with the SUMIF and COUNTIF functions which caused them to return an error when the specified criteria value was an error (7.0.4.110).
• Fixed a problem which caused an exception to be thrown when a cell containing an empty text string was formatted (7.0.4.110).
• Fixed a multithreaded recalc issue which caused IWorkbookSet.MaxChange to work inconsistently if it was changed after the first recalc of a workbook set, or if a workbook with a different MaxChange value was added to or removed from a workbook set (7.0.4.110).
• Fixed F.DIST to no longer return #NUM! for some valid boundary conditions (7.0.4.114).
• Made a minor improvement to the way sheet tabs are rendered (7.0.4.118).
• Fixed problems writing workbooks which contained formulas with external references to cells containing text (7.0.4.124).
• Fixed a Windows Forms WorkbookView painting problem which occurred when scrolling with fixed panes (7.0.4.126).
• Fixed printing problem which occurred when the last row or column being printed is hidden (7.0.4.126).
• Fixed parsing of cell values to require non-zero digits left of the thousands separator as Excel does for a value to be treated as a number, so "0,123" and "0,123,456" are treated as text rather than numbers (7.0.4.126).
• Fixed problems with editing and automatic sizing of rich text cells (7.0.4.130).
• Fixed PRICE, YIELD and ODD* functions to handle negative rates consistently even though Excel 2013 does not do so (7.0.5.118).
• Fixed a problem which occurred when copying text cells over the top of themselves (7.0.5.118).
• Fixed various issues which occurred when editing percent values with the in-cell editor and formula bar (7.0.5.118).
• Fixed an issue with the autofilter dropdown listbox position being set to an invalid value when rows are hidden or deleted (7.0.5.118).
• Fixed an issue which caused corruption of formula cells in certain cases where formula cells are copied or created (7.0.5.118).
• Fixed a calculation problem which could cause exceptions or invalid results after certain workbooks are calculated and then have their formula structure modified by inserting or deleting cells or by creating or modifying formulas (7.0.5.118).
• Fixed an issue in the Silverlight and WPF WorkbookView controls where background calculation was being continually interrupted by UI updating code causing calculation to make no progress for certain complex workbooks (7.0.5.138).
• Fixed various issues with the SpreadsheetGear Silverlight Samples (7.0.5.142).
• Fixed problems with the display of message boxes in WPF and Silverlight (7.0.5.142).
• Fixed exceptions when toggling Silverlight checkbox menu items (7.0.5.142).
• Fixed a problem with the display of "(Blanks)" in the autofilter dropdown list when there are blank cells in a column (7.0.5.142).
• Fixed a problem reading certain workbooks written by third party software which caused some blank formatted cells to be populated with a number (7.0.5.142).
• Fixed a Silverlight textbox editing scenario where Enter and other keys were not recognized (7.0.5.144).
• Fixed a calculation problem which caused an exception to be thrown for certain complex workbooks (7.0.5.144).
• Fixed entering an apparent fraction such as "1/0" to create a cell with the date "Jan 1, 2000"  as Excel does instead of creating an invalid cell with the numeric value Double.PositiveInfinity which can lead to exceptions being thrown later (7.0.5.146).
• Improved IHyperlinks performance with a large number of hyperlinks (7.0.5.150).
• Fixed an issue in the WorkbookView where selected AutoFiltered items beginning with an operator (<, >, =) did not filter properly (7.0.5.150).
• Fixed a problem which caused incorrect results to be returned by IWorksheetWindowInfo.RowToPoints and PointsToRow when a large number of adjacent rows were set to a large row height (7.0.5.150).
• Fixed an issue which caused an exception to be thrown in the case where a WPF WorkbookView control has a custom UIManager which overrides CreateCustomControl(IShape) and returns a WPF FrameworkElement, and the returned WPF FrameworkElement is then displayed in a Windows Forms WorkbookView control (7.0.5.150).
• Fixed data validation drop down listboxes which refer to cells containing text to use the unformatted cell text rather than the formatted cell text as Excel does (7.0.5.150).
• Fixed an issue where cells with General horizontal alignment, a numeric value and formatted as text ("@") incorrectly align right instead of left when rendered (7.0.5.150).
• Fixed an issue which caused the in-cell editor to sometimes be the wrong size in WPF and Silverlight (7.0.5.154).
• Fixed an issue which caused workbook set CultureInfo settings to sometimes not pick up customizations of the default or current CultureInfo (7.0.5.154).
• Fixed a problem where using the OFFSET function in an array formula could throw an exception for cases where very large arrays must be returned (7.0.5.154).
• Fixed a problem where copying cells when the source and destination columns overlapped would incorrectly leave some cells blank (7.0.5.154).
• Fixed an issue which caused a null reference exception to be thrown if a subclass of CommandManager returned null from CreateCommandDelete or CreateCommandInsert (7.0.5.164).
• Fixed Windows Forms rendering of arrowheads on cell comments to scale correctly when printing and in print preview by rendering our own arrowheads rather than using a GDI+ AdjustableArrowCap (7.0.5.164).
• Fixed issues with the ShapeAction event not being fired consistently for cell comments and for cases where worksheet protection is modified (7.0.5.164).
• Fixed a problem which caused Excel to return #NAME! for cell formulas containing NETWORKDAYS.INTL, WORKDAY.INTL, COUNTIFS, IFERROR or SUMIFS after reading an Excel 97-2003 (.xls) workbook which was written by SpreadsheetGear (7.0.6.104).
• Fixed an issue which caused Excel to return #REF! after reading Excel 97-2003 (.xls) workbooks written by SpreadsheetGear for formulas which contained Union, Range or Intersection operators with arguments containing 3d references or functions such as INDIRECT (7.0.6.104).
• Added a work around to read certain workbooks written by 3rd party components (7.0.6.108).
• Fixed an exception in the WPF and Silverlight controls which occurred when editing a cell if an attached FormulaBar control is collapsed (7.0.6.112).
• Added a workaround for an issue with base / default column widths for Open XML workbooks written by certain 3rd party software (7.0.6.112).
• Fixed an issue where IGradientStops.InsertAt(...) did not insert new stop at the given index (7.0.6.116).
• Fixed an issue which caused cells containing numbers between -1 and 1 formatted with the "General" number format to display with an exponent of "E+01" instead of "E-01" when the width of a column is narrow enough to cause SpreadsheetGear to display the number as scientific notation (7.0.6.116).
• Fixed an issue which caused a division by zero exception to be thrown when rendering certain  charts with a height or width of zero due to hidden rows or columns (7.0.6.116).
• Fixed to read saved supporing workbook data as Excel does when the 'refreshError' attribute of the CT_ExternalSheetData type is true in an Open XML workbook (7.0.6.116).
• Fixed a problem which caused exceptions to be thrown after using Find & Replace to modify formulas with a workbook set which is attached to a WorkbookView with Undo and Redo enabled (7.0.6.120).
• Fixed an issue in the GEOMEAN function which caused 0 to be returned rather than #NUM! for certain cases (7.0.6.124).
• Fixed an issue which caused certain workbooks using functions such as OFFSET and INDEX to throw exceptions when calculating (7.0.6.136).
• Fixed to support reading and writing IWorkbook.ReadOnlyRecommended to Open XML workbooks (7.0.6.142).
• Fixed WPF and Silverlight in-cell editor to paste multi-line text (7.0.6.144).
• Improved the calculation performance of certain workbooks which used functions such as INDEX, OFFSET, HLOOKUP and VLOOKUP with large ranges of cells (7.0.6.144).
• Fixed an issue which sometimes caused SUMIFS, AVERAGEIFS and COUNTIFS to throw an exception when evaluating ranges where some columns contain no valid criteria (7.0.6.144).
• Fixed problems which caused incorrect page numbers and total page counts to sometimes be printed in headers and footers(7.0.6.148).
• Fixed to try to load SpreadsheetGear2012.Drawing.dll and SpreadsheetGear2012.Windows.WPF.dll from the default path (including the Global Assembly Cache) if they are not found in the folder containing SpreadsheetGear2012.Core.dll (7.0.6.148).
• Fixed problems which caused PERCENTILE.EXC, QUARTILE.EXC and QUARTILE.INC to sometimes return incorrect results (7.0.6.148).
• Improved the performance of saving certain sparsely populated workbooks (7.0.6.148).
• Fixed an issue where an exception would be thrown when rendering a chart with special-case series attributes.  Also made series auto color rendering more consistent with Excel for these special-case series (7.0.6.148).
• Fixed an issue which caused exceptions to be thrown after copying an entire worksheet which contained autofilters (7.0.6.154).
• Fixed an issue which caused an exception to be thrown when reading certain xls workbooks with extended characters in cell text (7.0.6.154).
• Fixed an issue which caused SUMIFS, COUNTIFS and AVERAGEIFS to sometimes run slowly and to sometimes incorrectly return #VALUE!  (7.0.6.164).
• Fixed an issue which caused certain formulas containing whitespace to return incorrect results (7.0.6.164).
• Fixed a problem which caused the WorkbookView control to fail to repaint cells after calling IRange.Copy where the source range is larger than the destination range and the source worksheet is different than the destination worksheet (7.0.6.166).
• Fixed an issue which sometimes made selecting text difficult in the in-cell editor of the WPF and Silverlight WorkbookView controls (7.0.6.166).
• Fixed textbox autoshape editing in WPF and Silverlight to allow scrolling vertically when the text is too tall for the textbox (7.0.6.166).
• Fixed an issue which caused the TextBox autoshape to be repainted incorrectly after editing the textbox in the WPF WorkbookView control (7.0.6.166).
• Fixed the FormulaBar to display the defined name for the top-left cell of a merged cell when the merged cell is the active cell (7.0.6.172).
• Fixed an issue where the AVERAGEIF function did not return the correct result (7.0.6.172).
• Fixed ISheet.CopyAfter, ISheet.CopyBefore, ISheet.MoveAfter and ISheet.MoveBefore to return an instance of IChartSheet when the source ISheet is an IChartSheet (7.0.6.176).
• Fixed an issue which caused charts with both positive and negative custom error bar amounts to be saved incorrectly to Open XML workbooks (7.1.1.104).
• Fixed the Print... dialog box to be modal when using the WPF WorkbookView control from a Windows Forms application (7.1.1.122).
• Fixed a problem where calling IWorksheets.Add() while editing a cell caused the tab for the new worksheet to be displayed twice in the WorkbookView sheet tab bar (7.1.1.126).
• Fixed an issue which caused the IWorkbookSet.EndCalculate event to fail to be fired and also caused formula cells not to be repainted after some UI features (such as data validation dropdown lists) or APIs were used on workbooks with certain combinations of formulas (such as the INDIRECT function combined with circular references) (7.1.1.126).
• Added a workaround to allow reading of an Open XML workbook with the page setup first page number set to a value > 2147483647 (7.1.1.130).
• Fixed NullReferenceException for Excel 2013 workbooks that contain charts using a new series filter option.  Filtered series will be dropped when read into SpreadsheetGear (7.1.1.132).
• Fixed to throw a more descriptive exception (System.IO.IOException(string.Format("Unable to read unsupported function {0}", funcNumber))) when reading workbooks containing unsupported functions (such as the deprecated Excel 4 macro EVALUATE function) instead of throwing a NullReferenceException (7.1.1.132).
• Fixed issue where print headers and footers did not always scale correctly (7.1.1.144).
• Fixed ISheet.CopyBefore and CopyAfter to properly copy the current selection if it contains multiple areas (7.1.1.144).
• Fixed a problem which caused exceptions when calculating certain complex workbooks when connected to the Windows Forms WorkbookView control with background calculation off and without using GetLock() / ReleaseLock() (7.1.1.144).
• Fixed an exception which occurred in GDI+ when rendering an image to a picture autoshape which has a width or height of zero (7.1.1.144).
• Fixed issue which caused the RangeChanged event to be fired before cell references were fixed up when cutting and pasting cells (7.1.1.150).
• Fixed a problem which caused column formatting to be lost in certain cases where a row is formatted after the column, and the cell at the intersection of the row and column does not already have it's own format (7.1.1.154).
• Fixed an issue which caused exceptions or incorrect results when calculating if PrecisionAsDisplayed is enabled and certain changes had been made which affected cell formatting (7.1.1.154).
• Fixed reading Open XML files to handle xmlns attributes in shape fill elements (7.1.1.154).
• Fixed a problem which caused calculations to sometimes return incorrect results after setting IWorkbookSet.CalculationOnDemand to true (7.1.1.158).
• Fixed an issue which caused an exception if cell validation fails and the user chooses to Retry, but edit mode had been canceled for any reason (such as an API call which changes the currently active worksheet) before edit mode had been resumed (7.1.1.164).
• Fixed an issue which caused some rich text cells to fail to display the last visible line of text in the WPF WorkbookView control (7.1.1.164).
• Fixed a problem which caused non-interruptible calculation to occur with certain workbooks after editing a formula (7.1.1.164).
• Fixed an issue which caused the WorkbookView control to hang or run very slowly when Enter or Tab are pressed for certain combinations of selected ranges and hidden rows and hidden columns (7.1.1.168).
• Fixed an issue which caused columns to sometimes be hidden or set to a very narrow width when attempting to set the column to a very large width (7.1.1.168).
• Fixed a problem which caused formulas to fail to parse when an Intersection, Range or Union operator is followed by a space and then a #REF! error (such as "=Sheet1!#REF!, Sheet1!#REF!") (7.1.1.168).
• Fixed an issue which caused the WPF and Silverlight WorkbookView controls to fail to render pie slices with a sweep of 360 degrees (7.1.1.168).
• Fixed AutoFilter context menu position for the WPF WorkbookView control (7.1.1.172).
• Fixed an issue with rotated gradient fills in charts for the WPF WorkbookView control (7.1.1.172).
• Fixed an issue which caused Find and Replace to replace the first found instance twice in certain worksheets (7.1.1.172).
• Fixed an issue where Open XML workbooks containing formulas with OFFSET worksheet functions which contained #REF! errors but no valid cell references would not be opened because the formula could not be parsed (7.1.1.176).
• Fixed a problem which caused data validation to fail when a list of cells with certain types of number formats are used (7.1.1.180).
• Fixed an issue which caused XIRR to fail to converge in some cases where Excel does return a result because SpreadsheetGear was requiring a more accurate result. SpreadsheetGear still tries to find a more accurate result but falls back to less accuracy to return results in more cases (7.1.1.186).
• Fixed an issue which caused the WPF WorkbookView control to incorrectly render a trailing parenthesis for certain combinations of number formats and font styles (7.1.1.194).
• Fixed a problem with rendering of vertical text with space characters (7.1.1.194).
• Fixed the "filename" option of the CELL worksheet function to be more compatible with Excel (7.1.1.194).
• Fixed an issue which caused the loss of chart series line colors when reading an Open XML workbook written by Excel where the series had a custom line width but not a custom color (7.1.1.200).
• Fixed an issue which caused right-justified cells with trailing spaces to be rendered without the trailing spaces in some cases (7.1.1.200).
• Fixed some issues with the ACCRINT function (7.1.1.200).
• Fixed an issue related to variable calculation order due to use of the OFFSET function which caused certain workbooks not to be fully calculated when subsequent calculation was required after the initial calculation (7.1.1.204).
• Fixed an inconsistency with Excel in the LOOKUP worksheet function where #VALUE! was returned if the Results range was not large enough for the index of the matched value (7.1.1.208).
• Fixed the CELL worksheet function to return the workbook name and worksheet name with the "address" option when a different worksheet is specified in the second argument (7.1.1.212).
• Fixed an issue with SUMIFS and AVERAGEIFS which could cause unnecessary circular reference detection, leading to incorrect cell calculation order, in the case where cells in the sum / average range which do not meet the criteria would lead to circular references if they did meet the criteria (7.1.2.104).
• Fixed issue where copying a worksheet containing charts did not correctly copy axis BaseUnit setting (7.1.2.108).
• Fixed an issue with sorting which caused incorrect formats on re-ordered cells with certain combinations of individual cell formats interacting with formats applied to an entire row or entire column (7.1.2.108).
• Fixed an issue which caused Spinner form controls controls with a non-zero minimum to fire extra shape action events in the Windows Forms WorkbookView control (7.1.2.112).
• Fixed an issue with data validation dropdown listboxes in WPF and Silverlight which caused the listbox to not have the focus if there is currently no selected item in the list (7.1.2.112) when it is dropped down.
• Fixed an issue which caused footers to be printed in the wrong location when printing with the Center Vertically option enabled (7.1.2.112).
• Fixed an issue which caused cells in column A to lose formatting previously applied to column A when an entire row is being formatted for the first time, the cell in column A of that row does not have a unique format, and the attribute being set matches the format previously applied to column A (7.1.2.112).
• Fixed issues when paging down or right on a WorkbookView with a custom DisplayReference and hidden rows or columns (7.1.2.112).
• Improved the performance of SUMIF for certain cases where the range being summed contains a large number of formula cells and those formula cells are not used by SUMIF because those rows do not meet the criteria (7.1.2.116).
• Fixed an issue which caused an exception to be thrown when SpreadsheetGear.Windows.Printing.WorkbookPrintDocument is used from multiple threads (7.1.2.116).
• Fixed an issue where dropdown listbox form controls in the Silverlight WorkbookView control cause an exception when the list items are updated (7.1.2.116).
• Fixed the IFERROR function to pass through blank cells as blank rather than returning zero so that '=ISBLANK(IFERROR(A10,"ERROR"))' now returns TRUE if A10 is blank (7.1.2.122).
• Fixed deleting rows and columns to delete manual row and column page breaks as Excel does (7.1.2.122).
• Fixed an issue which caused rendering to fail when rendering cells with repeating characters in the number format. This only occurred in rare combinations of font sizes and column widths (7.1.2.124).
• Fixed an issue which caused formulas using the SUBTOTAL function to sometimes fail to automatically recalculate when the range being referenced by SUBTOTAL has row outlines and those outlines are collapsed or expanded (7.1.2.124).
• Fixed an issue which caused a NullReferenceException when editing formulas across multiple WPF WorkbookView controls which are contained in separate tabs of a tab control and linked to the same workbook set (7.1.2.134).
• Fixed issues which caused SpreadsheetGear help to sometimes be missing or out of date after running the SpreadsheetGear 2012 installer without first uninstalling a previous version of SpreadsheetGear 2012 (7.1.2.140).
• Fixed an issue which caused an exception to be thrown after pasting rich text cells with Paste Special or copying them with IRange.Copy when certain SpreadsheetGear.PasteType options are used (7.1.2.140).
• Optimized COUNTIFS, SUMIFS and AVERAGEIFS functions to be faster and more memory efficient, particularly when they reference entire columns of mostly blank cells (7.1.2.140).
• Fixed COUNTIFS and COUNTIF to work correctly when the result is greater than or equal to 2^32 (7.1.2.140).
• Fixed cells with word wrap enabled and repeating characters in the number format to render like Excel (7.1.2.140).
• Fixed an issue which caused copying of merged cells to fail to copy correctly when the columns in the source range are being replicated in the destination range multiple times (7.1.2.140).
• Fixed an issue which caused an exception to be thrown when reading some workbooks written by Google Docs Spreadsheet (7.1.2.140).
• Fixed an issue with all WorkbookView controls which caused calculation to be done on the UI thread when a chart is displayed for the first time, even though background calculation is enabled (7.1.2.140).
• Fixed printing hairline cell borders to print correctly when the Black and White printing option is used (7.1.2.152).
• Fixed ISheet.Select() and the IWorkbookWindowInfo.ActiveSheet and ActiveWorksheet property setters to throw an InvalidOperationException if the specified sheet is hidden (7.1.2.152).
• Fixed sorting to leave cell borders unchanged as Excel does (7.1.2.152).
• Fixed an issue which caused the copying of cell formats to too many rows if the source range had more than one row and the number of rows in the destination range was not an exact multiple of the number of source rows (7.1.2.152).
• Fixed an issue which caused Undo to sometimes incorrectly clear values from some cells after commands are performed on ranges with multiple areas (7.1.2.152).
• Fixed problems in the Windows Forms WorkbookView control caused by the fact that Windows sometimes calls WorkbookView.OnPaint(PaintEvengArgs) at unexpected times such as when disposing of a control or waiting on another thread due to COM Single Threaded Apartment message pumping (7.1.2.158).
• Fixed partially displayed merged cells to paint when the top left cell of the merged cell is modified but not displayed (7.1.2.158).
• Fixed an issue which caused some corrupt workbooks to go into an endless loop (7.1.2.158).
• Fixed an issue which caused Undo / Redo to fail to work correctly after selecting an item from a data validation listbox if the last cell with a data validation listbox was different from the cell where the Redo is being performed (7.1.2.162).
• Fixed an issue with the WPF WorkbookView control which caused WorkbookView.Print(false) to throw an exception (7.1.2.166).
• Fixed an issue which caused the various *Defined properties associated with an IRange (such as IRange.Fill.ColorDefined) to incorrectly return true in certain cases when the specified range extends beyond the last column with any non-empty cells (7.2.1.102).
• Fixed to read Open XML files with no size information in the Zip local file header and with no Data Descriptor record following the compressed data (7.2.1.102).
• Improved the RATE function to find an answer for more cases (7.2.2.100).
• Fixed an issue with the Silverlight WorkbookView control which caused dropdown combo boxes to close when the mouse is released if there is limited window space available for the dropdown (7.2.2.100).
• Fixed XIRR to ignore cases where the value is empty or zero and the date is empty as Excel does (7.2.2.100).
• Fixed Silverlight WorkbookView focus issues which occurred after closing combobox, data validation, and auto filter type drop downs (7.2.3.100).
• Improved IRange.GoalSeek to find an answer for more cases (7.2.3.100).
• Fixed problems creating or opening workbooks with the Silverlight WorkbookView with certain Macintosh culture settings which use a different character for the negative sign (7.2.4.100).
• Fixed painting problems in the Silverlight WorkbookView when converting unsupported pattern fills to solid fills (7.2.4.100).
• Fixed an issue which caused Factory.GetWorkbookSet() to throw an exception when DateTimeFormatInfo.DateSeparator or TimeSeparator is an empty string (7.2.4.100).
• Fixed adding of shapes at given top + height positions to verify that rows are autofitted if needed before the shape is actually added so that IShape.Top and IShape.Height do not change once rows are eventually autofitted (7.2.5.100).
• Fixed issues with BorderPicker in RangeExplorer when border colors are undefined or not available (7.2.5.100).
• Fixed a problem which occurred when copying formulas with area references containing mixed relative / absolute references where row 1 and row 2 or column 1 and column 2 were swapped but the relative / absolute flag for the references was not swapped (7.2.5.100).
• Fixed IWorkbookSet.Dispose() to stop background calculation if needed before disposing of the workbook set (7.2.6.100).
• Fixed an issue which caused incorrect formula results for certain large workbooks with a complex calculation order (7.2.6.100).
• Added a workaround to read Excel 2003 (.xls) workbooks written by Microsoft SQL Server Reporting Services (SSRS) with invalid MSO drawing record lengths for JPEG and PNG images which have a size greater then 64K (7.2.6.100).
• Fixed autofilter issues with zero length text, leading whitespace and trailing whitespace (7.2.6.100).
• Fixed an issue which caused numbers formatted as text and text cells which yielded the same text to be duplicated in the autofilter dropdown values list (7.2.6.104).
• Fixed an issue which caused entering a formatted value such as '1.0e5' into a cell which is formatted with a format such as '[>100000]"   ";0.000' (where the first number format section has a criteria but no actual number formatting) to incorrectly reformat the cell with the format of the entered value (7.2.6.104).
• Fixed an issue which caused the SUM function to return #REF! for a multisheet reference to a single cell (such as StartSheet:EndSheet!A1) in some cases, especially when used in array formulas (7.2.7.100).
• Fixed an issue which caused the Windows Forms WorkbookView control to sometimes fail to paint when there was a modal dialog box such as the data validation MessageBox displayed and a portion of the WorkbookView was uncovered (7.2.8.100).
• Fixed an issue which caused empty columns to be removed from autofilter ranges (7.2.9.100).
• Improved the performance and capacity of workbooks with large amounts of text in unique text cells (7.2.9.100).
• Fixed printing a worksheet with the print area set to entire rows and or entire columns to trim the actual printed range to the used range of the worksheet (7.2.9.100).
• Fixed an issue which caused inserting or deleting cells to incorrectly fix up conditional format formulas in certain cases where there are multiple condition formulas and certain relative references in some of the condition formulas (7.2.11.100).
• Fixed an issue which caused COUNTBLANK to return an incorrect value if the first column of the specified range is beyond column A and is also beyond the first column of the worksheet containing non-blank cells (7.2.11.100).
• Fixed problems with WorkbookXpsDocument.SaveToMemory and SaveToStream (7.2.12.100).
• Added a work around for an issue which caused Excel to be unable to open a workbook with a worksheet name such as "D5.1" and a formula such as ''=SUM(D5.1!A1:D5.1!B2)" (7.2.13.100).
• Fixed issue with automatic row heights involving hidden columns within a merged area with WrapText enabled or with CenterAcrossSelection alignment (7.2.14.100).
• Fixed an issue which caused SpreadsheetGear to write cell formulas which Excel could not read when worksheets names started with characters which looked like an R1C1 style row or column reference (such as "R1xxx" or "C2xxx") (7.2.15.100).
• Fixed an issue which caused some unicode whitespace characters to be lost when reading text from an Open XML workbook (7.2.16.100).
• Fixed Find and Replace to no longer update the underlying cell multiple times when doing multiple replacements in a single cell to fix cases such as replacing all occurrences of "#" with "=" in a cell which starts out as "#B1#B2". This fix also speeds up Find and Replace for multiple replacements in single cells (7.3.3.100).
• Add a work around for a System.Drawing.Graphics.MeasureString(...) bug which causes an exception to be thrown for text longer than 32,000 characters on Windows 8+ (7.3.4.100).
  Fixed an issue which caused IRange.Copy to copy over locked cells in certain cases where the source range and destination range do not have the same number of rows and columns (7.3.4.100).
• Fixed IRange.RowHeight to limit the new height to 0 <= height <= 409 as Excel does. Also fixed IRange.AutoFit() to limit row heights to a maximum of 409 (7.3.5.100).
• Fixed an issue with the COUNTIFS function for certain cases involving blank criteria columns (7.3.6.100).
• Fixed an issue which caused SpreadsheetGear to return different results than Excel for certain cases where PRODUCT is used on ranges with blank cells (7.3.6.100).
• Fixed an issue in the CELL function when using the "address" option to better match Excel when workbook names have spaces in them (7.3.6.100).
• Added a workaround for cases where newer versions of windows throw an exception when rendering cells with >32000 characters with GDI+ (7.3.6.100).
• Fixed the INDEX function to return #REF! if row > 1 or column > 1 in cases where the reference argument is a single cell reference, as Excel does (7.3.7.100).
• Fixed a problem which caused some large and complex workbooks to calculate incorrectly or to throw an exception during calculation (7.3.8.100).
• Added a "NoSharedFormulas" option to IWorkbookSet.Experimental which forces SpreadsheetGear to write workbooks with no shared formulas (7.4.1.100).
• Fixed to throw an exception when setting IFont.Name to "" and to convert font names of "" to IWorkbookSet.DefaultFontName when opening workbooks because Excel has problems opening workbooks which contain font names set to an empty string (7.4.1.100).
• Fixed an issue which caused cell text to sometimes render multiple times without clearing the cell background in the Windows Forms WorkbookView control leading to blurry text due to anti-aliasing artifacts (7.4.2.100).
• Changed the WorkbookView warning tooltip which is displayed if GetLock is called without a corresponding ReleaseLock to only be displayed if their is a debugger attached (7.4.3.100).
• Fixed an issue which caused background calculation to fail to calculate in some cases (7.4.4.100).
• Improved the way the WPF WorkbookView control displays rich formatted text with blank lines (7.4.6.100).
• Fixed a problem which caused goal seek to hang in certain cases where it was not able to converge (7.4.6.100).
• Fixed certain cases of copying formulas which reference sheet specific defined names to better match Excel's behavior (7.4.7.100).
• Added a work around to ignore unsupported worksheet protection passwords which use newer Excel 2013 and Excel 2016 algorithms so that workbooks can be opened (7.4.8.100).
• Fixed an issue which caused an invalid workbook to be created when overwriting a multi-cell array formula with a non formula value using the IRange.FormulaArray property or when using CTRL+SHIFT+Enter to enter the value (7.4.9.100).
• Fixed problem where CTRL+Enter or CTRL+SHIFT+Enter would not repaint entire range when entering constants into rows with no formulas (7.4.9.100).
• Updated all tools used to build SpreadsheetGear to the latest versions to fix an issue which caused installing on Windows 10 to fail in some cases (7.4.10.100).
• Improved the MROUND function to better match Excel for values which are just under the half-way point beyond the 15th least significant decimal digit (7.4.11.100).
• Added a workaround to read Open XML workbooks which have references to missing cell style format records (7.4.11.100).
• Fixed a problem which caused the BIN2HEX function to throw an exception during calculation if the 'number' argument was an empty string (7.4.11.100).
• Fixed an issue which caused the CELL function to return the incorrect value for the 'filename' option in some cases (7.4.11.100).
• Fixed IShape.Name to return an automatically generated name such as "Button 1" or "Rectangle 2" when the shape has a shape property but it is a zero length string (7.4.12.100).
• Fixed an issue which caused an exception to be thrown when reading workbooks written by Excel Mobile (7.4.13.100).
• Fixed an issue which caused the WPF WorkbookView control to throw an exception when rendering a cell containing an empty string and a number format where the text format is "@_)" (7.4.13.100).
• Fixed to keep quotes in non-quoted cells  when reading CSV and TXT files as Excel does (7.4.14.100).
• Fixed the intersection, union and range operators to handle arguments with array formulas (7.4.16.100).
• Fixed an issue which caused the INDIRECT function to return incorrect results in certain cases when it is used in an aggregate function (such as SUM) and the arguments to INDIRECT return a single valued array result (such as ROW($E$5) or COLUMN($E$5))) (7.4.17.100).