[Calc][oxt] A function for all python string methods

Creating a macro - Writing a Script - Using the API

[Calc][oxt] A function for all python string methods

Postby hubert lambert » 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.
Attachments
pystring.oxt
Accessing python string methods from within Calc
(4.09 KiB) Downloaded 178 times
pystring_examples_EN.ods
examples for pystring function
(24.32 KiB) Downloaded 142 times
AOOo 4.1.2 on Win7 | LibreOffice on various Linux systems
hubert lambert
 
Posts: 126
Joined: Mon Jun 13, 2016 10:50 am

Re: [Calc][oxt] A function for all python string methods

Postby Zizi64 » Sat Sep 09, 2017 4:40 pm

I just localized the extension for HU (Hungarian). I hope, it will work...

pystring_plus_hu.oxt
(4.1 KiB) Downloaded 86 times
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7985
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Calc][oxt] A function for all python string methods

Postby hubert lambert » Mon Sep 11, 2017 1:16 pm

Hello Tibor,

It works fine. Thank you very much!
:)
AOOo 4.1.2 on Win7 | LibreOffice on various Linux systems
hubert lambert
 
Posts: 126
Joined: Mon Jun 13, 2016 10:50 am


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 4 guests