ja

LibreOffice.Calc.Macro.Python

Write Python macros in LibreOffice Calc.

DEMO

Requirement

• 2020-09-25
• Raspbierry Pi 4 Model B Rev 1.2
• Raspbian buster 10.0 2019-09-26 setup
• bash 5.0.3(1)-release
• LibreOffice 6.1.5.2

$ uname -a
Linux raspberrypi 4.19.97-v7l+ #1294 SMP Thu Jan 30 13:21:14 GMT 2020 armv7l GNU/Linux

Installation

sudo apt -y install libreoffice libreoffice-l10n-ja libreoffice-help-ja
git clone https://github.com/ytyaru/Shell.LibreOffice.Calc.Macro.Python.20200925123834

Usage

cd Shell.LibreOffice.Calc.Macro.Python.20200925123834/src
./run.sh

1. Start LibreOffice Calc
2. Click Menu → Tools→Macros→ Manage Macros→Python
   
3. Open My Macro→hello_uno→hello from the tree
4. Click the Run button
   
5. 999 is entered in A1 of Sheet1
   

Set security to "medium"

If the macro cannot be executed, set the security to "medium".

1. Start LibreOffice calc
2. Click Menu → Tools→Options
3. Click LibreOffice→Security from the tree on the left side of the dialog
4. Click the Macro Security button on the right side of the dialog
5. Click the radio button medium in the security level tab`
6. Click the OK button

Author

ytyaru

• 
• 
• 

License

This software is CC0 licensed.