Free Support Forum - aspose.com

Is "Hide All Objects" supported in Aspose.Cells?

Hello,

I have an Excel file with Smart Markers (attached) in which checkbox objects have been hidden (by using Tools | Options | Hide All Objects (2003) or Excel Options | Advanced | For Objects Show Nothing (2007)).

After running the file through Aspose.Cells, the objects (checkboxes in this case) do not remain hidden.

Is this supported?

I’m attaching the original Excel file, plus the output after processing with Cells.

Thanks!

Mike

Hi Mike,

I think you can try to hide checkboxes using Aspose.Cells APIs i.e., CheckBox.IsHidden property.

e.g.,

WorkbookDesigner wd = new WorkbookDesigner();
workbook.Open(@"d:\test\Care+Bear.xls");
.
.
.
.
.

foreach(Aspose.Cells.CheckBox check in wd.Workbook.Worksheets[0].CheckBoxes)
{

check.IsHidden = true;

}
wd.Save("d:\\test\\out_Care Bear.xls - Mini Pharma Kick-Off Deal_out.xls");

Thank you.

Thanks Amjad.

What I’m really hoping for is that Cells would retain whatever settings were previously in the workbook without having to reset the property. In other words, since the checkboxes were hidden in the template, I would really love it if they stayed hidden in the output document.

In the meantime, I’ll experiment with your suggestion.

Thanks

Mike

Hi Mike,

Please try this fix.

We have added a property Workbook.DisplayDrawingObjects to support this issue.

Hi Warren,

Thanks so much for jumping on this.

I’m assuming that this property will show whatever value was saved into the file (whether to show objects or not), and that I can change it if desired.

I’ll play with it… many thanks.

Mike