An instruction video on editing data in an Editable Grid can be found here.

Data can be added manually to the Editable Grid in a similar way as data is added to an Excel Spreadsheet. Marking a field by clicking or navigating with the keyboard allows to enter data in the field.

Different data types result in different behavior when entering data. E.g., date and time can be added in different formats and is converted automatically, or dates are increased by one day automatically when adding a new line.

Entering an invalid value results in a default value for a new field and for maintaining the previous value when editing a field.

The most important keyboard shortcuts

Task

Keys

Navigation within the grid

Arrow keys for up, down, left right

(Shift+) Tab for left and right

Enter for down

Add line

Enter when in last line

Click image2019-1-10_11-33-6.png symbol

Enter data in text field

Start typing when in field

Enter data in date field

Start typing when in field

Toggle checkbox

Whitespace

Enter data in drop-down field

Whitespace to open drop-down

Start typing for search (only first letters, no full-text)

Arrow keys for navigation in drop-down


Data types

A date can be entered in the following formats and will be converted to the format set in the user settings.

  • ddMMyy
  • ddMMyyyy
  • dd.MM.yyyy


A time can be entered in the following formats and will be converted to the format set in the user settings.

  • hhmm
  • hmm
  • h:m
  • hh:mm
  • h:mm
  • hh:m