User:Blue.painting

Welcome to my user page!

This is me, and I am currently working on to put them in the English macro pages Macros/General & Macros/Writer & Macros/Calc & Macros/Base
 * Creating more Impress macro example pages, which are linked at Macros/Impress
 * Translating the French macro pages in Macros/General/fr & Macros/Writer/fr & Macros/Calc/fr & Macros/Base/fr

Please see my roadmap below for more information!

Useful pages

 * Useful tricks for LibreOffice macro programming
 * LibreOffice macro documentation standards
 * LibreOffice Impress macro development reference

General

 * Fix Macros/General/006 (Exporting to hybrid PDF format)
 * Fix Macros/General/007 (Download file directly to the client)
 * Fix Macros/General/008 (Pasting unformatted from clipboard)


 * Translate Macros/General/001/fr to Macros/General/001 (Comment ouvrir un document dans son application par défaut ?)
 * Translate Macros/General/002/fr to Macros/General/002 (Comment utiliser les icônes de LibreOffice ?)
 * Translate Macros/General/003/fr to Macros/General/003 (Récupérer la table de données d'un diagramme)
 * Translate Macros/General/004/fr to Macros/General/004 (Delete unused styles)
 * Translate Macros/General/005/fr to Macros/General/005 (Display the date & time a file was created or last modified)

Impress

 * Create Macros/Impress/001 (Insert rectangle to current slide)
 * Create Macros/Impress/002 (Manipulate LineShape objects selectively in current slide)
 * Create Macros/Impress/003 (Crop images in a custom manner)
 * Create Macros/Impress/004 (Copy shape's hex color to clipboard)
 * Create Macros/Impress/005
 * Create Macros/Impress/006
 * Create Macros/Impress/007

Draw

 * Translate Macros/Draw/001/fr to Macros/Draw/001 (Manipulate object properties by layer)
 * Create Macros/Draw/002 (Import and manipulate images to create PDF)
 * Create Macros/Draw/003

Math

 * Translate and migrate Faq/Math/102/fr to Macros/Math/001/fr and Macros/Math/001 (Change the size or font of all formulas)

Writer

 * Fix Macros/Writer/004 (Sort table columns alphabetically ascending or descending)
 * Fix Macros/Writer/005 (Paste unformatted text from the clipboard without linebreaks or styling)
 * Fix Macros/Writer/006 (Update indexes)


 * Translate Macros/Writer/001/fr to Macros/Writer/001 (Insert comment)
 * Translate Macros/Writer/002/fr to Macros/Writer/002 (Repair tables created through a DDE link)
 * Translate Macros/Writer/003/fr to Macros/Writer/003 (Table border manipulation)
 * Translate Macros/Writer/007/fr to Macros/Writer/007 (Identify text between two boundary strings)
 * Translate Macros/Writer/008/fr to Macros/Writer/008 (Convert a table to text)

Calc

 * Fix Macros/Calc/016 (Export a Calc sheet as PDF)


 * Translate Macros/Calc/001/fr to Macros/Calc/001 (Comment trouver la plage utilisée ?)
 * Translate Macros/Calc/002/fr to Macros/Calc/002 (Gérer la Feuille active)
 * Translate Macros/Calc/003/fr to Macros/Calc/003 (Comment gérer la sélection courante ?)
 * Translate Macros/Calc/004/fr to Macros/Calc/004 (Comment entrer une date dans une cellule ?)
 * Translate Macros/Calc/005/fr to Macros/Calc/005 (Comment accéder à un diagramme par son nom utilisateur ?)
 * Translate Macros/Calc/006/fr to Macros/Calc/006 (Comment définir la cellule liée à un contrôle de formulaire ?)
 * Translate Macros/Calc/007/fr to Macros/Calc/007 (Comment lier une cellule à un contrôle Calendrier (champ de date) ?)
 * Translate Macros/Calc/008/fr to Macros/Calc/008 (Comment filtrer une plage de cellules ?)
 * Translate Macros/Calc/009/fr to Macros/Calc/009 (Comment copier sans utiliser le presse-papiers ?)
 * Translate Macros/Calc/010/fr to Macros/Calc/010 (Comment forcer la saisie en majuscules ?)
 * Translate Macros/Calc/011/fr to Macros/Calc/011 (Comment gérer les bordures d'une plage de cellules ?)
 * Translate Macros/Calc/012/fr to Macros/Calc/012 (Simulateur du formatage conditionnel "Échelle de couleurs" (2 entrées))
 * Translate Macros/Calc/013/fr to Macros/Calc/013 (Comment lister les fonctions disponibles dans le tableur ?)
 * Translate Macros/Calc/014/fr to Macros/Calc/014 (Comment obtenir les références d'une plage fusionnée ?)
 * Translate Macros/Calc/015/fr to Macros/Calc/015 (Comment créer une forme et lui affecter une macro ?)

Base

 * Translate Macros/Base/001/fr to Macros/Base/001 (Manage linked images)
 * Translate Macros/Base/002/fr to Macros/Base/002 (Comment réaliser un filtre alphabétique par bouton ?)
 * Translate Macros/Base/003/fr to Macros/Base/003 (Comment paramétrer un rapport avec des champs d'un formulaire ?)
 * Translate Macros/Base/004/fr to Macros/Base/004 (Comment créer et supprimer des relations entre tables ?)
 * Translate Macros/Base/005/fr to Macros/Base/005 (Comment simuler des sous-rapports avec libreoffice-report-builder ?)

Macros

 * Macros
 * Macros/Impress
 * Macros/Writer
 * Macros/Writer/fr
 * Macros/Python Guide
 * Macros/Designing & Developing Python Applications
 * LibreOffice Python Scripts Help

Macro tools

 * MRI - UNO Object Inspection Tool
 * https://github.com/hanya/MRI/wiki/RunMRI
 * XrayTool website

Access2Base

 * www.access2base.com
 * Extension: Access2Base
 * LO Help - Access2Base
 * Access VBA reference

Code beautifiers

 * VBA beautifier from automateexcel.com
 * vbindent.com

Misc

 * Special:RecentChanges
 * Special:Upload
 * User:Blue.painting/Sandbox
 * Extension: TexMaths
 * http://openoffice3.web.fc2.com/OOoBasic_General4.html
 * RefCard LibOBasic-5-ExecLib-Flat-A4-EN-v101.pdf

Writer

 * File:EN.MACROS Writer 007 Search and highlight text found between two tags.odt
 * File:Example of macro paste from clipboard.odt
 * File:Example macro to convert table to text.odt
 * File:Example macro for sorting tables.odt
 * File:Example macro for table border manipulation.odt

Impress

 * File:Example macro to insert RectangleShape in slide.odp
 * File:Macro to selectively manipulate LineShape objects.odp
 * File:Screenshot of macro to selectively manipulate LineShape objects.png
 * File:Example macro for custom cropping of images.odp
 * File:Example macro to copy shape hex color to clipboard.odp

Calc

 * File:Example macro for exporting to hybrid PDF.ods
 * File:Example macro to export Calc sheet to PDF.ods

Draw

 * File:Example macro for manipulating object properties by layer.odg
 * File:Screenshot of ODG macro-example for Draw 001 layer object manip.png

Blog mentions

 * 2021-04-28 @ blog.documentfoundation.org - LibreOffice Macro Team: progress report
 * 2020-04-14 @ blog.documentfoundation.org - Open Badges for top wiki contributors!
 * 2020-04-08 @ blog.documentfoundation.org - LibreOffice Macro Team: progress report
 * 2019-11-26 @ blog.documentfoundation.org - LibreOffice Macro Team: progress report

Open Badges

 * https://www.libreoffice.org/open_badges/wiki-badge-011.json