Extension "YLC Utilities" for Excel and LibreOffice Calc
YLC Utilities Description
YLC Utilities - is a set of additional custom functions and utilities for Microsoft Excel and LibreOffice Calc as an extension (add-in).
This extension allows you to very quickly and easily get many new useful formulas, as well as a large set of utilities in a convenient menu, which will simplify your daily life when working with spreadsheets.
The use of additional functions is no different from standard functions Excel or Calc. All new functions will be displayed in the formulas menu, and will also be available in all files - new and old.
List of utilities
A complete list of utilities available in the extension YLC Utilities you can view on the tab: "Utilities"
List of functions
A complete list of new functions in the extension YLC Utilities you can view on the tab: "Functions"
Menu
Download
Below you can download the extension files YLC Light, YLC Functions or YLC Utilities, which automatically add new functions to your spreadsheet program:
To install the extension, there are two ways - quick (1) and standard (2):
1) After downloading the file *.oxt to your computer, it is enough to double-click on it and restart LibreOffice Calc.
2) Open the menu Tools - Extensions... and in the window that appears, click the button Add. After that, select your downloaded file *.oxt and restart LibreOffice Calc.
Excel:
After downloading the file *.xlam to your computer, copy it to the folder C:\Users\{YourUser}\AppData\Roaming\Microsoft\AddIns and in the Excel menu File - Options - Add-ins - Manage 'Excel Add-ins' click the button Go.... In the window that appears, check the box next to your file name and click OK.
Testing
This extension was tested in the following environment:
Operating system: Windows 10, Linux Mint (MacOS is not supported)
Version LibreOffice Calc: v7.6-26.2
Version Collabora Office Calc: v25.0 (only Collabora Office Classic)
Version Microsoft Excel: v2021-2024
Change history
A list of changes in the extension YLC Utilities you can view on the tab "Change history".
Feedback
If you have any questions, suggestions or problems with the extension, you can always write an email 24/7: feedback.youlibrecalc@gmail.com