Are there any plans to add more checkbox features?

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.

Hi,

Thanks for considering Aspose.

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.

Regards

Amjad Sahi

Aspose Nanjing Team

I will check the feature to link a checkbox to other cells. Could you tell me your expected date for this feature?

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.

Thanks for your information. Now we clearly understand your need.

Two months are enough to make this feature. Hopefully we can make in within one month.

Thank you very much! I’ll try to check back for updates.

I added this feature in this attached version. Please try it with following code:

Workbook excel = new Workbook();
int index = excel.Worksheets[0].CheckBoxes.Add(5, 5, 60, 60);
CheckBox checkBox = excel.Worksheets[0].CheckBoxes[index];
checkBox.Text = "hello";
checkBox.LinkedCell = "B1";

excel.Save("d:\\test\\abc.xls");

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.

Hi Frank,

I have put your new request in my work list and will make it soon.

Thanks again. I'll check back on the progress at a later date.

Frank