Welcome to YouLibreCalc Channel. If you want to learn LibreOffice Calc then our channel is the right place for you. You can find many free video tutorials to simplify your everyday life.
If the video was useful for you you can always support our channel to spread more knowledge:
Hi! i was able to use the bare formula and it returns very different names, but when I try to use the 0.5 parameter it returns Err:504 im using theYouLibreCalc.oxt
Hi! FuzzyLookup() in YouLibreCalc.oxt does't have the 3rd parameter unlike the macro version from the site: moonexcel.com.ua/fuzzy-lookup-function-libreoffice-calc_en
If the video was helpful for you - please let us know in the comments! More tips by the link: moonexcel.com.ua/main-libreoffice-calc_en A free extension "YouLibreCalc.oxt" with additional functions for LibreOffice Calc: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en A professional extension "YLC_Utilities.oxt" with many additional functions and useful utilities for LibreOffice Calc: moonexcel.com.ua/ylc-utilities-extension-libreoffice-calc_en
If the video was helpful for you - please let us know in the comments! More tips by the link: moonexcel.com.ua/main-libreoffice-calc_en A free extension "YouLibreCalc.oxt" with additional functions for LibreOffice Calc: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en A professional extension "YLC_Utilities.oxt" with many additional functions and useful utilities for LibreOffice Calc: moonexcel.com.ua/ylc-utilities-extension-libreoffice-calc_en
If the video was helpful for you - please let us know in the comments! More tips by the link: moonexcel.com.ua/main-libreoffice-calc_en A free extension "YouLibreCalc.oxt" with additional functions for LibreOffice Calc: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en A professional extension "YLC_Utilities.oxt" with many additional functions and useful utilities for LibreOffice Calc: moonexcel.com.ua/ylc-utilities-extension-libreoffice-calc_en
If the video was helpful for you - please let us know in the comments! More tips by the link: moonexcel.com.ua/main-libreoffice-calc_en A free extension "YouLibreCalc.oxt" with additional functions for LibreOffice Calc: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en A professional extension "YLC_Utilities.oxt" with many additional functions and useful utilities for LibreOffice Calc: moonexcel.com.ua/ylc-utilities-extension-libreoffice-calc_en
Hello sir, when I tried your given macro from the description box, my desktop is showing a message which states "a scripting framework error occurred while running the basic script standard.Module1.SpellNum_YoulibreCalc. Message: wrong number of parameters at /usr/src/debug/libreoffice-fresh/libreoffice-24.2.3.2/scripting/source/ basprov/basscript.cxx:204". Please tell me where I was wrong.
Looks like the key words are "wrong number of parameters"... Try to use the function with different number of parameters. If it does not help, you can also use SPELLNUMBER() function from "YouLibreCalc" extension: moonexcel.com.ua/spellnumber-function-youlibrecalc_en
If the video was helpful for you - please let me know in comments below! Link to the function: moonexcel.com.ua/concatif-function-youlibrecalc_en A free extension "YouLibreCalc.oxt" with additional functions for LibreOffice Calc: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en A professional extension "YLC_Utilities.oxt" with many additional functions and useful utilities for LibreOffice Calc: moonexcel.com.ua/ylc-utilities-extension-libreoffice-calc_en
You are a life saver! Thank you so much. I spent so many hours trying to find a solution to this that works with very large files. I think you're about the only person in the world that knows how to do this! Thanks so much. I subscribed.
Вітаю! Дана функція працює лише в LibreOffice Calc. Може виникати помилка, якщо версія вашого LibreOffice відрізняється від версії 7.6. Як альтернатива, ви може скористатися цією ж функцією завантаживши розширення "YouLibreCalc": moonexcel.com.ua/nbua-function-youlibrecalc_ua
As an alternative you can also try FuzzyLookup() from our new extension "YouLibreCalc.oxt" at the following link: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en
I have a challenge removing leading zeros on my data. I have over 10,000 lines of data appearing like this 00,176.00 00,001.00 10,023.75 08,137.89 00,025.50 How do I remove the commas and the zeros. I have tried formatting with General, and with Numbers but they are not working. The data size is too much and I need to do calculations for it.
@libreofficecalc-tipstricks2322 Thank you so much for this insight. I used CTRL F, inserted one line of comma "," inside the box with Find, I also clicked on the Replace and but didn't key in any information in that box. Then I clicked on Replace All. The job was done almost immediately. The commas disappeared and the leading zeros disappeared too
If the video was helpful for you - please let me know in comments below! Link to the function: moonexcel.com.ua/fuzzy-lookup-function-libreoffice-calc_en A free extension "YouLibreCalc.oxt" with additional functions for LibreOffice Calc: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en A professional extension "YLC_Utilities.oxt" with many additional functions and useful utilities for LibreOffice Calc: moonexcel.com.ua/ylc-utilities-extension-libreoffice-calc_en
Me aparece este error al copiar la función a otra celda: "Error de ejecución de BASIC. '1' Se ha producido una excepción Type: com.sun.star.lang.IllegalArgumentException Message: "
Thanks a lot. I was accustomed with Microsoft Office Excel, but not with Libre Office Calc. Further I also learnt from you how to mention the Indian currency. I'm grateful. However, kindly inform under which module it is to be saved.
The apostrophe isn't really part of the cell content, it just signifies that the cell is treated as text. The .* means "zero or more of any character" and & means "whatever was found". These are regular expressions which are explained in the Help section.
If the video was helpful for you - please let us know in the comments! More tips by the link: moonexcel.com.ua/main-libreoffice-calc_en A free extension "YouLibreCalc.oxt" with additional functions for LibreOffice Calc: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en A professional extension "YLC_Utilities.oxt" with many additional functions and useful utilities for LibreOffice Calc: moonexcel.com.ua/ylc-utilities-extension-libreoffice-calc_en
when I am trying to use your module I get message BASIC runtime error. '323' Module cannot be loaded; invalid format. What can be a reason of such behavior? it stops at line: Set XMLHTTP = CreateObject("MSXML2.ServerXMLHTTP")
You can try the following: 1) Double-check the "Option VBASupport 1" line in your copied code; 2) Play with LibreOffice Calc options... Choose Tools - Options - Load/Save - VBA Properties and mark the Executable code checkbox; 3) Update LibreOffice Calc.