We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Inserting CheckBox in chart-sheet using Aspose Cells

There is a post about adding a checkbox to a chart-sheet from 2011 with a response that the functionality will be available “soon”. Is it available? Because I’ve tried multiple ways of doing this and the checkbox does not show up on the chart page.


We are gathering details about the feature CELLSNET-40174 and will get back to you soon.

If the cell contains a formula, you can find it from formula, else find object from the value. Refer to following code snippet and let us know your feedback.

        Workbook workbook = new Workbook();
        int index = workbook.Worksheets.Add(SheetType.Chart);
        Worksheet sheet = workbook.Worksheets[index];
        sheet.Charts.AddFloatingChart(ChartType.Column, 0, 0, 1024, 960);
        sheet.Charts[0].NSeries.Add("{1,2,3}", false);
        sheet.Charts[0].Shapes.AddShapeInChart(MsoDrawingType.CheckBox, PlacementType.Move, 400, 400, 1000, 600);
        sheet.Charts[0].Shapes[0].Text = "CheckBox 1";
        int width = sheet.Charts[0].Shapes[0].Width;
        workbook.Save(dir + "dest.xlsx");