2015年4月12日 · this is a good example and exemplifies my impression that the LibreOffice flavor of Python is fairly unPythonic dialect of Java. Would help to have a reference of what are the major objects/methods to invoke to get started, the equivalent in LO Basic of ThisComponent ThisDatabaseDocument and dbg_methods , etc.

2024年9月17日 · Introducing LibePythonista This is the official announcement of LibrePythonista. An extension that brings the full power of python into of Calc Spreadsheets. Finally Python inside of LibreOffice Calc. LibrePythonista brings the power of Pandas, Matplotlib and much more to LibreOffice Calc. Watch the Introduction Video Highly recommened to watch first. Link …

2024年2月27日 · Hi Interested in trying the data stream option. Where is a good tutorial covering the subject including receiving data from serial port.

2015年4月11日 · If LibreOffice wants to be successful, it should integrate Python fully as a scripting language (even if it requires dumping StarBasic), because there are many more people who program in Python than there are who use Open/LibreOffice, and integration of Python and its other libraries will make OpenOffice Calc into a credible engineering tool.

2024年7月13日 · Is there a way to use the Calc functions in a Base query. Simply no.. Base can for example connect to an MySQL/MariaDB-Server “somewhere on the internet”. It will get the result back, but neither LibreOffice nor single Functions of Calc are available there.. But most databases have their set of functions available to SQL-queries.

2023年9月4日 · this is a good example and exemplifies my impression that the LibreOffice flavor of Python is fairly unPythonic dialect of Java. Would help to have a reference of what are the major objects/methods to invoke to get started, the equivalent in LO Basic of ThisComponent ThisDatabaseDocument and dbg_methods , etc.

2018年9月8日 · I am very new to LibreOffice BASIC for I have just moved from Windows and MS Office to Linux Mint 19 xfce and LibreOffice 6.0.3.2 . Now I am trying to write codes in LibreOffice Calc BASIC but it is very difficult. So, I would like to ask you where I can find the tutorial for the people who are jumping from MS Excel VBA to LO Calc BASIC. For one example: to move …

2019年6月25日 · “'Pivot Table - Libre Office Calc Tutorial” - YouTube. and. Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!) - YouTube. The LibreOffice Calc Guides are dry as dust (to me, an example why pivot tables are so difficult : ) but give comprehensive explanations once you understand the basics.

2022年2月21日 · I am developing an application with the delphi language that exchanges data through DDE with LibreOffice Calc. I can’t get a link using: Setlink(‘soffice’,’[myFileName]Sheet1’); I would like to write in a cell, for example cell A1. But the Setlink function returns false. What is the exact syntax for ‘[myFileName]Sheet1’? thanks

2023年11月13日 · Coming from a programming background myself, including Office scripting, which is a bit more fully featured in terms of programming references. Overall, is there a comprehensive polyglot document object model reference for the Calc objects, workbooks, worksheets, and so forth, BASIC, JavaScript, python? Would be nice to know what the objects …