I'm just curious about this issue. I have an existing web application that adds checkboxes and links the checked value to a cell in the spreadsheet, but that application is using the Excel.Interop assembly. I would like to implement the same solution without having Excel installed on the web server, but as far as I can tell the Aspose.Cells checkboxes don't allow me to link the value to other cells in the spreadsheet.
Do you have any plans to add more checkbox features like the cell linking? Or is there possibly some way to do this that I'm missing? As far as I can tell, you can place checkboxes on the spreadsheet, but they can't really be used for much.
Aspose.Cells is a non UI spreadsheet generation component which does not require MS Excel to be installed on the system and can be implemented in both forms of Applications(Web and Windows). Well, Cell linking with Checkboxes feature is not supported yet as Aspose.Cells does not support events. I think you can implement your requirement using External links and Aspose.Cells supports external links.
I don't really have an expected date in mind. I've already got a version of the application running that is not using Aspose, but I'd like to be able to do away with having Excel installed on the web server. So, there is no definite time that it must be done, it's just something I would like to do at some time. I guess ideally, I'd like to be able to do it within the next two months if possible.
And I'd like to try to clarify what I'm looking for when I mention the checkbox value linking to other cells. It has nothing to do with external links. If you are using Excel and you add a checkbox to the spreadsheet, you can go to the properties window of the checkbox and it has a place where you can enter a "Cell link." You can enter any cell (C3, B8, etc.) and the specified cell will contain the word TRUE or FALSE depending on whether or not the checkbox is checked.
I'm sorry it took me so long to get back to you on this. I wasn't expecting such a quick turnaround. I tested the new functionality and it appears to work. Thank you very much!
Frank
P.S. I apologize once again because I have another small request that goes along with my first one. The LinkedCell property works correctly, but the checkbox is not checked by default. Could you also add a CheckBox.Value property that would allow me to mark the checkbox as true or false?
There is no rush on this new feature either, but I thank you for the previously quick turnaround.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.