Hi,
Most of the time, setting checkbox value works - but in the case of one excel sheet, the following code does not seem to work:
For Each cb As Aspose.Cells.CheckBox In sheet.CheckBoxes
'Testing
cb.CheckValue = CheckValueType.Checked
Next
The only distinguishing factor is these checkboxes seem to be linked to other cells in the worksheet. When checked manually in Excel, a few cells are populated automatically.
Is this is a known issue, or do I have to do something special in this case?
Version 4.9.0.5
Thanks!
-Andrew
Hi Andrew,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Please share the complete sample code and template excel file to show the issue. We will check it soon.
Thank You & Best Regards,
Ok, please find the following attachments:
-aspose.xls
-screenshot.png
From the screenshot, you’ll see one of the checkboxes was checked successfully, but the other 2 are not.
Here is the code I used: (all 3 checkboxes were hit)
For Each cb As Aspose.Cells.CheckBox In sheet.CheckBoxes
cb.CheckValue = Aspose.Cells.CheckValueType.Checked
Next
Thanks!
-Andrew
Hi Andrew,
Thanks for providing us the template file and screen shot.
After an initial test using your template file, I can find the issue as you have mentioned. We will figure it out soon.
I have logged your issue into our issue tracking system with an issue id: CELLSNET-17607.
Thank you.
Hi,
Please try the attached version.
We have fixed your
issue
Thank you.