Python scripts in LibreOffice Calc using the ScriptForge library - LibreOffice Conference 2021

Sdílet
Vložit
  • čas přidán 6. 10. 2021
  • A session from the online LibreOffice Conference 2021. Presenter: Rafael Lima
    Learn more: conference.libreoffice.org/2021/
    Support our community: www.libreoffice.org/donate/

Komentáře • 27

  • @miyamotomasao3636
    @miyamotomasao3636 Před 2 lety +6

    At 4:03 you show links.
    You should paste them under the video.
    Thank you !

  • @aplnx
    @aplnx Před 2 lety +3

    This video is really great! Thanks for posting such useful info. Libreoffice and Python is a very powerfull tool!!

  • @hessmess9504
    @hessmess9504 Před rokem

    Very explicit presentation. Thank you for sharing.

  • @VR_FNZ
    @VR_FNZ Před rokem +1

    Thanks a nice presentation ! As a DS , I like to create customized labelling tools with MS Excel+VBA to solve my data labelling problem. Definitely i will switch to the libreoffice+python solution, assume i can easily use the pandas dataframe as the backend data structure, and to train ML models immediately after update a label - that is perfect setup for data scientist !

  • @bantix9902
    @bantix9902 Před rokem +1

    this is fire! 🔥

  • @guillermogizzi462
    @guillermogizzi462 Před 2 lety

    Great video, very helpfull for me!!! Thanks a lot!

  • @varshneydevansh
    @varshneydevansh Před 6 měsíci

    Amazing

  • @kychemclass5850
    @kychemclass5850 Před 2 lety +3

    Would love to see more LO programming videos.
    I'm going to do make some but I know they will be very basic (no pun intended) and amateurish, but hopefully they'll halp someone and be a good reminder to myself.

    • @libreoffice-tdforg
      @libreoffice-tdforg  Před 2 lety +1

      Cool! Please let us know when you do make them, and we can help to spread the word! Drop us a line: info @ documentfoundation . org

    • @kychemclass5850
      @kychemclass5850 Před 2 lety

      @@libreoffice-tdforg BTW. I simply LOVE what's been done here. Kinda way beyond any knowledge I have. I was going to pitch to utter newbies, or low level tinkers like me making the shift from VBA.

  • @DamENIZ
    @DamENIZ Před 2 lety

    Great Video Thanks, I can't find anywhere how to define TAB delimiter in filter_option (how many does it take?) for ImportFromCSVFile nor from SF_Array.ImportFromCSVFile which I would prefer to use, so that I can separate what needs to be imported and what not.

    • @libreoffice-tdforg
      @libreoffice-tdforg  Před 2 lety +1

      Glad you like it! You can ask here to get more help: ask.libreoffice.org

  • @piotrbienkowski1095
    @piotrbienkowski1095 Před 2 lety +1

    Cool. :-)

  • @kychemclass5850
    @kychemclass5850 Před rokem

    Ho (again). Is there a way to use python to insert a row? - and specifically when an independent 'storage' cell gets updated.

  • @vardsuzvards1075
    @vardsuzvards1075 Před rokem

    maybe super noob question but how to start writing those macros in python? like python macro that writes hello world in a1 cell?

  • @roinujDK
    @roinujDK Před 2 lety

    May you share your example files from your presentation? Thanks.

    • @libreoffice-tdforg
      @libreoffice-tdforg  Před 2 lety +1

      Hi! You can get the slides here: events.documentfoundation.org/libocon2021/talk/FCU9NB/ - For more information, see: ask.libreoffice.org/

  • @mosesfrancis4976
    @mosesfrancis4976 Před měsícem

    Your presentation is good. But I have to know where should I write my code? Please help me

  • @neereda5138
    @neereda5138 Před rokem

    > using Offset for manipulate cell addresses

  • @stevealexander8010
    @stevealexander8010 Před 2 lety

    Nice presentation, tho it doesn't address my issue.