Bind data seamlessly with various local and remote data sources such as JSON, RESTful services, OData services, and WCF services. The control uses a data manager to handle data and supports customizing data requests and processing.
Instant loading allows users to load large amounts of data into a worksheet and view it on demand with the help of row and column virtualization.
Values are automatically recalculated when a dependent cell is edited.
Number formatting provides a type for your data in Spreadsheet. It helps to display your data as currency, percentages, short dates, long dates, time, fractions, and scientific numbers, similar to Excel.
Using cell formatting, users can highlight a particular cell or range of cells from a whole workbook. The control supports various formatting options: font size, font family, font color, fill color, indent, and horizontal and vertical alignments of text.
Easily save the Spreadsheet control with data accuracy, styles, and formats as an Excel file. It supports various file formats such as Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-delimited values (.csv).
There is built-in support for hyperlinks and bookmarks. You can navigate to web links or cell references within the sheet or other sheets in the workbook.
This feature makes it easy to collaborate on workbooks. It allows multiple users to work on a spreadsheet at the same time and view the changes made by others instantly.
Use the clipboard operations cut, copy, and paste, just like in Microsoft Excel. You can paste the values or formulas with or without formatting in a new selected range.
The context menu improves user interaction with Spreadsheet using a pop-up menu. It appears when a cell, row header, column header, or sheet tab is right-clicked. In addition to built-in default menu items, it allows you to add custom context menu items.
The resize and autofit options help you adjust the row height and column width.
Five built-in, SASS-based themes are available: Material, Bootstrap, Bootstrap 4, Fabric, and high contrast. Simplify theme customization either by overriding the existing SASS styling or creating custom themes using the Theme Studio application.
Right-to-left rendering allows you to display the text and layout of the Spreadsheet from right to left. This improves the user experience and accessibility for RTL languages.
Developers can customize their UI and control its behaviors according to the end user’s requirement using the control’s rich set of client-side APIs.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.