Hi
I will export an excel sheet with multiple checkboxes in columns and rows. I tried a solution from this forum but doesn't work. See excel sample. Only one checkbox will be set on the end of the sheet.
int i = 0;
foreach (item in obect)
{
i++;
ICheckBox checkbox = sheet.CheckBoxes.AddCheckBox(i, 12,15,75);
checkbox.CheckState = (CheckState)ConversionHelper.ToInt16(position.Properties.IsVisible);
checkbox.Name = "CH" + i + "12";
checkbox1.LinkedCell = sheet.Range[i, 12];
}
ICheckBox checkbox1 = sheet.CheckBoxes["CH212"];
checkbox1.LinkedCell = sheet.Range[2, 12];
Tried both ways to set the checkbox in the loop and also tried to set one checkbox on first row. But even the checkbox is at the end of the sheet.
Anybody know where is the bug?