Create a Python function in LibreOffice Calc

preview_player
Показать описание
How to make and run a python function in LibreOffice Calc. Let's use python macros for writting functions.
Write and run python scripts in a quick and simple way - LibreOffice Calc Tutorial
Libre Office Calc (former StarOffice, OpenOffice) is a free analogue of Microsoft Excel spreadsheets.

Link to downlad the Notepad++ code editor:

If the video was useful for you you can always support our channel to spread more knowledge:
Buy Me A Coffe:

#libreoffice #libreofficecalc

A professional extension "YLC Utilities" with many new functions and useful utilities for Microsoft Excel and LibreOffice Calc:
--------------------------------------------------------------------------------------------------------------------------------------
Macro codes from the video lesson:
Рекомендации по теме
Комментарии
Автор

Thanks! I was going crazy with my UDF.

helenaspljushka
Автор

I am so grateful for this video. It's simple enough to understand and try by myself 🎉🎉🎉 Thanks!!!

Lobaluna
Автор

What is Libre Pythonista? Is that an easier way to add Python code than the method you show here?

GrooveMan
Автор

It drives me up the wall that we are given no choice but to use BASIC wrappers to use Python scrips as calc functions.

Sledgmatic
Автор

Thanks for the video! I didn't know that Libre has macros and Python support. My comment is that this video is very slow. Please speak 2 times faster.

victorlinde
Автор

Can you do another one that uses scriptforge for python please?

joneeryanty
Автор

Hello, what modifications would have to be made so that the function receives two strings and returns an integer result? I tried to create the "Levenshtein distance" function in Calc (which I already had implemented in Python), but I couldn't get it to work.

matiasbenzo
Автор

hello how we can rename the folder Standard ? also how i can create another folders ?

ΑναστάσιοςΓιαλίδης
Автор

This doesn't make sense. So in order to use a Python function in a formula, I have to call it using Basic? Why can't we just use Python functions in cell forumulas like we can with Basic?

michaelmiller
visit shbcf.ru