Fixed to use the default number format for Open XML number formats which cannot be read. Fixed to clear undo buffer when IWorkbook. Equals to no longer cause a stack overflow exception. Fixed saving Open XML workbooks with external workbook references to no longer prepend "file: 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 issues with RangeExplorer clearing cell formatting when formatting hyperlinks. Fixed mouse wheel scrolling issue which occurred when using a high-resolution mouse.
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 some issues with plotting error and empty type values on area charts that use a date axis. Fixed cell merging to fix up cell borders and formats.
Fixed printing routine to only print visible sheets when printing entire workbook. 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 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 default print range to work more like Excel regarding blank formatted cells.
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 picture shape to no longer display visible border upon creation and fixed issues with writing picture line format information in. 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 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. ReferenceStyle is set to ReferenceStyle. 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 cases where auto sizing of row heights caused shape positions to be left in an undetermined state. Fixed an issue which caused an exception after setting certain ThemeColor properties to ColorSchemeIndex.
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 a problem which caused four builtin number formats to be incompatible with Excel: Fixed an issue which caused a NullRefException when clearing all data linked to a chart date axis. 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. Fixed a problem with row and column header text which occurred with some High Contrast Windows 8 themes 7.
Fixed a problem in IRange. Copy which caused exceptions to be thrown in certain cases 7. Fixed a problem which caused an exception to be thrown when a cell containing an empty text string was formatted 7. 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.
Made a minor improvement to the way sheet tabs are rendered 7. Fixed problems writing workbooks which contained formulas with external references to cells containing text 7. Fixed a Windows Forms WorkbookView painting problem which occurred when scrolling with fixed panes 7. Fixed printing problem which occurred when the last row or column being printed is hidden 7.
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," and "0,," are treated as text rather than numbers 7.
Fixed problems with editing and automatic sizing of rich text cells 7. Fixed a problem which occurred when copying text cells over the top of themselves 7. Fixed various issues which occurred when editing percent values with the in-cell editor and formula bar 7.
Fixed an issue with the autofilter dropdown listbox position being set to an invalid value when rows are hidden or deleted 7. Fixed an issue which caused corruption of formula cells in certain cases where formula cells are copied or created 7.
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.
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. Fixed various issues with the SpreadsheetGear Silverlight Samples 7. Fixed problems with the display of message boxes in WPF and Silverlight 7. Fixed exceptions when toggling Silverlight checkbox menu items 7. Fixed a problem with the display of " Blanks " in the autofilter dropdown list when there are blank cells in a column 7.
Fixed a problem reading certain workbooks written by third party software which caused some blank formatted cells to be populated with a number 7. Fixed a Silverlight textbox editing scenario where Enter and other keys were not recognized 7. Fixed a calculation problem which caused an exception to be thrown for certain complex workbooks 7.
PositiveInfinity which can lead to exceptions being thrown later 7. Improved IHyperlinks performance with a large number of hyperlinks 7. Fixed a problem which caused incorrect results to be returned by IWorksheetWindowInfo.
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. 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.
Fixed an issue which caused the in-cell editor to sometimes be the wrong size in WPF and Silverlight 7. Fixed an issue which caused workbook set CultureInfo settings to sometimes not pick up customizations of the default or current CultureInfo 7.
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. Fixed a problem where copying cells when the source and destination columns overlapped would incorrectly leave some cells blank 7. Fixed an issue which caused a null reference exception to be thrown if a subclass of CommandManager returned null from CreateCommandDelete or CreateCommandInsert 7.
Fixed issues with the ShapeAction event not being fired consistently for cell comments and for cases where worksheet protection is modified 7. Fixed an issue which caused Excel to return REF! Added a work around to read certain workbooks written by 3rd party components 7. Fixed an exception in the WPF and Silverlight controls which occurred when editing a cell if an attached FormulaBar control is collapsed 7.
Fixed an issue where IGradientStops. 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. Fixed to support reading and writing IWorkbook. Fixed WPF and Silverlight in-cell editor to paste multi-line text 7. Fixed problems which caused incorrect page numbers and total page counts to sometimes be printed in headers and footers 7. Fixed to try to load SpreadsheetGear