Hello,
is there any way to open an existing Excel document that contains macros and control elements (such as buttons) and preserve them until the document is being saved again?
Dim wb As Infragistics.Excel.Workbook = Infragistics.Excel.Workbook.Load("MyExcel.xls")wb.Save("MyExcel2.xls")
=> All macros, buttons etc. lost in MyExcel2.xls.
Thanks
Max
Unfortunately, there is no way to round-trip these items. You can submit a feature request for this here: http://devcenter.infragistics.com/Protected/RequestFeature.aspx.
Hi,
I need to have buttons, labels in the excel file. Has this feature been implemented.
REgards,
Yamini
The macros are now round-tripped, but forms such as buttons and labels are not. I have forwarded this post to the Developer Support Manager to create a feature request on your behalf.
Yamini,
I've just submitted feature request FR12066 for the functionality to round-trip the contents of forms (such as buttons and labels) when loading and subsequently saving an Excel file through our Excel engine to be added to a future version of the toolset.
For anyone else who is interested in seeing similar functionality in a future version of the NetAdvantage for .NET toolset, you can submit a feature request here. Remember, the number of requests we receive for a given feature is one of the tools we use to prioritize what functionaltiy goes in to a given release.
Hi kopfsick, I have double check again with our development team and found that this functionality is still not supported. So I have created a another feature request for your behalf - 12798 .For anyone else who is interested in seeing similar functionality in a future version of the NetAdvantage for .NET toolset, you can submit a feature request here. Thank you.Sincerely,DimiDeveloper Support EngineerInfragistics, Inc.
I'm bumping this thread as it has not been given an answer.
Has feature request FR12066 made it to implementation?
I love the infragistics excel component but if you need more heavy duty charts/macros etc roundtripping you might have to invest in something like gembox spreadsheet maybe? Hope infragistics improves their excel component soon.
I ask again; Has the presence of forms such as buttons and comboboxes been roundtripped ?
Please answer as it is urgent and necessary for my companys product.
Has this feature been implemented yet?