Version 4.2

released on February 23, 2017

New Features


  • recalculate method
  • compactStyles method to remove unused styles from sheet styles
  • onBefore/AfterSheetShow events instead of onSheetShow
  • autocorrection of formulas (e.g. to upper case, etc.)


  • dialogs restore previously selected values
  • clearRange() can remove editors and filters
  • preserving custom row height for wrapped cells and cells with custom height
  • add human readable CSS for preset format (like custom format)
  • add text padding not to cover it with dropdown icon
  • allow column operations without cell selection
  • remove sizes for non-existent items
  • block all actions for conditional dialog
  • block selection and editor bar
  • clear-style removes conditional format
  • color marker in color selectors
  • column autowidth is never executed
  • compatibility with IE edge
  • CONCATENATE doesn't not work with separate operands
  • default text color
  • do not move selection when edit is canceled
  • dropdown editors and editbar
  • duplicate range names
  • editor bar and selection removing
  • frozenRows and frozenColumns are shared between sheets
  • image autosize fixed
  • key navigation for live editor
  • let live editor show formulas only if users enter formula mode ( types "=")
  • live editor expects cell reference after math operator only for formulas
  • load and import from excel
  • logical operations in IF command
  • math serialization
  • multi-sheet math finalized
  • paint editor value in the related cell
  • parse sheet structure on adding row/column
  • prefill conditional format dialogs in case of multiselection
  • preserve not-affected sizes
  • preserve selection during context menu call
  • prevent from user action for sheet operations in readonly mode
  • prevent from removing all rows and all columns
  • processing hidden headers, gridlines, rows and columns per sheet
  • regression in inline image pasting
  • rowCount and columnCount are not calculated correctly
  • prevent from header column selection
  • selection area during column operations
  • serialization of empty values
  • spreadsheet reset affects only active sheet
  • style cross interference in corner cases
  • styling of top area in no-gridlines mode
  • undo for hidden columns and rows
  • unnecessary focus on dialog closing
  • update cell when live editor value changes
Back to top
If you have not checked yet, be sure to visit site of our main product Webix ui widget library and page of spreadsheet product.