Changelog for extension "YLC Utilities"

4) Version 24.8 (August 2024)

Utilities:

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

Features:

Added new features that do the following:

• Transliterates the text from Russian into Latin: TRANSLITRU .
• Returns the value of gender (male/female): GETSEX .
• Returns any word in the text by the given set of separators: 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 into a dictionary (Python or PHP): TABLETODICT .
• Converts a table into an array of values in CSV format: TABLETOCSV .
• Converts a table of values to a SQL command INSERT INTO : TABLETOSQL .
• Converts the table into HTML format: TABLETOHTML .
• Converts a table to JSON format: TABLETOJSON .
• Converts a table to XML format: TABLETOXML .
• Calculates 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 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 (eg 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 a number or amount in writing/words" ).
  10. Convert/recognize dates... ( "Convert/Recognize Dates" ).
• A new menu has been added "External Data" ( "External data" ), which contains utilities for obtaining data from the Internet:
  1. Currency Exchange Rates... ( "Official exchange rates" ).

Features:

• New functions have been added to receive exchange rates from the official websites of national banks of the following countries:
  1. of the Central Bank of Russia (cbr.ru): NBRU .
  2. of the National Bank of Kazakhstan (nationalbank.kz): NBKZ .
  3. of the 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. of the National Bank of Georgia (nbg.gov.ge): NBGE .
  7. of the Central Bank of Turkmenistan (cbt.tm): NBTM .
  8. of the National Bank of Kyrgyzstan (nbkr.kg): NBKG .
  9. National Bank of Tajikistan (nbt.tj): NBTJ .
  10. of the 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 ( "Designation of unique values" ) in the menu "Range" .
• A new menu has been added Table Style ( "Table Style" ), which contains 7 ready-made styles for formatting tables.

Features:

• Added summation of values by cell color: SUMBYCELLCOLOR .
• Added calculation of the number of values by cell color: COUNTBYCELLCOLOR .
• Added summation of values by the color of the text in the cell: SUMBYFONTCOLOR .
• The calculation of the number of values by the color of the text in the cell has been added: COUNTBYFONTCOLOR .
• Added a function that gets the comment text from the specified cell: GETCOMMENT .

General changes:

• Added undo last action for utilities ("Undo") .
• Increased the number of colors for display of duplicates until the 16th

1) Version 24.5 (May 2024)

Utilities:

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

Features:

• Added 25 new functions .