Volume 3 delivers more essential data visualizations and features to your web apps with a new Spreadsheet control, multiregion and lasso selection for Charts, and OLAP cube binding support in the Pivot Table.
Multi-select options have been provided to allow users to select multiple regions in a chart.
Lasso select allows users to select a region by drawing freehand shapes.
Options have been provided to rotate data labels.
Axis labels can be hidden when they overlap.
Circular gauge annotations and ranges now support tooltips.
Circular gauge ranges now support legends with a toggle option. If you toggle a legend item, its color will change to that of the corresponding range bar. Customization options are available for legend shape, alignment, and position. There is also an option to hide axis labels when they overlap in the legend.
This feature allows the connector to detect diagram shapes and reroute its path around it rather than crossing the diagram shape.
Added file system providers for the following services,
Provided Amazon S3 Cloud Storage service provider support to manage the files in the File Manager component. To run the service, create an Amazon S3 account and a S3 bucket, and then register your Amazon S3 client account details like awsAccessKeyId, awsSecretKeyId, and awsRegion in RegisterAmazonS3 method to perform file operations.
Provided Firebase Realtime Cloud Database service provider support to manage the files in the File Manager component. To run the service, a Firebase project has to be created to access firebase realtime database. Register the realtime database details like REST API link and the root node in the SetRESTAPIURL method of FirebaseRealtimeFileProvider in the controller part of the ASP.NET Core application.
This feature allows you to export Gantt data to Excel and CSV formats. Using the Gantt toolbar buttons, you can export Gantt data to the desired format.
A toggle option has been provided for legends. When a legend item is toggled, its color will change in the corresponding shape item.
Form-filling support has been added to the PDF Viewer control. It allows users to add and edit handwritten signatures in the signature fields and save the values in the form fields of AcroForms in a PDF document.
Free-text annotation is used to add text content to a PDF document. The text content styles are customizable.
Import and export annotation details as JSON objects in the PDF Viewer control and save the JSON data in local storage.
In addition to the existing data sources, pivot table now provides an option to connect and visualize SSAS OLAP cube and its elements like dimensions, hierarchies, measures, named sets, etc. The pivot table is used to create and edit a report on the fly using field list and grouping bar options, and it can also be stored for later use. End users can visualize the results in graphical and tabular formats (chart and grid).
Other common options like drill down/drill up, sorting, filtering, formatting, calculated field, conditional formatting, drill through, defer layout update, show/hide totals, etc. are also supported.
Images from Microsoft Word and Outlook can be pasted along with the content, and it can be uploaded to the server before being inserted into the editor.
This feature allows inserting images in the editor by dragging and dropping them from the local system. Images can be uploaded to the server before being inserted into the editor.
This feature allows resizing the editor dynamically by dragging its resize handler, which is positioned at the bottom-right of the control. Users can resize it in a diagonal direction to adjust its width, height, or both. The content of the editor will be adjusted automatically based on the new width and height.
Added timeline year view, which allows users to display the events throughout the year in the scheduler. Provided orientation support also.
Provided cellHeaderTemplate support for month and monthAgenda views to format the date or other customizations.
Provided firstDayOfWeek property support in individual view. Now, different first day can be set for different views.
Provided property based CRUD action support for inserting, updating, and deleting events. The new APIs, allowAdding is used for insert action, allowEditing for edit action, and allowDeleting for delete action.
The Spreadsheet control is an interactive component for organizing and analyzing data in a tabular format. It has configuration options for customization, and it can load data by importing an Excel file or from a data source, such as RESTful JSON data services and local JavaScript object array binding. Populated data can be exported to Excel in .xlsx, .xls, and .csv formats.
It supports the following features:
Provided support to drag and drop tree grid rows within the TreeGrid control, between TreeGrid controls, or between the TreeGrid control and any custom component, to change row positions dynamically in the UI.
Provided support to freeze specific rows or columns and make them always visible at the top and/or left side of the Tree Grid when scrolling.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.