List of changes for the "YLC Utilities" extension

12) Version 26.3 (March 2026)

Functions:

• Added new functions to retrieve data from the "Yahoo Finance" website (finance.yahoo.com):
  • Retrieving historical data for the period: YFINANCE.
  • Treasury bonds: BONDS.
  • Options: OPTIONS.
  • Futures: FUTURES.
  • Exchange-traded funds: ETF.
  • Mutual funds: FUNDS.
  • Stock prices traded on the Frankfurt Stock Exchange "DAX": DAX.
• Added new functions for working with artificial intelligence:
  • Modification of VLOOKUP for fuzzy data merging: AILOOKUP.
• Added other functions:
  • Retrieving text fragments highlighted in bold: GETBOLD.

11) Version 26.1 (January 2026)

Utilities:

• Added a new menu "Power Query" ("Powerful Query"), which contains tools for data processing:
  1. Make PQ worksheet ("Create Power Query worksheet").
  2. Duplicate column ("Create a duplicate of the column").
  3. Transform data... ("Transform data...").
  4. Remove outer function ("Remove outer function").
• Added a new menu "Export" ("Export"), which contains tools for data export:
  1. Export range as CSV data... ("Export data range in CSV format...").
  2. Export range as XML data... ("Export data range in XML format...").
  3. Export range as JSON data... ("Export data range in JSON format...").
  4. Export range as SQL data... ("Export data range in SQL format...").
  5. Export range as HTML data... ("Export data range in HTML format...").
  6. Create Pandas dataframe... ("Create Pandas dataframe...").
  7. Create Jupyter notebook... ("Create Jupyter notebook...").
  8. Create Openpyxl template... ("Create Openpyxl template...").
  9. Create Xlwings template... ("Create Xlwings template...").
• Added new utilities in the "Date" ("Date") menu:
  • Auto date conversion ("Automatic date conversion").
  • Quick date recognition ("Quick date recognition").
  • Mark weekends... ("Mark weekends...").
  • Quick date formatting ("Quick date formatting").
  • Fill dates ("Fill dates").
• Added new utilities in the "Text" ("Text") menu:
  • Add extra characters to existing text ("Add characters to existing text").
  • Remove words from text... ("Remove words from text...").
  • Convert similar letters ("Convert similar letters"):
    • Cyrillic into Latin ("Cyrillic into Latin").
    • Latin into Cyrillic ("Latin into Cyrillic").
    • Accented into plain (e.g., ã > a, é > e) ("Accented into plain (e.g., ã > a, é > e)").
  • Fill alphabet ("Fill selected cells with letters from the alphabet").
  • Reverse text ("Reverse text").
  • Show/Hide non-printable chars ("Show/Hide non-printable characters").
  • Show Unicode for each char in text ("Show Unicode for each character in text").
  • Replace private data ("Replace private data").
• Added new utilities in the "Number" ("Number") menu:
  • Hide numeric values ("Hide numeric values").
• Added a new utility in the "Python" ("Python") menu:
  • Run python script ("Run Python script").

10) Version 25.10 (October 2025)

Utilities:

• Added new utilities in the "Comment" ("Comment") menu:
  • Copy image to object ("Copy image to object").
  • Save image to folder... ("Save image to folder...").
  • Generate QR code... ("Generate QR code...").
  • Generate Barcode... ("Generate barcode...").

Functions:

• Added new functions for adding images to the worksheet:
  • Add any image by link: IMAGE.
  • Generate QR code for text: QRCODE.
  • Generate barcode for text: BARCODE.

9) Version 25.9 (September 2025)

Functions:

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

8) Version 25.8 (August 2025)

Utilities:

• Added a new utility in the "File" ("File") menu:
  • Reopen current file ("Reopen current file").
• Created a separate "Python" ("Python") menu, which includes new tools for working with Python libraries:
  • Open standard PY libraries ("Open folder with standard Python libraries").
  • Open imported PY packages ("Open folder with imported Python packages").
  • Install PIP package ("Install 'PIP' package").
  • Install PY package ("Install Python package").

Functions:

• Added new functions to retrieve 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.
  • Norges Bank (norges-bank.no): NBNO.
  • Bank of Canada (bankofcanada.ca): NBCA.
• Added new functions to retrieve historical prices from the "Yahoo Finance" website (finance.yahoo.com):
  • Cryptocurrencies: CRYPTO.
  • Stocks: STOCK.

7) Version 25.5 (May 2025)

Utilities:

• Added new utilities in the "Text" ("Text") menu:
  • 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 characters (abc123_)").
    • Remove all except sentence chars (abc 123_.,!?) ("Remove all except sentence characters (abc 123_.,!?)").
• Added a new utility in the "Date" ("Date") menu:
  • Remove time component ("Remove time component").
• Added new utilities in the "Range" ("Range") menu:
  • 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 regular").
• Added new utilities in the "Comment" ("Comment") menu:
  • Show/Hide authorship ("Show/hide authorship").
  • Image to comment... ("Insert image into comment").
• Added new utilities in the "Sheet" ("Sheet") menu:
  • Make list of worksheets ("Make list of worksheets").
  • Rename worksheets... ("Rename worksheets").
  • Change tab colors ("Change tab colors").
• Added new utilities in the "Table Style" ("Table Style") menu:
  1. Excel ("Table styles like in Excel") - added 60 new styles, similar to table styles in MS Excel:
  • Light - 21 light styles;
  • Medium - 28 medium styles;
  • Dark - 11 dark styles.
  2. YLC ("YLC Table styles") - added 3 new styles:
  • Consolas;
  • Dotted Blue;
  • Ocean White.
• Added a new utility in the "External Data" ("External Data") menu:
  • Insert table from image... ("Insert table from image").
• Added a new utility in the "Interface" ("Interface") menu:
  • Crosshair highlighting ("Crosshair highlighting"). Highlighting columns and rows when selecting cells.
• Added a new menu "File" ("File"), 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)

Programs:

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

Utilities:

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

5) Version 24.11 (November 2024)

Programs:

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

Utilities:

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

4) Version 24.8 (August 2024)

Utilities:

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

Functions:

Added new functions that perform the following:

• Transliterates text from Russian into Latin: TRANSLITRU.
• Returns gender value (male/female): GETSEX.
• Returns any word in 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 table to array of values (1D or 2D): TABLETOARRAY.
• Converts table to dictionary (Python or PHP): TABLETODICT.
• Converts table to array in CSV format: TABLETOCSV.
• Converts table with values into SQL command INSERT INTO: TABLETOSQL.
• Converts table to HTML format: TABLETOHTML.
• Converts table to JSON format: TABLETOJSON.
• Converts table to XML format: TABLETOXML.
• Calculates the number of work hours in a given date range considering weekends and holidays: WORKHOURS.
• Returns country code in selected format: ISOCOUNTRY.

3) Version 24.7 (July 2024)

Utilities:

• Added a new menu "Number & Date" ("Number & 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 values to text values (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 front (e.g. 47- to -47)").
  8. Use a significant number of decimals... ("Use a significant number of decimals").
  9. Spell/write out numbers or amounts... ("Write out number or amount in words").
  10. Convert/recognize dates... ("Convert/recognize dates").
• Added a new menu "External Data" ("External Data"), which contains utilities for retrieving data from the internet:
  1. Currency Exchange Rates... ("Official currency exchange rates").

Functions:

• Added new functions to retrieve 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. European Central Bank (ecb.eu): NBEU.
  13. National Bank of Romania (bnro.ro): NBRO.
  14. Central Bank of Brazil (bcb.gov.br): NBBR.
• Improved the COUNTBYCELLCOLOR function, which can now count empty colored cells.

2) Version 24.6 (June 2024)

Utilities:

• Added Google Translate... ("Google Translate...") in the "Text" menu.
• Added Mark unique values ("Marking unique values") in the "Range" menu.
• Added a new menu Table Style ("Table Style"), which contains 7 ready-made styles for formatting tables.
• Improved Mark duplicate values ("Marking duplicates"). Increased the number of colors 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 comment text from a specified cell: GETCOMMENT.

General changes:

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

1) Version 24.5 (May 2024)

Programs:

• Created "YLC Utilities" extension for LibreOffice Calc.

Utilities:

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

Functions:

• Added 25 new functions.