The Document Foundation Planet


October 19, 2018

Andreas Mantke

Change IN GPX File Export

I bought a gps sport watch some month ago and found a free software program to get the activity data out of it.  This program and software project is named ttwatch with regards to the name of the manufacturer of the sport watch: Tom Tom.

This free software is able to get the activity data from the sport watch and convert them into different file formats, e.g. the gpx file format. I compared the gpx output files, created by this software with the ones, written by the free software gpsprune. The output of this two programs have a different order of the attributes latitude and longitude. I read about discussions about the correct order of this two attributes and decided that I would like to follow the order of gpsprune. Thus I created an issue report for the original project and added the necessary changes to a fork that I created on my Github account.

by Andreas Mantke at October 19, 2018 08:18 PM

Collabora Community

“Real Time, Secure Collaboration” presentation at ownCloud Conference 2018

From September 18 until September 21, ownCloud held their annual conference oCCon2018 in Nürnberg, Germany. Participants joined the four days of the conference, hacking, learning and trying out new ideas on the ownCloud platform.

During the ownCloud conference, Collabora Productivity’s General Manager Michael Meeks gave a talk about how Collabora Online integrates into ownCloud. Collabora Online is a powerful LibreOffice-based online office that supports all major document, spreadsheet, and presentation file formats, which is easy to deploy in ownCloud, as a simple extension. Key features are collaborative editing and excellent office file format support.


Check out the slides above for the complete presentation:

Download the slides from the presentation “Real Time & Secure Collaboration”!


The post “Real Time, Secure Collaboration” presentation at ownCloud Conference 2018 appeared first on Collabora Productivity.

by Jona Azizaj at October 19, 2018 01:04 PM

Muhammet Kara

Resurrecting Mozilla Themes for LibreOffice - Part 1

As some of you might already know, LibreOffice has had the ability to use Mozilla Themes (Personas) for some time (Tools > Options > Personalization); but it kept breaking all the time, and never had an acceptable UX. Also tons of errors/warnings, and very slow search and apply processes almost brought it to the point of being killed for good.

But I couldn’t let it die, started looking into the related code and the bug reports. These might be some of the possible reasons why I couldn’t let it die: * It was a tiny silly feature, which brings some colour/fun to the UI * It might add to the level of emotional adoption by users * There were user requests * I already touched the code before

First thing to do was to fix the search functionality to make it operational again. It was broken because of some small changes in the source code of the persona pages on the Mozilla side.

Then I started fixing some small issues, and looking into ways to improve the under-the-hood part of the Personas dialog. It turned out that the dialog was fetching many web pages and parsing them to find the useful pieces on every search; and there was no caching. And the fetcher code, based on Neon, was also buggy, and was causing a lot of issues on its own.

After some web debugging and searching on the web and inside our own code-base, I have found the new API of Mozilla, which was returning JSON data, consisting of all of the useful info about each theme; and realized that we could simply use curl to fetch the data we need. (It seemed, to me, faster and simpler than Neon.)

Here is a summary of what has been done so far: * Make the search functional again * Fix some crashers * Refactor to improve performance, readability, stability, and to make the code future-proof * Modernize under-the-hood part * Reveal & polish the buried sub-features like preinstalled/bundled themes * Some other small bug fixes and improvements

From all, the under-the-hood patch had a major positive impact on the dialog, fixing multiple bugs at the same time, and preventing some more. After this commit: * The initial search time went down from ~40 seconds to ~6 seconds * The subsequent searches for the same term went down to ~3 seconds from ~40 seconds * So the search process became much much faster and more stable

And this is the commit message:

Modernize personas under-the-hood - The search

* Upgrade the used mozilla API from v1.5 to v3
* Ditch Neon for curl
* Get rid of the get-HTML-then-search-within craziness

It is much faster and smarter now:
* Fetches the search results at once in JSON format,
  instead of repetitively making http calls for each persona,
  and relying on an ever-changing HTML design
* Doesn't redownload and overwrite files each time, so it is
  much faster for the second time of the same search query

This patch handles the search part. A follow-up patch will
handle the apply part.

This is how the Personalization dialog looks like with a set of 6 preinstalled/bundled themes: LibreOffice Personalization Dialog

This is how the Select Firefox Theme dialog (search screen) looks like after selecting the Nature category: LibreOffice Select Firefox Theme dialog

And here is a list of related commits on Personas:

  1. tdf#118881: Fix HTML parsing for personas
  2. Do not crash when there are more default personas than intended
  3. Use slug instead of name to store Personas
  4. Make use of the already defined constants for personas
  5. tdf#60543: Remember the URL of the currently applied persona
  6. Ensure settings consistency for default personas
  7. Separate persona download thread
  8. Modernize personas under-the-hood - The search
  9. tdf#101629: Handle invalid urls and search strings for Personas
  10. tdf#99776: Preload a persona category initially
  11. tdf#120506: Get rid of unnecessary accentcolor parsing for personas
  12. Use curl while getting the actual persona
  13. Increase number of default personas to 6

by Muhammet Kara ( at October 19, 2018 12:00 AM

October 18, 2018

Björn Michaelsen

trusty old horses

Will you still need me, will you still feed me
When I’m sixty-four?
— When I’m sixty-four,  Sgt. Pepper’s Lonely Hearts Club Band, The Beatles

So almost six years ago I started using my LibreOffice development rig “Big Bertha”. Back then I thought: “This likely will be my last big machine, the next time I wont buy anything for under my desk, I will just build in the cloud.”. Six years on, that is partially true: I did not buy a new “desktop” machine. On the other hand, I am not building on some cloud machine either: I still use good old Bertha. So, why that?

For one, the speed of processors stopped improving at the insane rate it had before, so indeed machines that one buys today are not that much faster than those six years ago. However, cloud computing prices also stopped dropping like they used to. Which leaves me with not much reasons to buy new hardware — but also with little reason to consider to accept the additional inconveniences that come with building on remote hardware.

In 2012, the fastest build of a then-master checkout of LibreOffice from scratch and without caches I got out of Big Bertha was in ~18 minutes. I have not tried it again with present day LibreOffice — I assume it to be quite a bit slower, if only because e.g. we added tests left and right. But still: the old machine under the desk is still competing. A look at the numbers: A c4.8xlarge “compute-optizimed” instance on EC2 promises 36 vCPUs and 60GiB of memory. Now those 36 cores might be faster than those on the old Opteron 6272s I am running on. But I assume not much: CPUs really did not get much faster in the last six years — especially for workloads like compiling LibreOffice. For the most part they got better in other ways though: they use less power and push out less heat. So in the end the two Opteron 6272 with 32GB are likely still competing quite well with the stuff available from cloud providers.

So, why am I posting this? Buying a modern Server CPU still costs a fortune: a 16-core AMD Epyc 7281 costs 672 EUR at the time of posting. A new full machine with two of those comparable to Big Bertha will cost 2000-3000 EUR. Everybody loves AMDs Epycs apparently. But this challenge is also an opportunity: If one does not buy new hardware. Looking for “Opteron 6272” and “Opteron 6276” I found full systems available for 410 USD or even a 64-core, 256MB RAM system for 999 USD. These systems might be making too much heat and eating too much electricity: When I measured Bertha back in the day, compiling used ~400 Watt. At local electricity prices of 0.30 EUR/KWh that is 0.12 EUR per hour. Even if the c4.8xlarge on EC2 might be a bit faster, it still costs 10x as much. One should not make decisions without measuring, but its unlikely to be that much faster.

So I guess Im saying: If your LibreOffice build is too slow, have a look at the results on ebay for “opteron 6272” or “opteron 6276”. Those beasts might have served their time in the datacenter, but they may still be a steal for LibreOffice development. Or at least they should be worth a consideration …

by bmichaelsen at October 18, 2018 08:05 PM

Andras Timar

Build your LibreOffice development team!

Our success story in a nutshell and on 54 slides (extended version of my presentation at LiboCon, Tirana) : fixing more than 30 serious interoperability and usability problems of LibreOffice during 3 months, gallery of our nice results and introduction of our mentoring program with the secret sauce: Building a LibreOffice development team.



by Németh László at October 18, 2018 03:42 PM

Official TDF Blog

Video recap: LibreOffice Conference 2018 in Tirana, Albania

Our Albanian community has created this great recap video the recent conference in Tirana – check it out! And a big thanks for their help with organising the event.

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

by Mike Saunders at October 18, 2018 11:39 AM

October 17, 2018

CIB News

LibreOffice Hackfest in modulE

After a great LibreOffice Conference in Tirana we are now proud to invite you to the LibreOffice Hackfest that we are organizing in cooperation with The Document Foundation. The Hackfest is planned for the last weekend of October, from Friday 26 to Sunday 28 and will take place in our office in Munich, in the new … LibreOffice Hackfest in modulE weiterlesen

by CIB Marketing at October 17, 2018 04:47 PM

Official TDF Blog

LibreOffice Conference 2018: State of the Project (video)

We’ve edited and uploaded another video from our conference in Tirana, in which Italo Vignoli gives an overview of the project and community. (Use headphones for the best audio.)

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

by Mike Saunders at October 17, 2018 04:42 PM

Andreas Mantke

Stop TDF Volunteer Work ==> More Time For Health/Fitness

Since I stopped my volunteer work for The Document Foundation because of the communications style and behavior from leading members of the project I had more time to improve my health and fitness. I use my spare time for frequent traings sessions, especially for a run in the woods or in the fields and cycling. Great experience because of this warm autumn 😉

by Andreas Mantke at October 17, 2018 02:50 AM

October 16, 2018

Michael Meeks

2018-10-16 Tuesday

  • Mail chew; administration & form filling, built ESC stats.
  • The increasing volume of sextortion SPAM I get is quite extraordinary and rather liberating given its comic lack of any basis. Interesting to see the large increase in purchase-order, payment related scams too - thank goodness our finance department are savvy (and run Linux Desktops).
  • Joined the LOT Network today; was extraordinarily impressed and pleased to see Microsoft's unambiguously good move of joining OIN - was wisely preceeded by joining LOT - to avoid concerns about indirect trolling. Already had a great deal of respect for Microsoft's engineers (having worked with some in the deepish past), now it seems they have commercial people to match. If you read the MS Legal VP's quote I linked - it is interesting that he traces their open-ness back to open-sourcing ASP.Net in 2008. Miguel's Mono project combined with his positive and constructive engagement with many good people inside Microsoft seems to have yielded much sweet fruit in the end. Which is of course not to say that the bad-cops did not play a role too, but - anyhow; most pleased at the positive outcome for all.

October 16, 2018 12:59 PM

TDF Infrastructure Status

Dashboard - monitoring

Resolved - 2018-10-16 11:55:01 UTC Our GrimoireLab dashboard was migrated to a new host with an upgraded stack.

Dashboard check failed (server time: 2018-10-16 11:44:00 UTC)

Get x509: certificate is valid for, not

by The Document Foundation's Infrastructure Status at October 16, 2018 11:44 AM

Official TDF Blog

Coming up on 22 October: First Bug Hunting Session for LibreOffice 6.2

LibreOffice 6.2 is currently being developed by our worldwide community, and is due to be released in early February 2019 – see the release notes describing the new features here. We’re still early in the development cycle, so more features are still to come!

In order to find, report and triage bugs, the LibreOffice QA team is organizing the first Bug Hunting Session for LibreOffice 6.2 on Monday October 22, 2018. Tests will be performed on the first Alpha version, which will be available on the pre-releases server a few days before the event. Builds will be available for Linux (DEB and RPM), macOS and Windows, and can be installed and run in parallel along with the production version.

Mentors will be available from 07:00 UTC to 19:00 UTC for questions or help in the IRC channel #libreoffice-qa and the Telegram QA Channel. Of course, hunting bugs will be possible also on other days, as the builds of this particular Alpha release (LibreOffice 6.2.0 Alpha 1) will be available until mid-November.

During the day there will be a dedicated session to test the new KDE 5 integration available in LibreOffice 6.2 from 14:00 to 16:00 UTC.

All details of the first bug hunting session are available on the wiki. Come join us, and help to make LibreOffice 6.2 the best release yet!

by Mike Saunders at October 16, 2018 11:10 AM

October 15, 2018

Michael Meeks

2018-10-15 Monday

  • Interview; mail chew, sync with Kendy & Eloy. Lunch with J.
  • Tried to restore the missing Mattermost to IRC bridge that just got shut down; horrors. The lack of good nick / tab-autocompletion - plus the insistence on requiring '@' before completing (which ambiguates itself via other unusual fields) makes it deeply cumbersome to use for conversation. Surely it is possible to learn to communicate effectively in a much more constrained fashion - say with a lump of coal in your mouth; but why ? I wonder if RocketChat copes with typing the 1st char of a nick, and tab to dis-ambiguate it.

October 15, 2018 09:00 PM

Official TDF Blog

Community Member Monday: Ahmad Haris

Today we talk to Ahmad Haris, who helps out with LibreOffice events in Asia, and has recently joined The Document Foundation’s Membership Committee. (Click here to learn more about the benefits of membership.) Here’s what he had to say…

Where do you live, how can people find you on the web, and what are your interests outside of LibreOffice?

I live in Bogor, West Java, Indonesia. However, I was born in East Java (the opposite side). I’m active on Facebook, Twitter, and sometimes Google+ and IRC (last one only for meetings with GNOME Foundation Members).

When I’m not working on LibreOffice, I play the guitar, or ride my motorcycle :-)

What have you been doing in the LibreOffice community?

I helped to organize the Indonesia LibreOffice Conference 2018 in March this year. (See the full report here.) That’s my biggest contribution so far. Before that, I just using and testing the software.

How did you get involved?

In 2008, I was migrating a city (Central Aceh – Aceh Province) and a province (Yogyakarta Province) here in Indonesia to use Free and Open Source Software (FOSS). At that time I used I was helping the government to use it for two years, based on my job. Then time flied… LibreOffice arrived, so I moved to it.

What does LibreOffice need most right now?

In my opinion, LibreOffice needs a growing community, especially in developing countries in South East Asia or Africa. And we need to do more research, for instance on how people in those locations use office suites, what kind of templates they need, and so forth. In Indonesia, many users ask about page borders (a feature in other office software).

What tools do you use?

My main tools in all of my laptops (I have more than one, for travelling, for work and for playing/recording music) are LibreOffice, Visual Studio for code editing, Inkscape for vector graphics, Gimp for bitmap graphics, and Audacity for editing audio.

Anything else you want to mention?

To increase technical contributions to LibreOffice, I’d like to see more how-to guides for beginners, such as for contributing code for the first time, and organising workshops. Also, we should highlight success stories about implementations of and migrations to LibreOffice (I can help here, in terms of Indonesia).

A big thanks to Haris (as he likes to be known!) for his support and contributions to our worldwide community. And to everyone reading this, wherever you are on the planet, you too can make a difference and help to spread the word about LibreOffice. See here to get started!

by Mike Saunders at October 15, 2018 02:20 PM

Coming up on 25 – 28 October: LibreOffice Hackfest in Munich

The LibreOffice community organises regular Hackfests, where developers and community members meet up, work on new features, fix bugs and enjoy good food! Later this month, we’ll meet in Munich, in the south of Germany. Munich is situated just north of the Alps, and is known for its cosy old town, churches and beer halls:

Interested in joining? Click here for the full details – and add your name to the list if you plan to attend!

(Munich photo: Reinald Kirchner, CC-BY-SA 2.0)

by Mike Saunders at October 15, 2018 12:20 PM

TDF Infrastructure Status

piwik - monitoring

Resolved - 2018-10-15 01:28:00 UTC

piwik check failed (server time: 2018-10-15 01:05:00 UTC)

Expected HTTP response status: 200, got: 502

by The Document Foundation's Infrastructure Status at October 15, 2018 01:05 AM

October 14, 2018

Andreas Mantke

Plone Theming – So Difficult ;-)

The Plone CMS/DMS came with a theming editor, where you could create a new theme and edit themes. You could copy an already on the site available theme or create a theme from scratch. It’s your choice. I used the theme part in the administration interface to copy the Plone default theme ‘Barceloneta’ and save it under a new name.

Plone – New Theme Created From Default Theme

I could edit this new theme with the Plone theme editor (button ‘Modify Theme’.

The Plone Theme Editor

The theme is based on the Diazo theme engine (

by Andreas Mantke at October 14, 2018 11:26 PM

Michael Meeks

2018-10-14 Sunday

  • All Saints, music group, chatted with people; back for lunch with Lydia. Mended part of the creche door, back to All Saints to fit it, odd issue with Organ bellows over-filling and triggering a relief valve - interesting. Home to read stories, dinner late, iplayer, bed.

October 14, 2018 09:00 PM

Andreas Mantke

Gave Plone 5.2 On Python 3 Another Try

I updated my local copy of the Github repository for Plone buildout.coredev and gave the branch for the Python 3 migration another try. I run the script and all packages were updated. Then I started Plone with ‘./bin/wsgi fg’ and created a new Plone site.

I activated the multilingual add-on to make the new Plone site available in different languages. This added a special dialog to the administration page. I opened this dialog and added a second language to the site (in my case German). Plone created different folders for each of the two languages. I gave first the English folder a try and added a first page to it. Because I don’t want to use my time for typing I copied content from the website of The Document Foundation website.

Plone 5.2 on Python 3 – First Page

I published this page and choose it as the default page of the English section. Then I tried out the translation framework of Plone. I made a test with a translation of the page into German.

Plone 5.2 on Python 3 – Using Translation Feature

The dialog shows me the different fields of the English page and I could easily start to write a translation into German. If I had already local or somewhere else a translation of the English text, I could do copy and paste.

Once finished with the translation I saved it and published the page. I set it as the default of the German section. Users with German laguage setting or preference will get this translated page as their entry point now.

by Andreas Mantke at October 14, 2018 01:54 AM

October 13, 2018

Michael Meeks

2018-10-13 Saturday

  • Up lateish, did some maths with E. and M. - read with H. and lazed around with N. Out to David's for lunch - and enjoyed an Escape Room with H,N,M & David.
  • Home for some hacking about in the garden, a fine dinner, cake for David - and up late talking.

October 13, 2018 09:00 PM

Andreas Mantke

Fake News About Expense?

I read in an email on the LibreOffice design list that has been resources allocated to the extensions and templates website for about 25 thousand Euro (from a long time member of the board of The Document Foundation: This generates the impression that there has been spent this amount of money to improve the site. But if you look into the accounting legers of The Document Foundation (TDF) ( you will get the real data. TDF spent in 2017 6399,44 Euro and in 2018 642,60 Euro; all in all 7042,04 Euro, which seemed only a bit less than 25 thousand Euro 😉

This TDF resources were used espially to migrate the content of the first LibreOffice extensions and template websites into the new one, for smaller fixes within the code, a professional buildout and maintenance environment and a training of two TDF staff member on the platform and its maintenance (myself wasn’t part of the training session).

The biggest part of the development of the new LibreOffice extensions and templates website was done  during my spare time. I tried to save as much as possible expenses for TDF, because I thought it would help to lower the adminstration expenses of TDF and free more money for the promotion of education and science.

by Andreas Mantke at October 13, 2018 12:43 AM

October 12, 2018

Michael Meeks

2018-10-12 Friday

  • Interview(s) - still trying to find a good JS developer to work on Online. Worked on catch-up calls with Eloy, Kendy, Miklos, lots of backed up mails and tasks to do.

October 12, 2018 09:00 PM

Florian Effenberger

LibreOffice Hackfest 2018 in München

Ein wichtiges Anliegen der LibreOffice-Community ist die Weitergabe von Wissen. Neben Initiativen wie Workshops, Bug Hunting Sessions oder Vorträgen arbeiten wir gemeinsam auf Hackfesten daran, nicht nur das Programm zu verbessern, sondern geben dort auch einen Einblick in die Programmierung von LibreOffice, um mehr Menschen die Mitarbeit im Projekt zu ermöglichen. Das nächste Hackfest findet vom 26. bis 28. Oktober in München statt.

Als Allgäuer freut’s mich natürlich besonders, dass die Veranstaltung diesmal quasi direkt vor der Haustür stattfindet – denn die Hackfeste sind immer eine spannende und gewinnbringende Veranstaltung! ;-)

Uns alle eint das Interesse an LibreOffice und solche Community-Treffen sind ganz klar eines der Highlights im Jahr, vor allem weil man sich persönlich sieht. Das ist ja auch das Schöne an Open-Source-Communities: Aus Kollegen werden schnell Freunde, die einen über viele Jahre begleiten – man kennt sich, man hat gemeinsame Interessen und eine solche Veranstaltung bietet wieder die Gelegenheit, Entwickler persönlich kennen zu lernen und ein Gesicht zum Namen zu bekommen. Solche Kontakte sind viel wert, gerade in einem großen Projekt wie dem unseren und ich freu’ mich schon auf den gemeinsamen Austausch!

Mehr Informationen gibt's im Wiki
Mehr Informationen gibt’s im Wiki

Auf der Wiki-Seite sind schon viele Teilnehmer gelistet und ich würde mich freuen, auch deinen Namen dort zu sehen, denn Anfänger wie “alte Hasen” sind gleichermaßen willkommen!

Los geht’s am Freitag, den 26. Oktober ab 17 Uhr im “modulE” in der Elektrastraße 6a in München, abgerundet wird die am Sonntag endende Veranstaltung durch eine Stadtführung. Mein herzlicher Dank geht auch an unseren Gastgeber CIB, der unter anderem die Räumlichkeiten zur Verfügung stellt!

In diesem Sinne: Happy Hacking!

LibreOffice Hackfest 2018 in München

by Florian Effenberger at October 12, 2018 08:56 AM

October 11, 2018

Björn Michaelsen

Getting Started With LibreOffice Development: Object-oriented Programming and C++ Introductions

Turned around and found the right line

— No Leaf Clover, Metallica

So, for getting started with LibreOffice development e.g. with an EasyHack four things are needed:

  • Understanding of Object Oriented Programming
  • C++ Language Fundamentals
  • Completing a Build from Scratch of LibreOffice master
  • Understanding git and gerrit to submit your changes

We traditionally have covered the latter two quite well in our Wiki:

However, we did not have hints on where to find good documentation on object oriented programming in general and modern C++ programming. At most universities these days programming is taught with Java, JavaScript and Python, which leaves a missing piece on getting started with C++ programming. So Eike and me started looking for good resources on these topics too. Here is what we added to the General Programming Guidelines:

The OOP books are using Java as reference language, but they do not get lost in language details and intentionally allow using the concepts on other languages like C++. The university lecture starts off expecting basic knowledge of programming (e.g. in Java/JavaScript) so both together should yield a reasonable coverage of what is needed for your first EasyHacks.

Finding a good and modern starting point for C++ development was by far the hardest topic to cover of those named above. However, looking for them prompted Eike to dig out his personal “developer bookmarks” — a treasure trove that I will keep exploring further for other good content (this is where the “C++ Annotations” link came from).


P.S. As a sidenote and additional motivation: All those books — but especially “Head First: Design Patterns” should provide the context to understand many of the in-jokes found on the oldest wiki ever, the C2 WikiWikiWeb which can be an quite entertaining read once in a while.

by bmichaelsen at October 11, 2018 02:55 PM

October 10, 2018

TDF Infrastructure Status

CI - monitoring

Resolved - 2018-10-10 07:04:01 UTC

CI check failed (server time: 2018-10-10 06:23:31 UTC)

Expected HTTP response status: 200, got: 503

by The Document Foundation's Infrastructure Status at October 10, 2018 06:23 AM

CI - monitoring

Resolved - 2018-10-10 06:18:31 UTC

CI check failed (server time: 2018-10-10 06:17:01 UTC)

Expected HTTP response status: 200, got: 503

by The Document Foundation's Infrastructure Status at October 10, 2018 06:17 AM

October 08, 2018

CIB News

Fedora Women´s Day München – at modulE powered by CIB

On October 19th, with the support of the local Fedora Diversity & Inclusion Team, we invite you to attend the Fedora Women’s Day (FWD), an event created to highlight and celebrate the women in open source communities like Fedora and their invaluable contributions to their projects and community. The FWD will take place at modulE … Fedora Women´s Day München – at modulE powered by CIB weiterlesen

by CIB Marketing at October 08, 2018 03:19 PM


Adding Graphics to Labels Using Libreoffice

Adding Graphics to Your Labels

When people think of labels, the first thing that comes to mind is lines of text like addresses or tab markers. But these are just the simplest uses for labels. Photos, greeting cards, business cards, inserts for CD jewel cases — all of these can be created with a color printer and a package of labels. And with thermal transfer technologies, the possibilities expand to include everything from printed T-shirts to buttons for political campaigns and causes. All of these and more can be created using LibreOffice to create your own graphics.

LibreOffice is a complete office suite that is free for the download on Linux, MacOS, and Windows. You can create designs to add to any label in LibreOffice Draw application. You can edit images in LibreOffice’s Draw application, or create your own using Draw’s “primitives” — basic shapes ranging from circles and squares to stars and crosses. Another useful tool is Insert| Fontworks, in which you can arrange text in creative ways, substituting your letters for those in the templates:

A painless way to learn how to design your images is Robin William’s The Non-Designer’s Design Book. Williams (No, not that one) suggests keeping in mind four basic principles for arranging different aspects of your design: alignment, contrast, proximity, and repetition. More than one of these principles can be used at the same time. For example, in the business card below, the lines with contact information are all right aligned, while the company logo and the contact information have contrasting backgrounds:

If your design skills are not up to the task, you can download royalty free images and free fonts from hundreds of Internet sites. Another useful tool to download are dingbat fonts — fonts in which typing a character prints an image instead of a letter or symbol. For example, here is a small image created with a dingbat that consists of whimsical, nursery rhyme characters use with Fontworks:




When you design the images for labels, keep in mind the size of the labels. While it is easier to design at a much larger size than the label itself will use, if you have to shrink down an image, it is going to lose much of the detail. In addition, too much color could reduce the image to a few blobs of color. You should always experiment, but when working with smaller labels, think in terms of simple designs and a few bold colors.

Similarly, remember the background on which the image will be displayed — either its own, or the color of the label. The basic rule for legibility is light colors on a dark background, and dark colors on a background. Most of the time, a background of many different colors will be confusing.


Preparing the Label Sheet

In LibreOffice, a label sheet is created by producing a file for the Writer application with outlines that are equal to the dimension of the label. If your label is a thermal transfer or an unusual size, you will need to measure the size of the label carefully, and then select File | New | Writer Document. Set the page to the same size as the label sheet using Insert | Page. Then add Insert | Frame | Frame and set the frame so that it is the same size as your label(s), and positioned in the same way on the page.

With any luck, LibreOffice may support the manufacturer and type of label you are using. To check, To start preparing labels, start LibreOffice’s Writer word processor and select File | New | Labels. From this window, you can select the label type and how it is fed into your printer. You can also enter any text for your labels, either manual in the empty pane provided, or else from a database (check the online help for how to create and connect to a database.) You do not need to add text, and images will have to be added later, when the label sheet is prepared.


If your label sheet is not supported, you can set Writer to use it on the Options page, where you can enter the size of each label (if each page has more than one) and the spaces between the labels. You can also create a custom label sheet manually from an empty Writer document by measuring the label sheet and by using Insert | Frame | Frame and setting frames so that each the same size as your label(s), and positioned in the same way on the page. Probably, too, you will want to select the frame and right-click on it to make the borders of each frame invisible when you print.

The last step in preparing the label is to select Synchronize contents on the window’s Option tag. This feature sets the resulting file you create so that all changes to the first label on a page can be duplicated on the other labels with a single click.

When you are ready, click the New Document button. Writer will open a new file, showing frames for each label on the sheet and a floating Synchronize Contents button. This button is especially useful for adding images.


Adding Images to Your Labels

If your label is big enough, you can create your image using the Draw toolbar in the file created for printing by LibreOffice. Even then, though, you may find using Draw easier.

If you are using Draw, your last step should be to select all the separate elements by running the mouse cursor around all of them so that their frames and selective points show. By selecting Shape | Group, you can move and resize all the elements as if they were only one.

Then click on the grouped elements and select Position and Size from the right-click menu to reduce the size of the image so that it fits on the label. This step is necessary because if the image is too large for the label, adjusting it can be difficult. When you are ready, you copy and paste the image to the first label on the page. Clicking Synchronize Contents will replicate the first label on all the other labels. You are then ready to print.

A Matter of Practice

Adding images to a label may seem awkward at first, but it is really a matter of practice. After a few tries, you will start to see that LibreOffice’s tools are actually designed to save you effort and frustration. Once you are comfortable with the steps, you will find that, when you go beyond text, labels actually have more possibilities than you originally suspected.

By Bruce Byfield, author of Designing with – visit and download the book here

by wlmanager at October 08, 2018 01:17 PM

October 05, 2018

Cor Nouws

Fruit basket

Years and years ago I was visiting the region of Lyon - of course by bike. At one morning I entered a little village early and visited the local market to get me some nice fruit and vegs. One of the stalls was a bit strange. The man had really wide baskets, but with only a little bit of fruit in them. I could think of some boites hidden at another place for more, but wondered why that was so.

So I asked the man just if he liked to show his fruits with so much space. The man friendly explained to me that is was a matter of education. For him, when you see an abundance of fruits, it may seem that it's all so easy, comes at little cost. But for the grower that was not at all the case. He summed to me all things he had to spend time and money on before he could go to market with the results of his hard work, with selling fruit. Items as keeping the paths in good state, preparing compost and covering soil with it, pruning trees, repairing the roof of the grange, buying clothes to work in, getting help in picking, petrol and repair for the machines, and so on.

For me, the man concluded, all that are costs I have to make on the fruit. So if you see a basket filled to top with fruit, don't be misled and remember how much has to be done before it can be presented..
Happily I bought me a bunch of fresh figs. But from then on, for me a market never has been the same.

by Cor & OfficeBuzz ( at October 05, 2018 03:14 PM

CIB News

LibreOffice Conference 2018 in Tirana

The LibreOffice yearly conference is THE annual community meeting and a great opportunity to discuss and share ideas with contributors, companies and public administrations from all over the world. Our team was involved in internal meetings like the board of directors and the community meeting. The board met the new elected membership committee and discussed … LibreOffice Conference 2018 in Tirana weiterlesen

by CIB Marketing at October 05, 2018 02:10 PM

>Marius Popa Adrian

Firebird 3.0.4 sub-release is available

Firebird Project is happy to announce general availability of Firebird 3.0.4 — the 4th point release in the Firebird 3.0 series.This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows, Linux and Android platforms are immediately available for download, Mac OS kits will follow shortly.

by Adrian Marius Popa ( at October 05, 2018 11:56 AM

TDF Infrastructure Status

piwik - monitoring

Resolved - 2018-10-05 00:44:46 UTC

piwik check failed (server time: 2018-10-05 00:41:51 UTC)

Get net/http: request canceled (Client.Timeout exceeded while awaiting headers)

by The Document Foundation's Infrastructure Status at October 05, 2018 12:41 AM

October 02, 2018

LibreOffice QA Blog

QA Report: September 2018

Reported Bugs

577 bugs have been reported by 324 people.

Top 10 Reporters

  1. Telesto ( 35 )
  2. Zolnai Tamás ( 19 )
  3. Gabor Kelemen ( 18 )
  4. Xisco Faulí ( 16 )
  5. Michael Weghorn ( 11 )
  6. andreas_k ( 11 )
  7. Aron Budea ( 11 )
  8. kompilainenn ( 10 )
  9. perie_gut ( 10 )
  10. Albert Acer ( 9 )

Triaged Bugs

581 bugs have been triaged by 76 people.

Top 10 Triagers

  1. Buovjaga ( 134 )
  2. Xisco Faulí ( 70 )
  3. Dieter Praas ( 32 )
  4. raal ( 29 )
  5. Heiko Tietze ( 28 )
  6. V Stuart Foote ( 25 )
  7. kompilainenn ( 24 )
  8. Alex Thurgood ( 22 )
  9. Oliver Brinzing ( 19 )
  10. Julien Nabet ( 15 )

Fixed Bugs

106 bugs have been fixed by 35 people.

Top 10 Fixers

  1. heiko tietze ( 9 )
  2. László Németh ( 9 )
  3. Justin Luth ( 9 )
  4. Caolán McNamara ( 9 )
  5. Miklos Vajna ( 6 )
  6. Samuel Mehrbrodt ( 5 )
  7. Julien Nabet ( 5 )
  8. Maxim Monastirsky ( 5 )
  9. Noel Grandin ( 4 )
  10. Mike Kaganski ( 4 )

Verified bug fixes

99 bug fixes have been verified by 14 people.

Top 10 Verifiers

  1. Xisco Faulí ( 43 )
  2. BogdanB ( 29 )
  3. Lior Kaplan ( 9 )
  4. Buovjaga ( 6 )
  5. Thomas Lendo ( 2 )
  6. Aron Budea ( 2 )
  7. Julien Nabet ( 1 )
  8. Heiko Tietze ( 1 )
  9. kompilainenn ( 1 )
  10. Drew Jensen ( 1 )

Categorized Bugs

657 bugs have been categorized with a metabug by 28 people.

Top 10 Categorizers

  1. Thomas Lendo ( 453 )
  2. Dieter Praas ( 42 )
  3. Buovjaga ( 38 )
  4. Xisco Faulí ( 26 )
  5. Aron Budea ( 13 )
  6. V Stuart Foote ( 11 )
  7. Michael Weghorn ( 10 )
  8. kompilainenn ( 9 )
  9. Lior Kaplan ( 7 )
  10. Luke ( 7 )

Bisected Bugs

79 bugs have been bisected by 8 people.

Top 10 Bisecters

  1. Xisco Faulí ( 46 )
  2. Buovjaga ( 13 )
  3. raal ( 6 )
  4. Aron Budea ( 6 )
  5. Drew Jensen ( 3 )
  6. Telesto ( 3 )
  7. Justin L ( 1 )
  8. Mike Kaganski ( 1 )

Evolution of Unconfirmed Bugs

Thank you all for making Libreoffice rock!
Join us and help to keep LibreOffice super reliable!
Check the Get Involved page out now!

The post QA Report: September 2018 appeared first on LibreOffice QA Blog.

by x1sc0 at October 02, 2018 02:47 PM

Muhammet Kara

Recap: LibOCon18 & Tirana

Group photo from LibOCon18 This year’s LibreOffice Annual Conference has been held in Tirana, Albania on September 25 to September 28, 2018. It was organized by a group of independent volunteers from the Open Labs Hackerspace in Tirana.

I will try to give some information about my talks, and share my experience.

Talk Less, Listen More

In these kind of events, I usually tend to propose multiple talks and/or workshops, trying to do as much as possible in a limited time; but since the conference program was full of interesting talks and workshops, I wanted to watch & learn more, and talk less this time. :)

I have attended this year’s conference with two talks, one regular and one lightning.

Talk 1: ODF and LibreOffice Adoption in Turkey: a Status Report

Migration of public institutions to LibreOffice and ODF is going on in Turkey, backed by Turkish Academic Network And Information Center (TUBITAK ULAKBIM). Some ministries, public institutions and municipalities have already completed their migrations to LibreOffice and ODF. Migrations in some institutions are in progress. And many public institutions are waiting in the line. I talked about the history, current status, problems and the future plans of Turkey’s migration to ODF, LibreOffice, GNU/Linux (particularly Pardus) and open source software in general; and tried to answer the questions of the audience.

The reaction of the audience was very positive and encouraging. I got various help/support offers. We have also discussed/brainstormed on ways to ensure the success of the migrations in Turkey, during the Certification Workshop with Lothar Becker, Italo Vignoli, and the other fellow community members. This seems like one of the upsides of having such a great community full of fantastic people. :)

The slides of the presentation on Speaker Deck

Talk 2 (Lightning): Customize Dialog: The Road So Far and the Next Steps

In this lightning talk, I tried to give a quick status report on: What has been done/improved/fixed in the Customize dialog after GSoC 2017 until now; what is the current status, what is left to do, and the future plans.

Screenshot of LibreOffice Customize Dialog

The slides of the presentation on Speaker Deck

The New MC

The new MC of TDF I have run for membership of the new Membership Committee of the Document Foundation, and has been elected as a deputy for the next term. It was a pleasure being introduced to the community as part of the MC.

We had a joint meeting with the Board of Directors, and also some private MC meetings.

Must Do’s in Tirana and Some Tips

Tirana is nice and small Balkan city. You can go everywhere on foot or via a bike. Although there are more to do (like a walk to the mountains, or a bike tour to the north), I’ll try to give just a few tips.

Attend a Free Walking Tour

In my last day in Tirana, I attended a free walking tour. It took about 2 hours, and was guided by a nice Albanian named Eri. He showed all of the significant places in the city center, and gave extensive information about these places and the history of Albania & Tirana.

The tour starts at 10am and 6am every day, and the starting point is in front of the Opera house at the Skanderbeg Square. You may give some tip at the end, but there is no pressure to do so; the guide was super polite. You can find more info on their web site.

Eat Traditional Food

They have delicious food, mostly meat, and they use pork extensively; but you also have a lot of other options if you are a vegan or vegetarian.

You might try Era for some traditional food in a small and calm environment.

Bike Sharing

There some bike sharing services in Tirana (like Mobike). You may download their app to your phone, and see/rent the nearest bike. There are separate bike lanes in the main roads.

Buy Tourist SIM

If your GSM service provider also has high roaming prices like the most, then you should definitely get a tourist pack from a Vodafone store as soon as you arrive at Tirana. It costs around 10 EUR for 5GB data plan, 10 min international and plenty of domestic call minutes; and it will be valid for 2 weeks. There is a Vodafone store at the airport.

Avoid Exchange at the Airport

The exchange office at the airport (in the arrival hall) has a bad rate. Try to do your EUR <->LEKE exchanges in one of the offices in the city center. Many stores and taxis will also accept EUR.

Try Daily Tours

If you are going to stay for a longer period, then you might get bored after a while. So taking some daily tours to nearby cities might be a good idea in such a case.

Berat is one of the several options. This 2,413 years-old city, the pride of Albanian architecture which is under the protection of UNESCO, is located 120 km from Tirana.

Some Points of Interest


  • Skanderbeg Square
  • Opera
  • Clock Tower
  • Bunkers
  • Pyramid
  • Et’hem Bey Mosque

The Language

You can speak in English with the most of the younger people in Tirana. Their language (Albanian) is called Shqip. Po means Yes, Yo means No. And here is a survival dictionary.


It was a great experience overall, with many interesting and illuminating talks from different parts of the world. We have met new friends, and had a good time with the old ones also.

Looking forward to the next LibOCon in Spain!

by Muhammet Kara ( at October 02, 2018 12:00 AM

October 01, 2018


LibreLogo in schools and teacher training programs

LiboCon, Tirana, 2018 • On the annual conference of LibreOffice, I talked about LibreLogo in my short presentation “LibreOffice & eTwinning – LibreLogo in schools and teacher training programs”. You can see the slides also with a small LibreLogo introduction here. Abstract of the presentation:


  • Shipped LibreLogo package of Ubuntu and other Linux distributions has got localization support from LibreOffice 5.4.4.
  • LibreLogo works on more (all) macOS versions.
  • Recent LibreLogo regression (“drying ink”: drawing shorter lines as the path of the turtle) of the LibreOffice development code has been solved during the conference.


  • Brazil: Gilvan Vilarim has continued his LibreLogo curse at the digital inclusion conference SEMID, also he wrote a LibreLogo manual in Portuguese.
  • Germany: Mirek Hančl has included several LibreLogo worksheet templates in his upcoming grade 5/6 exercise book, published by Cornelsen Verlag in February, 2019.
  • Hungary: LibreLogo is used in several elementary and middle schools. Looking for a method by Péter Kecskeméti to add an immutable background image, for example, a graph paper behind the Logo turtle, I suggested a solution (usage of GDI image format) to create exciting worksheet templates for Logo exercises.


  • Research of University of Florence has been proven LibreLogo’s exceptional abilities in the education of computer programming. LibreLogo supports the concept “low floor, high ceiling”, which was first formulated in the 1970s by Seymour Papert, co-inventor of the Logo programming language: learning programming is a child’s play with LibreLogo, while it’s still very easy to learn more abstract programming principles with it. (A. R. Formiconi & F. Mancini: A step back into the future, draft, University of Florence, 2017)
  • As part of the research project of the university, Andreas Formiconi initiated the LibreLogo usage in eTwinning educational platform of EU, at eTwinning conferences and by leading online seminars.

Thanks for the great help of all LibreLogo contributors!

by Németh László at October 01, 2018 04:05 PM

Miklos Vajna

Text layout performance in LibreOffice conference lightning talk

Last Friday I gave a Text layout performance lightning talk at LibreOffice Conference 2018. Click on the image to get the hybrid PDF slides!

October 01, 2018 08:26 AM

September 29, 2018

September 28, 2018

Miklos Vajna

ReqIF import/export in LibreOffice Writer conference talk

Earlier today I gave an Editing ReqIF-XHTML fragments with Writer talk at LibreOffice Conference 2018. The room was well-crowded — perhaps because the previous talk was about OOXML interoperability. ;-)

I expect quite some other slides will be available on Planet, don’t miss them.

September 28, 2018 10:26 AM