[Solved] LibreOffice Calc PySort

Discussions about using 3rd party extension with OpenOffice.org
Post Reply
FrogFan
Posts: 27
Joined: Tue Aug 30, 2016 6:51 pm

[Solved] LibreOffice Calc PySort

Post by FrogFan »

Hello,

I use the PySort extension in OpenOffice calc. It works well there. I'm currently in the process of migrating a workbook that uses this extension a lot to LibreOffice. The reason for the migration is that I'm having stability issues with OpenOffice in Windows 10 and I'm hoping LibreOffice is more stable in the Windows 10 environment. (I recently got a new computer running Windows 10.)

In LibreOffice, I navigated to the extension manager and thought I had installed PySort in exactly the same manner that I installed it in OpenOffice. I got no error messages when doing so and the extension manager indicates that its installed. It's not functioning though. Every cell in the output array reports a VALUE error, the same result I get when the extension is not installed at all.

Is there any way to make this extension work in LIbreOffice? Thanks for any assistance.
Last edited by MrProgrammer on Tue Jul 30, 2019 4:59 am, edited 2 times in total.
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.3 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LibreOffice Calc PySort

Post by Villeroy »

It is not a regular extension from extensions.openoffice.org. It is made by Charlie Young (last visit 2015) who published the extension on this forum: viewtopic.php?f=21&t=56916
It installs OK, appears in the function wizard under category "Add-In" but =PYSORT(A1:A33) [entered as array function] returns #VALUE.
The code in PySort.py compiles fine when testing with py3compile. I don't have the time to debug further.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
FrogFan
Posts: 27
Joined: Tue Aug 30, 2016 6:51 pm

Re: LibreOffice Calc PySort

Post by FrogFan »

Thank you, Villeroy. I think it's curious that it works running in OpenOffice but doesn't in LibreOffice. If it won't compile, then it shouldn't work in either, right?

I understand you're busy. I've posted my question over on Ask LibreOffice to see if they can help me.

Thanks again.
OpenOffice 4.1.3 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LibreOffice Calc PySort

Post by Villeroy »

LibreOffice uses Python3, OpenOffice sticks to Python2. This is a major source of incompatibility. Since the code compiles, it would be necessary to debug it line by line testing each and every function argument. Takes some hour or two.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
FrogFan
Posts: 27
Joined: Tue Aug 30, 2016 6:51 pm

Re: LibreOffice Calc PySort

Post by FrogFan »

OK. I understand. I'm in no particular hurry with this so, if you do find time and have a chance to look at it, I'll be standing by. Meantime, I'll post a message over on Ask LibreOffice that you've responded to this thread. I don't want to waste anyone's time.

Here is a link to my post over at Ask LibreOffice. https://ask.libreoffice.org/en/question ... breoffice/

Thank you again.
OpenOffice 4.1.3 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LibreOffice Calc PySort

Post by Villeroy »

Solved by mikekaganski viewtopic.php?f=21&t=56916#p474771
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
FrogFan
Posts: 27
Joined: Tue Aug 30, 2016 6:51 pm

Re: LibreOffice Calc PySort

Post by FrogFan »

Thank you!
OpenOffice 4.1.3 on Windows 7
Post Reply