In v 4.5 following steps unhide a hidden tab
- Read a tab/page from Excel file.
- Write a tab back with different name.
- Read same tab as in 1.
- Write tab with the same name as in 2.
Result Excel has 2 tabs from steps 1 and 2, and one hidden tab did not been visible after step 2 but visible after step 4.
thanks for the report! Unfortunately, we cannot reproduce (Mac and/or Windows) and maybe we need some clarification: Where do you observe the hidden tab? When you open the Excel file with Excel or with KNIME?
This is the setup I’ve used:
No hidden Tab shows up for me, neither in KNIME nor in Excel… Maybe you can share your Excel configuration as well?
Thank you, @LukasS.
The hidden tabs are observed in Excel (actually file has 3 hidden tabs). Knime does not show them.
Knime open the file with upended sheet.
Hidden tab appears only after second upend / overwrite.
thank you @izaychik63 for brining this up!
I was able to reproduce the issue and created a bug ticket for the issue.
Internal reference: AP-18198
Ah, when there is a hidden tab (“hidden tab”) in the Excel file like so
and I append a new sheet (“KNIME tab”) with KNIME (excel file saved with the “KNIME tab” active), the hidden tab will be unhidden after appending/overwriting with KNIME:
Is that what you mean?
Note that this was particularly difficult to reproduce because it only happens when the tab that is overwritten by KNIME is saved selected in Excel - so it already might be a workaround for you to save the Excel file such that the tab-to-be-overwritten is not selected when saving.
I looks like KNIME is unhiding the tab for some reason - which is a Bug I just filed with the internal reference AP-18199.
Again, thanks for reporting!
Edit: ah, too slow will merge the tickets
Thank you @Kathrin and @LukasS. Just make sure you did not post same issue twice
Internal reference: AP-18198, AP-18199.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.