Hi there,
I’m trying to add and use an activex combobox in a protected worksheet. However, setting the ‘Locked’ property to false, seems to have no effect. If I open the resulting file in Excel, turn protection off and design mode on and then look at the combobox properties ‘Locked’ is set true.
Is this a bug, or am I doing something wrong?
Workbook wb = new Workbook();
Worksheet sheet = wb.Worksheets[0];
Style style;
StyleFlag flag;
for (int i = 0; i <= 255; i++)
{
style = sheet.Cells.Columns[(byte)i].Style;
style.IsLocked = false;
flag = new StyleFlag();
flag.Locked = true;
sheet.Cells.Columns[(byte)i].ApplyStyle(style, flag);
}
style = sheet.Cells.Columns[0].Style;
style.IsLocked = true;
flag = new StyleFlag();
flag.Locked = true;
sheet.Cells.Columns[0].ApplyStyle(style, flag);
Aspose.Cells.Drawing.Shape s = sheet.Shapes.AddActiveXControl(Aspose.Cells.Drawing.ActiveXControls.ControlType.ComboBox, 5, 0, 5, 0, 100, 20);
Aspose.Cells.Drawing.ActiveXControls.ComboBoxActiveXControl c = (Aspose.Cells.Drawing.ActiveXControls.ComboBoxActiveXControl)s.ActiveXControl;
s.ActiveXControl.IsLocked = false;
c.IsVisible = true;
c.BorderStyle = Aspose.Cells.Drawing.ActiveXControls.ControlBorderType.None;
c.Font.Name = “Arial”;
c.Font.Color = System.Drawing.Color.Black;
c.ListRows = 12;
c.MatchEntry = Aspose.Cells.Drawing.ActiveXControls.ControlMatchEntryType.None;
sheet.Protect(ProtectionType.All);
wb.Save(@“C:/Protected.xlsb”, SaveFormat.Xlsb);
Note: Using Cells 17.2.0.0