Hello, We are using aspose.cells(.net) for spreadsheet excel functionility for one of our legacy application. But our client denied to use the aspose.cells for the ongoing application due to its having vulnarabilities. So we started using OpenXML as an altenative. But we are unable to achieve the required functionalities like events, triggers, onclick, oncellchange etc. I would like to know certain event triggering features like onclick, oncellchange, onvaluechange, custom validation, dynamic cell color change for empty cells etc are achievable or not in aspose.cells excel. We do have aspose.cells license. Currently we are planning to implement this aspose.cells inside azure function(.net core 2.2). Please provide me the feasibility in achieving the above features in aspose.cells(.net core 2.2).
Thanks for your query.
For your information, there are no vulnerabilities in any of Aspose.Cells for .NET versions, only some C++ versions (e.g v19.1) have these security vulnerabilities which were fixed in newer Aspose.Cells for C++ versions (we recommend you to kindly try our latest Aspose.Cells for C++ v19.10 ). If you find any security issues (vulnerabilities) in any .NET version in any case, let us know with details, we will check it soon.
Please note, Aspose.Cells for .NET is a pure .NET library which does not provide any GUI or events.
Although we have two grid controls, i.e.,
- Aspose.Cells.GridDesktop Control - A grid control designed for the desktop/winform (.NET) environment. It is a stand-alone control that allows you to load an Excel file into its grid matrix, create/design a worksheet, and update/operate data into cells in WYSIWYG (visual) mode. It can dynamically load, manipulate/edit and save/restore Excel files, all content in Windows Forms. It supports events. Please refer to the file/article for reference:
- Aspose.Cells.GridWeb Control - Grid control designed for web environments or
Asp.NETprojects. It is a stand-alone control that allows you to load an Excel file into its grid matrix, create/design a worksheet, and update/operate data into cells in WYSIWYG (visual) mode. It can dynamically load, manipulate/edit and save/re-save Excel files, all content in the browser type. It supports events. Please refer to the file/article for reference:
Unfortunately Aspose.Cells.GridWeb control does not support .NET Core, hense it cannot be used on azure. We are working over the task but it’s like rewriting it for .NET Core framework. It might take a couple of months to implement it.