Here is a UNO dispatch commands list (under construction) for Calc.
Topics
About: UNO (Universal Network Objects)
About: LibreOffice
About: Apache OpenOffice
The table of contents of this article
Starting Context
- The reader has knowledge on what UNO dispatch commands are.
Target Context
- The reader will know the URLs and the contents of UNO dispatch commands.
Orientation
There are some articles that explain how to execute any UNO dispatch commands and get the whole available information from the execution, in Java, in C++, in C#, in Python, and in LibreOffice or Apache OpenOffice Basic.
There is the list for the application foundations and the list for Writer of the UNO dispatch commands listed so far in this series.
Main Body
1: The UNO Dispatch Commands List
| URL | Description |
|---|---|
| .uno:ActiveCell | This command has been removed from LibreOffice. |
| .uno:ActiveTable | This command has been removed from LibreOffice. |
| .uno:AddPrintArea | This command adds the selected cells areas or the current cell (if no cell is selected) as printed areas or a printed area of the spread sheet. |
| .uno:Address | When the cells selection area is a rectangle, this command gets the address of the area as the related information of this command; otherwise, this command does nothing. |
| .uno:AdjustPrintZoom | This command adjusts the printing scale so that the selected cells ranges fit inside one page. |
| .uno:Calculate | When a formula cell is in the cell-contents-are-edited mode, this command shows the would-be-recalculated-cell-value as a hint without updating the cell value. Otherwise, this command recalculates all the formula cell values in the spread sheets document. |
| .uno:CalculateHard | This command recalculates all the formula cell values in the spread sheets document. |
| .uno:Cells | This command has been removed from LibreOffice. |
| .uno:CellText | This command has been removed from LibreOffice. |
| .uno:ChangeCaseRotateCase | This command changes the contents of the selected cells to the title case, the upper case, or the lower case, cyclically. This command is meant to be called only when when one or more cells are in the whole-cell-has-focus mode. This command does not judge the current cases of the selected cells, but just apply the next case the office instance remembers: it is not that as the contents of a cell is in the upper case now, the cell will become lower case. |
| .uno:ChangeCaseToFullWidth | This command changes the selected string, the string contents of the selected cells, the comment of the cell in the comment-is-edited mode, or the string contents of the shape object in the contents-are-edited mode to full-width. |
| .uno:ChangeCaseToHalfWidth | This command changes the selected string, the string contents of the selected cells, the comment of the cell in the comment-is-edited mode, or the string contents of the shape object in the contents-are-edited mode to half-width. |
| .uno:ChangeCaseToHiragana | This command changes the selected string, the string contents of the selected cells, the comment of the cell in the comment-is-edited mode, or the string contents of the shape object in the contents-are-edited mode to hiragana (only the katakana characters become hiragana characters). |
| .uno:ChangeCaseToKatakana | This command changes the selected string, the string contents of the selected cells, the comment of the cell in the comment-is-edited mode, or the string contents of the shape object in the contents-are-edited mode to katakana (only the hiragana characters become katakana characters). |
| .uno:ChangeCaseToLower | This command changes the selected string, the string contents of the selected cells, the comment of the cell in the comment-is-edited mode, or the string contents of the shape object in the contents-are-edited mode to lowercase. |
| .uno:ChangeCaseToSentenceCase | This command changes the first character and the other characters of each of the target lines to upper case and to lower case, respectively. The target lines are determined like this: when a cell is in the whole-cell-has-focus mode, all the lines in the cell are the target lines; when a cell is in the cell-contents-are-edited mode or a cell is in the comment-is-edited mode or a shape object is in the contents-are-edited mode, if a string part of the contents is selected, all the lines to which the string part belongs are the target lines, while if no string part is selected, if the text cursor is not in front of a space character or at the end of the line, the line to which the text cursor belongs is the target line, otherwise, no line is any target line. |
| .uno:ChangeCaseToTitleCase | This command changes the first character and the other characters of each of the target words (whether it is an article, a preposition, or a coordination conjunction or not) to upper case and to lower case, respectively. The target words are determined like this: when a cell is in the whole-cell-has-focus mode, all the words in the cell are the target words; when a cell is in the cell-contents-are-edited mode or a cell is in the comment-is-edited mode or a shape object is in the contents-are-edited mode, if a string part of the contents is selected, all the words to which the string part belongs are the target words, while if no string part is selected, if the text cursor is in front of or in a word, the word is the target word, otherwise, no word is any target word. |
| .uno:ChangeCaseToToggleCase | This command changes the case (the upper case or the lower case) of each of the target characters. The target characters are determined like this: when a cell is in the whole-cell-has-focus mode, all the characters in the cell are the target characters; when a cell is in the cell-contents-are-edited mode or a cell is in the comment-is-edited mode or a shape object is in the contents-are-edited mode, if a string part of the contents is selected, all the selected characters are the target characters, while if no string part is selected, if the text cursor is in front of or in a word, all the characters in the word is the target characters, otherwise, no character is any target character. |
| .uno:ChangeCaseToUpper | This command changes the selected string, the string contents of the selected cells, the comment of the cell in the comment-is-edited mode, or the string contents of the shape object in the contents-are-edited mode to uppercase. |
| .uno:ChangePrintArea | This command sets the printed areas, the repeatedly printed rows area, and the repeatedly printed columns area, of the spread sheet, at the specified areas. |
| .uno:CharFontName | This command sets the font family of the current cell, the selected word, or the selected characters. |
| .uno:ChineseConversion | This command shows the 'Chinese Conversion' dialog. |
| .uno:ClipboardFormatItems | This command works only when the Calc instance is in the cell-contents-are-edited mode. This command gets the formats assumed by the datum contained in the clipboard as the related information of this command, and optionally pastes the datum with the formats or not. |
| .uno:CompareDocuments | This command compares the current document with the specified document file and keeps recording the changes to the current document thereafter. If the current document has been being already tracked, the user will be asked whether he or she wants to end the existing tracking first and proceed with the processing, or wants to continue the existing tracking and cancel the processing. |
| .uno:Copy | This command works only when the Calc instance is in the cell-contents-are-edited mode. This command copies the selected part of the contents with the formats. |
| .uno:CursorEndOfScreen | This command vertically moves the current cell to the bottom row that is shown in the frame. |
| .uno:CursorTopOfScreen | This command vertically moves the current cell to the top row that is shown in the frame. |
| .uno:Cut | This command works only when the Calc instance is in the cell-contents-are-edited mode. This command cuts the selected part of the contents with the formats. |
| .uno:DataPilotTables | This command has been removed from LibreOffice. |
| .uno:DataSelect | This command shows the datum selection list for the current spread sheet cell. |
| .uno:DefinePrintArea | This command sets the printed areas of the spread sheet at the selected cells areas or the current cell (if no cell is selected). |
| .uno:Delete | There are 3 different behaviors according to the editing mode of the spread sheet. When it is in the whole-cell-has-focus mode, this command deletes the specified (by the cell types) cell contents and the specified cell properties (the comments and/or the formats) of the selected cells (focus can be on only a single cell, but some multiple cells can be selected anyway). When it is in the cell-contents-are-edited mode, this command deletes the selected contents. When it is in the non-cell-objects-are-selected mode, this command deletes the selected non-cell-objects. |
| .uno:DeletePrintArea | This command returns the printed areas of the spread sheet to the default (the minimal all-the-non-empty-cells-included rectangle). |
| .uno:DeleteScenario | This command removes the existing specified scenario in the document (the scenario does not have to be on the current sheet). |
| .uno:DeleteStyle | This command deletes the specified Calc style. |
| .uno:EditPrintArea | This command shows the 'Edit Print Ranges' dialog. |
| .uno:EditScenario | This command shows the scenario configuration dialog for the existing specified scenario in the document (the scenario does not have to be on the current sheet). |
| .uno:EditStyle | This command shows the dialog that edits the specified Calc style. |
| .uno:EnterString | This command inputs the specified string into the current cell and optionally commits the input. Inputting the string does not necessarily mean that the cell value becomes a text; for example, inputting a number string into a number-valued cell makes the cell value a number. This command replace the whole contents of the cell even if the current cell is in the cell-contents-are-edited mode. |
| .uno:ExecuteSearch | This command searches the current spread sheet or the spread sheets document for the specified string or with the specified regular expression or the specified glob expression or for the cells of the specified cell style. The search can be done for the next occurrence or for all the occurrences. Some criteria like case sensitivity, similarity degree, etc. can be specified. The found strings can be optionally replaced with the specified replacing string; the style of the found cells by cell style search can be optionally replaced with the specified replacing style. |
| .uno:ExternalEdit | This command opens the currently-selected image in the image editor that is associated (in the operating system) with the file extension of the image (the saved image in the image editor is reflected to the image on the spread sheet). |
| .uno:FocusCellAddress | This command sets the focus on the so-called "Name Box" (the box that shows the current cell address or the selected cells range expression (address or name), which is in the so-called "Formula Bar"). |
| .uno:FontHeight | This command sets the font size of the current cell, the selected word, or the selected characters. |
| .uno:FontNameList | This command gets the list of the font names as the related information of this command. |
| .uno:Formula | When the current cell is a formula cell, this command gets the formula of the current cell as the related information of this command; otherwise this command gets the standard string expression (not the formatted expression) of the value of the current cell as the related information of this command. |
| .uno:GetColorTable | This command is supposed to get the list of the colors as the result information, but does not do so. |
| .uno:GetRedoStrings | This command gets the list of some brief descriptions of the possible redo operations, as the related information. |
| .uno:GetUndoStrings | This command gets the list of some brief descriptions of the possible undo operations, as the related information. |
| .uno:GoDown | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell down by the specified number rows, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the down arrow key is pressed the specified rows number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoDownBlock | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell down by the specified number pages, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the 'Page Down' key is pressed the specified pages number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoDownBlockSel | This command changes the cells selection as though the 'Page Down' key is pressed the specified pages number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoDownSel | This command changes the cells selection as though the down arrow key is pressed the specified rows number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoDownToEndOfData | First, let us assume that no cell is selected or the current cell is the sole selected cell; otherwise, the behavior is unfathomable for the author. . . . Second, let us define (for this article) 'next destination cell' as this: if the current cell is empty or is the bottom cell of a consecutive non-empty cells in the column, the cell of the first non-empty cell down the current cell, or the bottom cell if there is no such a cell; otherwise, the bottom cell of the column's consecutive non-empty cells to which the current cell belongs. . . . Third, let us define (for this article) 'n-th next destination cell' as a cell that is reached after the current cell is move to the next destination cell n times. . . . There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell to the specified-number-of-times-th next destination cell, discarding the cell selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the down arrow key is pressed with the 'Shift' key pressed until the selection reaches the specified-number-of-times-th next destination cell, without moving the current cell. |
| .uno:GoDownToEndOfDataSel | First, let us assume that no cell is selected or the current cell is the sole selected cell; otherwise, the behavior is unfathomable for the author. . . . Second, let us define (for this article) 'next destination cell' as this: if the current cell is empty or is the bottom cell of a consecutive non-empty cells in the column, the cell of the first non-empty cell down the current cell, or the bottom cell if there is no such a cell; otherwise, the bottom cell of the column's consecutive non-empty cells to which the current cell belongs. . . . Third, let us define (for this article) 'n-th next destination cell' as a cell that is reached after the current cell is move to the next destination cell n times. . . . . . . This command changes the cells selection as though the down arrow key is pressed with the 'Shift' key pressed until the selection reaches the specified-number-of-times-th next destination cell, without moving the current cell. |
| .uno:GoLeft | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell left by the specified number columns, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the left arrow key is pressed the specified columns number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoLeftBlock | This command moves the current cell left by the specified number pages, discarding the cells selection. |
| .uno:GoLeftBlockSel | This command changes the cells selection as though the 'Page Up' key is pressed the specified pages number times with the 'Shift' and 'Alt' keys pressed, without moving the current cell. |
| .uno:GoLeftSel | This command changes the cells selection as though the left arrow key is pressed the specified columns number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoLeftToStartOfData | First, let us assume that no cell is selected or the current cell is the sole selected cell; otherwise, the behavior is unfathomable for the author. . . . Second, let us define (for this article) 'next destination cell' as this: if the current cell is empty or is the leftmost cell of a consecutive non-empty cells in the row, the cell of the first non-empty cell to the left of the current cell, or the leftmost cell if there is no such a cell; otherwise, the leftmost cell of the row's consecutive non-empty cells to which the current cell belongs. . . . Third, let us define (for this article) 'n-th next destination cell' as a cell that is reached after the current cell is move to the next destination cell n times. . . . There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell to the specified-number-of-times-th next destination cell, discarding the cell selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the left arrow key is pressed with the 'Shift' key pressed until the selection reaches the specified-number-of-times-th next destination cell, without moving the current cell. |
| .uno:GoLeftToStartOfDataSel | First, let us assume that no cell is selected or the current cell is the sole selected cell; otherwise, the behavior is unfathomable for the author. . . . Second, let us define (for this article) 'next destination cell' as this: if the current cell is empty or is the leftmost cell of a consecutive non-empty cells in the row, the cell of the first non-empty cell to the left of the current cell, or the leftmost cell if there is no such a cell; otherwise, the leftmost cell of the row's consecutive non-empty cells to which the current cell belongs. . . . Third, let us define (for this article) 'n-th next destination cell' as a cell that is reached after the current cell is move to the next destination cell n times. . . . This command changes the cells selection as though the left arrow key is pressed with the 'Shift' key pressed until the selection reaches the specified-number-of-times-th next destination cell, without moving the current cell. |
| .uno:GoRight | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell right by the specified number columns, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the right arrow key is pressed the specified columns number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoRightBlock | This command moves the current cell right by the specified number pages, discarding the cells selection. |
| .uno:GoRightBlockSel | This command changes the cells selection as though the 'Page Down' key is pressed the specified pages number times with the 'Shift' and 'Alt' keys pressed, without moving the current cell. |
| .uno:GoRightSel | This command changes the cells selection as though the right arrow key is pressed the specified columns number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoRightToEndOfData | First, let us assume that no cell is selected or the current cell is the sole selected cell; otherwise, the behavior is unfathomable for the author. . . . Second, let us define (for this article) 'next destination cell' as this: if the current cell is empty or is the rightmost cell of a consecutive non-empty cells in the row, the cell of the first non-empty cell to the right of the current cell, or the rightmost cell if there is no such a cell; otherwise, the rightmost cell of the row's consecutive non-empty cells to which the current cell belongs. . . . Third, let us define (for this article) 'n-th next destination cell' as a cell that is reached after the current cell is move to the next destination cell n times. . . . There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell to the specified-number-of-times-th next destination cell, discarding the cell selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the right arrow key is pressed with the 'Shift' key pressed until the selection reaches the specified-number-of-times-th next destination cell, without moving the current cell. |
| .uno:GoRightToEndOfDataSel | First, let us assume that no cell is selected or the current cell is the sole selected cell; otherwise, the behavior is unfathomable for the author. . . . Second, let us define (for this article) 'next destination cell' as this: if the current cell is empty or is the rightmost cell of a consecutive non-empty cells in the row, the cell of the first non-empty cell to the right of the current cell, or the rightmost cell if there is no such a cell; otherwise, the rightmost cell of the row's consecutive non-empty cells to which the current cell belongs. . . . Third, let us define (for this article) 'n-th next destination cell' as a cell that is reached after the current cell is move to the next destination cell n times. . . . This command changes the cells selection as though the right arrow key is pressed with the 'Shift' key pressed until the selection reaches the specified-number-of-times-th next destination cell, without moving the current cell. |
| .uno:GoToCell | This command moves the current spread sheet cell (the cell that is current, but not necessarily has the GUI focus) and the GUI focus to the specified spread sheet cell. The existing 'cells selection' will be discarded. |
| .uno:GoToCurrentCell | This command moves the GUI focus to the current spread sheet cell (the cell that is current, but not necessarily has the GUI focus). The existing 'cells selection' will be preserved. |
| .uno:GoToEndOfData | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell to the bottom rightmost cell of the smallest cells rectangle that contains all the data of the sheet, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the {down or up} and/or {right or left} arrow key are repeatedly pressed with the 'Shift' key pressed until the cells selection includes the bottom rightmost cell of the smallest cells rectangle that contains all the data of the sheet, without moving the current cell. |
| .uno:GoToEndOfDataSel | This command changes the cells selection as though the {down or up} and/or {right or left} arrow key are repeatedly pressed with the 'Shift' key pressed until the cells selection includes the bottom rightmost cell of the smallest cells rectangle that contains all the data of the sheet, without moving the current cell. |
| .uno:GoToEndOfRow | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell to the rightmost data-containing-column cell of the current row, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though first, the cells outside of the rows between (including) the firstly-selected cell row and the current row are deselected and then, the left or right arrow key is repeatedly pressed with the 'Shift' key pressed until the cells selection includes the rightmost data-containing-column cell of the current row (except that if the rightmost data-containing-column cell of the current row is a non-selected current cell, the cells selection is not changed), without moving the current cell. |
| .uno:GoToEndOfRowSel | This command changes the cells selection as though first, the cells outside of the rows between (including) the firstly-selected cell row and the current row are deselected and then, the left or right arrow key is repeatedly pressed with the 'Shift' key pressed until the cells selection includes the rightmost data-containing-column cell of the current row (except that if the rightmost data-containing-column cell of the current row is a non-selected current cell, the cells selection is not changed), without moving the current cell. |
| .uno:GoToObject | This command moves the GUI focus to the specified object of certain kinds (an image object, a media object, a chart object, a formula object, an OLE object, a shape object, or a form control (only in the design mode)) in the document. |
| .uno:GoToStart | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell to the top leftmost cell, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the up and/or left arrow key are repeatedly pressed with the 'Shift' key pressed until the cells selection includes the top leftmost cell (except that if the top leftmost cell is a non-selected current cell, the cells selection is not changed), without moving the current cell. |
| .uno:GoToStartOfRow | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell to the leftmost cell of the current row, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though first, the cells outside of the rows between (including) the firstly-selected cell row and the current row are deselected and then, the left arrow key is repeatedly pressed with the 'Shift' key pressed until the cells selection includes the leftmost cell of the current row (except that if the leftmost cell is a non-selected current cell, the cells selection is not changed), without moving the current cell. |
| .uno:GoToStartOfRowSel | This command changes the cells selection as though first, the cells outside of the rows between (including) the firstly-selected cell row and the current row are deselected and then, the left arrow key is repeatedly pressed with the 'Shift' key pressed until the cells selection includes the leftmost cell of the current row (except that if the leftmost cell is a non-selected current cell, the cells selection is not changed), without moving the current cell. |
| .uno:GoToStartSel | This command changes the cells selection as though the up and/or left arrow key are repeatedly pressed with the 'Shift' key pressed until the cells selection includes the top leftmost cell, without moving the current cell. |
| .uno:GoUp | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell up by the specified number rows, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the up arrow key is pressed the specified rows number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoUpBlock | There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell up by the specified number pages, discarding the cells selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the 'Page Up' key is pressed the specified pages number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoUpBlockSel | This command changes the cells selection as though the 'Page Up' key is pressed the specified pages number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoUpSel | This command changes the cells selection as though the up arrow key is pressed the specified rows number times with the 'Shift' key pressed, without moving the current cell. |
| .uno:GoUpToStartOfData | First, let us assume that no cell is selected or the current cell is the sole selected cell; otherwise, the behavior is unfathomable for the author. . . . Second, let us define (for this article) 'next destination cell' as this: if the current cell is empty or is the top cell of a consecutive non-empty cells in the column, the cell of the first non-empty cell up the current cell, or the top cell if there is no such a cell; otherwise, the top cell of the column's consecutive non-empty cells to which the current cell belongs. . . . Third, let us define (for this article) 'n-th next destination cell' as a cell that is reached after the current cell is move to the next destination cell n times. . . . There are two modes, the moving-the-current-cell mode and the changing-the-cells-selection mode. In the moving-the-current-cell mode, this command moves the current cell to the specified-number-of-times-th next destination cell, discarding the cell selection. In the changing-the-cells-selection mode, this command changes the cells selection as though the up arrow key is pressed with the 'Shift' key pressed until the selection reaches the specified-number-of-times-th next destination cell, without moving the current cell. |
| .uno:GoUpToStartOfDataSel | First, let us assume that no cell is selected or the current cell is the sole selected cell; otherwise, the behavior is unfathomable for the author. . . . Second, let us define (for this article) 'next destination cell' as this: if the current cell is empty or is the top cell of a consecutive non-empty cells in the column, the cell of the first non-empty cell up the current cell, or the top cell if there is no such a cell; otherwise, the top cell of the column's consecutive non-empty cells to which the current cell belongs. . . . Third, let us define (for this article) 'n-th next destination cell' as a cell that is reached after the current cell is move to the next destination cell n times. . . . This command changes the cells selection as though the up arrow key is pressed with the 'Shift' key pressed until the selection reaches the specified-number-of-times-th next destination cell, without moving the current cell. |
| .uno:GotoDocument | This command selects the specified document as the current document. |
| .uno:Grow | When only a single cell is selected, this command increases the font size of the current cell by 2 points; when a cell is in the cell-contents-are-edited mode, this command increases the font size of the selected characters (when a part of the cell is selected) or the word that is just behind the text cursor or includes the text cursor (when no part of the cell is selected) by 1 level of the size combo box in the characters properties setting dialog. |
| .uno:HangulHanjaConversion | This command works only when 'Tools' -> 'Options' -> 'Language Settings' -> 'Languages' -> 'Default Languages for Documents' -> 'Asian' is set at 'Korean (RoK)'. This command shows the 'Hangul/Hanja Conversion' dialog. |
| .uno:Hide | This command hides the current spread sheet. |
| .uno:InsertMode | This command cyclically changes the cell-contents-are-edited mode between the inserting mode and the overwriting mode. |
| .uno:Italic | The characters processed by this command are all the characters of the selected cells or the selected non-cell objects in the whole-cell-has-focus mode or in the non-cell-objects-are-selected mode or the selected characters; this command makes the non-italic characters italic or the italic characters non-italic, where the characters are deemed to be italic only when all the characters are italic. |
| .uno:JumpToMark | If a cells range is specified, this command selects the specified cells range and moves the current cell to the top-leftmost cell of the range; if a cell is specified, this command moves the current cell to the specified cell with the cells selection intact. |
| .uno:JumpToNextTable | This command moves the current spread sheet to the next (in the spread sheets order in the spread sheets document) spread sheet. |
| .uno:JumpToPrevTable | This command moves the current spread sheet to the previous (in the spread sheets order in the spread sheets document) spread sheet. |
| .uno:JumpToPreviousCell | This command moves the current cell, but not the GUI focus, to the previous cell (the cell to that 'Shift + Enter' would move the current cell (the current 'cells selection' dictates which is the previous cell)). The existing 'cells selection' will be preserved. |
| .uno:JumpToTable | This command moves the current spread sheet to the specified spread sheet. |
| .uno:LanguageStatus | This command sets the Western language, reset the languages (Western, Asian, and complex text layout) to the default values, or show the languages configuration dialog, for the current document. |
| .uno:MergeDocuments | This command merges the specified document file, which is supposed to a derivative of the current document and has recorded the changes from the current document, into the current document and keeps recording the changes to the current document thereafter. |
| .uno:Name | This command renames the specified table (one of the items that are listed under the 'Sheets' tree in the 'Navigator' window, which is shown by checking the 'Navigator' item of the 'View' menu item) in the document. |
| .uno:NewStyle | This command shows the dialog that creates a Calc style. |
| .uno:NoteText | This command gets the comment of the current cell as the related information of this command. |
| .uno:Notebookbar | This command sets the current notebook bar ('notebook bar' is an experimental new tool bar) configuration file name and redraws the notebook bar according to the configuration file. The experimental feature is enabled by selecting the 'Tools' -> 'Options...' menu item; selecting 'LibreOffice' -> 'Advanced' in the left pane in the 'Options' dialog; checking the 'Enable experimental features (may be unstable)' checkbox; selecting the 'View' -> 'Toolbar Layout' -> 'Notebookbar' menu item. |
| .uno:OpenHyperlinkOnCursor | This command opens the hyper link target of the current cursor position. |
| .uno:Overline | This command toggles on-off the current overline status, which is about what is currently the target of the status. If a single cell is selected or the current cell without any cell selection in the whole-cell-has-focus mode, the cell is the target, but if some multiple cells are selected, the whole of the selected cells is the target (the current status is 'off' unless all the selected cells are in the 'on' status); if some characters in a cell or an object are selected, the whole of the characters is the target (the current status is 'off' unless all the selected characters are in the 'on' status); if the text cursor is in a word without any selection, the word is the target. |
| .uno:PageStyle | This command gets some primary information on the page style of the current spread sheet of the spread sheets document, as the related information of this command. |
| .uno:ParaStyle | This command gets the cell style of the selected cells (if the cells have the same style) as the related information and shows the 'Styles' sidebar. |
| .uno:Paste | This command works only when the Calc instance is in the cell-contents-are-edited mode. This command pastes the already-has-been-copied datum into the current spread sheet with the datum's format. |
| .uno:PasteOnlyFormula | If the already-has-been-copied datum is a formula cell datum, this command will paste the formula into the current spread sheet without the datum's format; if the already-has-been-copied datum is a non-formula cell datum, this command will erase the datum of the current cell; if the already-has-been-copied datum is a non-cell datum (for example, a plain string, even if it is a string like '= A1 + A2'), this command will paste nothing. |
| .uno:PasteOnlyText | If the already-has-been-copied datum is a text cell datum (including when it is a formula cell), this command will paste the cell value (not the formula) into the current spread sheet with the datum's format; if the already-has-been-copied datum is a non-text (for example, number) cell datum, this command will erase the datum of the current cell; if the already-has-been-copied datum is a non-cell datum (for example, a plain string), this command will paste nothing. |
| .uno:PasteOnlyValue | If the already-has-been-copied datum is a number or boolean cell datum, this command will paste the cell datum into the current spread sheet without the datum's format; if the already-has-been-copied datum is a non-number, non-boolean cell datum, this command will erase the datum of the current cell; if the already-has-been-copied datum is a non-cell datum (for example, a plain string, even if it is a string like '1'), this command will paste nothing. |
| .uno:PasteSpecial | This command pastes the already-has-been-copied datum into the current spread sheet in the specified format. |
| .uno:PasteUnformatted | This command pastes the already-has-been-copied datum into the current spread sheet without the datum's format (the pasted datum will assume the format of the pasted-to-context). |
| .uno:Position | This command does nothing. |
| .uno:Protect | This command shows the dialog window for protecting the current sheet or the dialog window for unprotecting the current sheet. |
| .uno:Range | This command has been removed from LibreOffice. |
| .uno:Redo | This command redoes the specified-number latest undone modifications. |
| .uno:Repeat | This command performs the latest cell modification, to the selected cells, when the spread sheet is in the whole-cell-has-focus mode. |
| .uno:RepeatSearch | This command repeats the previous find-for-next-occurrence search. |
| .uno:Replace | This command executes the search for the specified string or with the specified regular expression or the specified glob expression and replace the next occurrence with the specified string, or executes the search for the specified cell style and replace the next occurrence with the specified cell style, on the preset search condition. The resulting current cell will be the will-be-searched-next-time cell (if the before-execution current cell is the searched-this-time cell) or the searched-this-time cell (if the before-execution current cell is not the searched-this-time cell). |
| .uno:ReplaceAll | This command executes the search for the specified string or with the specified regular expression or the specified glob expression and replace all the occurrences with the specified string, or executes the search for the specified cell style and replace all the occurrences with the specified cell style, on the preset search condition. |
| .uno:ResetPrintZoom | This command resets the printing scale to 100%. |
| .uno:Save | This command stores the current document to the original file URL, possibly as a version. |
| .uno:SaveAs | This command stores the document to the specified file URL. |
| .uno:ScenarioManager | This command creates a scenario (which is created with all the options ("Display border", "Copy back", "Copy entire sheet", and "Prevent changes") off) or show the scenario creation dialog, for the selected cells range (which has to consist of multiple cells) if the selected cells range is not on any scenario sheet (which is a sheet created by creating a scenario with the "copy entire sheet" option on), or extends the scenario of the scenario sheet of the selected cells range if the selected cells range (which has to consist of multiple cells) is on a scenario sheet. |
| .uno:Search | This command executes the search for the specified string or with the specified regular expression or the specified glob expression or for the specified cell style, on the preset search condition. The search is done for the next occurrence. |
| .uno:SearchAll | This command executes the search for the specified string or with the specified regular expression or the specified glob expression or for the specified cell style, on the preset search condition. The search is done for all the occurrence. |
| .uno:SearchOptions | This command gets the sum of the allowed search option ('search', 'search all', 'replace', 'replace all', 'regular expression search', 'backward search', etc.) flags for the document, as the related information of this command. |
| .uno:SearchProperties | This command gets the currently-set properties ('search direction', etc.) of the search functionality, as the related information of this command. |
| .uno:SelectAll | When the Calc instance is not in the cell-contents-are-edited mode, this command selects the whole of the current sheet; when the Calc instance is in the cell-contents-are-edited mode, this command selects the whole of the cell contents. |
| .uno:SelectData | This command selects the current cell. The existing 'cells selection' will be discarded. |
| .uno:SelectScenario | This command activates the existing specified scenario on the current sheet. |
| .uno:Selection | This command has been removed from LibreOffice. |
| .uno:SetHyperlink | This command sets the specified hyperlink to something that is determined by the current selection. When a string is selected, the string is the something; when the text cursor is in a text area (like inside a cell) without any string selected, the new string inserted before the text cursor is the something; when a graphic object like a shape is selected, the graphic object is the something. |
| .uno:SetInputMode | This command set the current cell in the 'cell contents editing mode' (the mode in which a text cursor is shown inside the cell and any inputted character is inserted before the text cursor). |
| .uno:Show | This command shows the specified spread sheet. |
| .uno:Shrink | When only a single cell is selected, this command decreases the font size of the current cell by 2 points, with the limit of the 2 points size; when a cell is in the cell-contents-are-edited mode, this command decreases the font size of the selected characters (when a part of the cell is selected) or the word that is just behind the text cursor or includes the text cursor (when no part of the cell is selected) by 1 level of the size combo box in the characters properties setting dialog until the 6 points size and by an unknown-to-author rule thereafter, with the limit of the 2 points size. |
| .uno:Spacing | In the cell-contents-are-edited mode, this command gets the spacing of the current text cursor position or characters selection as the related information of this command. |
| .uno:StateTableCell | This command gets the average and the sum of the currently selected non-string cells as the related information of this command. Any date cell is treated as a number in which '1899-12-30' is '0', '1899-12-31' is '1', and so on; any date and time cell is treated as a number in which '1899-12-30T00:00:00' is '0.0', '1899-12-31T00:00:00' is '1.0', and so on; any time cell is treated as a number in which '00:00:00' is '0.0' and '24:00:00' is '1.0'; any boolean cell is a number in which 'TRUE' is '1.0' and 'FALSE' is '0.0'; any string cell is ignored. The average and the sum in the related information are shown in the format of the current cell unless the current cell is a string cell (as an exception, if the current cell is a 'FALSE' cell and the all the other selected cells (the current cell may be selected or not be selected) are string cells, they are shown as numbers); if the current cell is a string cell, they are shown as numbers. |
| .uno:StatusDocPos | This command shows a 'Navigator' window. |
| .uno:StatusFunction | This command gets the average and the sum of the currently selected non-string cells as the related information of this command. Any date cell is treated as a number in which '1899-12-30' is '0', '1899-12-31' is '1', and so on; any date and time cell is treated as a number in which '1899-12-30T00:00:00' is '0.0', '1899-12-31T00:00:00' is '1.0', and so on; any time cell is treated as a number in which '00:00:00' is '0.0' and '24:00:00' is '1.0'; any boolean cell is a number in which 'TRUE' is '1.0' and 'FALSE' is '0.0'; any string cell is ignored. The average and the sum in the related information are shown in the format of the current cell unless the current cell is a string cell (as an exception, if the current cell is a 'FALSE' cell and the all the other selected cells (the current cell may be selected or not be selected) are string cells, they are shown as numbers); if the current cell is a string cell, they are shown as numbers. |
| .uno:StatusSelectionMode | This command cyclically changes the spread sheet cells selection mode (the mode that dictates how the mouse click or the key stroke changes the spread sheet cells selection) to one of tree modes (the mode that an squared area will be selected according to the mouse click or the arrow, 'Page Up', or 'Page Down' key stroke, the mode that new cells will be selected or deselected according to the mouse click (and the mouse drag), with the other cells intact, and the mode that new cells will be selected with the previous selection canceled). |
| .uno:StatusSelectionModeExp | This command cyclically changes the spread sheet cells selection mode (the mode that dictates how the mouse click or the key stroke changes the spread sheet cells selection) to one of two modes (the mode that new cells will be selected or deselected according to the mouse click (and the mouse drag), with the other cells intact and the mode that new cells will be selected with the previous selection canceled). |
| .uno:StatusSelectionModeExt | This command cyclically changes the spread sheet cells selection mode (the mode that dictates how the mouse click or the key stroke changes the spread sheet cells selection) to one of two modes (the mode that an squared area will be selected according to the mouse click or the arrow, 'Page Up', or 'Page Down' key stroke and the mode that new cells will be selected with the previous selection canceled). |
| .uno:StatusSelectionModeNorm | This command changes the spread sheet cells selection mode (the mode that dictates how the mouse click or the key stroke changes the spread sheet cells selection) to the mode that new cells will be selected with the previous selection canceled. |
| .uno:Strikeout | This command toggles on-off the current strikeout status, which is about what is currently the target of the status. If a single cell is selected or the current cell without any cell selection in the whole-cell-has-focus mode, the cell is the target, but if some multiple cells are selected, the whole of the selected cells is the target (the current status is 'off' unless all the selected cells are in the 'on' status); if some characters in a cell or an object are selected, the whole of the characters is the target (the current status is 'off' unless all the selected characters are in the 'on' status); if the text cursor is in a word without any selection, the word is the target. |
| .uno:StyleNewByExample | This command creates a new style as a copy of the current style (the style that has been applied to the current spread sheet). If there is already a style of the specified name, the existing style is first removed. |
| .uno:StyleWatercanMode | This command shows the 'Styles' side bar. |
| .uno:SubScript | This command toggles on-off the current subscript status, which is about what is currently the target of the status. If some characters in a cell or an object are selected, the whole of the characters is the target (the current status is 'off' unless all the selected characters are in the 'on' status); if the text cursor is in a word without any selection, the word is the target; any whole cell or cells cannot be any target. |
| .uno:SuperScript | This command toggles on-off the current superscript status, which is about what is currently the target of the status. If some characters in a cell or an object are selected, the whole of the characters is the target (the current status is 'off' unless all the selected characters are in the 'on' status); if the text cursor is in a word without any selection, the word is the target; any whole cell or cells cannot be any target. |
| .uno:TableCount | This command gets the number of the spread sheets in the current spread sheets document as the related information of this command. |
| .uno:Tables | This command has been removed from LibreOffice. |
| .uno:TextValue | This command gets the formatted expression of the value of the current cell as the related information of this command. |
| .uno:Underline | This command toggles on-off the current underline status, which is about what is currently the target of the status. If a single cell is selected or the current cell without any cell selection in the whole-cell-has-focus mode, the cell is the target, but if some multiple cells are selected, the whole of the selected cells is the target (the current status is 'off' unless all the selected cells are in the 'on' status); if some characters in a cell or an object are selected, the whole of the characters is the target (the current status is 'off' unless all the selected characters are in the 'on' status); if the text cursor is in a word without any selection, the word is the target. |
| .uno:UnderlineDotted | This command toggles on-off the current dotted-underline status, which is about what is currently the target of the status. If a single cell is selected or the current cell without any cell selection in the whole-cell-has-focus mode, the cell is the target, but if some multiple cells are selected, the whole of the selected cells is the target (the current status is 'off' unless all the selected cells are in the 'on' status); if some characters in a cell or an object are selected, the whole of the characters is the target (the current status is 'off' unless all the selected characters are in the 'on' status); if the text cursor is in a word without any selection, the word is the target. |
| .uno:UnderlineDouble | This command toggles on-off the current double-underline status, which is about what is currently the target of the status. If a single cell is selected or the current cell without any cell selection in the whole-cell-has-focus mode, the cell is the target, but if some multiple cells are selected, the whole of the selected cells is the target (the current status is 'off' unless all the selected cells are in the 'on' status); if some characters in a cell or an object are selected, the whole of the characters is the target (the current status is 'off' unless all the selected characters are in the 'on' status); if the text cursor is in a word without any selection, the word is the target. |
| .uno:UnderlineNone | This command turns off the current underline status, which is about what is currently the target of the status. If a single cell is selected or the current cell without any cell selection in the whole-cell-has-focus mode, the cell is the target, but if some multiple cells are selected, the whole of the selected cells is the target; if some characters in a cell or an object are selected, the whole of the characters is the target; if the text cursor is in a word without any selection, the word is the target. |
| .uno:UnderlineSingle | This command toggles on-off the current single-underline status, which is about what is currently the target of the status. If a single cell is selected or the current cell without any cell selection in the whole-cell-has-focus mode, the cell is the target, but if some multiple cells are selected, the whole of the selected cells is the target (the current status is 'off' unless all the selected cells are in the 'on' status); if some characters in a cell or an object are selected, the whole of the characters is the target (the current status is 'off' unless all the selected characters are in the 'on' status); if the text cursor is in a word without any selection, the word is the target. |
| .uno:Undo | This command undoes the specified-number latest modifications. |
| .uno:Visible | This command shows or hides the current spread sheet. |
<The previous article in this series | The table of contents of this series | The next article in this series>
