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)
@TheMarkdo1980 Can you provide an example and step-by-step actions? There is not clear how you want to "find" the value (the "error" word) - manually or use a macro, if macro - how you will run it and what you will have selected before...
A free extension for LibreOffice Calc with many additional functions: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en
How can I take a cell content into account for a function, instead of a hard-core value?
Just use a cell reference, e.g. =tripple(A1). Please check the new video: ruclips.net/video/pbdELxzYTig/видео.html
Nice! Is there an easy way for tripple(x) to use the data in an adjacent cell?
Just use a cell reference, e.g. =tripple(A1). Please check the new video: ruclips.net/video/pbdELxzYTig/видео.html
Very helpful thanks!
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)
Hi! Please check a new video about the python macros: ruclips.net/video/w-GnPl-5ssw/видео.html
@@libreofficecalc-tipstricks2322 Thanks, thanks a lot!💖
Good, you made it seem so easy LOL
Thanks!
Hello, i want tom make sound like beep when i found a cell contain specified number, can you do it?
Hi! Interesting task... Can you provide more details?
@@libreofficecalc-tipstricks2322 yes, if some cell contain word error, ,than librecalc sound beep
@@libreofficecalc-tipstricks2322 yes, i need to hear sound when a cell in libreofficecalc contain error word, can you do it?.
@TheMarkdo1980 Can you provide an example and step-by-step actions? There is not clear how you want to "find" the value (the "error" word) - manually or use a macro, if macro - how you will run it and what you will have selected before...
How do you add custom functions to the autofill?
Great! Can you do the same with python instead of LO Basic?
Good idea!
good video
What is the program language?
StarBasic