We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Problem with excel 2003 checkboxes (linked cells ?)

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.