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 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