Buttons saved as Image

GemBox.Spreadsheet
1

With GemBox.Spreadsheet I open a xlsm file in which there are userform-controls, buttons in my case.

After opening in my code I will change some values in several cells, but I don’t want to do anything with these buttons.

But, after saving the workbook and opening it in Excel, these buttons are no longer controls but images which results in a excel workbook that is useless…

Why is that ? Does Gembox change these controls ?
And if so, are there any plans to change this ?
Or even better, any solution to avoid this behavior ?

2

Hi Frank,

Can you please send us your input Excel file that can reproduce this issue so that we can investigate it?

Regards,
Mario

3

I sent you the files by replying to the mail.

4

Please try again with this NuGet package:

Install-Package GemBox.Spreadsheet -Version 49.0.1668-hotfix

Note that this is a hidden pre-released version, to install it you’ll need to run the above command on the NuGet Package Manager Console (Tools → NuGet Package Manager → Package Manager Console).

Does this solve your issue?

5

I have tried it in my test-application and it works fine, thanx!