Clearing TextBoxes not working

Aspose.Cells Product Family
1

I am using version 7.5.0.0 of Aspose.Cells. I am trying to convert a spreadsheet to PDF using Workbook.Save(). This spreadsheet contains a number of textboxes that I don’t want to be in the PDF file.


In an attempt to remove these textboxes, I tried clearing the TextBoxes collection property of the Worksheet class but after clearing the textboxes collection when I save the workbook as PDF, I can see all the textboxes there.

Why are the textboxes showing up in the PDF file?

Thanks
2

Hi,


I think you may try to use TextBoxCollection.RemoveAt(index) method to remove your unwanted text boxes in the worksheet, see the sample code snippet below:

Sample code:

//…
Aspose.Cells.Drawing.TextBoxCollection textboxes = worksheet.TextBoxes;
MessageBox.Show(textboxes.Count.ToString());
textboxes.RemoveAt(0); //Remove the first text box.
//You may write your own code to loop through the text boxes in the worksheet to remove each text box.

Thank you.
3

Thanks Amjad. RemoveAt seems to be working. I thought Clear() removes all the textboxes. If this is not what Clear() does, then when will someone use Clear()?

4

Hi,


I have logged a ticket with an id “CELLSNET-41849” for the issue regarding TextBoxCollection.Clear() method. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.
5

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

6

The issues you have found earlier (filed as CELLSNET-41849) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.