Developing an extension to manipulate charts

Discussions about using 3rd party extension with OpenOffice.org
Post Reply
tiagoda
Posts: 1
Joined: Mon Mar 30, 2020 12:40 am

Developing an extension to manipulate charts

Post by tiagoda »

Hi everyone,

I'm a newcomer to the openoffice community. I have tried to use it as a replacement for Microsoft Office and although it is on par on a lot of things I feel that working with charts is not very user friendly and limited in some senses.

I would like to attempt to create an extension that would expand on the functionalities for charts but I don't know how to start. I know a bit of VBA, C, R and Python so I know my way around scripting, however I never created any application (just data analysis basically)

I tried to read the documentation but it is dated to previous versions of OpenOffice and not very clear. I also couldn't find any useful videos or tutorials online related to extension development for OpenOffice or LibreOffice. In contrast Microsoft has made it very very easy for anyone to start developing add-ins for their Office suite.

Would a kind soul give me some hints on how to start, knowing that I am comfortable with programming but that I also know nothing aout APIs and OpenOffice.

Best regards,
Tiago
OpenOffice 4.1.7 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Developing an extension to manipulate charts

Post by Villeroy »

OpenOffice is dead. LibreOffice is the actively developed successor. https://www.libreoffice.org/community/get-involved/

If you are familiar with R ... why do you need to improve any spreadsheet charts?
If you can drive a highway truck ... why do you care about pick-ups?
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
JeJe
Volunteer
Posts: 2777
Joined: Wed Mar 09, 2016 2:40 pm

Re: Developing an extension to manipulate charts

Post by JeJe »

You may find extension compiler helpful.

https://wiki.openoffice.org/wiki/Extensions_Packager

If you choose BASIC you may find these useful:

http://www.pitonyak.org/oo.php

https://wiki.openoffice.org/w/images/c/ ... o3.2.0.pdf

I use BASIC as its what I know already, its what most people use, there's an IDE, and there some commonality with VBA and a lot of adaptable VB6 code available. Also if you are stuck you're far more likely to find a thread with a solution in BASIC here already.

And I use OO instead of LO as code written in that is more likely to be compatible with both (as LO has more added features that aren't in OO).

There are very few people writing extensions for OO/LO - but there's a lot of scope for them... lots of features/improvments that could be added via...
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
Post Reply