(Part 1) Create own function - Quick & Simple | LibreOffice Calc Tutorial

Поделиться
HTML-код
  • Опубликовано: 29 окт 2024

Комментарии • 22

  • @libreofficecalc-tipstricks2322
    @libreofficecalc-tipstricks2322  Год назад +1

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

  • @LibreOfficeHispano
    @LibreOfficeHispano 2 месяца назад +1

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

    • @libreofficecalc-tipstricks2322
      @libreofficecalc-tipstricks2322  2 месяца назад +2

      Just use a cell reference, e.g. =tripple(A1). Please check the new video: ruclips.net/video/pbdELxzYTig/видео.html

  • @kdub1666
    @kdub1666 2 месяца назад

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

    • @libreofficecalc-tipstricks2322
      @libreofficecalc-tipstricks2322  2 месяца назад

      Just use a cell reference, e.g. =tripple(A1). Please check the new video: ruclips.net/video/pbdELxzYTig/видео.html

  • @juliankonrath3617
    @juliankonrath3617 Год назад

    Very helpful thanks!

  • @Lobaluna9333
    @Lobaluna9333 Месяц назад

    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)

    • @libreofficecalc-tipstricks2322
      @libreofficecalc-tipstricks2322  6 дней назад +1

      Hi! Please check a new video about the python macros: ruclips.net/video/w-GnPl-5ssw/видео.html

    • @Lobaluna9333
      @Lobaluna9333 5 дней назад

      @@libreofficecalc-tipstricks2322 Thanks, thanks a lot!💖

  • @mhavock
    @mhavock Год назад

    Good, you made it seem so easy LOL

  • @dgmugen
    @dgmugen 8 месяцев назад

    Thanks!

  • @TheMarkdo1980
    @TheMarkdo1980 2 месяца назад

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

    • @libreofficecalc-tipstricks2322
      @libreofficecalc-tipstricks2322  2 месяца назад

      Hi! Interesting task... Can you provide more details?

    • @TheMarkdo1980
      @TheMarkdo1980 2 месяца назад

      @@libreofficecalc-tipstricks2322 yes, if some cell contain word error, ,than librecalc sound beep

    • @TheMarkdo1980
      @TheMarkdo1980 2 месяца назад

      @@libreofficecalc-tipstricks2322 yes, i need to hear sound when a cell in libreofficecalc contain error word, can you do it?.

    • @libreofficecalc-tipstricks2322
      @libreofficecalc-tipstricks2322  2 месяца назад

      @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...

  • @NavySturmGewehr
    @NavySturmGewehr 8 месяцев назад

    How do you add custom functions to the autofill?

  • @henrylawson430
    @henrylawson430 Год назад +1

    Great! Can you do the same with python instead of LO Basic?

  • @sonokajfumo3969
    @sonokajfumo3969 Год назад

    good video

  • @folainer
    @folainer Год назад

    What is the program language?