I create a spreadsheet control ("SC") in a dialog to show the content of an Excel file. I would like upon closing the dialog to get the selected range of cells in the current sheet.
I found the property SC.ExcelProperties.CurrentExcelRangeStyle which seems to correspond to what I want, but it does not seem to work when I select multiple ranges in the spreadsheet control (using Ctrl and the mouse). Is there a way to get a multiple selection of ranges, or a list of selected ranges? If it is not possible, can I at least deactivate multi-select in the control so that my users do not believe that it is possible to select non contiguous ranges?