• UA
• RU
• EN
• ⯈
  ES JA DE HI AR CN PT FR IT KO PL RO TR

The complete list of utilities included in the "YLC_Utilities.oxt" extension

1) Text

• Change the text to UPPER CASE Capitalize all words
• Change the text to lower case Writing all words in lowercase letters
• Start the text with a capital letter Writing the first word with a capital letter and the rest of the words with a small letter
• Start all words with a capital letter Change the text so that each word starts with a capital letter
• The first character is capitalized Change the first character in the text to a capital letter, but do not change the case of the remaining characters
• Other variants of registers Sentence Case, Heading Case, Pascal Case, Camel Case, Snake Case, Kebab Case and Space Case
• Delete all letters in the text Text cleaning by removing all letters in the text
• Delete all numbers in the text Text cleaning by removing all numbers in the text
• Remove trailing spaces in the text Remove all spaces from the beginning and end of the text
• Remove excess spaces in the text Remove all spaces at the beginning and end of the text, as well as excess spaces in the middle of the text
• Remove leading characters Delete a certain number of characters at the beginning of the text
• Remove trailing characters Deleting a certain number of characters at the end of the text
• Delete text after a certain number of characters Delete all text starting at a specific position
• Get the word by the specified separators Splitting the text into parts by many separators at the same time and obtaining the necessary element by entry number
• Mark Latin letters in the text Mark Latin letters in red
• Mark Cyrillic letters in the text Mark the Cyrillic letters in red
• Google Translate Translate the text using the "Google Translate" site

2) Number and Date

• Apply additional calculations to selected cells Quickly insert additional calculations into a formula
• Change the formulas to their calculated values Replace the formula in the selected cells with their calculated values
• Converting unrecognized numbers (text?) to numbers Changes numbers that LO Calc does not recognize and that are displayed as text to real numeric numbers
• Change value to text (adding ' in front) Changes all numbers in the selected cells to text values
• Fill the cells with their formatted value Replaces the contents of the selected cells with their formatted values
• Change negative numbers to positive and vice versa Changes positive numbers to negative and negative numbers to positive
• Move the minus sign from the end to the beginning (for example, 47- to -47) Fixes negative numbers that have a minus sign at the end
• Use a substantial number of commas Rounds or applies the appropriate format to numbers in cells to display non-zero digits after the decimal point/point
• Writing a number or sum in words Converts numbers or the sum written in numbers to text in English
• Date conversion/recognition Converts unrecognized dates in selected cells

3) Range

• Mark unique values Marking cells with unique values in yellow
• Mark different values Marking cells with different values in yellow
• Mark duplicates Designation of cells with repetitions in different colors
• Reconstruction of the table Expanding the table (unpivot) from crosswise to flat

4) Sheet

• Add sheets Insert new sheets into the workbook using the names from the selected cells
• Sort sheets Sort all sheets alphabetically (ascending or descending)
• Save sheets as books Save selected sheets to separate files

5) Comment

• Copy the value to the comment Copying the cell result into a comment
• Copy the formula into a comment Copying a cell formula into a comment
• Copy the comment to the cell Copying a comment into a cell formula

6) Formula

• Convert formula to text Save the cell formula as a text value
• Convert text into a formula Save the cell value as a formula
• Display "empty" if error Wrapping a cell formula in a IFERROR function with an alternative value of "empty"
• Display "0" if error Wrapping a cell formula in a IFERROR function with an alternative value of "0"
• Insert YLC function Insert function from set "YLC Utilities"

7) Styles for tables

• Change the style of the table Table formatting according to the selected color template (black, blue, red, green, purple, navy, orange)

8) External data

• Official exchange rates Obtaining exchange rates from official websites of national banks of countries