List of changes for the "YLC Utilities" extension

8) Version 25.8 (August 2025)

Utilities:

• Added a new utility to the "File" menu:
  • Reopen current file.
• A separate "Python" menu was created, to which new tools for working with Python libraries were added:
  • Open standard PY libraries.
  • Open imported PY packages.
  • Install PIP package.
  • Install PY package.

Functions:

• Added new functions to get currency rates from the official websites of the national banks of the following countries:
  • Bank of Israel (boi.org.il): NBIL.
  • Reserve Bank of Australia (rba.gov.au): NBAU.
  • Norges Bank (norges-bank.no): NBNO.
  • Bank of Canada (bankofcanada.ca): NBCA.
• Added new functions to get historical prices from the "Yahoo Finance" (finance.yahoo.com) website:
  • Cryptocurrencies: CRYPTO.
  • Stocks: STOCK.

7) Version 25.5 (May 2025)

Utilities:

• Added new utilities to the "Text" menu:
  • Remove other characters:
    • Remove all except letters (a-z).
    • Remove all except digits (0-9).
    • Remove all except word chars (abc123_).
    • Remove all except sentence chars (abc 123_.,!?).
• Added a new utility to the "Date" menu:
  • Remove time component.
• Added new utilities to the "Range" menu:
  • Make drop-down list....
  • Make dependent DD list....
  • Insert checkboxes in selection.
  • Delete checkboxes in selection.
  • Make font color as background.
  • Convert conditional format to direct.
• Added new utilities to the "Comment" menu:
  • Show/Hide authorship.
  • Image to comment....
• Added new utilities to the "Sheet" menu:
  • Make list of worksheets.
  • Rename worksheets....
  • Change tab colors.
• Added new utilities to the "Table Style" menu:
  1. Excel - added 60 new styles, similar to the table styles in MS Excel:
  • Light - 21 light styles;
  • Medium - 28 moderate styles;
  • Dark - 11 dark styles.
  2. YLC - added 3 new styles:
  • Consolas;
  • Dotted Blue;
  • Ocean White.
• Added a new utility to the "External Data" menu:
  • Insert table from image....
• Added a new utility to the "Interface" menu:
  • Crosshair highlighting. Highlighting columns and rows when selecting cells.
• Added a new "File" menu, which contains tools for working with files and folders:
  1. Open current file folder.
  2. Open python scripts folder.
  3. Create new folders from selection....
  4. Insert a list of existing files....

6) Version 25.1 (January 2025)

Programs:

• "YLC Utilities" has been adapted for use in the Linux version of LibreOffice Calc.

Utilities:

• Added a new "Interface" menu, which contains tools for quick setup of the LibreOffice Calc environment:
  1. Address style (R1C1).
  2. Hide Grid Lines.
  3. Input Direction (Right).
  4. Dark Mode.
• Added Show/Hide Indicators to the "Comment" menu.

5) Version 24.11 (November 2024)

Programs:

• Created a version of "YLC Utilities" for Microsoft Excel.

Utilities:

• Added Mark odd values to the "Range" menu.
• Added Show/Hide formulas to the "Formula" menu.
• Added Move comment to cell to the "Comment" menu.
• Added Show/Hide comments to the "Comment" menu.

4) Version 24.8 (August 2024)

Utilities:

• Added Get word by delimiters... to the "Text" menu.

Functions:

Added new functions that perform the following:

• Transliterates text from Russian to Latin: TRANSLITRU.
• Returns the value of the gender (male/female): GETSEX.
• Returns any word in the text based on 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 to an array of values (one-dimensional or two-dimensional): TABLETOARRAY.
• Converts a table to a dictionary (Python or PHP): TABLETODICT.
• Converts a table to an array of values in CSV format: TABLETOCSV.
• Converts a table with values to an SQL INSERT INTO command: TABLETOSQL.
• Converts a table to 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, taking into account weekends and holidays: WORKHOURS.
• Returns the country code in the selected format: ISOCOUNTRY.

3) Version 24.7 (July 2024)

Utilities:

• Added a new "Number & Date" menu, which contains utilities for working with numbers and dates:
  1. Add extra calculation to selected cells....
  2. Change formulas to their calculated values....
  3. Convert unrecognized numbers (text?) to numbers.
  4. Change values to text values (adding ' in front).
  5. Fill cells with their formatted value.
  6. Change negative numbers to positive and vice versa....
  7. Move minus sign from back to front (e.g. 47- to -47).
  8. Use a significant number of decimals....
  9. Spell/write out numbers or amounts....
  10. Convert/recognize dates....
• Added a new "External Data" menu, which contains utilities for getting data from the internet:
  1. Currency Exchange Rates....

Functions:

• Added new functions to get currency rates from the official websites of the 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. 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.
• The COUNTBYCELLCOLOR function has been improved and can now count empty colored cells.

2) Version 24.6 (June 2024)

Utilities:

• Added Google Translate... to the "Text" menu.
• Added Mark unique values to the "Range" menu.
• Added a new menu Table Style, which contains 7 ready-made styles for table formatting.
• Improved Mark duplicate values. The number of colors has been increased to 16.

Functions:

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

General changes:

• Added "Undo" functionality for utilities.

1) Version 24.5 (May 2024)

Programs:

• Created the "YLC Utilities" extension for LibreOffice Calc.

Utilities:

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

Functions:

• Added 25 new functions.