Kategorie: LibreOffice

Worked With The Zope Instance

I took some time to set up the environment to forward the Zope server port to my local box. Because I want to log into the Zope Management Interface with the permissions of an admin user I had add one first to the Zope instance. I run the debug instance of the Plone CMS with the command ‘adduser <adminusername> <password>’ for this purpose.

Then I started the debug-instance with the command ‘fg’. Once the debug-instance ran in forground (fg) mode, I started the forwarding within a terminal on my local box:
$ ssh -L 8085:localhost:8085 -N <server_name> -v

The <server-name> is the login to the server, whose port I wanted to forward.

The I could reach the forwarded server port in my browser with: http://localhost:8085/manage

This pointed me to the login of the root of the Zope instance and the ZMI. There I could login with the newly created admin user.

Notification About New Projects On The Review List

If a member of the LibreOffice extensions and templates website submitted a new project for publication it was added to the review list. But there is currently no notification of the reviewer about this new entry on the list. Thus the reviewer had to log in to the site constantly to check if there is a new project on the list.

To make the life of the reviewer a bit easier I added a notification by email in case someone submitted a new project for publication. I did this for both Plone addons which drive the LibreOffice extensions and templates site. The site itself runs on Plone 5, a powerful Content Management System.

Upgrade To Leap 42.3

I upgradet my notebook to openSuSE Leap 42.3 with zypper dup and everything went well. It took only a relatively short time in comparison with an upgrade of MS Windows and I had not to restart my box several times.

The upgrade needed only some edits to the software repositories that I used for the notebook. Nearly all of them needed only a change of the version number in the URL Form 42.2 to 42.3. The LibreOffice Factory repository (needed especially for building) needed a different tweek. There is no sub-repo for 42.3 yet. This I had to change to the sub-repo ‘openSUSE_Factory’ instead. That was all I had to do before I run the zypper dup command.

Really easy to update the Linux distribution. And I had not to reedit my user configuration etc. Everything works AS before.

Anleitung zum Erstellen von LibreOffice Extensions

Meine Freizeit in den letzten Wochen habe ich häufig dazu genutzt, eine Anleitung für das Erstellen von LibreOffice Extensions (Erweiterungen) zu schreiben. Eine erste Version dieser Anleitung, die zunächst die grundsätzliche Struktur und den Bau von Extensions behandelt, die weitere Inhalte LibreOffice hinzufügen, beispielsweise weitere Vorlagen oder AutoTexte (Textbausteine). Die Anleitung wird in den nächsten Wochen um weitere Abschnitte ergänzt werden. Sie können die erste Version von meiner Homepage hier  herunterladen. Die Anleitung steht unter der Creative Commons Lizenz 4.0 ohne kommerzielle Nutzung.

LibreOffice Extensions and Templates Site: New Plone Add-On Releases

The LibreOffice extensions and templates site runs on the Content Management System Plone 5 with some add-ons. I added together with our service provider some fixes and improvements to this add-ons during the last weeks. I made new releases of this Plone add-ons and uploaded them to the Python Cheeseshop:
https://pypi.python.org/pypi/tdf.templateuploadcenter/0.12
https://pypi.python.org/pypi/tdf.extensionuploadcenter/0.15

LibreOffice Extensions and Templates Site: Fix For Listing Releases

The listing of LibreOffice extension and templates releases and linked releases had an issue. The newest final release was not shown to the user. This issue was caused from the custom URL for the releases. The new releases and linked releases get an URL that placed them at the top of a list, which lead in the reverse order to getting them to the bottom of the list.

I fixed this issue with a new sorting key. The releases are listed in reverse order by the date they were created. The current final release is choosen by its release date in reverse order.

I contributed this fix to the TDF Github repository and delivered it to the LibreOffice extensions and templates website today.

Creating LibreOffice Extensions

I’m currently working on some content for a howto or handbook about making LibreOffice extensions. I want to cover the usual boilerplate and write about examples of different sorts of extensions. There is already some content available distributed all over the internet. Thus it is  not often not always easy to find, because it lives in seperate areas. Furthermore the existing content is regularly only available in English, a language that a lot of people in my and other countries doesn’t read and speak fluently (although things getting better this days). On these grounds I decided to write my document in German language. It’s work in progress and the ’source code‘ is public on my Github account:
https://github.com/andreasma/extensionbook

First Steps With LibreOffice Online – Running It For The First Time

I finally compiled LibreOffice online and reached my first milestone. Once this was done I had to create a new subdirectory on my machine:

sudo mkdir -p /usr/local/var/cache/loolwsd

Because I had to run the LibreOffice online with the rights of the user I had to change the ownership of that directory:

sudo chown `whoami` /usr/local/var/cache/loolwsd

Then I could start the online office with:

make run

Once the server of the online office is up I get the information in my shell about the URL of the office with the direct link to the usual hello world document and of the admin Console. The latter one is https://admin:admin@localhost:9980/loleaflet/dist/admin/admin.html
The first one depends on the special configuration and file structure of your machine. It starts with:
https://localhost:9980/loleaflet/64dd841/loleaflet.html?file_path=file://(…)

I pointed my browser to this URL and get to the hello world document. But first I had to deal with the security configuration of my browser (Firefox), which complains about an unknown certificate.

LibreOffice Online – The Hello World Document

And I could also get to the admin console with the URL that was displayed to me in the shell.

The LibreOffice online admin console