[Calc][oxt] A function for all python string methods
Posted: Sat Jun 18, 2016 6:14 pm
Hello,
Keeping on exploring Calc add-ins, I built for myself a small extension that adds a PYSTRING function in Calc. Once installed, the function appears in the "Text" category of the functions wizard. PYSTRING gives access, within Calc, to all python built-in string methods (see spreadsheet below).
Some of these methods have their equivalent among the native functions of Calc, but most have not and thus provide an interesting complement. I’m not sure everyone would find it useful, but I’m pleased to share it as I found here (and in the french forum) all information that was lacking in the official documentation.
PYSTRING works fine under Apache OpenOffice. It works the same way under LibreOffice, except for the little issue described here.
Keeping on exploring Calc add-ins, I built for myself a small extension that adds a PYSTRING function in Calc. Once installed, the function appears in the "Text" category of the functions wizard. PYSTRING gives access, within Calc, to all python built-in string methods (see spreadsheet below).
Some of these methods have their equivalent among the native functions of Calc, but most have not and thus provide an interesting complement. I’m not sure everyone would find it useful, but I’m pleased to share it as I found here (and in the french forum) all information that was lacking in the official documentation.
PYSTRING works fine under Apache OpenOffice. It works the same way under LibreOffice, except for the little issue described here.