Option Button Grouping and Creation Problems.

[Austin Fay]

I've been wrestling with the spreadsheet control for the last few days, and I cannot for the life of me get an option button to appear on the worksheet I am editing.

The C# I am using is:

IOptionButtonShape optionButton = spreadsheet.ExcelProperties.WorkBook.ActiveSheet.OptionButtons.AddOptionButton(row, column);

optionButton.Text = "This Button Won't show up";

spreadsheet.GridProperties.ActiveSpreadsheetGrid.InvalidateCell(GridRangeInfo.Cell(row, column));

spreadsheet.GridProperties.ActiveSpreadsheetGrid.InvalidateVisual();

This adds the option button to the options button collection, but the button never appears on the spreadsheet control. What do I need to do to make the button appear on the spreadsheet control?

[Austin Fay]

I forgot to mention, I'm also looking for how to group the option buttons but don't see an obvious field or method to do so. Any advice?

[Pannir Selvam S]

Hi Austin,

 

We regret to let you know that currently spreadsheet control do not have support for OptionButton and other developer controls.

 

Regards,

Pannir