Hello, first of all, great work on the library, it works like a charm.
I am porting code that used to be com excel interop and using Aspose instead and everything was pretty straightforward to port except the buttons and labels of the sheet.
I am able to create the button or label with aspose with Aspose, but once I open the sheet, when I click on the button or label, it selects it instead of actually clicking on it.
Here is how I create the controls :
Label btnAddRequest = worksheet.Shapes.AddLabel(rowIndex, 10, 1, 5, 12, 50);Button btnAddRequest = worksheet.Shapes.AddButton(rowIndex, 10, 1, 5, 12, 50);
btnAddRequest.Name = “btnAddRequestGroup” + groupIndex.ToString();
btnAddRequest.Text = “Add”;
btnAddRequest.Placement = PlacementType.Move;
or
btnAddRequest.Name = “btnAddRequestGroup” + groupIndex.ToString();
btnAddRequest.Text = “Add”;
btnAddRequest.Placement = PlacementType.MoveAndSize;
Before, with Excel interop, here’s how I created my label :
Excel.Shape btnAddRequest = worksheet.Shapes.AddOLEObject(“Forms.Label.1”, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, 5, 47 + 14.25 * (rowIndex - 4), 20, 12.75);
btnAddRequest.Name = “btnAddRequestGroup” + groupIndex.ToString();
Excel.OLEObject sheetBtn = (Excel.OLEObject)worksheet.OLEObjects(btnAddRequest.Name);
sheetBtn.Object.GetType().InvokeMember(“Caption”, BindingFlags.SetProperty, null, sheetBtn.Object, new object[] { “Add” });
sheetBtn.Object.GetType().InvokeMember(“BackStyle”, BindingFlags.SetProperty, null, sheetBtn.Object, new object[] { 0 });
sheetBtn.Object.GetType().InvokeMember(“ForeColor”, BindingFlags.SetProperty, null, sheetBtn.Object, new object[] { 16711680 });
sheetBtn.Object.GetType().InvokeMember(“FontBold”, BindingFlags.SetProperty, null, sheetBtn.Object, new object[] { true });
sheetBtn.Object.GetType().InvokeMember(“FontSize”, BindingFlags.SetProperty, null, sheetBtn.Object, new object[] { 9 });
Any ideas?
Thanks