Adding textbox with scrollbar in Excel

Aspose.Cells Product Family
1

Hi,


I need to insert a text box in place of a cell and then added a scrollbar to that text box. Please let me know if its possible.

I need to show data in a cell whose cell size is fixed. So we should able to scroll down or scroll horizontally to see the data in excel sheet.

Please let me know if its possible with Aspose.Cell

Regards,
Aniket Khorjuvekar
2

Hi Aniket,

Thanks for your posting and considering Aspose.Cells.

Please provide us your source Excel file with your desired textbox. We will look into it and let you know if it can be created with Aspose.Cells or not. You can create such a file manually using MS-Excel.

For adding various types of controls including text box control, please see the following document for your reference.

Adding Cell Controls in Worksheets

3

Hi,


Attached an excel file. I have added a text-box with scrollbar.
Please attach a code snapshot to replicate the same.

Thank You,
Aniket Khorjuvekar
4

Hi Aniket,

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

We have looked into your issue and found that you are using ActiveX control which is not supported by Aspose.Cells. Aspose.Cells only supports Form Controls. Please use Form Controls for your needs.

5

Thanks Shakeel for the reply.


Can you please provide any reference link to achieving the above mention format.

I don’t want to use a simple text-box since its important to scroll through data because of the limitation of space for showing the data.

Any help will be very helpfully.

Regards,
Aniket Khorjuvekar

6

Hi Aniket,

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

Actually, Aspose.Cells cannot support ActiveX controls, so we request you to provide some Excel files with your desired text using Form Controls instead of ActiveX controls. We will then look into it and it will help us to provide you some sample code showing how to achieve it using Aspose.Cells API.