excelR icon indicating copy to clipboard operation
excelR copied to clipboard

ExcelR Table Crashes in Shiny when Pressing Enter on Last Row

Open millett-a opened this issue 3 years ago • 1 comments

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:

  1. Set up an excel table in a Shiny app
  2. Select a value on the last row of the table
  3. 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 avatar Feb 24 '22 17:02 millett-a

@millett-a Can you check if you can replicate the issue in the latest development version?

Swechhya avatar Oct 16 '22 01:10 Swechhya