List of changes for the extension "YLC Utilities"

9) Version 25.9 (September 2025)

Functions:

• New functions added, for obtaining data from the website "Yahoo Finance" (finance.yahoo.com):
  • International currency exchange rates: FOREX.
  • Dividends: DIVIDEND.
  • Company information: PROFILE.
  • Stock prices traded on the Paris Stock Exchange "CAC 40": CAC_40.
  • Stock prices traded on the London Stock Exchange "FTSE 100": FTSE100.
  • Stock prices traded on the Tokyo Stock Exchange "NIKKEI 225": NIKKEI225.
  • Exchange prices for commodities (gold, oil, natural gas, etc.): COMMODITY.
• New functions added for working with artificial intelligence:
  • Obtaining information from a large language model: AI.
  • Filling a column with generated data: AIFILL.
  • Obtaining information from text: AIEXTRACT.
  • Text translation: AITRANSLATE.
  • Table generation with data: AITABLE.

8) Version 25.8 (August 2025)

Utilities:

• New utility added to the menu "File" ("File"):
  • Reopen current file ("Reopen current file").
• A separate menu "Python" ("Python") created, to which new tools for working with Python libraries have been added:
  • Open standard PY libraries ("Open folder with standard libraries for Python").
  • Open imported PY packages ("Open folder with imported packages for Python").
  • Install PIP package ("Install 'PIP' package").
  • Install PY package ("Install Python package").

Functions:

• New functions added, for obtaining exchange 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.
  • Central Bank of Norway (norges-bank.no): NBNO.
  • Central Bank of Canada (bankofcanada.ca): NBCA.
• New functions added, for obtaining historical prices from the website "Yahoo Finance" (finance.yahoo.com):
  • Cryptocurrencies: CRYPTO.
  • Stocks: STOCK.

7) Version 25.5 (May 2025)

Utilities:

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

6) Version 25.1 (January 2025)

Applications:

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

Utilities:

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

5) Version 24.11 (November 2024)

Applications:

• A version "YLC Utilities" created for Microsoft Excel.

Utilities:

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

4) Version 24.8 (August 2024)

Utilities:

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

Functions:

New functions added that perform the following:

• Transliterates text from Russian into Latin: TRANSLITRU.
• Returns gender value (male/female): GETSEX.
• Returns any word in the text by 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 into a dictionary (Python or PHP): TABLETODICT.
• Converts a table into an array of values in CSV format: TABLETOCSV.
• Converts a table with values into an SQL command INSERT INTO: TABLETOSQL.
• Converts a table into HTML format: TABLETOHTML.
• Converts a table into JSON format: TABLETOJSON.
• Converts a table into 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:

• New menu "Number & Date" ("Number & Date") added, 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 values to text (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 minus sign from end to 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 out numbers or amounts in words/spelling").
  10. Convert/recognize dates... ("Convert/recognize dates").
• New menu "External Data" ("External Data") added, which contains utilities for obtaining data from the internet:
  1. Currency Exchange Rates... ("Official currency exchange rates").

Functions:

• New functions added, for obtaining exchange 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 function COUNTBYCELLCOLOR improved, which can now count empty colored cells.

2) Version 24.6 (June 2024)

Utilities:

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

Functions:

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

General changes:

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

1) Version 24.5 (May 2024)

Applications:

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

Utilities:

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

Functions:

• Added 25 new functions.