Видео

A free extension for LibreOffice Calc with many additional functions: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en

A free extension for LibreOffice Calc with many additional functions: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en

El video es muy bueno, pero ahora la onda está con Python y las macros en LibreOffice Calc. ¿Podrías apoyarnos con una función personalizada escrita en Python, guardada en Mis Macros? Por favor, por supuesto, Yuliya. Gracias por adelantado.

The video is useful! Thanks! Any chance to teach us how to use Python instead of BASIC to programming a custom function in LibO Calc? I mean, after programming the algorithm needed inside the function, how do I integrate it as a custom function, for example =MyPyFunction(a1;b1;c1)

this is very helpful, thanks! is there a way to do this and be able to make multiple selections? for example, i have a list of movies and i would like to add subtypes such as "romance" and "comedy" and pick each one that applies

Thanks for replying to my previous message (Part 1)!

Very helpful

Hello, i want tom make sound like beep when i found a cell contain specified number, can you do it?

How can I use "range" as arg to my function? I tried "=myfunction(A1:B1)" but got an object error... I checked arg type with TypeName func and got "Variant()" type. How can I convert "Variant()" to range to access "range" object and it's properties? Also how can I access cell data? I mean "=myfunc(A1)" can I make "Visual Basic" understand that A1 is not just a number, but a link to "A1" cell on sheet named "Лист1"?

Thanks buddy!!

How can I take a cell content into account for a function, instead of a hard-core value?

The best solution for me. Thank you!

Nice! Is there an easy way for tripple(x) to use the data in an adjacent cell?

This was SO SO helpful and saved me so much time!! Thank you!

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

That didn't work

You saved 3 or 4 hours of time, thank you :)

Can you write a macro for indian currency in crores lakhs and thousands instead of Millions, Billion and trillion ? i need that thanks in advance

A free extension for LibreOffice Calc with many additional functions: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en

A free extension for LibreOffice Calc with many additional functions: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en

A free extension for LibreOffice Calc with many additional functions: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en

A free extension for LibreOffice Calc with many additional functions: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en

Why have you selected Search in Formulas rather than Values?

You saved my time. I spent a lot of time find the solution, only your solution worked!

Thankyou! I'd never have found this solution in a million years. Utterly crazy, but it works. You've saved my life.

Standing ovation!! Finally I have the solution. Thanks a lort indeed.

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.

Thank you so much! So helpful!

A free extension for LibreOffice Calc with many additional functions: moonexcel.com.ua/youlibrecalc-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.

How do you add custom functions to the autofill?

Wow about date? I cant change the format of date

Добрий день! На жаль, не виходить зробити. Чи працює ця функція в ексель? Чомусь видає помилку "#значення!". Що можу не так робити?

Error 449 at 13 line

Thanks!

It’s very useful, thank you

З Новим роком! This formula works perfectly in version 7.4, but in version 6.4 (Build ID: 1:6.4.7-0ubuntu0.20.04.9) the result is "#NAME?" Any ideas?

Cool, it worked!

Thank you so much !

Very helpful...!

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.

A free extension for LibreOffice Calc with many additional functions: moonexcel.com.ua/youlibrecalc-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.

pięknie - działa

Thanks for the video. Why does the .* find an apostrophe and why does & replace it. Does not make sense to me but it works.

I just tried it.Great job. Thanks a lot

Great , I have done the same in excel VBA for Greek spelling, years ago , but I found it hard to migrate it to Libreoffice Basic.

What is the program language?

Not working ,basic run time error,type'com.sun.star.container.notsuchelementexceptionmassage