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?