Skip to content

ExcelR Table Crashes in Shiny when Pressing Enter on Last Row #109

@millett-a

Description

@millett-a

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)

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions