JARVIS
Ich setze mich grade ein wenig mit Nextcloud, Docker und dem Online Office ONLYOFFICE auseinander. Soweit bin ich recht angetan von allem, ob es was “taugt”, zeigt wie immer der längere Praxistest. Da ich gerne mit Tastaturkürzeln arbeite und weniger mit der Maus, ich finde es geht einfach schneller, grade wenn man eh auf dem Keyboard tipp, bin ich ein Freund von Shortcuts / Tastaturkürzeln.
ONLYOFFICE 4.3.3 Keyboard Shortcuts / Tastaturkürzel
Nachfolgend eine Kopie aus der Hilfe von ONLYOFFICE:
| Working with Spreadsheet | ||
|---|---|---|
| Open ‘File’ panel | Alt+F | Open the File panel to save, download, print the current spreadsheet, view its info, create a new spreadsheet or open an existing one, access Spreadsheet Editor help or advanced settings. |
| Open ‘Find and Replace’ window | Ctrl+F | Open the Find and Replace window to start searching for a cell containing the characters you need. |
| Open ‘Find and Replace’ window with replacement field | Ctrl+H | Open the Find and Replace window with the replacement field to replace one or more occurrences of the found characters. |
| Open ‘Comments’ panel* | Ctrl+Shift+H | Open the Comments panel to add your own comment or reply to other users’ comments. |
| Open comment field* | Alt+H | Open a data entry field where you can add the text of your comment. |
| Open ‘Chat’ panel* | Alt+Q | Open the Chat panel and send a message. |
| Save spreadsheet | Ctrl+S | Save all the changes to the spreadsheet currently edited with Spreadsheet Editor. |
| Print spreadsheet | Ctrl+P | Print your spreadsheet with one of the available printers or save it to a file. |
| Download as | Ctrl+Shift+S | Open the Download as pane to save the currently viewed spreadsheet to the computer hard disk drive in one of the supported formats: XLSX, ODS, CSV, HTML. |
| Full screen | F11 | Switch to the full screen view to fit Spreadsheet Editor into your screen. |
| Help menu | F1 | Open Spreadsheet Editor Help menu. |
| Navigation | ||
| Jump to the beginning of the row | Home | Outline the A column of the current row. |
| Jump to the beginning of the spreadsheet | Ctrl+Home | Outline the A1 cell. |
| Jump to the end of the row | End, or Ctrl+Right | Outline the last cell of the current row. |
| Jump to the end of the spreadsheet | Ctrl+End | Outline the last cell of the spreadsheet situated at the bottommost row with data of the rightmost column with data. If the cursor is at the formula line, it will be placed to the end of the text. |
| Move to the previous sheet | Alt+PgUp | Move to the previous sheet in your spreadsheet. |
| Move to the next sheet | Alt+PgDn | Move to the next sheet in your spreadsheet. |
| Move up one row | Up Arrow | Outline the cell above the current one in the same column. |
| Move down one row | Down Arrow | Outline the cell below the current one in the same column. |
| Move left one column | Left Arrow, or Tab | Outline the previous cell of the current row. |
| Move right one column | Right Arrow, or Tab+Shift | Outline the next cell of the current row. |
| Data Selection | ||
| Select all | Ctrl+A, or Ctrl+Shift+Spacebar | Select the entire worksheet. |
| Select column | Ctrl+Spacebar | Select an entire column in a worksheet. |
| Select row | Shift+Spacebar | Select an entire row in a worksheet. |
| Select fragment | Shift+Arrow | Select the cell by cell. |
| Select from cursor to beginning of row | Shift+Home | Select a fragment from the cursor to the beginning of the current row. |
| Select from cursor to end of row | Shift+End | Select a fragment from the cursor to the end of the current row. |
| Extend the selection to beginning of worksheet | Ctrl+Shift+Home | Select a fragment from the current selected cells to the beginning of the worksheet. |
| Extend the selection to the last used cell | Ctrl+Shift+End | Select a fragment from the current selected cells to the last used cell on the worksheet. |
| Undo and Redo | ||
| Undo | Ctrl+Z | Reverse the latest performed action. |
| Redo | Ctrl+Y | Repeat the latest undone action. |
| Cut, Copy, and Paste | ||
| Cut | Ctrl+X | Cut the the selected data and send them to the computer clipboard memory. The cut data can be later inserted to another place in the same worksheet, into another spreadsheet, or into some other program. |
| Copy | Ctrl+C | Send the selected data to the computer clipboard memory. The copied data can be later inserted to another place in the same worksheet, into another spreadsheet, or into some other program. |
| Paste | Ctrl+V | Insert the previously copied/cut data from the computer clipboard memory to the current cursor position. The data can be previously copied from the same worksheet, from another spreadsheet, or from some other program. |
| Data Formatting | ||
| Bold | Ctrl+B | Make the font of the selected text fragment bold giving it more weight or remove bold formatting. |
| Italic | Ctrl+I | Make the font of the selected text fragment italicized giving it some right side tilt or remove italic formatting. |
| Underline | Ctrl+U | Make the selected text fragment underlined with the line going under the letters or remove underlining. |
| Strikeout | Ctrl+5 | Make the selected text fragment struck out with the line going through the letters or remove strikeout formatting. |
| Add Hyperlink | Ctrl+K | Insert a hyperlink to an external website or another worksheet. |
| Data Filtering | ||
| Enable/Remove Filter | Ctrl+Shift+L | Enable a filter for a selected cell range or remove the filter. |
| Format as table template | Ctrl+L | Apply a table template to a selected cell range. |
| Data Entry | ||
| Complete cell entry and move down | Enter | Complete a cell entry in the selected cell or the formula bar, and move to the cell below. |
| Complete cell entry and move up | Shift+Enter | Complete a cell entry in the selected cell, and move to the cell above. |
| Start new line | Alt+Enter | Start a new line in the same cell. |
| Cancel | Esc | Cancel an entry in the selected cell or the formula bar. |
| Delete to the left | BACKSPACE | Delete one character to the left in the formula bar or in the selected cell when the cell editing mode is activated. |
| Delete to the right | Delete | Delete one character to the right in the formula bar or in the selected cell when the cell editing mode is activated. |
| Clear cell content | Delete | Remove the content (data and formulas) from selected cells without affecting cell format or comments. |
| Functions | ||
| SUM function | Alt+’=’ | Insert the SUM function into the selected cell. |
*available for paid versions only
Interessiert in verschiedenste IT Themen, schreibe ich in diesem Blog über Software, Hardware, Smart Home, Games und vieles mehr. Ich berichte z.B. über die Installation und Konfiguration von Software als auch von Problemen mit dieser. News sind ebenso spannend, sodass ich auch über Updates, Releases und Neuigkeiten aus der IT berichte. Letztendlich nutze ich Taste-of-IT als eigene Dokumentation und Anlaufstelle bei wiederkehrenden Themen. Ich hoffe ich kann dich ebenso informieren und bei Problemen eine schnelle Lösung anbieten. Wer meinen Aufwand unterstützen möchte, kann gerne eine Tasse oder Pod Kaffe per PayPal spenden – vielen Dank.