Hi supporter, i want to get value of any dropdown or any control in xlsm file when convert from xlsm file to xlsx or pdf file. Please help me how to get it. Thanks
Official response
Mario at GemBox
Hi,
This feature request has been implemented and is available in the latest versions of GemBox.Spreadsheet.
Regards,
Mario
GemBox.Spreadsheet currently lacks API support for these elements, for now, they are supports only through preservation.
Note, this is a feature that we hope to provide some time in the future, but at the moment there are other requests with greater priority.
Nevertheless, note that you could read and write the form field values indirectly, by using linked cells.
For instance, take a look at the following example:
https://www.gemboxsoftware.com/spreadsheet/examples/excel-forms-macros/802
The input file, "FormsAndMacros.xlsm", has controls that have "Cell link:" specified to some cell.
You may notice that the DropDown control has an "F8" linked cell, changing the value of that linked cell will trigger the change in the control, and changing the value in the control will trigger the change in that linked cell.
Regards,
Mario