diff options
| author | TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com> | 2025-02-15 10:58:12 +0900 |
|---|---|---|
| committer | TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com> | 2025-02-15 10:58:12 +0900 |
| commit | c1c1eba0cd689a9bf42a778e7a23f3d8fcfe6284 (patch) | |
| tree | c2d1bcf04f7832da48e719b3d1502803e1f342aa /default/.local/share/thesiah/keys | |
| parent | e001f324c620474c355a049c924599117f0e5125 (diff) | |
updates
Diffstat (limited to 'default/.local/share/thesiah/keys')
| -rw-r--r-- | default/.local/share/thesiah/keys/calcurse | 10 | ||||
| -rw-r--r-- | default/.local/share/thesiah/keys/mutt | 34 | ||||
| -rw-r--r-- | default/.local/share/thesiah/keys/ncmpcpp | 21 | ||||
| -rw-r--r-- | default/.local/share/thesiah/keys/newsboat | 22 | ||||
| -rw-r--r-- | default/.local/share/thesiah/keys/nsxiv | 16 | ||||
| -rw-r--r-- | default/.local/share/thesiah/keys/sc-im | 2226 | ||||
| -rw-r--r-- | default/.local/share/thesiah/keys/zathura | 19 |
7 files changed, 0 insertions, 2348 deletions
diff --git a/default/.local/share/thesiah/keys/calcurse b/default/.local/share/thesiah/keys/calcurse deleted file mode 100644 index a20e624..0000000 --- a/default/.local/share/thesiah/keys/calcurse +++ /dev/null @@ -1,10 +0,0 @@ - _ - ___ __ _| | ___ _ _ _ __ ___ ___ - / __/ _` | |/ __| | | | '__/ __|/ _ \ -| (_| (_| | | (__| |_| | | \__ \ __/ - \___\__,_|_|\___|\__,_|_| |___/\___| - -calcurse is the calendar and schedule manager. - tab - Switch from calendar to todo to appointments - h/j/k/l - Move left/down/up/right - Most other bindings are listed in the program. diff --git a/default/.local/share/thesiah/keys/mutt b/default/.local/share/thesiah/keys/mutt deleted file mode 100644 index 41069ff..0000000 --- a/default/.local/share/thesiah/keys/mutt +++ /dev/null @@ -1,34 +0,0 @@ - _ _ - _ __ ___ _ _| |_| |_ -| '_ ` _ \| | | | __| __| -| | | | | | |_| | |_| |_ -|_| |_| |_|\__,_|\__|\__| - -mutt is the email client. - j/k - Move down/up - d/u - Move down/up half page - gg - Move to top - v - View/download attachments - G - Move to last message - r - Reply - R - Reply all - S - Sync/save mailbox changes - D - Mark message for deletion - U - Unmark message for deletion - ctrl-u - Seek urls - ,, - Seek urls - ctrl-f - Search mail indexed with notmuch - ctrl-r - Mark all as read - l - Limit mail - o - Run quick sync with offlineimap - O - Run full sync with offlineimap - C - Copy a message to another mailbox - M - Move a message to another mailbox - B - Hide/reveal sidebar - ctrl-j/k - Move down/up on sidebar - ctrl-o - Open box selected in sidebar - gi - Go to inbox - gs - Go to sent mail - gd - Go to drafts - gS - Go to spam - i# - Go to a different account (# is the number of the account) diff --git a/default/.local/share/thesiah/keys/ncmpcpp b/default/.local/share/thesiah/keys/ncmpcpp deleted file mode 100644 index 75cdf26..0000000 --- a/default/.local/share/thesiah/keys/ncmpcpp +++ /dev/null @@ -1,21 +0,0 @@ - - _ __ ___ _ __ ___ _ __ ___ _ __ _ __ -| '_ \ / __| '_ ` _ \| '_ \ / __| '_ \| '_ \ -| | | | (__| | | | | | |_) | (__| |_) | |_) | -|_| |_|\___|_| |_| |_| .__/ \___| .__/| .__/ - |_| |_| |_| - -ncmpcpp is the music player. - h/j/k/l - Move left/down/up/right - d/u - Down/up page - a - Add song(s) to playlist - c - Clear playlist - g - Go to top - G - Go to bottom - p - Pause - m - Media library - f - Music sorted by directory structure - t - Tag editor - s - Search - v - Visualizer - P - Playlist diff --git a/default/.local/share/thesiah/keys/newsboat b/default/.local/share/thesiah/keys/newsboat deleted file mode 100644 index b6953b3..0000000 --- a/default/.local/share/thesiah/keys/newsboat +++ /dev/null @@ -1,22 +0,0 @@ - _ _ - _ __ _____ _____| |__ ___ __ _| |_ -| '_ \ / _ \ \ /\ / / __| '_ \ / _ \ / _` | __| -| | | | __/\ V V /\__ \ |_) | (_) | (_| | |_ -|_| |_|\___| \_/\_/ |___/_.__/ \___/ \__,_|\__| - -newsboat is the RSS reader. - j/k - Move down/up - l - Open entry - h/q - Back/quit - Q - Quit immediately - J/K - Previous/next feed - n - Next unread - N - Previous unread - a - Toggle article read/unread - A - Mark all as read - U - Show all URLs - ,, - Open main link with linkhandler - ,p - Pick which program to open link with - ,v - Open video link in mpv - ,w - Open link in w3m - ,c - Copy link to clipboard diff --git a/default/.local/share/thesiah/keys/nsxiv b/default/.local/share/thesiah/keys/nsxiv deleted file mode 100644 index 78403bb..0000000 --- a/default/.local/share/thesiah/keys/nsxiv +++ /dev/null @@ -1,16 +0,0 @@ - - _ __ _____ _(_)_ __ -| '_ \/ __\ \/ / \ \ / / -| | | \__ \> <| |\ V / -|_| |_|___/_/\_\_| \_/ - -nsxiv is the image viewer. - h/j/k/l - Pan image - -/+ - Zoom out/in - Enter - Toggle thumbnail mode - f - Fullscreen - n/p - Previous/next image in list/directory - r - Reload image if changed - m - Mark/unmark image - w - Zoom to fit window - ctrl-x - Run external command (see ~/.config/nsxiv/exec/key-handler for options) diff --git a/default/.local/share/thesiah/keys/sc-im b/default/.local/share/thesiah/keys/sc-im deleted file mode 100644 index b5a2e90..0000000 --- a/default/.local/share/thesiah/keys/sc-im +++ /dev/null @@ -1,2226 +0,0 @@ - _ - ___ ___ (_)_ __ ___ -/ __|/ __|____| | '_ ` _ \ -\__ \ (_|_____| | | | | | | -|___/\___| |_|_| |_| |_| - -sc-im is a vim-like csv viewer. - -============================================================================== -sc-im has the following modes: - -sc-im has the following modes: - NORMAL MODE: In Normal mode, you can navigate cells and input normal - commands. - INSERT MODE: Use the '=', '<', '>', or '\' to go to Insert mode, where you - can enter new values and expressions into cells. - EDIT MODE: Use the 'e' or 'E' keys to go to Edit mode and enter a single - line, Vi-like, command to modify cell content - and expressions. The 'e' and 'E' keys enter this mode. - COMMAND MODE: Use the ':' key to enter Command mode. This is for entering - special commands such as quitting the app and saving files. - VISUAL MODE: Visual mode is used for selecting a range of cells. See the - section 'Selecting a range' below. - The 'v' key enters this mode from Normal mode, or <C-v> in - Insert and Command modes. - -============================================================================== -&NORMAL MODE& - -Navigation commands: - j k l h Move cursor down, up, right or left. - <UP> Move cursor up - <DOWN> Move cursor down - <LEFT> Move cursor left - <RIGHT> Move cursor right - ^ Go up to row 0 of the current column. - # Go down to the last valid row of the current column. If - already in last valid row of the current column, then jump to - last valid row of the last valid cell in spreadsheet. - 0 Go left to column A in the current row. - $ Go right to the last valid column of the current row. - b Go back to the previous valid cell. - w Go forward to the next valid cell. - '{a-zA-Z} Go to the cell or range marked previously with the character. - See 'm' for details. - goab24 Go to cell AB24. (There is no need to press <ENTER>.) - g0 Go to the leftmost column visible on screen. - g$ Go to the rightmost column visible on screen. - gM Go to the middle column on the screen. - gf Open filename or URL in current cell. - Uses helper script 'scopen' by default. - A different executable may be used by changing the - 'default_open_file_under_cursor_cmd' configuration variable - at runtime, using the :set command. - H Go to the top row visible on screen. - L Go to the lowest row visible on screen. - M Go to the middle row on the screen. - gg c-a Go to the first cell of sheet. - G gG Go to last valid cell of sheet. - gl Go to the last (previously occupied) cell position. - gt Move to next sheet in file. - gT Move to previous sheet in file. - c-f c-b Scrolls down and up full screen. - :set half_page_scroll=1 to scroll by half a page instead. - half_page_scroll=0 (default) scrolls by a full page. - See :set command for details. - c-e c-y Scroll a row down and up. - zh Scroll left one column. - zl Scroll right one column. - zH Scroll left half a page. - zL Scroll right half page. - zm Scroll horizontally to position the selected cell at the - center of the screen. - zz or z. Scroll vertically to position the selected cell at the middle - of the screen. - zt Scroll vertically to position the selected cell at the top - of the screen. - zb Scroll vertically to position the selected cell at the bottom - of the screen. - Vir Select the smallest range that covers all valid cells. - ESC or c-g Clean stdin buffer, so sc-im no longer waits for completing a - correct command. - - -Commands for handling cell content: - x dd Delete the current selected cell or range and save its - content in the yankbuffer. - m{a-zA-Z} Mark the current cell or selected range with that letter. - Note: When a mark is changed, all ranges that use that mark - are deleted. - c{a-zA-Z} Copy the marked cell or range to the current position, - adjusting row and column references in its numeric or string - expression, if any. - R{a-zA-Z}{a-zA-Z} - Select the range defined by the two marks. - Note: If a range already exists, it is replaced with the new - values. - - { } | Align the content of a cell to the left, right or center. If - a range is selected, every cell of the range gets aligned. - - f< , fh , f-LEFT: Change column format: Decrement column width. - f> , fl , f-RIGHT: Change column format: Increment column width. - f+ Change column format: Increment decimal precision. - f- Change column format: Decrement decimal precision. - fj , f-DOWN: Change row format: Increase height. - fk , f-UP: Change row format: Decrease height. - - fr Freeze a row or the rows selected. - If none is selected it freezes the current row. - - fc Freeze a col or the cols selected. - If none is selected it freezes the current col. - - fa Freeze the area selected. - - ir Insert a row. - ic Insert a column. - or Open a row: insert after the current row. - oc Open a column: insert after the current column. - sk Shifts the current cell or range up. - sj Shifts the current cell or range down. - sh Shifts the current cell or range left. - sl Shifts the current cell or range right. - - yy Yank the selected cell. - y If a range is selected, yank the range. - yr Yank current row. - yc Yank current column. - - p Paste the previously yanked cell or range. - If yr was used to yank a row, create a new row below and - paste content there. - If yc was used to yank a column, create a new column to the - left and paste content there. - Pf Works like 'p' except that only the cell formatting is - merged, leaving cell values intact. - Pv Works like 'p' except that only cell values are copied, - leaving cell formatting intact. - Pc Works like 'p' except that all cell references are adjusted - in the same way that they are for the copy command. - Pt Paste a range of cells but transposed. - - t Same as 'p' but if yr was used to yank a row, create a new - row above and paste content there. - If yc was used to yank a column, create a new column to the - right and paste content there. - Tf Works like 't' except that only cell formatting information - is merged in, leaving cell values intact. - Tv Works like 't' except that only cell values are copied, - leaving cell formatting intact. - Tc Works like 't' except that all cell references are adjusted - in the same way that they are for the copy command. - - dr Delete the current row. - dc Deletes the current column. - . Repeat the last normal mode command. - - Decrease a numeric value of the cell or range. - + Increase a numeric value of the cell or range. - - u UNDO last change - c-r REDO last change - Note: Events implemented for undo and redo: - 1. cell or range deletion - 2. cell input - 3. cell editing - 4. cell or range change in alignment - 5. pasting a cell or range - 6. range or cell shift with sh sj sk sl - 7. row or column insertion - 8. row or column deletion - 9. pasting a row or column - 10. zap(hide) or show a row or column - 11. reordering of a range - 12. changing the format of a range or cell - 13. '-' and '+' commands in normal mode - 14. locking and unlocking of cells - 15. the datefmt command - 16. the cellcolor command - 17. Change in format of a column as a result of the 'f' command - 18. Change in format of a column as a result of auto_jus - 19. Change format of columns as a result of ic dc - 20. fill command - 21. unformat - 22. change in the format of rows - - c-d Convert the text content of a selected cell or range to a - date, using default LOCALE's D_FMT format. - This converts text to a numeric value that can be shown as a - date. See DATES INPUT below for more info. - Note: USELOCALE has to be enabled during build. - - aa c-j Auto-resize the selected column(s) to accommodate the widest - cells. - - Other commands: - ^L Redraw the screen. - Zr Zap (hide) the current row. - Zc Zap (hide) the current column. - Sr If a range is selected, show the rows hidden in the range. - Sc If a range is selected, show the columns hidden in the range. - / Alias for ':int goto '. - - If a number is given, sc-im will search for a cell containing - that number. Searches for either strings or numbers proceed - forward from the current cell, wrapping back to a0 at the end - of the table, and terminate at the current cell if the string - or number is not found. - - Example: Type '/4' to look for cells containing the value 4. - Or type '/"value"' to look for cells that has "value" as - label content. - You can quote a regular expression, and sc-im will search for - a cell containing a string matching that regular expression. - Example: Type / followed by "[_mente]" (with the double - quotes). That will look up for cells that has one character - and finish with 'mente' - - You can search for formatted numbers or expressions using - regular expressions by preceding the opening quotes of the - regular expression with a '#' (for formatted numbers) or a - '%' (for expressions). - These are handy for searching for dates within a specified - range or cells which reference a given cell, for example, - although they are somewhat slower than searching through - ordinary strings, since all numbers must be formatted or - expressions decompiled on the fly during the search. - - ? Same as / but searches backwards. - n Move to next search match. - N Move to previous search match. - - rl Lock the current cell or range. Locking makes cells immune to - any type of editing. A locked cell can't be changed in any - way until it is unlocked. - ru Unlock a locked cell or range, making it editable. - rv Valueize the current cell or range. Valueizing removes - expressions, leaving only the values. - -============================================================================== -&INSERT MODE& - - = Enter a numeric constant or expression. - < Enter a left justified string or string expression. - \ Enter a centered label. - > Enter a right justified string or string expression. - > - NOTE: if entering strings that exceed column width, you - can make them show truncated, overlapping to adjacent column, or to - wrap it increasing the rows height. - Please see :set overlap, :set truncate, :set autowrap - options. - You can also type \n when entering strings and sc-im will increase - row height accordangly. - - <TAB> Return to Edit mode from Insert mode. - <LEFT>, <RIGHT> - Move the cursor with the arrow keys. - Keys <ENTER> - Input numbers, letters and operators. - <BS>, <DELETE> - Delete the character after or before the cursor. - <ESC> Go back to NORMAL MODE. If you were in EDIT MODE before, - it goes back to that mode, instead of NORMAL MODE. - c-r{a-zA-Z} - If the character is a mark of a cell or range, the range - represented is inserted into the field. - c-v Enter Visual mode. See C-o and C-k commands in VISUAL MODE. - \\{char} Fills the cell with n occurrences of {char} to complete its width. - -============================================================================== -&EDIT MODE& - - e In normal mode, enter Edit mode to edit a numeric value. - E In normal mode, enter Edit mode to edit a text value. - h Move a character left. - l Move a character right. - w Move to the beginning of the next word. - e If at the end of a word, move to the end of the next word. - Otherwise, move to the end of word under the cursor. - b If at the beginning of a word, move to beginning of the - previous word. Otherwise, move to beginning of word under the - cursor. - 0 Move to the beginning of the line. - ^ Go to the first non blank character of the line - $ Move to the end of the line. - g_ Go to the last non blank character of the line - f{char} Move to the next occurrence of {char} to the right. - F{char} Move to the previous occurrence of {char} to the left. - t{char} Move until the next occurrence of {char} to the right. - T{char} Move until the previous occurrence of {char} to the left. - r{char} Replaces the character under the cursor with {char}. - R{word} Each character you type replaces an existing character, - starting with the character under the cursor. - ESC key or ENTER key must be pressed when finished typing the - new word. - - de Delete until the end of the word. - dw Delete until the beginning of the next word. - - d0 Delete until the beginning of the line. - d$ Delete until the end of the line. - d^ Delete from position until the first non blank character of the line - dg_ Delete from position until the last non blank character of the line - - db If at the beginning of a word, delete until the beginning of - the previous word. Otherwise, delete until the beginning of - the word under the cursor. - daw Delete the word under the cursor. - dE Delete until the end of WORD. - dW Delete until the beginning of the next WORD. - - dB If at the beginning of a word, delete until the beginning of - previous WORD. Otherwise, delete until the beginning of the - WORD under the cursor. - daW Delete the WORD under the cursor. - dl Delete the character under the cursor. - d<RIGHT> Delete the character under the cursor. - dh Delete the character before the cursor. - d<LEFT> Delete the character before the cursor. - df{char} Delete until the first occurrence of {char} to the right. - dF{char} Delete until the previous occurrence of {char} to the left. - dt{char} Delete until the next occurrence of {char} to the right. - dT{char} Delete until the previous occurrence of {char} to the left. - - - ce Same as "de", then enter Insert mode. - cw Same as "dw", then enter Insert mode. - c0 Same as "d0", then enter Insert mode. - cb Same as "db", then enter Insert mode. - caw Same as "daw", then enter Insert mode. - cE Same as "dE", then enter Insert mode. - cW Same as "dW", then enter Insert mode. - c$ Same as "d$", then enter Insert mode. - c^ Same as "d^", then enter Insert mode. - cg_ Same as "dg_", then enter Insert mode. - cB Same as "dB", then enter Insert mode. - caW Same as "daW", then enter Insert mode. - cl Same as "dl", then enter Insert mode. - c<RIGHT> Same as "d<RIGHT>", then enter Insert mode. - ch Same as "dh", then enter Insert mode. - c<LEFT> Same as "d<LEFT>", then enter Insert mode. - cf{char} Same as "df{char}", then enter Insert mode. - cF{char} Same as "dF{char}", then enter Insert mode. - ct{char} Same as "dt{char}", then enter Insert mode. - cT{char} Same as "dT{char}", then enter Insert mode. - - x Delete the character under the cursor. - X Delete the character before the cursor. - i or = Go back to Insert mode. - a Append a character after the cursor. - s Delete a character under the cursor, then enter Insert mode. - A Append at the end of the line. - I Append at the beginning of the line. - D Delete from the current cursor position to end of line. - C Same as D, but then enter Insert mode. - <SPACE> Add a space under the cursor. - <ENTER> Confirm changes. - <ESC> It also confirm changes. If you were in INSERT MODE before, - it goes back to that mode, instead of NORMAL MODE. -============================================================================== -&COMMAND MODE& - - <LEFT>, <RIGHT> - Move the cursor position with the arrow keys. - - <ENTER> - Confirm a command. - - <DELETE>, <BS> - Delete the character under the cursor, or before the cursor. - - <HOME>, <END> - Move the cursor to the beginning or end of the line. - - <TAB> Complete a command that begins with the text already entered - in the command line. - - <C-w>, <C-b> - Move forward or backwards a word. - - <C-f> - Paste the current cell format (if any) to the command line. - - <C-v> Starts VISUAL MODE. See C-o and C-k commands in VISUAL MODE. - - :w Save the current spreadsheet. - :w {file} Save the current spreadsheet as {file}. - :w! {file} Save the current spreadsheet as {file}, forcing an overwrite - if {file} already exists. - The format in which it will be save will be according to the current file extension, if any. - - :h Show this help. - :help Show this help. - - :q[uit] Quit sc-im. - :q[uit]! Quit sc-im, ignoring unsaved changes. - - :load {file} - Load (or reload) {file} into the sc-im database. - - {file} can be an sc format file (.sc), a comma-separated file - (.csv), a tab-separated file (.tab, .tsv),a markdown table - file (.md, mkd, .markdown), an xlsx or xls file. - - If loading a csv, tab or tsv file and - 'import_delimited_to_text' configuration variable is set - Sc-im will import numbers as text. - - If loading an xlsx file and 'xlsx_readformulas' is set, Sc-im - will try to import formulas, rather than the final values of - a cell. - - :load! {file} - Same as previous, but ignore changes done to the current - loaded spreadsheet. - - :x Save the current spreadsheet and quit sc-im. - :wq - - :x {file} Save the current spreadsheet to {file} and quit sc-im. - - :x! {file} Like ":x", but overwrite {file} if it exists. - - :e tab Export the current spreadsheet to a tab-separated file. - The name of the created file comes from the current - spreadsheet, with ".tab" appended. - If a range is selected, only that range is exported. - NOTE: If you do an export with the :e command, current file - name stays unchanged. - See :file command for more details. - See 'ignore_hidden' configuration variable below to avoid exporting - hidden rows. - - :e tab {file} - Export the current spreadsheet to tab-separated file {file}. - - :e! tab {file} - Like ":e tab", but overwrite {file} if it exists. - If a range is selected, only that range is exported. - - :e csv Export the current spreadsheet to a comma-separated file. - - :e csv {file} - Export the current spreadsheet to comma-separated file - {file}. - - :e! csv {file} - Like ":e csv", but overwrite {file} if it exists. - - :e txt Export current spreadsheet to plain text. - If a range is selected, only that range is exported. - - :e txt {file} - Export the current spreadsheet to plain text file {file}. - - :e! txt {file} - Like ":e txt", but overwrite {file} if it exists. - - :e tex Export current spreadsheet to Latex file. - If a range is selected, only that range is exported. - - :e tex {file} - Export the current spreadsheet to Latex file {file}. - - :e! tex {file} - Like ":e tex", but overwrite {file} if it exists. - - :e mkd Export the current spreadsheet to a markdown file solely - containing a single markdown table. - The column alignments come from the cells on the row. All - other alignments are ignored as markdown tables do do not - support cell level alignment. - - :e mkd {file} - Export the current spreadsheet to markdown file {file}. - - :e! mkd {file} - Like ":e mkd", but overwrite {file} if it exists. - - :e xlsx {file} - Export the current spreadsheet to xlsx file {file}. - If 'xlsx_readformulas' is set, sc-im tries to export - formulas, rather than the final values of a cell. - - :e! xlsx {file} - Like ":e xlsx", but overwrite {file} if it exists. - - :ccopy Copy a selected range to clipboard. - When 'ccopy' command is executed, the default value of macro - DEFAULT_COPY_TO_CLIPBOARD_CMD (set in Makefile during build) - is executed. - That value contains a system command that is executed to copy - to an specific clipboard. See in Makefile the different - options available. - You can also set a different value of - 'default_copy_to_clipboard_cmd' configuration variable at - runtime, using the :set command. - This process will export content as plain text. - It will not delimit columns with '\t' chars. - If you wish to delimit columns with tabs in order to paste - content directly into other spreadsheet programs rather than - an editor, set "copy_to_clipboard_delimited_tab" to "1". - If you wish to copy a full string representation of the range - instead of how its currently displayed in Sc-im, set - "copy_to_clipboard_wysiwyg" to "0". - - :cpaste Paste clipboard content to Sc-im. - When 'cpaste' command is executed, the default value of macro - DEFAULT_PASTE_FROM_CLIPBOARD_CMD (set in Makefile during - build) is executed. - That value contains a system command that is executed to - paste content of a specific clipboard to Sc-im. - See in Makefile the different options available. - You can also set a different value of - 'default_paste_from_clipboard_cmd' configuration variable at - runtime, using the :set command. - This process will treat '\t' chars as column delimiter, and - '\n' chars as rows delimiters. - - :version Show sc-im version number. - - If you start Sc-im with ./sc-im --version - version number of Sc-im will be printed on screen, including - the different features that were enabled when Sc-im was - compiled. Afterwards Sc-im will exit. - - :refresh Refresh the UI. Acts like the <C-l> command of NORMAL_MODE. - - :set Show all configuration options and their values. - - :set {option}={value} - Set a configuration option to {value}. The arguments may be - repeated. - Example: :set half_page_scroll=0 numeric_zero=1 - :set numeric (same as :set numeric=1) - :set nonumeric (same as :set numeric=0) - :set default_paste_from_clipboard_cmd="xsel" - - :newsheet "{name}" - create a new sheet in file and move to it. - - :nextsheet - move to next sheet in file - - :prevsheet - move to previous sheet in file - - :delsheet "{name}" - deletes the sheet named {name}. - - :delsheet - deletes the current sheet. - - :renamesheet "{name}" - rename the current sheet to {name}. - - :showmaps Show all key mappings. - - :nmap {lhs} {rhs} - Map the key sequence {lhs} to {rhs} This mapping takes effect - only in NORMAL_MODE. - Example: :nmap "H" ":h<cr>" - - :imap {lhs} {rhs} - Map the key sequence {lhs} to {rhs} This mapping takes effect - only in INSERT_MODE. - Example: :imap "<C-f>" "format" - - :emap {lhs} {rhs} - Map the key sequence {lhs} to {rhs} This mapping takes effect - only in EDIT_MODE. - Example: :emap "<C-k>" "D" - - :vmap {lhs} {rhs} - Map the key sequence {lhs} to {rhs} This mapping takes effect - only in VISUAL_MODE. - Example: :vmap "e" "y" - - :cmap {lhs} {rhs} - Map the key sequence {lhs} to {rhs} This mapping takes effect - only in COMMAND_MODE. - Example: :cmap "<C-q>" "quit<cr>" - :cmap "kj" "<ESC>" - - :nnoremap {lhs} {rhs} - This is the non-recursive version of ":nmap". See NOTES on - MAPPING below - - :inoremap {lhs} {rhs} - This is the non-recursive version of ":imap". See NOTES on - MAPPING below - - :enoremap {lhs} {rhs} - This is the non-recursive version of ":emap". See NOTES on - MAPPING below - - :vnoremap {lhs} {rhs} - This is the non-recursive version of ":vmap". See NOTES on - MAPPING below - - :cnoremap {lhs} {rhs} - This is the non-recursive version of ":cmap". See NOTES on - MAPPING below - - :nunmap {lhs} - Remove the map sequence {lhs} that takes effect in - NORMAL_MODE. - - :iunmap {lhs} - Remove the map sequence {lhs} that takes effect in - INSERT_MODE. - - :eunmap {lhs} - Remove the map sequence {lhs} that takes effect in - EDIT_MODE. - - :vunmap {lhs} - Remove the map sequence {lhs} that takes effect in - VISUAL_MODE. - - :cunmap {lhs} - Remove the map sequence {lhs} that takes effect in - COMMAND_MODE. - - :file [{file}] - If {file} is given, expand {file}, and set the current file - name to the result of the expansion. - - If {file} is not given, display the current file name on - the status line. - Take note that current file name is set during loading of - Sc-im or with this command. If you do an export with the :e - command, current file name stays unchanged. - - :fill {range} {initial_number} {increment_number} - Fill range {range} with values. The first cell of the range - will have {initial_number} and each successive cell - increments by {increment_number}. - Example: :fill A0:A100 1 0.25 - - :format "{format_string}" - Set the numeric format for the selected cell or range. - {format_string} can contain one or more of these: - - # Digit placeholder. If the number has fewer digits on either - side of the decimal point than there are '#' characters in - the format, the extra '#' characters are ignored. The number - is rounded to the number of digit placeholders as there are - to the right of the decimal point. If there are more digits - in the number than there are digit placeholders on the left - side of the decimal point, then those digits are displayed. - - 0 Digit placeholder. Same as for '#' except that the number - is padded with zeroes on either side of the decimal point. - The number of zeroes used in padding is determined by the - number of digit placeholders after the '0' for digits on - the left side of the decimal point and by the number of - digit placeholders before the '0' for digits on the right - side of the decimal point. - - . Decimal point. Determines how many digits are placed on - the right and left sides of the decimal point in the number. - Note that numbers smaller than 1 will begin with a decimal - point if the left side of the decimal point contains only - a '#' digit placeholder. Use a '0' placeholder to get a - leading zero in decimal formats. - - % Percentage. For each '%' character in the format, the actual - number gets multiplied by 100 for the purposes of formatting - (the original value is unmodified) and the '%' character is - placed in the same position as it is in the format. - - , Thousands separator. The presence of a ',' in the format - (multiple commas are treated as one) will cause the number - to be formatted with a ',' separating each set of three digits - in the integer part of the number with numbering beginning - from the right end of the integer. - - d Specifies a date format that is applied to the numeric value - of a cell. (See also the DATES INPUT section below.) Date - format strings are identified by the presence of a 'd' in the - first position. If this is present, the remainder of the - string is passed to the strftime() function, and therefore - uses the same conversion specifiers as strftime(). - For more information on conversion specifiers for date format - strings, see the man page for strftime(3). - - E- E+ e- e+ - Scientific format. Causes the number to formatted in - scientific notation. The case of the 'E' or 'e' given is - preserved. If the format uses a '+', then the sign is always - given for the exponent value. If the format uses a '-', then - the sign is only given when the exponent value is negative. - Note that if there is no digit placeholder following the '+' - or '-', then that part of the formatted number is left out. In - general, there should be one or more digit placeholders after - the '+' or '-'. - - Examples: :format "###,###,000" - :format "d%d/%m/%Y" - :format "####.####E+3" - - :formatcol {width} {precision} {fixed-point} - Format the selected column or range of columns with the - specified format of width, precision and fixed-point. - - :formatrow {height} - Format the selected row or range of rows with the specified - height. - - :datefmt "{date_format_string}" See the DATES INPUT section below. - - - :sort {range} "{sort_string}" - Sort a range of cells with a given criteria. - The rows in the specified range will be sorted according - to a criteria given in the form of a string of characters. - This string, enclosed in double quotes, may comprise a - single criterion or multiple criteria in decreasing order - of precedence. Each criterion has three parts, all of which - are mandatory. - - The first part is a single character, either + or -, which - specifies whether the sort should be done in ascending or - descending order, respectively. - - The second part, also a single character, is either # or $, - and specifies whether the sort should be based on the numeric - portion or the string portion, respectively, of the cells - being - used for the comparison. - - The third part is one or two letters (case insensitive) that - specify the column used for making the comparisons. This - column must be in the range being sorted. - - Criteria may be concatenated with ';' and are applied in the - order specified. - - Examples: :sort C10:E13 "+#D" - :sort C10:E13 "+#C;-#D" - - :sort "{sort_string}" - Like ":sort {range}", but the sort is performed on the - selected range. - - :subtotal {col_range} {operation} {col_operation} - Apply subtotals over the data in a selected range. - {col_range} is the column to group by. - {operation} can be one of the following: - @sum, @prod, @avg, @count, @stddev, @max, @min - {col_operation} is the column whose values will be used - to do the {operation}. - Example: load the file example examples/sc/subtotals.sc, - select the A1:C9 range, and type :subtotal A @sum C - - :addfilter "{filter_string}" - :showfilters - :filteron {range} - :filteroff - :delfilter {filter_number} - :delfilters - These commands filter a range of rows by multiple criteria. - - ":addfilter" defines a filter according to {filter_string} in - this format: - - The first part is either '#' or '$', and specifies whether the - expression evaluates the numeric portion or the string portion - of the cell. - - The second part specifies the column that contains the values - to be evaluated with the expression. - - The third part is the actual expression evaluated. - - Multiple criteria can be separated with the ';' character. - - Examples: - :addfilter "#B<8000" - :addfilter "#C>1500" - :addfilter "@eqs(@substr($B,1,3),'SEP')" - :addfilter "#B>3000;#B<5000;#B>@avg(B1:B20)" - - Once filters are added, you can see the details of each filter - with ":showfilters". - Each filter is preceded by a number. You can delete a filter - with ":delfilter {filter_number}". - For example, to remove the first filter defined: - :delfilter 0 - - ":delfilters" deletes all defined filters. - - ":filteron {range}" applies the filters to the range. - Example: :filteron B10:C13 - - If a range is selected you can simply type ":filteron". - - ":filteroff" turns off the filters. - - :strtonum {range} - Converts string field containing digits to a numeric field. - So you can calculate with it. - Example: - label A0 = "5" -> let A0 = 5 (internal representation) - - :int "{string}" - Send a command to the interpreter. - Example: :int goto B2 - - - :hidecol {column} - :hidecol {column:column} - Hide the column or column range given. (Case insensitive.) - - :hiderow {row} - :hiderow {row:row} - Hide the row or rows given. - - :showcol {column} - :showcol {column:column} - Show columns that were previously hidden. - - :showcols - Having a selected range, it will show cols that were previously hidden in that range. - - :showrow {rows} - :showrow {row:row} - Show rows that were previously hidden. - - :showrows - Having a selected range, it will show rows that were previously hidden in that range. - - :hiddenrows - Show details of hidden rows. - - :hiddencols - Show details of hidden columns. - - :freezecol {column} - :freezecol {column:column} - Freeze the column or column range given. (Case insensitive). - (the rest of the screen scrolls but the column/s stays fixed - on the screen). - :freezecol {range} - Freeze the columns determined by the selected range. - - :freezerow {row} - :freezerow {row:row} - Freeze the row or row range given. - (the rest of the screen scrolls but the row/s stays fixed on - the screen). - :freezerow {range} - Freeze the rows determined by the selected range. - - :unfreezecol {column} - :unfreezecol {column:column} - Unfreeze a previous frozen col or range of cols. - - :unfreezerow {row} - :unfreezerow {row:row} - Unfreeze a previous frozen row or range of rows. - - :pad {spaces} - Apply a left padding {spaces} characters in width to a column. - If a range selected, pad the columns inside that range. - - :color "{key}={arg} .." - Change a color definition. - - {key} is one of the following: - type, fg, bg, bold, italic, dim, reverse, standout, underline, - blink - Notes: The type, fg, and bg keys are mandatory. - Some terminal dont support some attributes, such as italic. - - The value of type shall be one of the following: - HEADINGS, HEADINGS_ODD, MODE, NUMB, STRG, DATEF, - EXPRESSION, GRID_EVEN, GRID_ODD, - CELL_ERROR, CELL_NEGATIVE, CELL_SELECTION, - CELL_SELECTION_SC, INFO_MSG, ERROR_MSG, CELL_ID, - CELL_FORMAT, CELL_CONTENT, WELCOME, NORMAL, INPUT, - HELP_HIGHLIGHT. - - The value of fg and bg shall be one of the following: - WHITE, BLACK, RED, GREEN, YELLOW, BLUE, MAGENTA, CYAN, - DEFAULT_COLOR or NONE_COLOR. - - DEFAULT_COLOR just takes the default color of your - terminal. If you set it as fg color it will take default - color of your foreground. If you set it as bg color it - will take the default background color of your terminal. - - - If you set fg or bg value to NONE_COLOR. Colors will be kept - intact and will not be changed. Just bold, italic and other - attributes will be applied. - - - The value of other parameters are booleans, 1 or 0. - - Example: :color "type=HEADINGS bold=0 fg=BLACK bg=YELLOW" - - Colors can be set at runtime or specified in: - a. the scimrc file stored in $HOME/.config/sc-im/ - b. the current .sc file. - - color "type=HEADINGS fg=WHITE bg=CYAN" - - - The different types and its details: - - HEADINGS Topmost (header) row that lists column names - (only for even columns), and leftmost (header) column - that lists row numbers. - - HEADINGS_ODD The same that above but shown for odd columns. - - MODE The text in the top right that indicates which - mode sc-im is currently in. - - NUMB The cell styling used for cells formatted as - numbers (That are positive) - - STRG The cell styling used for cells formatted as - strings. - - DATEF The cell styling used for cells formatted as - dates. - - CELL_SELECTION - The row and column selection styling - used on the HEADINGS to indicate the coordinates of the - selected row. - - CELL_SELECTION_SC The currently (focussed) cell. - - GRID_EVEN: Color shown for even columns itself. - - GRID_ODD: Color shown for odd columns itself. - - EXPRESSION The cell styling used for cells that are - the result of an expression. - - CELL_ERROR The cell styling used for when an expression - results in an error (like dividing by zero) - - CELL_NEGATIVE The cell that is used when a number (or - expression) is a negative value. - - INFO_MSG The text in the top left corner just above "A" - that will provide info messages "At column A" when you - try and go past the farthest column to the left - - ERROR_MSG The text that will display in the top left - corner when a command fails for some reason. - - CELL_ID The coordinates of the currently selected cell - that displays in the upper top left corner. Just to the - left of the CELL_FORMAT and CELL_CONTENT. - - CELL_FORMAT The text just to the right of the CELL_ID - and left of the CELL_CONTENT in the top left corner that - shows the formatting of the currently selected cell. - - CELL_CONTENT The text just to the right of the CELL_ID - and CELL_FORMAT that shows the content of the currently - selected cell. This will show the expression used to get - the current cell. - - WELCOME The text that shows up when you first open sc-im - - NORMAL Text that shows on top of the terminal (like in :help) - - INPUT The text that shows up while you type text in the - input bar at the top left of the screen. - - HELP_HIGHLIGHT Color used for highlighting search results - and titles of help page. - - :cellcolor "{key}={arg} .." - Change the color of the current cell or range. - Example: :cellcolor "bg=CYAN fg=WHITE" - :cellcolor "fg=RED bold=1 underline=1" - :cellcolor A2:A6 "fg=CYAN bold=1 underline=1" - - :unformat - :unformat {range} - Removes a previous format set over a range. - If not range is specified, it removes the format over current - cell. - - :define_color "{color} {R} {G} {B} - Create a custom color named {color} with {R} {G} {B} RGB - values. - RGB values range from 0 to 255. - - Note: This requires that ncurses is built with --enable-ext-colors, - and the terminal must support 256 colors. For example, TERM=xterm-256color. - You can check how many colors your terminal supports with: 'tput colors' command. - sc-im must also be linked to ncursesw library and not the common ncurses library. - - Example of use: :define_color "skyblue" 75 50 200 - - To make this take effect every time sc-im is started, you can - add it to $HOME/.config/sc-im/scimrc: - DEFINE_COLOR "skyblue" 75 50 200 - - You then can use the color defined above to colorize a type, like this: - :color "type=HEADINGS fg=skyblue bg=BLACK" - or adding in $HOME/.config/sc-im/scimrc: - color "type=HEADINGS fg=skyblue bg=BLACK" - - - :redefine_color "{color}" {R} {G} {B} - Change the RGB values of the colors defined by ncurses. - RGB values range from 0 to 255. - - Note: This requires that ncurses is built with - --enable-ext-colors, and the terminal must support 256 colors. - For example, TERM=xterm-256color. sc-im must link to - ncursesw library and not the common ncurses library. - - Example: :redefine_color "RED" 250 0 0 - - To make this take effect every time sc-im is started, you can - add it to $HOME/.config/sc-im/scimrc: - REDEFINE_COLOR "RED" 250 0 0 - - Redefining the BLACK color itself is another way to change the - default background color of sc-im. - - :lock Lock the current cell or range. Locked cells are immune to - any type of editing and can't be changed in any way until - unlocked. - - :unlock Reverses the effect of ":lock", making the current cell or - range editable. - - :valueize Replace expressions in the current cell or range with the - values evaluated from the expressions. - - :! {cmd} Executes shell command {cmd}. - - :autofit {column} - :autofit {column}:{column} - Auto-resize the column or column range to fit their contents. - - :autofit Auto-resize the columns covered by the selected cell or range. - - :trigger Trigger action on cell or range. Trigger can be Read or Write - or Both. On Read, trigger is executed before evaluating cells - value, on Write, after the evaluation. Type of Trigger can be - Lua or C. In Lua there are sc-im specific function available - accessing cells, more in "examples/lua* directory. - - Example: - :trigger a5 "mode=R type=LUA file=trg.lua function=trg" - - Triggers when ever cell a5 is read and calls function - trg() in file trg.lua. In Lua column, row and mode is - passed as parameter to the function. Mode is whether - it was a READ or WRITE trigger. - - :trigger b10 "mode=W type=C file=trg.so function=wr2mysql" - - Function "wr2mysql" in trg.so is called when to - cell b10 is written a new value. - See "examples/Module/module.c" for more Infos. - Adding "-Wl,--export-dynamic" in Makefile for linking - sc-im, will export all symbols from sc-im, making it - available for dynamic linking with modules. - - The search path for LUA trigger files is - $PWD/lua/ or $HOME/.config/sc-im/lua/ or /usr/local/share/sc-im/lua - (in that order) and for C Trigger - $HOME/.sc-im/module or /usr/local/share/sc-im/module - - - :untrigger Delete Trigger action on cell. Use with care. - - :fsum Sum the numeric values of a range. - - The range is defined by the immediate cell above the current - cell for vertical ranges, or by the immediate cell at the left - of the current cell for horizontal ranges. - - The top or left corner is limited by the first non-numeric - cell found. - - :fcopy Copy the formula of a selected cell down a number of rows. - The number of rows down is determined by the first empty cell - in the column to the left of current cell. - - If a range is selected, the formula in the top left cell will - be copied down to the end of the range. - - :fcopy {action} - Copy the formulas of multiple selected cells into a direction. - - Use "c" or "columns" to copy every formula in the first - selected row down its column, "r" or "rows" to copy every - formula in the first selected column to the right in its row - or "cells" to copy the formula of the first selected cell into - all cells of the selected range. - - :plot {type} - Plot a graphic using a selected range. - Right now, only 'line', 'scatter', 'bar' and 'pie' types are - allowed. - - Ex. of use: :plot line - This command calls gnuplot using the file called 'plotline' - that is first looked in $HOME/.config/sc-im/, and if not found in - /usr/local/share/sc-im/ (or HELPDIR path of Makefile). - This 'plotline' can be customized by user. (See :plotedit - command below). You can set terminal and other gnuplot - parameters. Default terminal is 'dumb', although 'caca' - terminal is recommended for colors and wide chars support. - - :plotedit {type} - Edit a plot file that will be used for plotting. - Can contain any gnuplot command. - Right now, only 'line' type, 'scatter' type, 'bar' type and - 'pie' type files can be edited. - - Ex. of use: :plotedit scatter - - c-r{a-zA-Z} - If the character is a mark of a cell or range, the range - represented is inserted into the command line. - - Command line history is stored in $HOME/.sciminfo. - - c-p - <UP> Go back in command line history. - NOTE: if inputline is not empty, up and down keys recall older - commands from history, but taking whose commands that - beginning matches the current inputline content. - - c-n - <DOWN> Go forward in command line history. - -============================================================================== -&VISUAL MODE& - Selecting a range - - Visual mode is used for selecting a range of cells for an operation. - - You can enter this mode with 'v' in Normal mode, or with <C-v> in Insert - and Command mode. - - When entering Visual mode from Normal mode, the top left and the bottom - right limit of the selected range is set to current row and column. - - From Insert or Command mode, press <C-v>, then position the cursor with - arrow keys or hjkl keys, and then press <C-o> to begin selection. - Move the cursor to complete the selection, then press <C-k> to input - the range into the cell. - - The following motion commands move the cursor during selection: - j k l h Move down, up, right or left. - 0 Move to column A. - $ Move forward to the last valid column of the current row. - # Move down to the last valid row of the current column. - ^ Move up to row 0 of the current column. - '{a-zA-Z} Move to the cell or select the range marked previously with - {a-zA-Z}. See the 'm' command for details. - c-f c-b Increase selection down or up a full screen. - :set half_page_scroll=1 to scroll by half a page instead. - See :set command for details. - c-a Moves to first cell of spreadsheet. - - y Yank the selected cell or range and exit Visual mode. - p Paste the previously yanked cell or range into the Visual - Range repeating to fill up the range - P Works like 'p' except that all cell references are adjusted - in the same way that they are for the copy command. - - x , dd Delete the current range, saving its content to the - yankbuffer. - H Move to the first row visible on screen. - L Move to the last row visible on screen. - M Move to the middle row visible on screen. - w Move forward to the next valid cell. - b Move back to the previous valid cell. - G Move to last valid cell of spreadsheet. - - : Enters Command mode preserving the range selection, so a - special command can be entered. - Zr Zap (hides) the rows covered by the selected range. - Zc Zap (hides) the columns covered by the selected range. - f Freeze the selected range - Sr Show rows that are hidden and that are covered by the selected - range. - Sc Show columns that are hidden and that are covered by the - selected range. - { } | Align the content of the cells covered by the selected range - to the right, left or center. - rl Lock the current cell or range. Locking makes cells immune to - any type of editing. A locked cell can't be changed in any - way until it is unlocked. - ru Unlock a locked cell or range, making it editable. - rv Valueize the current cell or range. Valueizing removes - expressions, leaving only the values. - m{a-zA-Z} Mark the current cell or selected range with that letter. - Note: When a mark is changed, all ranges that use that mark - are deleted. - c-d Convert the text content of a selected cell or range to a - date, using default LOCALE's D_FMT format. - This converts text to a numeric value that can be shown as a - date. See DATES INPUT below for more info. - Note: USELOCALE has to be enabled during build. - c-j Auto-resize the selected column(s) to accommodate the widest - cells. - -============================================================================== -&MAPPING& - - Mapping can be done in any sc-im file or in CONFIG_DIR/scimrc file. - - Maps can be added with the :nmap, :imap, :emap, :cmap and :vmap commands and - removed with the :nunmap, :iunmap, :cunmap and :vunmap commands. - Example: - :nmap "d" ":h<cr>" -> Maps d to ':help<cr>' in Normal mode. - :imap "f" "foo" -> Maps f to the string 'foo' in Insert mode. - :imap "kj" "<ESC>" -> Maps kj sequence to the ESC key in Insert mode. - :emap "<C-k>" "D" -> Maps C-k to D in Edit mode. - :cmap "kj" "<ESC>" -> Maps kj sequence to the ESC key in Command mode. - :vmap "e" "y" -> Maps e to y in Visual mode. - - Some notes: - The Left and Right sequence of a mapping cannot contain numbers. - - The following special keys can be used for mappings: - <CR> <C-x> <TAB> <LEFT> <RIGHT> <DOWN> <UP> <DEL> <BS> <HOME> <END> - <PGDOWN> <PGUP> <ESC> - - If an existing map sequence is remapped, it is replaced with the new one. - Mapping is recursive by default. The non-recursive versions of :nmap, - :imap, :emap, :cmap and :vmap are :nnoremap, :inoremap, :enoremap, - :cnoremap and :vnoremap. - Example: - nmap "a" "b", - nnoremap "b" "j" - nmap "j" ":h<cr>" - With this, 'a' maps to 'j', and only 'j' maps to ':h<cr>'. - -============================================================================== -&COMMAND MULTIPLIER& - - An optional number may precede commands in Normal, Visual or Edit mode to - multiply or iterate the command. - Ex. '4j' in Normal mode, translates to 4 times 'j'. - Ex. '4yr' in Normal mode, yanks current row and the 3 rows below it. - - Note: The 'x' command in Visual mode, and the shift commands in Visual - mode and Normal mode when a range is selected, cannot be multiplied. - -============================================================================== -&DATES INPUT& - - Dates are internally stored in sc-im as numeric values, and they are - displayed as dates if a date format is applied to the cells that store - them. You have 3 options for entering dates: - - 1. Dates can be entered as text and then converted to a numeric - value with <C-d> or with the :datefmt command. - - a. With <C-d> keybinding: - The <C-d> command works on NORMAL and VISUAL modes, and converts - cell's text content that represents a date, and sets the numeric - value of the cell using using locale's D_FMT format. - After conversion, the same format is applied automatically to the - cell so that the value is displayed as a date. - You can then change the date format with :format command or - just leave it as it is with the current locale D_FMT format. - - Example: - \03/04/1984 - <C-d> - :format "d %b %Y" - will output 'Mar 1984' with my current locale. - - NOTES: + You can edit the date value by changing the text content - of the cell with 'E' command. - + To get current locale's D_FMT format, you might want to - issue ``locale -k d_fmt`` on your current shell. - - - b. With :datefmt command: - This command works like <C-d> but instead of using locale's D_FMT - format for conversion, it takes a strftime-compatible format string as - a parameter. Its syntax is ':datefmt "{strftime_format}"' - After conversion, the same format is applied automatically to the cell - so that the value is displayed as a date. - - Example: \12/03/2020 - :datefmt "%d/%m/%Y" - - NOTE: Take note here that if you edit the date with the 'E' command, - sc-im will nevertheless convert the date using locale's D_FMT format - and not the one you used with datefmt. - You will need to reapply :datefmt "%d/%m/%Y" or whatever format - you used earlier to reapply the format after the modification. - - 2. You can also enter dates using the @date and @dts functions. - Example: \"@date(@dts(2015, 23, 2), "%d/%m/%Y") - will show '23/02/2015'. - - 3. Another option is to enter the numeric value that represents the - datetime (that would be the number of seconds since the beginning of the - epoch - December 31, 1969, midnight, GMT) and apply a format with the - :format special command. - Example: =1424660400 - :format "d%d/%m/%Y" - - - Please see &Built-in Date and Time Functions& below for more details. - -============================================================================== -&NUMBER FORMATS& - - Numbers follow cell-specific format if set by the :format command. - Otherwise they default to column specific format, which can be set by the - scripting command FORMAT. The scripting FORMAT command has the syntax - FORMAT {COLUMN} {WIDTH} {PRECISION} {TYPE} - where TYPE is one of: - 0 Fixed-point - 1 Scientific format - 2 Engineering format - The default column format is (10 2 0), meaning width 10, precision 2, and - fixed-point. The column format width follows changes to the column width. - - Note: If the exponent is too large (>10^21) or too small (<10^-18), the - scientific format is used. - -============================================================================== -&Entering Greek and Math operator symbols& - - Greek letters and a large set of math symbols available in UTF-8 - can be entered and will display, provided your terminal supports them. - - The full list is given below. In each column, left of the equal sign is - the keyboard sequence to be entered, to obtain the character on the right - of the equal sign. - - Ctrl-K a * = α Ctrl-K b * = β Ctrl-K c * = ξ Ctrl-K d * = δ - Ctrl-K e * = ε Ctrl-K f * = φ Ctrl-K g * = γ Ctrl-K h * = θ - Ctrl-K i * = ι Ctrl-K j * = ϊ Ctrl-K k * = κ Ctrl-K l * = λ - Ctrl-K m * = μ Ctrl-K n * = ν Ctrl-K o * = ο Ctrl-K p * = π - Ctrl-K q * = ψ Ctrl-K r * = ρ Ctrl-K s * = σ Ctrl-K t * = τ - Ctrl-K u * = υ Ctrl-K v * = ϋ Ctrl-K w * = ω Ctrl-K x * = χ - Ctrl-K y * = η Ctrl-K z * = ζ - - Ctrl-K A * = Α Ctrl-K B * = Β Ctrl-K C * = Ξ Ctrl-K D * = Δ - Ctrl-K E * = Ε Ctrl-K F * = Φ Ctrl-K G * = Γ Ctrl-K H * = Θ - Ctrl-K I * = Ι Ctrl-K J * = Ϊ Ctrl-K K * = Κ Ctrl-K L * = Λ - Ctrl-K M * = Μ Ctrl-K N * = Ν Ctrl-K O * = Ο Ctrl-K P * = Π - Ctrl-K Q * = Ψ Ctrl-K R * = Ρ Ctrl-K S * = Σ Ctrl-K T * = Τ - Ctrl-K U * = Υ Ctrl-K V * = Ϋ Ctrl-K W * = Ω Ctrl-K X * = Χ - Ctrl-K Y * = Η Ctrl-K Z * = Ζ - - Ctrl-K * s = ς Ctrl-K R T = √ Ctrl-K F A = ∀ Ctrl-K T E = ∃ - Ctrl-K N B = ∇ Ctrl-K ( - = ∈ Ctrl-K - ) = ∋ Ctrl-K d P = ∂ - Ctrl-K I n = ∫ Ctrl-K I o = ∮ Ctrl-K D I = ∬ Ctrl-K * P = ∏ - Ctrl-K + Z = ∑ Ctrl-K + - = ± Ctrl-K - + = ∓ Ctrl-K 0 ( = ∝ - Ctrl-K 0 0 = ∞ Ctrl-K - L = ∟ Ctrl-K - V = ∠ Ctrl-K P P = ∥ - Ctrl-K A N = ∧ Ctrl-K O R = ∨ Ctrl-K ) U = ∪ Ctrl-K ( U = ∩ - Ctrl-K ) C = ⊃ Ctrl-K ( C = ⊂ Ctrl-K ) _ = ⊇ Ctrl-K ( _ = ⊆ - Ctrl-K . : = ∴ Ctrl-K : . = ∵ Ctrl-K ? - = ≃ Ctrl-K ! = = ≠ - Ctrl-K = 3 = ≡ Ctrl-K = < = ≤ Ctrl-K > = = ≥ Ctrl-K < * = ≪ - Ctrl-K > * = ≫ Ctrl-K ! < = ≮ Ctrl-K ! > = ≯ - - Note: It is possible to enter these characters also in the command mode, - but your OS may not support filenames containing them. - -============================================================================== -&Other configuration variables& - - 'autocalc' - Set it to recalculate values automatically, or to '0' to do it manually - upon execution of a '@' command. - - 'numeric' - Set it to '1' to make an initial digit start a numeric value. - Set it to '0', to make a digit act as a command multiplier. - - 'numeric_zero' [default off] - 'numeric_decimal' [default off] - When these are set, the zero digit or decimal point will correspondingly - initiate numeric entry, but only when 'numeric' is also set. - - 'newline_action' [default 0] - Set it to 'j' to move the cursor down after an entry. - Set it to 'l' to move right, or set it to '0' to take no action. - - 'external_functions' [default off] - Disabled by default, set this variable to enable external functions. See - @ext function below. - - 'exec_lua' [default on] - Enabled by default, set this variable to enable the execution of @lua - scripts. See @lua function below. - - 'overlap' [default off] - If cell content exceedes column width it gets cut off to fit the column - width. If overlap is set, the content overflows into the next column. - - 'input_bar_bottom' [default off] - Place the input bar at the bottom of the screen. - - 'input_edit_mode' [default off] - Always go from INSERT_MODE to EDIT_MODE when pressing ESC in the former. - - 'underline_grid' [default off] - Underline cells to make a nicer grid - - 'truncate' [default off] - If cell content exceedes column width it gets replaced by asterisks '*'. - If truncate is set, the content is cut off at the end of the cell. - - 'autowrap' [default off] - Auto wrap cell content and auto adjust row height to cover it. - Works only when overlap and truncate are set to off. - - 'debug' [default off] - set this to see debug messages in screen - - 'half_page_scroll' [default off] - set this to scroll by half a page instead of full page. - - 'xlsx_readformulas' [default off] - If 'xlsx_readformulas' is set, sc-im tries to import formulas, rather than - the final values of a cell. - - 'tm_gmtoff' [default -10800 seconds] - set gmtoffset used for converting datetimes to localtime. - - 'command_timeout' [default 3000 milli seconds] - the time sc-im waits for a valid command to be entered (the time it stays in '?') - - 'mapping_timeout' [default 1500 milli seconds] - this is used when some user input collides with the start of a mapping. - sc-im will wait 'mapping_timeout' for user to complete a mapping. If - passed that time no mapping was reached, that input would be passed to - the stdin buffer. - - 'ignorecase' [default off] - set this to ignore case in searches done with '/' command. - - 'autobackup' [default 0 (no autobackup)] - set this to a number in seconds 'n', to backup current file every 'n' - seconds. - AUTOBACKUP must be set during sc-im build for this feature to be - available. - If you set this to 0 but AUTOBACKUP was set during build, it still will - check for existence of backups before loading a file. - - 'show_cursor' [default off] - Make the screen cursor follow the active cell. Useful for people - using sc-im with a braille display. - - 'ignore_hidden' [default off] - set this if you want the hidden rows of a spreadsheet to be ignored when exporting them - to another format. - this will also be used in case you also want to copy/paste a range that have hidden rows in - it (for instance, the result of an applied filter). - -============================================================================== -&Built-in Range Functions& - - The following functions return the result of performing an operation on - all valid (nonblank) entries in the given {range}. The optional second - argument {expr} is an expression that is to be evaluated for each cell - in the specified range to determine which cells to include in the - function. Only those cells for which the expression evaluates to true - (non-zero) will be used in calculating the value of the function. - - - @sum({range}) - @sum({range},{expr}) - Sum up the values. - examples with optional {expr} argument: - @sum(D1:D20,D1>25) - @sum(D1:D20,E1>25) - @sum(D1:D20,@eqs(C1,"s")) - @sum(D1:D20,@eqs(@fixed(C1),"s")) - - @prod({range}) - @prod({range},{expr}) - Multiply the values together. - - @avg({range}) - @avg({range},{expr}) - Average the values. - - @count({range}) - @count({range},{expr}) - Count the values. - examples with optional {expr} argument: - @count(D1:D20,@eqs(D1,"enero")) - - @max({range}) - @max({range},{expr}) - Find the maximum value. - See also the multi-argument version of @max below. - - @min({range}) - @min({range},{expr}) - Find the minimum value. - See also the multi-argument version of @min below. - - @stddev({range}) - @stddev({range},{expr}) - Get the sample standard deviation of the values. - - @rows({range}) - @cols({range}) - Count the number of rows or columns. - -============================================================================== -&Built-in Numeric Functions& - - @exp({expr}) - Return e (Euler's number) raised to the {expr} power. - - @ln({expr}) - Return the natural logarithm of {expr}. - - @log({expr}) - Return the base-10 logarithm of {expr}. - - @floor({expr}) - Return the largest integer not greater than {expr}. - - @ceil({expr}) - Return the smallest integer not less than {expr}. - - @rnd({expr}) - Round {expr} to the nearest integer. Numbers halfway between integers - are rounded up. - - @round({expr},{n}) - Round {expr} to {n} decimal places. {n} may be positive to round off - the right side of the decimal point or negative to round off the left - side. See @rnd({expr}) above for rounding types. - - @ascii("{se}") - Interpret the string expression {se} as a base-256 number without - digit 0 and convert to a base-10 nonnegative number. - See also @chr. - - @frow({var}) - Return the row of the cell {var}. Ex. @frow(A4) returns 4 - - @fcol({var}) - Return the number of the col of the cell {var}. Ex. @fcol(D4) returns 3 - - @abs({expr}) - @fabs({expr}) - Return the absolute value of {expr}. - - @pow({expr1},{expr2}) - Return {expr1} raised to the power of {expr2}. - - @hypot({expr1},{expr2}) - Return @sqrt({expr1}*{expr1}+{expr2}*{expr2}), taking precautions - against overflows. - - @pi - Return a constant quite close to pi. - - @dtr({expr}) - Convert {expr} from degrees to radians. - - @rtd({expr}) - Convert {expr} from radians to degrees. - - @sin({expr}) - @cos({expr}) - @tan({expr}) - Evaluate the trigonometric functions on {expr}, in radians. The - magnitude of the arguments are not checked to assure meaningful - results. - - @asin({expr}) - Return the arc sine of {expr} in the range -pi/2 to pi/2. - - @acos({expr}) - Return the arc cosine of {expr} in the range 0 to pi. - - @atan({expr}) - Return the arc tangent of {expr} in the range -pi/2 to pi/2. - - @atan2({expr1},{expr2}) - Returns the arc tangent of e1/e2 in the range -pi to pi. - - @max({expr1},{expr2},...) - @min({expr1},{expr2},...) - Return the maximum or minimum of the values of the expressions. Two or - more expressions may be specified. - See also the range version of @max and @min above. - - @ston("{se}") - Convert string expression {se} to a numeric value. - - @nval("{se}",{expr}) - Return the numeric value of a cell selected by name. String expression - {se} must evaluate to a column name ("A" - "ZZ") and {expr} must - evaluate to a row number (0 - maxrows, by default 65536). - If {se} or {expr} is out of bounds, or the cell has no numeric - value, the result is 0. - You can use this for simple table lookups. See also @sval below. - =@nval("B", 0); would output the same as =B0 - - @eqs("{se1}","{se2}") - Return 1 if string expressions {se1} and {se2} have the same value, 0 - otherwise. - - @slen("{se}") - Returns the length of string expression {se}. - - @evaluate("{se}") - Evaluate a string expression as a numeric formula. Example of use: - If you have in cell D0 a formula as text, "@sum(A0:A11)", instead of a proper - numeric formula inserted with '=', you could make it get evaluated in another - cell (for this example E0) with =@evaluate(D0). Please note that this will not - added the dependency to the evaluation graph. That means that if you later - update the value of cell A0, it will not get updated in cell D0. - -============================================================================== -&String Expressions& - - String expressions are made up of string constants (characters surrounded - by double quotation marks), variables (cell names, which refer to the - cell's label strings or expressions), and string functions. - - Note: String expressions are only allowed when entering a cell's label - string, not its numeric part. They are entered with a backslash followed - by a double quote. - Examples: \"@coltoa(4) - \"A0 # "Plate" - - Note: String expression results may be left or right flushed or centered, - according to the type of the cell's string label. - - # Concatenate strings. - For example, if the value of A0's string is "the la", then the - string expression - - A0 # "zy dog" - - returns the string "the lazy dog". - -============================================================================== -&Built-in String Functions& - - String functions can be entered typing \" - - @substr("{se}",{expr1},{expr2}) - Extract from string expression {se} the substring indexed by character - number {expr1} through {expr2}. (Defaults to the length of {se} if - greater than the length.) If {expr1} is less than 1 or greater than - {expr2}, the result is the null string. For example, - - @substr ("River Plate", 4, 8) - - returns the string 'er Pl'. - - @upper("{se}") - @lower("{se}") - Convert the string expression {se} to uppercase or lowercase. - - @capital("{se}") - Convert the initial letter of words in {se} to upper case and other - letters to lower case. - - @replace("{se}","{eold}","{enew}") - Replace occurrences of {eold} in {se} with {enew}. - For example, having in A1 the string "Extension" and entering in A2 - the following: - @replace(A1,"n","Z") - will result "ExteZsioZ" in A2. - - @ext("{se}",{expr}) - Call an external program or script. This allows arbitrary functions - on values, e.g. table lookups and interpolations. String expression - {se} is a command or command line to call with popen(3). {expr} is - evaluated, converted to a string, and appended to the command line - as an argument. The result of @ex is a string: the first line printed - to standard output by the command. The command should emit exactly - one output line. Additional output, or output to standard error, - messes up th screen. @ext returns a null string and prints an - appropriate warning if external functions are disabled, {se} is null, - or the attempt to run the command fails. - - External functions can be slow to run, and if enabled are called at - each screen update, so they are disabled by default. Use the set - command to enable them when needed. - - Example: - @ext ("echo", a1) - - You can use @ston to convert the @ext result back to a number. - - Example: - @ston (@ext ("form.sc.ext", a9 + b9)) - - Note: You can build a command line (including more argument values) - from a string expression with concatenation. You can also "hide" the - second argument by ending the command line (first argument) with a "#" - shell comment. - - @coltoa({expr}) - Return a string name for a column from the numeric result of {expr}. - - Example: - @coltoa(@mycol-1) @nval(coltoa(@mycol-1), @myrow+1) - - @sval("{se}",{expr}) - Return the string value of a cell selected by column and row. String - expression {se} must evaluate to a column name (A - AE) and {expr} - must evaluate to a row number (0 - 199). If {se} or {e} is out of - bounds, or the cell has no string value, the result is the null - string. - - @set8bit("{se}") - Return the string "{se}" with 8th bit set. - - @chr({expr}) - Interpret {expr} as a base-10 nonnegative integer and convert to a - string (base-256 number without digit 0). - See also @ascii. - - @lua("{luascript}", {i}) - Executes a "luascript". Using Lua script, sc-im can be extend with lot - new functionality, such as complex programming, accessing databases - etc. - - Two global variables {r} and {c} are injected in the "luascript". The - variables denote the row and column of the calling cell respectively. - - The second parameter {i} is 0 or 1 indicating if the reference to this - cell should be added to the formula evaluation graph. Setting it to 0 - may be a good idea if you call sc.lquery to often in your scripts. - However, in the cases were its not added to the dependency graph, it - will nevertheless be executed when the cell that calls the script - executions is referenced by another cell. - - The return of value of the "luascript" is inserted in the calling - cell if it is a string. - - The search patch for LUA scripts files is $PWD/lua/ - $HOME/.sc-im/lua/ or /usr/local/share/sc-im/lua (in that order) - - To call a lua script use \" as with any other string function. - @lua("luascript", 1) - - @fmt("{se}", {e}) - Convert a number to a string. The argument se must be a valid - printf(3) format string. e is converted according to the standard - rules. For example, the expression - \"@fmt("**%6.3f**", 10.5) - yields the string ``**10.500**''. e is a double, so applicable - formats are e, E, f, g, and G. Try ``%g'' as a starting point. - More details on: - https://www.gnu.org/software/libc/manual/html_node/Floating_002dPoint-Conversions.html - - @sevaluate("{se}") - Evaluate a string expression as a string formula. Example of use: - If you have in cell D0 a string formula as text, "@substr(A0, 4, 6)", - instead of a proper string formula inserted with '\"', you could make it - get evaluated in another cell (for this example E0) with =@sevaluate(D0). - Please note that this will not added the dependency to the evaluation - graph. That means that if you later update the value of cell A0, it will - not get updated in cell D0. - -============================================================================== -&Built-in Date and Time Functions& - - The following functions operate on an expression {date_expr} denoting a - UNIX timestamp. - - @year({date_expr}) - Return the year. Valid years begin with 1970, although many systems - will return years prior to 1970 if e is negative. The last legal year - is system dependent. - - @month({date_expr}) - Return the month, encoded as 1 (January) to 12 (December). - - @day({date_expr}) - Return the day of the month, encoded as 1 to 31. - - @hour({date_expr}) - Return the number of hours since midnight, encoded as 0 to 23. - - @minute({date_expr}) - Return the number of minutes since the last full hour, encoded as 0 to - 59. - - @second({date_expr}) - Return the number of seconds since the last full minute, encoded as 0 - to 59. - - @now() - Return the current time encoded as the number of seconds since the - beginning of the epoch (December 31, 1969, midnight, GMT). - - @date({date_expr}, {sexpr}) - Convert the time {expr} in seconds to a date string, applying a format {sexpr}. - This functions is entered as a string formula with \". Example: - \"@date(@now, "%d/%m/%Y") - Note that you can extract parts of this fixed-format string with @substr(). - A format string compatible with the strftime() function may optionally be - given as a second argument to override the default format. - See the strftime(3) man page for details. - - @dts({expr1}, {expr2}, {expr3}) - Convert a date to the number of seconds from the epoch to the first - second of the specified date, local time. Dates may be specified - in either (m,d,y) or (y,m,d) format, although the latter is preferred, - since it's more universally recognized (m,d,y is only used in America). - If e2 > 12 or e3 > 31, then (m,d,y) is assumed. Otherwise, (y,m,d) - is assumed. - Example of use: - @date(@dts(1976, 12, 14)) yields 'Tue Dec 14 00:00:00 1976' - @date(@dts(2015, 23, 2), "%d/%m/%Y") yields '23/02/2015' - - The month should range from 1 to 12; the day should range from 1 to the - number of days in the specified month; and the year should - include the century (e.g. 1999 instead of 99). Any date capable of being - handled by the system is valid, typically 14 Dec 1901 to '18 Jan 2038' - on a system that uses a 32 bit time_t. Invalid dates or dates outside of - this range will return ERROR. For rapid entry of dates using only the - numeric keypad, sc provides the alternate syntax y.m.d or m.d.y, which is - automatically converted to the @dts(...) format above. - The year, month, and day must be entered numerically in the alternate - syntax; formulas are not allowed. - - @tts({expr1}, {expr2}, {expr3}) - @tts(8,20,45) converts the time 8:40:45 to the number of seconds since - midnight, the night before. The hour should range from 0 to 23; - the minutes and seconds should range from 0 to 59. - - -============================================================================== -&Other functions& - @myrow - references current row - - @mycol - references current column - - @if({expr}, {expr}, {expr}) - Conditional: If the first expression is true then the value of - the second is returned, otherwise the value of the third. - example of use: @if(@eqs(A1,"a"),B1,0) - example of use with string expression: @if(A1>100,"over","not enough") - Remember string expressions should be entered by typing \" - - @getent({e}, {e}) - Reference to a cell evaluating expressions. First expression in - formula corresponds to row number, the second expression to column - number. - Example of use: =@sum(A0:@getent(@lastrow-1,0)) - - -============================================================================== -&LUA Scripts and Triggers& - - sc-im was extended with LUA capabilities and also provided with helper - functions to manipulate sc-im data with Lua at runtime. Since it is a - fully functional Lua, you can also use all Lua packages for sc-im lua - scripts. Use luarocks to install additional packages. - - Function provided to lua script/triggers : - - sc.lgetnum (c, r) - get numeric value of cell c,r (c/r is number - column/row) returns value - sc.lsetnum (c, r, val) - set numeric value to a cell c,t - sc.lsetform (c, r, str) - set formula to a cell. Basically it does "let - cell= str" - sc.lsetstr(c, r, str) - set string to a cell - sc.lgetstr(c, r, str) - get string from a cell - sc.lquery(str) - query input from user, but first prints str. - Use with care!! - Dont use this function within triggers!! - returns string - sc.sc(str) - send str to sc-im parser - sc.a2colrow(str) - convert ascii cell representation to numeric - column/row returns column, row example: - c,r=sc.a2colrow("c5") - sc.colrow2a(c,r) - returns ascii representation of numeric - column/row - sc.maxcols() - return current maximum columns - sc.maxrows() - return current maximum rows - sc.curcol() - return current column - sc.currow() - return current row - - The search patch for LUA scripts files is $PWD/lua or - $HOME/.config/sc-im/lua/ or /usr/local/share/sc-im/lua (in that order) - Example can be found in sc-im/examples/lua in source code tree. - - -============================================================================== -&Supported file formats / File import& - - sc-im can open the following file formats: - .sc sc-im's native text format - .xls Microsoft Excel Spreadsheet - .xlsx Microsoft Office Open XML Workbook - .csv Comma-separated values - .tsv Tab-separated values - .tab Tab-separated values - .txt Simple text files - .mkd Markdown file with only table contents - .md Markdown file with only table contents - - You can pass files of any of the above formats to sc-im binary. - If you pass a .txt or .csv file to sc-im, it is imported using a comma as - the delimiter. - If you pass a .tsv or .tab file to sc-im, it is imported using the tab - character as the delimiter. - - Note: You can always override the delimiter used passing the --txtdelim - parameter to sc-im. - - Example: ./sc-im --txtdelim="\t" file.txt - - Possible values are: - --txtdelim="\t" - --txtdelim="," - --txtdelim=";" - --txtdelim="|" - -============================================================================== -&THEMES& - - There are a couple of themes you can use with sc-im. - They are "dracula", "old.sc", "papercolor-dark" and "prince.persia", and - they are located in the "/themes" folder. - You can add the corresponding lines of those to $HOME/.config/sc-im/scimrc - or you can load them at runtime with `:load path_to_theme_file` - -============================================================================== -&External scripts& - - sc-im can read data from a external script, either through a pipeline or - redirection. - This enables sc-im to be used as a non-interactive calculator. - - It can also be run interactively without the ncurses interface if you pass - the --nocurses flag. - - You can set the --output parameter to save the results to a file. - - You can set the --quiet parameter to avoid printing messages of all kinds - (info, error or debug). - - Export to csv, tab, markdown or plain text formats without interaction: - ./sc-im --quit_afterload --nocurses --export_csv - ./sc-im --quit_afterload --nocurses --export_tab - ./sc-im --quit_afterload --nocurses --export_mkd - ./sc-im --quit_afterload --nocurses --export_txt # (or just --export) - - If you set the --quit_afterload flag, sc-im will quit after loading all - files, but before becoming interactive. - - Suppose you have a file called "script" with the following content: - let A2=0 - let A3=A2+14 - recalc - getnum A3 - - The following invocations demonstrate sc-im's input and output options. - - Output to stdout, then quit: - cat script | ./sc-im --nocurses --quit_afterload - - Receive data from a pipe and output results to a file: - cat script | ./sc-im --quit_afterload --output=return_file - - Receive data from a pipe and continue in non-ncurses mode: - cat script | ./sc-im --nocurses - - Read data from a script and output to a file: - ./sc-im a.sc --quit_afterload --output=return_file - - Receive data from both a pipe and a script, and output to file: - cat script | ./sc-im a.sc --quit_afterload --output=return_file - - Export data and create pdf - echo 'export "mkd" "/dev/stdout"' | ./sc-im --nocurses --quiet --quit_afterload foo.csv | text2pdf -L > fighters.pdf - - Start interactive mode but with no ncurses interface: - ./sc-im --nocurses - - Note: Setting the --output parameter implies setting the --nocurses flag. - - sc-im script function names are case insensitive. - 'LET A0=1' is the same as 'let A0=1' - - Almost every interactive sc-im command is available for non-interactive - scripting. Search the equivalent interactive commands for usage - information. - - sc-im has these commands for available for external scripts. - - LET {[COL][ROW]}={expr} - Sets the contents of a cell with a value or an expression. E.g. - 'LET A1=A2*A2' - - LABEL {[COL][ROW]}={expr} - Sets the label of a cell with to a string value. - - EXECUTE "{STRING}" - Call an internal COMMAND MODE command. Examples: - EXECUTE "load /tmp/test.csv" - - EXPORT "{STRING}" "{STRING}" - Export spreadsheet. First parameter is type, second is path to file. - example of use: - echo 'export "mkd" "/dev/stdout"' | ./sc-im --nocurses --quiet --quit_afterload foo.csv | text2pdf -L > fighters.pdf - - RECALC - Recalculates a formulas in all cells - - GETNUM {[COL][ROW]} - Get numeric value from cell and print to STDOUT - - GETSTRING {[COL][ROW]} - Get text value from cell and print to STDOUT - - GETEXP {[COL][ROW]} - Get expression from cell and print to STDOUT - - GETFORMAT {COL} - Get format from cell and print to STDOUT - - GETFMT {[COL][ROW]} - Get format from cell and print to STDOUT - - QUIT - Quits sc-im. - - Other available commands for scripting are: - - DETAIL {var} - LEFTSTRING {var_or_range} - RIGHTSTRING {var_or_range} - LEFTJUSTIFY {var_or_range} - RIGHTJUSTIFY {var_or_range} - CENTER {var_or_range} - FORMAT {COL} {NUMBER} {NUMBER} {NUMBER} - FMT {var_or_range} {STRING} - DATEFMT {var_or_range} {STRING} - DATEFMT {STRING} - HIDE {COL} - HIDE {NUMBER} - SHOW {COL} - SHOW {NUMBER} - HIDECOL {COL} - SHOWCOL {COL} - HIDEROW {NUMBER} - SHOWROW {NUMBER} - SHOWCOL {COL} : {COL} - SHOWROW {NUMBER} : {NUMBER} - HIDECOL {COL} : {COL} - HIDEROW {NUMBER} : {NUMBER} - SHIFT {var_or_range} {STRING} - MARK {COL} {var_or_range} - MARK {COL} {var_or_range} {var_or_range} - FILL {var_or_range} {num} {num} - FILL {num} {num} - UNFREEZE - FREEZE {range} - FREEZE {NUMBER} : {NUMBER} - FREEZE {NUMBER} - FREEZE {COL} : {COL} - FREEZE {COL} - SORT {range} {STRING} - SUBTOTAL {range} {COL} {STRING} {COL} - RSUBTOTAL {range} {COL} {STRING} {COL} - FILTERON {range} - AUTOJUS {COL} : {COL} - AUTOJUS {COL} - GOTO {var_or_range} {var_or_range} - GOTO {var_or_range} - GOTO {num} - GOTO {STRING} - GOTO # {STRING} - GOTO % {STRING} - CCOPY {range} - CPASTE - LOCK {var_or_range} - UNLOCK {var_or_range} - NMAP {STRING} {STRING} - IMAP {STRING} {STRING} - EMAP {STRING} {STRING} - NNOREMAP {STRING} {STRING} - INOREMAP {STRING} {STRING} - ENOREMAP {STRING} {STRING} - NUNMAP {STRING} - IUNMAP {STRING} - EUNMAP {STRING} - COLOR {STRING} - CELLCOLOR {var_or_range} {STRING} - TRIGGER {var_or_range} {STRING} - UNTRIGGER {var_or_range} - CELLCOLOR {STRING} - UNFORMAT {var_or_range} - UNFORMAT - REDEFINE_COLOR {STRING} {NUMBER} {NUMBER} {NUMBER} - FCOPY - FCOPY {strarg} - FSUM - PAD {NUMBER} {COL} : {COL} - PAD {NUMBER} {COL} - PAD {NUMBER} {var_or_range} - PLOT {STRING} {var_or_range} - SET {setlist} - DEFINE {strarg} {range} - DEFINE {strarg} {var} - UNDEFINE {var_or_range} - EVAL{expr} - REBUILD_GRAPH - PRINT_GRAPH - SYNCREFS - UNDO - REDO - SEVAL{expr} - ERROR {STRING} - - The commands below can be used for calculations. - - @MONTH ({expr}) - @DAY ({expr}) - @YEAR ({expr}) - @NOW - @DTS ({expr},{expr},{expr}) - {NUMBER} . {NUMBER} . {NUMBER} - @TTS ({expr},{expr},{expr}) - @STON ({expr}) - @SLEN ({expr}) - @EQS ({expr},{expr}) - @DATE ({expr}) - @DATE ({expr},{expr}) - @FMT ({expr},{expr}) - @UPPER ({expr}) - @LOWER ({expr}) - @CAPITAL ({expr}) - @INDEX ( {range} ,{expr}) - @INDEX ({expr}, {range} ) - @INDEX ( {range} ,{expr},{expr}) - @LOOKUP ( {range} ,{expr}) - @LOOKUP ({expr}, {range} ) - @HLOOKUP ( {range} ,{expr},{expr}) - @HLOOKUP ({expr}, {range} ,{expr}) - @VLOOKUP ( {range} ,{expr},{expr}) - @VLOOKUP ({expr}, {range} ,{expr}) - @STINDEX ( {range} ,{expr}) - @STINDEX ({expr}, {range} ) - @STINDEX ( {range} ,{expr},{expr}) - @EXT ({expr},{expr}) - @LUA ({expr},{expr}) - @NVAL ({expr},{expr}) - @SVAL ({expr},{expr}) - @REPLACE ({expr},{expr},{expr}) - @SUBSTR ({expr},{expr},{expr}) - FNUMBER - @PI - @FILENAME ({expr}) - @MYROW - @MYCOL - @LASTROW - @LASTCOL - @COLTOA ({expr}) - @ASCII ({expr}) - @SET8BIT ({expr}) - @CHR ({expr}) - @ERR - ERR - @REF - REF - - The commands below set runtime configuration values: - - OVERLAP = {NUMBER} - OVERLAP - NOOVERLAP - AUTOBACKUP = {NUMBER} - NOAUTOBACKUP - AUTOCALC - AUTOCALC = {NUMBER} - NOAUTOCALC - DEBUG - DEBUG = {NUMBER} - NODEBUG - TRG - TRG = {NUMBER} - NOTRG - EXTERNAL_FUNCTIONS - EXTERNAL_FUNCTIONS = {NUMBER} - NOEXTERNAL_FUNCTIONS - EXEC_LUA - EXEC_LUA = {NUMBER} - NOEXEC_LUA - HALF_PAGE_SCROLL - HALF_PAGE_SCROLL = {NUMBER} - NOHALF_PAGE_SCROLL - QUIT_AFTERLOAD - QUIT_AFTERLOAD = {NUMBER} - NOQUIT_AFTERLOAD - XLSX_READFORMULAS - XLSX_READFORMULAS = {NUMBER} - NOXLSX_READFORMULAS - NOCURSES - NOCURSES = {NUMBER} - CURSES - NUMERIC - NUMERIC = {NUMBER} - NONUMERIC - IGNORECASE - IGNORECASE = {NUMBER} - NOIGNORECASE - NUMERIC_DECIMAL - NUMERIC_DECIMAL = {NUMBER} - NONUMERIC_DECIMAL - NUMERIC_ZERO - NUMERIC_ZERO = {NUMBER} - NONUMERIC_ZERO - NEWLINE_ACTION - NEWLINE_ACTION = {WORD} - DEFAULT_COPY_TO_CLIPBOARD_CMD = {strarg} - DEFAULT_PASTE_FROM_CLIPBOARD_CMD = {strarg} - COPY_TO_CLIPBOARD_DELIMITED_TAB - COPY_TO_CLIPBOARD_DELIMITED_TAB = {NUMBER} - NOCOPY_TO_CLIPBOARD_DELIMITED_TAB - COPY_TO_CLIPBOARD_WYSIWYG - COPY_TO_CLIPBOARD_WYSIWYG = {NUMBER} - NOCOPY_TO_CLIPBOARD_WYSIWYG - DEFAULT_OPEN_FILE_UNDER_CURSOR_CMD = {strarg} - NEWLINE_ACTION = {NUMBER} - TM_GMTOFF - TM_GMTOFF = {num} - MAPPING_TIMEOUT - MAPPING_TIMEOUT = {num} diff --git a/default/.local/share/thesiah/keys/zathura b/default/.local/share/thesiah/keys/zathura deleted file mode 100644 index 8fa1ec8..0000000 --- a/default/.local/share/thesiah/keys/zathura +++ /dev/null @@ -1,19 +0,0 @@ - _ _ - ______ _| |_| |__ _ _ _ __ __ _ -|_ / _` | __| '_ \| | | | '__/ _` | - / / (_| | |_| | | | |_| | | | (_| | -/___\__,_|\__|_| |_|\__,_|_| \__,_| - -zathura is the pdf/djvu reader. - h/j/k/l - Move left/down/up/right in document - d/u - Down/up a half page - gg - Top of document - G - Bottom of document - f - Highlight URLS to follow - J/K - Zoom out/in - s - Zoom to fit width - a - Zoom to fit height - r - Reload document if changed - R - Rotate document - D - Toggle dual-page mode - p - Print document |