This is an exciting year for Spread.NET! We are working on many new feature enhancements and are excited to share our plans for 2021. We are adding several new customer-requested enhancements and major new features in the upcoming releases. Here are highlights of these new features.
This release in early May 2021 includes new customer-requested features for tracking changes in cells. Powerful new APIs in IWorkbook enables developers to easily capture all cell changes across the entire workbook in one event handler and customize how Calculation-On-Demand operates to recalculate the cells.
We are also adding customer-requested enhancements for tracing formula references across worksheets in WinForms spreadsheets. New properties in IRange returns all dependent and precedent cells, including cross-worksheet references. Formula auditing code processes all related cells across the entire workbook and traces all dependents and precedents.
We are also adding two new calculation functions, VALUETOTEXT and ARRAYTOTEXT, which are much more useful than the TEXTJOIN for cases involving cells with a Cell Data Type object applied. For more details about this enhancement, please see this blog.
We are enhancing the lookup functions' performance optimizing calculation speed for cases with lookups in very large ranges. This enhancement improves HLOOKUP, MATCH, VLOOKUP, XLOOKUP, and XMATCH functions and is implemented by creating an internal cache that optimizes the searches in the target ranges during the calculation.
We are enhancing Spread Designer for WinForms to support hiding and showing sheets using the tab strip context menu just like Excel. This already works in run-time, however, the Spread Designer did not include these items because hidden sheets were always displayed as visible for design purposes. Now you can use the Spread Designer to hide and show worksheets as in Excel.
We are enhancing Pie charts to support formatting the value as a percentage like Excel. Previously, the only way to do this was by using a special calculated range of percentages as the values to use in the chart. With this enhancement, now use your raw data to create the Pie chart and calculate the percentages to show in the data label for each slice like Excel.
This release in early August 2021 will focus on customer-reported issues and feature enhancements that can be implemented before v15 release and improve design-time support for the .NET 5 controls. The issues and enhancements will come from feedback, so please share questions and issues with the team here.
The next major release in early November 2021 features many big enhancements. Here are some highlights of what is coming:
The new LAMBDA Function enables users to create custom functions using formulas in custom names called from other formulas. This powerful new feature allows the import and export of workbooks containing LAMDA formulas, which are then easily copied and reused across workbooks.
The new Table Binding Enhancement enables developers to create a table in the worksheet easily and bind the content to a DataTable, DataView, or other .NET data source.
Many new Visual Functions which use cell formulas to specify the sparkline arguments and render the sparkline in the cell will be added to support the Enhanced Sparkline types of SpreadJS, including:
Design-time support for .NET 5 will be completed.
Protect Sheet Options and new ribbon button UI in Spread Designer will enable the user to set sheet protection options and password.
Enhanced Chart Label Format will support chart labels' new options, such as showing negative numbers in red along the axis or in data labels.
Enhanced Border Rendering will support drawing cell borders and gridlines as in Excel using the BorderCollapse property. This will make imported XLSX with complex merged cells, and cell borders look exactly as in Excel.
Stay tuned to our next GrapeCity Spread.NET releases through 2021! We are truly excited to bring these new features and improvements to the community and hope you're excited about using these new items in 2021 and beyond!
If you have any questions or need clarification, please use the comments section available below. You can also contact us by submitting your questions on the GC Documents Formus, or if you already have an account, you can log in to submit your support question.