Old Change Log

High Importance-20 Old versions are not under maintains and no longer recommended to be used. Check the change log for latest versions.

v0.9.3.0-beta – Dec 9 2015

  • Improved rich format text display, added superscript and subscript support
  • Improved currency format, add prefix symbol and postfix symbol, e.g. $10 or 10 USD
  • Added rich format text Excel import/export support
  • Added currency format reading and saving from/to Excel file
  • Added formula calculation support for entire range or column, e.g. SUM(A:A)
  • Added ISNUMBER function
  • Added fill data serial by dragging selection feature
  • Fixed bug that generated Excel file cannot be opened by LibreOffice and OpenOffice
  • Fixed bug that generated Excel file may lose row style
  • Fixed incorrect row height and column width calculation when reading and saving Excel
  • Fixed incorrect text color when reading from Excel
  • Fixed ToAddress method return incorrect address when range is entire row or column, e.g. A:A
  • Fixed incorrect undo/redo behavior for ReoGrid Editor (#179)
  • Fixed bug that exception happens during scrolling on some loaded Excel files
  • Fixed bug that exception happens when creating RichText
  • Fixed bug that data in formula cells cannot be deleted when pressed DEL key
  • Fixed incorrect currency format for some cultures
  • Fixed incorrect color when reading from RGF file (WPF edition)
  • Fixed bug that component crashes when loading from some RGF file (WPF edition)
  • Fixed reading datetime format from Excel will get a number value problem
  • Changed graphics class interface, moved Color parameter into last position
  • Rename class ReoGridControlStyle to ControlAppearanceStyle
  • Rename enum ReoGridControlColors to ControlAppearanceColors
  • Rename property for script’s style object from font-size to fontSize
  • Rename property for script’s style object from font-name to fontName

v0.9.2.0-beta – Oct 27 2015

  • Added NewWorksheet for workbook object =AddWorksheet(CreateWorksheet())
  • Added EnableSettings and DisableSettings for workbook object
  • Fixed bugs when clear all worksheets
  • Fixed minor bugs of WPF-edition
  • Fixed ‘Parameter is not valid’ exception
  • Fixed floating object doesn’t appear after adding onto worksheet
  • Removed dependency of System.Drawing.DLL from WPF-edition
  • Improved multiple thread operations

v0.9.1.0-beta – Sep 28 2015

  • Fixed error when reading Excel which contains chart graphic
  • Fixed ‘Object is currently in use elsewhere’ problem (#169)

v0.9.0.0-beta – Sep 9 2015

  • Added across worksheet reference =Sheet1!A1 (#134, #159)
  • Added worksheet scroll events and control APIs (#154)
  • Added new button visible setting for sheet tab control (#155)
  • Added new demo for sync-scrolling worksheet
  • Fixed CellEditTextChanging and CellEditCharInputted events not fire in WPF edition (#149)
  • Fixed error when loading RGF from a detached worksheet (#160)
  • Fixed ToString method for Graphics.Point and Graphics.Rectangle class
  • Fixed OnCellMouseUp event not fired
  • Fixed percent cannot input correctly problem

v0.8.9.3-beta – Aug 29 2015

  • Added Bar Chart
  • Added IterateBorders method for iterating over all borders in specified range (feature proposal in comment)
  • Fixed Editor project build error (#146)
  • Fixed losing cell styles after dragging range
  • Fixed WPF edition IME problem
  • Fixed first capital letter cannot be inputted by WPF edition control (#148)
  • Fixed background color of cell body displayed at wrong position
  • Fixed cells displayed incorrect position when worksheet has frozen cells (#151)

v0.8.9.2-beta – Aug 2 2015

  • Added print title feature (fixed row and column)
  • Added saving and loading print settings into/from Excel file
  • Added cell pattern fill style Excel support
  • Added saving and loading cell types into/from RGF file
  • Fixed saving floating images into Excel file
  • Fixed SUM function problem (#126)
  • Fixed styles cannot be saved into RGF file if loaded from Excel
  • Fixed sheet tab control’s style settings
  • Fixed unmerging range will change other cell styles
  • Fixed Cell.GetData<T> cannot convert data to double from string (#143)
  • Fixed print and preview will cause cell bodies show on incorrect positions
  • Fixed print settings loading and saving from/to RGF format
  • Fixed left top header will be displayed when headers hidden (#144)
  • Fixed some problems during loading or saving from/to LibreOffice generated Excel file
  • Changed SetRangeStyle to SetRangeStyles

v0.8.9.1-alpha – Jul 7 2015

v0.8.9.0-alpha – Jul 2 2015

  • Stability improvement
  • Floating object
  • Line chart, Column chart and Pie 2d chart are available
  • Added retrieving control instance from worksheet (#112)
  • Print APIs improvement, changed CreatePrintDocument to CreatePrintSession
  • Added print support for multiple worksheets (#108)
  • Renamed ReoGridPrintSettings to PrintSettings
  • Introduced customize SolidColor class instead of system Color class
  • Improved MIN and MAX function to support range
  • Added LOG, LOG10 and MOD functions
  • Added RangeDataChanged event for monitoring range changes
  • Fixed demo project building errors from Visual Studio 2008
  • Fixed incorrect result when convert decimal value to date/time format
  • Fixed tab key handling during editing cell (#79)
  • Fixed built-in cell types with background color display (#125)
  • Fixed exception happen when deleting columns (#128)
  • Other bug fixes and improvements

v0.8.8.5-beta – Mar 24 2015

  • Improved DropDownCell, add auto-height and button size properties
  • Improved DropdownCell, make drop-down window control instance only be created once
  • Improved formula error handling, added ISERROR, ISERR and ISNA functions
  • Improved performance on cell updating and data sort
  • Improved IF function (jump to branch logic depending on check result)
  • Improved formula self reference check (allow self references in ROW and COLUMN function)
  • Improved percent input and calculation (5%=5%, convert 0.1 to 10%)
  • Added settings to WorksheetSettings for toggling automatic reference formula recalculation
  • Added Recalculation method to force recalculation entire worksheet
  • Added ColumnDropdownListCell to optimize drop-down list cell for entire column
  • Added FormulaStatus property for cell to return formula calculation status
  • Added cell indent style (#101)
  • Added add/remove/collapse/expand actions for outline feature
  • Outline classes moved into unvell.ReoGrid.Outline namespace
  • Added events for copying and moving range by dragging mouse (#104)
  • Added RowOutlines and ColumnOutlines collection property
  • Added COUNTA function (count cells value including empty text)
  • Added reading Boolean type of cell value from Excel
  • Added AutoFitRowHeight and AutoFitColumnWidth methods for worksheet
  • Added ExpandRowHeight and ExpandColumnWidth methods for cell instance
  • Fixed adding outlines with same end-position (#101)
  • Fixed full row or column range format support (A:B, 1:100)
  • Fixed ClearRangeContent method to delete data formats from range
  • Fixed some incorrect number format if worksheet was loaded from Excel
  • Fixed cell body position not changed when alignment style was updated
  • Fixed DropdownListCell cannot display cell data after selecting item
  • Fixed lost cell data during sort in range that contains different merged cell
  • Fixed text format will be converted into number when loading from Excel (#99)
  • Fixed exception happen when dragging focus selection to position out of control
  • Fixed some Excel-compatible functions on mismatched value type handling
  • Fixed ROW and COLUMN function (returning incorrect reference cell address)
  • Fixed formula will be restore as cell data after cell edit operation cancelled
  • Fixed loading shared formulas from Excel worksheet

v0.8.8.4-beta – Jan 27 2015

  • Add skipping hidden rows and columns when moving selection by keyboard
  • Add LinkColor, ActivatedColor and VisitedColor properties to improve HyperlinkCell
  • Add culture number decimal separator support ( dot ‘.’ and comma ‘,’)
  • Add formula minus operator support
  • Add script language range address string support (create range from string)
  • Add BeforeSelectionRangeChange event to control selection (see Selection) (#79)
  • Add EmptyCellReferenceProvider to make customized empty cell reference value (#72)
  • Improved formula performance to update multiple referenced cell
  • Change: read formula ignores its syntax and parse errors during loading from Excel
  • Change: continued to recalculate referenced cell and ignores errors from other cells
  • Change: ReoGridEditor changed to open-source, BSD license
  • Fix: release used memory before control (workbook) destroy (#68)
  • Fix: change foreground color in Editor might cause GDI+ exception (#69)
  • Fix: cannot load Excel file that is saved by OpenXML 2.0 SDK (#70)
  • Fix: attempt to undo a worksheet that is just created will cause exception happen
  • Fix: “d” pattern cannot format correctly date-time value (#72)
  • Fix: default control cursors cannot be changed (#73)
  • Fix: print or preview cause exception happen (#75)

v0.8.8.3-beta – Jan 9 2015

  • Add formula exp(^) operator and EXP function
  • Add formula greater-than and less-than comparison
  • Add worksheet CSV export support
  • Add full row and full column address support (1:12, $1:$12, $A:$C)
  • Add NamedRanges collection to worksheet
  • Add strike-through and underline font support for Excel format
  • Add PrintableRangeChanged event
  • Change name definition scope from worksheet to workbook
  • Change ReoGridBorderPos to BorderPositions
  • Change ReoGridBorderStyle to BorderStyle
  • Change SetRangeBorder to SetRangeBorders
  • Change GetRangeBorder to GetRangeBorders
  • Change some border styles in order to compatible with Excel borders
  • Fix: save a loaded Excel file will lost its style information
  • Fix: cannot input text into a cell which has been cut into clipboard (#64)
  • Fix: name definitions loaded from Excel cannot update formula values
  • Fix: value of percent format cannot be loaded from Excel correctly
  • Fix: SelectionRangeChanged when mouse down is not invoked (#60)
  • Fix: restore ClearActionHistory method to control
  • Fix: remove cell data will lost cell’s alignment styles (#62)
  • Fix: script event onpaste not firing
  • Fix: some print bugs
  • Added some test-cases

v0.8.8.2-beta – Dec 17 2014

  • Add custom function extension and name parsing provider interface (#55)
  • Add new customize function interface demo
  • Add Name Manager for Editor (#38)
  • Add RenameNamedRange method for worksheet (#38)
  • Add initialize hidden rows from loading Excel file
  • Add hide spreadsheet headers from loading Excel file
  • Add zoom spreadsheet from loading Excel file
  • Add reading and saving name definitions from/to Excel file
  • Add absolute range address $A$1:$B$2 format support
  • Add GetWorksheetByName for workbook object
  • Fix: vertical alignment style cannot load from Excel file correctly
  • Fix: named range reference in formula works incorrectly
  • Fix: COUNT function causes exception
  • Fix: 1 pixel background overlay between neighboring cells
  • Fix: cell text-wrap does not work correctly
  • Fix: export incorrect Excel border styles
  • Fix: removing cell styles does not work properly
  • Fix: deleted outlines, named range and highlight ranges cannot be restore when undo removing rows and columns
  • Fix: adjusting page breaks may cause exception happen
  • Minor bug fixes

v0.8.8.1-alpha – Dec 14 2014

  • Add Client Profile support (ReleaseCP) build packages (#56)
  • Add ClearRangeContent method to delete content from specified range
  • Complete Style property for RowHeader and ColumnHeader object
  • Fix: built-in sheet tab control cannot hide (#52)
  • Fix: scroll bars cannot hide
  • Fix: update named range after inserting or removing rows (#38)
  • Fix: cannot select range if first row or column is merged cell (#55)
  • Fix: SetRangeStyle method makes cell losing original style information (#59)
  • Fix: cell body appears at wrong position after moving range
  • Fix: set SelectionMode to None will cause exception (#51)
  • Fix: cannot move range even hover on it
  • Fix: cannot change control appearance
  • Fix: export incorrect Excel border ‘dashed’ style
  • Fix: editor may crash when SelectionMode set to None
  • Fix: editor will overwrite vertical alignment to top

v0.8.8.0-alpha – Dec 6 2014

  • Excel format support (xlsx)
  • Multiple sheet support
  • Improvement formula calculation
  • Improvement performance and memory usage
  • Add Custom drop-down cell interface (#49)
  • Add ExportAsHTML method arguments (#39)
  • Fix: data in read-only cell could be changed by backspace and delete key (#38)
  • Fix: text will be clipped inside cell (#38)
  • Fix: copy, cut and pasting operations (#38)
  • Minor bugs fixed

v0.8.7.0-beta – Sep 4 2014

v0.8.6.2-beta – Jun 24 2014

  • Scroll to cell/range
  • New Cell edit user events
  • Fix cell content display problem in ‘Editor’ and ‘Minimum’ release package (#11)
  • Fix formula returns zero when reference to string in cells
  • Fix SelectionChanged fired twice in some cases
  • Add property descriptions for Visual Studio property list
  • Add ‘Print…’ menu in ReoGridEditor
  • Add ‘Print Report’ demo program
  • Add hide/unhide actions (#9)
  • Remove CellsContextMenuStrip property from control, use default ContextMenuStrip instead
  • Change RowHeadContextMenuStrip to RowHeaderContextMenuStrip
  • Change ColHeadContextMenuStrip to ColumnHeaderContextMenuStrip
  • Change ColCount to ColumnCount
  • Change some class name: removing ‘RG’ prefix
  • Other bugs fix

v0.8.6.1-alpha – Jun 17 2014

  • Fix text truncate problem in print and preview (#4)
  • Fix duplicated PrintableRange property in VB.NET (#2)
  • Loading CSV format
  • Add Export as HTML (#3)
  • Control.Ranges[] property is available
  • Control.Cells[].Style is available
  • Change/Remove page breaks
  • Saving/Loading page settings
  • Change cells type in Editor
  • Some class rename: RGCellEventArgs => CellEventArgs
  • Other bugs

v0.8.6.0-alpha – Jun 2 2014

v0.8.5.1-beta – Apr 27 2014

  • Fix: PInvoke exception on .NET 4.x
  • Get focusPos from script

v0.8.5.0-beta – Jan 15 2014

  • New: Group & Outline
  • New: Built-in Cell Types
  • New: Custom Cell
  • New: Add cell events Events
  • Fix: Delete columns and rows on merged cell will lost the cell styles
  • Fix: CJK Fonts cannot be displayed properly
  • Fix: Performance Optimization: Scrolling
  • Fix: Wrapped text cannot display last line correctly
  • Fix: Cannot undo paste
  • Fix: Error in column index convert between alpha letters and number
  • Fix: Preview does not work
  • Performance Improvement
  • Fixed other bugs
  • Script event name changed to lowercase
  • Reduce reference DLLs by merging code, and open source
  • Namespace changed to ‘unvell’ from ‘Unvell’