Spread.NET
In This Topic
    LegacyBehaviors
    In This Topic

    Following are the breaking changes for LegacyBehaviors.

    LegacyBehaviors.CalculationEngine

    By default, in Spread WinForms 12, the date time functions and formulas used in worksheets return the serial numeric values as results.  

    However, if a user uses the LegacyBehaviors.CalculationEngine, the date time functions and formulas will return DateTime values instead of the serial numeric values.       

    LegacyBehaviors.PropertyDefaults

    By default, LegacyBehaviors.PropertyDefaults is turned off in V12. When this flag is turned off then there are some changes as compared with the older versions as described below-

    1. Changes in default values for the following APIs

      FpSpread.AllowUserFormulas = true
      FpSpread.AllowDragDrop = true
      FpSpread.AllowDragFill = true
      FpSpread.AllowSheetMove = true
      FpSpread.AllowEditOverflow = true
      FpSpread.BorderCollapse = BorderCollapse.Collapse
      FpSpread.ResizeZeroIndicator = true
      FpSpread.TabStripPolicy = TabStripPolicy.Always   
      SheetView.SelectionPolicy =SelectionPolicy.MultiRange
      SheetView.AutoFilterMode = AutoFilterMode.EnhancedContextMenu
      SheetView.Protect = false and Cell.Locked = true (same with V11J but different from V10 and lower versions)


    2. Changes during keyboard navigation

      Pressing the "F2" key will start editing with current cell value.
      Pressing "Backspace" key will start editing with empty editor.
      Pressing the "F4" key takes no effect.
      When a user presses an input key to start editing, the current cell value will be replaced by the pressed key.

    Back to Breaking Changes for Version 12.45.20181.0.