At the request of many customers, there are now improved Excel-like advanced hyperlinks in SpreadJS v13.1. Hyperlinks will remain intact in imported Excel files. It is possible to create hyperlinks with SpreadJS and successfully export them to Excel. Users can also take advantage of the extensive API to manage the properties of those hyperlinks, including getters, setters, and hyperlink types. Additionally, hyperlinks in SpreadJS can be connected to a particular behavior so that when the hyperlink is clicked, it can run custom commands that the developer defines. Read more about hyperlink support in SpreadJS v13.1.
Format strings provide a way for text to be automatically formatted in cells, to developer specifications. With the new enhancements, developers have more control over how they set formats, including formulas and values at the same time. Additionally, formulas can be set as formatting and applied to different cells. Read more about format strings in SpreadJS v13.1.
SpreadJS has added dirty cell states to the cell state implementation. This new feature allows developers to use different styles to mark cells that have been changed by the user. This action can be helpful when there is a need to track changes in a workbook or processing data after user input. In workbooks that use data from a database, acquiring only the cells that were changed instead of the whole database is useful for performance enhancements. Read more about about dirty cell states in SpreadJS v13.1.
GrapeCity is an award-winning Microsoft Gold Certified Partner and one of the world's largest providers of developer components. The company has more than 850 employees and hundreds of thousands of customers worldwide. For over 30 years, GrapeCity has provided enterprises worldwide with state-of-the-art developer tools and components, software services, and solutions. For more company information, visit http://www.grapecity.com/.
All product and company names herein may be trademarks of their respective owners.