List of changes for the "YLC Utilities" extension

5) Version 24.11 (November 2024)

Programs:

• Created version "YLC Utilities" for Microsoft Excel.

Utilities:

• Added Mark odd values ( "Mark outliers" ) in the menu "Range" .
• Added Show/Hide formulas ( "Show/Hide Formulas" ) in the menu "Formula" .
• Added Move comment to cell ( "Move comment to cell" ) in the menu "Comment" .
• Added Show/Hide comments ( "Show/hide comments" ) in the menu "Comment" .

4) Version 24.8 (August 2024)

Utilities:

• Added Get word by delimiters... ( "Get the word by the specified separators" ) in the menu "Text" .

Functions:

New functions have been added that do the following:

• Transliterates text from Russian into Latin: TRANSLITRU .
• Returns the gender value (male/female): GETSEX .
• Returns any word in the text according to a given set of delimiters: GETWORD .
• Gets the name of the current workbook: WORKBOOK .
• Gets the name of the current worksheet: SHEETNAME .
• Converts a table into an array of values (one-dimensional or two-dimensional): TABLETOARRAY .
• Converts a table to a dictionary (Python or PHP): TABLETODICT .
• Converts a table into an array of values in CSV format: TABLETOCSV .
• Converts a table with values to SQL command INSERT INTO : TABLETOSQL .
• Converts a table to HTML format: TABLETOHTML .
• Converts a table to JSON format: TABLETOJSON .
• Converts a table to XML format: TABLETOXML .
• Counts the number of working hours in a given date range, including weekends and holidays: WORKHOURS .
• Returns the country code in the selected format: ISOCOUNTRY .

3) Version 24.7 (July 2024)

Utilities:

• A new menu has been added "Number & Date" ( "Number and Date" ), which contains utilities for working with numbers and dates:
  1. Add extra calculation to selected cells... ( "Apply additional calculations to selected cells" ).
  2. Change formulas to their calculated values... ( "Change formulas to their calculated values" ).
  3. Convert unrecognized numbers (text?) to numbers ( "Convert unrecognized numbers (numbers-as-text) to numbers" ).
  4. Change values to text values (adding ' in front) ( "Change the value to text (by adding an apostrophe in front)" ).
  5. Fill cells with their formatted value ( "Fill cells with their formatted value" ).
  6. Change negative numbers to positive and vice versa... ( "Change negative numbers to positive numbers and vice versa" ).
  7. Move minus sign from back to front (e.g. 47- to -47) ( "Move the minus sign from the end to the beginning (e.g. 47- to -47)" ).
  8. Use a significant number of decimals... ( "Use a significant number of decimal places" ).
  9. Spell/write out numbers or amounts... ( "Write the number or amount in words/phrases" ).
  10. Convert/recognize dates... ( "Convert/Recognize Dates" ).
• New menu added "External Data" ( "External data" ), which contains utilities for retrieving data from the Internet:
  1. Currency Exchange Rates... ( "Official currency exchange rates" ).

Functions:

• New functions have been added to obtain currency rates from the official websites of national banks of the following countries:
  1. Central Bank of Russia (cbr.ru): NBRU .
  2. National Bank of Kazakhstan (nationalbank.kz): NBKZ .
  3. Central Bank of Uzbekistan (cbu.uz): NBUZ .
  4. of the Central Bank of Azerbaijan (cbar.az): NBAZ .
  5. National Bank of Moldova (bnm.md): NBMD .
  6. National Bank of Georgia (nbg.gov.ge): NBGE .
  7. Central Bank of Turkmenistan (cbt.tm): NBTM .
  8. National Bank of Kyrgyzstan (nbkr.kg): NBKG .
  9. National Bank of Tajikistan (nbt.tj): NBTJ .
  10. Central Bank of Armenia (cba.am): NBAM .
  11. Bank of Lithuania (lb.lt): NBLT .
  12. Central Bank of the European Union (ecb.eu): NBEU .
  13. National Bank of Romania (bnro.ro): NBRO .
  14. Central Bank of Brazil (bcb.gov.br): NBBR .
• Improved function COUNTBYCELLCOLOR , which can now count empty colored cells.

2) Version 24.6 (June 2024)

Utilities:

• Added Google Translate... ( "Google Translate..." ) in the menu "Text" .
• Added Mark unique values ( "Unique value designation" ) in the menu "Range" .
• New menu added Table Style ( "Table Style" ), which contains 7 ready-made styles for formatting tables.
• Improved Mark duplicate values ( "Marking duplicates" ). The number of colors has been increased to 16.

Functions:

• Added summing of values by cell color: SUMBYCELLCOLOR .
• Added counting of values by cell color: COUNTBYCELLCOLOR .
• Added summing of values by text color in a cell: SUMBYFONTCOLOR .
• Added counting of the number of values by text color in a cell: COUNTBYFONTCOLOR .
• Added a function that gets the comment text from the specified cell: GETCOMMENT .

General changes:

• Added undo of last action for utilities ("Undo") .

1) Version 24.5 (May 2024)

Programs:

• The extension "YLC Utilities" has been created for LibreOffice Calc.

Utilities:

• Added 35 utilities for working with text, cell ranges, sheets, comments, and formulas.

Functions:

• Added 25 new features .