Spread.NET 14.1

New CalculationOnDemandMode and CellValueChanged Event

• This enhancement gives developers control over the calculation of on-demand behavior and recalculation of dependent cells. Setting CalculationOnDemandMode to Off will force dependent cells to immediately recalculate - triggering the new CellValueChanged event for each of those cells. This event is used to handle changes to calculated cells caused by formulas, which is useful for tracking all workbook changes.

Performance Improvements for Lookup and Match Functions

• Added a new API specifying CalculationEngine.CacheOptions to optimize the performance of lookup and match functions. It improves performance using many LOOKUP, HLOOKUP, VLOOKUP, XLOOKUP, MATCH and XMATCH functions in a workbook. This enhancement is modeled after the recent Microsoft Excel enhancements to lookup and match functions.

New VALUETOTEXT and ARRAYTOTEXT Functions

• Added new calculation functions which match the new Excel Functions for VALUETOTEXT and ARRAYTOTEXT - currently available in beta to Excel users in the insider's program. These functions operate as in Excel and are handy for formulas and operations on dynamic arrays.

New GetFullDependents and GetFullPrecedents

• Added new APIs, IRange.GetFullDependents and IRange.GetFullPrecedents, which return all dependent or precedent cells, including cross-workbook and external references. Since these emulate the VSTO API, the APIs for IRange.GetDependents and IRange.GetPrecedents will continue to operate within the worksheet to return only the references on the active worksheet.

Percentage Labels in Pie Charts

• Users can now enable percentage labels in pie charts, similar to Excel. After creating a Pie chart and adding Data Labels for the series, you can use Format Data Labels... to specify the percentage type for the pie slice labels.

Support Hide/Unhide in Tab Strip Context Menu of Spread Designer

• Enabled hiding and unhiding worksheets in the Spread Designer tool. Previously, users could hide worksheets using only the PropertyGrid to set the Visible property of the worksheet. That setting would be overridden in the Spread Designer to always show the hidden worksheets. You now have the option to specify whether to show hidden sheets in the Spread Designer Preferences.

Pixel Scrolling by a Set Number of Pixels

• Enabled setting the vertical scroll bar to scroll in increments of a specific number of pixels using the mouse wheel. A new API VerticalScrollBarMode.PixelEnhanced allows this behavior using the value of the property VerticalScrollBarSmallChange to determine the number of pixels to scroll.