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

Free Support Forum - aspose.com

A Problem in setting a CheckBox value of already existing checkbox

Hi,

I have a following problem when I try to set the value of already existing checkbox it does not work. However creating a checkbox and setting it does work without any problems. Is this feature not implemented or am I missing something ?

changing an existing checkbox (does not work - checkbox stays unchecked)

Aspose.Cells.CheckBox cb = sheet.CheckBoxes[0];
cb.Value = true;

inserting checkbox and setting a value (works - checkbox is checked)
sheet.CheckBoxes.Add(8,8,80,150);
Aspose.Cells.CheckBox cb = sheet.CheckBoxes[1];
cb.Value = true;

Thanks in advance

Michal

Hi,

Thanks for considering Aspose.

The feature is not implemented yet, we will add it soon.

Thank you.

Hi,

thanks for the answer. Could you please give me a approximate release date on the feature.

thanks in advance

Michal

Please try this attached version.

wow this was fast… it works. thanks a lot

Hi Laurence,

I'm using aspose.cells version 4.4.3.21 and I still have a problem of using an existing check box.

I'm using this sample code on an exsiting excel 2007 document in which I've inserted a checkbox control (not through code but through the developer->insert tab):

Workbook excelbook = new Workbook();

excelbook.Open("book2.xlsx",FileFormatType.Excel2007Xlsx);

int i=0;

foreach(CheckBox check in excelbook.Worksheets[0].CheckBoxes)

excelbook.Worksheets[0].Cells["B"+i.ToString()].PutValue(check.Text);

the excelbook.Worksheets[0].CheckBoxes doe'nt contain any obejcts.

This problem not seem to happen if I save the same file in excel 2003/97 format.

Is this a known issue?

thanks,

Ofir

Hi,

Well, currently, the feature (manipulating CheckBoxes in .xlsx file) is not available for MS Excel 2007 .xlsx file. We will support it soon.

Thank you.

Thanks Amjad,

Do you have any time estimation for this release?

Ofir

Hi,

We can give you an eta for the feature soon.

Thank you.

Thanks.

I'll keep in touch.