User:LibreOfficiant

quick notes:
 * Design guidelines, Style guide as of Full Circle magazine
 * Tour d'horizon des images libres (et non libres)
 * Open-source illustrationʂ for every project you can imagine and create
 * photos for everyone
 * Smithsonian Open Access
 * Openverse@WordPress
 * https://wiki.documentfoundation.org/WikiAction/edit/Template:Menu.Macros
 * Utiliser LibreOffice comme environnement Python plus facilement, Takeshi Abe march 2018
 * Utilisation d'O…Office / LibreOffice (traduit du japonais)
 * Database Programming with OO.o Base & Basic, Roberto Benitez
 * my extensions, Namespaces

Completed

 * in this wiki, since Nov-2017 (work in progress)
 * my extensions
 * LibreOffice Basic syntax diagrams cheatsheet
 * Input/Output to Screen with Python
 * Designing and developing Python applications | Conception et développement d'applications Python
 * Developing Python macros in IDE's with IDE_utils module.


 * in LibreOffice help pages (work in progress):
 * elsewhere
 * Enum.erations or Constant groups | Constantes groupées ou Enum.érations, Oct-2018
 * IDE_utils Gitlab project to ease coding of (Libre/Open)Office Python macros, Mar-2018
 * Develop *Office Python macros within IDEs | Développement de macros Python *Office dans un EDI, Mar-2018
 * Appels de routines Basic avec Python .. et réciproquement, Feb-2017
 * XSCRIPTCONTEXT revisité, Jan-2017 - in french

Projects, on-going Task(s) & references

 * some VBA undocumented stuff, cf. infra
 * |LibreOffice Basic syntax diagrams - aggregation as of now
 * Libre Librɘries OOP Basic & Python induction for (Libre/Open)Office, incl. illustration of Design Patterns (wip)
 * Document Tools.Debug library
 * Basic calls to C libraries (all platforms)
 * Designing & Developing Python Applications | Conception et Développement d'Applications Python with the help of:
 * Java LibreOffice Programming v2 (JLOP)
 * [Basic Gestion dynamique de dialogue (Consulter le sujet) • Forum OpenOffice LibreOffice NeoOffice]
 * [Solved [Python ] How to use packages (View topic) • Apache OpenOffice Community Forum]

To Do

 * LibreOffice Help | Aide LibreOffice

e-Books

 * Learning Python Application Development], Ninad Sathaye
 * Python:Master the Art of Design Patterns, Dusty Phillips, Sakis Kasampalis, Chetan Giridhar
 * Mastering Object-oriented Python, Steven F. Lott
 * Mapt powered by Packt
 * Welcome to Python cheatsheet!
 * Algorithms in Python

Bookmarks

 * Python-UNO examples, Python Language Bindings, Utilisation de bibliothèques Python (Linux & Win)
 * Regular expressions online tester
 * Calc REGEX function,
 * com.sun.star. util.SearchDescriptor or com.sun.star. util.ReplaceDescriptor or com.sun.star. util.SearchAlgorithms,
 * JavaScript RegExp, Python re module,
 * Search & replace Chinese characters in a multi-lingual document
 * Openpyxl
 * Autoriser l'exécution de scripts
 * Obtenir l'heure UTCː Basic, Python

API
algorithms]
 * UNO Contexts, [https://forum.openoffice.org/en/forum/viewtopic.php?f=44&t=89845&p=423990&hilit=basic+javascript+owlbrudder#p424049 text search
 * [Java OOo Writer and Calc macro examples]

Python

 * Installing pip(3) in Libreoffice's embedded Python …


 * Multi-Chronos
 * Dialog ProgressBar
 * Python Array Sort add-in function
 * Get/Set color properties easily
 * UserFields class via python dictionary api
 * Tim Golden's Python stuff, mostly win32 related

UI

 * Macros description, Barre d'outils personnelle, Sidebar for developers
 * Dialogues à onglets, Get Active Tab/Page ID from a Python dialog box

LibreOffice Basic

 * Generate own UNO services with OO Basic
 * Macro to detect OpenOffice version, Tout (ou presque) sur le type Array
 * Intercept menu events, Cancelling XTopWindowListener windowClosing

VBA compatibility stuff

 * The Ultimate Guide To Collections in VBA, Paul Kelly
 * Getting started with VBA, Macros-commandes VBA
 * VB Arrays - Better Solutions
 * Compatibility of Star/OpenOffice Basic to VBA, 23-Jan-2004
 * Miscellaneous undocumented keywords in Basic such as Option Compare|ClassModule, Implements, Enum, In, Like, ParamArray, Property, Text, 30-Dec-2008
 * The VBA ParamArray for a dynamic list of VBA arguments - Analyst Cave; Choose( ndx, ParamArray) use case
 * Understanding the ParamArray + Case studies in problem solving with Microsoft Excel and VBA
 * GetObject from VBA but also Option Compatible, COM/OLE, VBScript, Execute statement, OleObjectFactory. Note that ScriptControl can execute JavaScript code, 18-Feb-2008

Debugging

 * [Tutorial Introduction into object inspection with MRI (View topic) • Apache OpenOffice Community Forum]
 * [Solved Object Inspection Tool: XRAY or MRI (View topic) • Apache OpenOffice Community Forum]

others

 * Changer pour OpenOffice.org, circa 2008