Description:
When working with an Excel file (that is defined using a variable) with multiple worksheets, if you select a sheet that is not the first one, then when you reset the node (e.g. monthly file) and open the Excel config box, the previously selected sheet is not selected; rather, the first radio button is selected.
This is very annoying (and for obvious reasons very dangerous) especially if you have a large number of sheets in a single file.
I don’t know if this is a bug - could be by design.
This happened in the previous version as well. I don’t think it happened in v4.x…
Steps to reproduce:
- Select Excel Reader
- Select an Excel file (using a variable) with multiple worksheets
- Select any worksheet, but not the first one.
- Run - all good.
- Save, close KNIME and restart
- Open the workflow and click configure in the Excel node.
- The previously selected node is no longer selected; rather, the first option is selected!
Actual results:
In my example, I had previously selected Networx Adjustments. Now it is preselected to the first worksheet “Networx Report”.
Expected results:
Previously selected worksheet (Networx Adjustment) should be pre-selected.
Attachments:
OS:
Win 11