I am implementing Aspose.Cells into an existing ASP.NET website to open up an existing Excel XLSX file, fill out data in some cells on a single worksheet, and save the workbook.
I have gotten everything working with the exception of Checkboxes on the worksheet. The following code is not working:
Dim cb As Aspose.Cells.Drawing.CheckBox
cb = worksheet.CheckBoxes(0)
cb.Value = True
If I step through my code, I can see that the value of the checkbox is False, and I can see it change to True, but when I save the workbook and open the spreadsheet, the checkbox is not checked.
Does anyone have a solution for this problem?