Change History for the "YLC Utilities" Extension

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, same as in MS Excel:
     • Light - 21 light styles;
     • Medium - 28 medium 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. Highlights rows and columns when selecting cells.
• Added a new "File" menu 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" adapted for use in the Linux version of LibreOffice Calc.

Utilities:

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

5) Version 24.11 (November 2024)

Programs:

• Version created for Microsoft Excel.

Utilities:

• Added Mark odd values
• Added Show/Hide formulas
• Added Move comment to cell
• Added Show/Hide comments

4) Version 24.8 (August 2024)

Utilities:

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

Functions:

Added new functions that perform the following:

• Transliterates text from Russian into Latin: TRANSLITRU.
• Returns sex 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 within 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 new menu "Number & Date", 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 new menu "External Data", which contains utilities for getting data from the Internet:
  1. Currency Exchange Rates...

Functions:

• Added new functions to get currency 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.
• Improved function COUNTBYCELLCOLOR, which can now count empty colored cells.

2) Version 24.6 (June 2024)

Utilities:

• Added Google Translate... to the menu "Text".
• Added Mark unique values
• Added new menu Table Style, which contains 7 ready-made styles for table formatting.
• Improved Mark duplicate values

Functions:

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

General changes:

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

1) Version 24.5 (May 2024)

Programs:

• Extension created for LibreOffice Calc.

Utilities:

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

Functions:

• Added 25 new functions.