ExcelR Table Crashes in Shiny when Pressing Enter on Last Row
Describe the bug When editing the table in a Shiny app, I noticed that the app will crash when you press 'enter' on the last row. I noticed that briefly it seems to try to add a new row onto the end of it. Looking at the logs, I see this error:
Warning: Error in if: missing value where TRUE/FALSE needed
The problem isn't just changing the last row. If you change the last row then click elsewhere, the table updates as expected.
To Reproduce Steps to reproduce the behavior:
- Set up an excel table in a Shiny app
- Select a value on the last row of the table
- Press Enter
Expected behavior I don't know what the expected behavior should be, as in Excel it would move to the next (empty) row. I would maybe suggest that if you're on the last row in a Shiny app, and you hit enter, it would then go back to the top of the table?
Desktop (please complete the following information):
- OS: MacOS
- Browser: Chrome
- Version 98.0.4758.102 (Official Build) (x86_64)
@millett-a Can you check if you can replicate the issue in the latest development version?