Call to Action: Hackfests “The New Generation”

LibreOffice’s development community has been growing steadily for seven years, thanks to the great enthusiasm demonstrated by several core members. They have mentored an entirely new generation of LibreOffice developers, also thanks to Hackfests and other face-to-face meeting opportunities such as FOSDEM and the LibreOffice Conference.

After seven years is now the right time to start thinking about the new generation of Hackfests. For several reasons, their number has decreased over the last couple of years, and they have never really gone beyond European borders (even with core developers flying over the Atlantic to attract potential new developers).

Bjoern Michaelsen will be hosting a conference call to discuss HackFests “The New Generation” on Sunday, September 17, at 4:30PM CEST (Berlin time, or UTC +2). Everyone interested is warmly invited to participate, especially from LibreOffice native language communities around the world.

If you cannot connect, make your voice heard by sending a couple of ideas by email to the Projects mailing list: projects@global.libreoffice.org.

Updates from the Document Liberation Project


The Document Liberation Project (aka DLP) is working to free users and content creators from vendor lock-in. To achieve this, it develops and maintains libraries for reading documents in many different formats – including those generated by proprietary software. To learn more about the DLP, check our our short video.

In recent months, DLP developers have been working on updates and new features, so read on for all the details.

QuarkXPress import filter

Lithuanian coder Aleksas Pantechovskis (who we interviewed last year) has been working with David Tardon on a filter to read documents generated by the QuarkXPress desktop publishing application. He was doing this as a Google Summer of Code project, and added code for importing text boxes, shapes and other objects.

The image below shows an original QuarkXPress document on the left, and how it is converted into the open and standardised OpenDocument Format for use in LibreOffice and other software:

Aleksas and David have implemented the filter in a new library, libqxp – it supports QuarkXPress 3.1 – 4.1 documents at the moment.

PowerPoint and StarOffice

Meanwhile, Laurent Alonso has been improving a number of libraries for better compatibility with legacy documents. For instance, in libmwaw he has implemented an import filter for presentations created in Microsoft PowerPoint 2 (Windows), PowerPoint 4 (Mac and Windows) and PowerPoint for Windows 95. If you have old presentations in this format and need to retrieve the main contents, this filter will help you out.

In addition, he has updated libstaroffice, which is a library used to read files generated by StarOffice (which later became OpenOffice.org and then LibreOffice – see our timeline for the full history). Thanks to Laurent’s work, .sdc spreadsheet files preserve more of their formatting when imported, while .sda files created with StarOffice Impress are now converted as presentations.

Give us a hand!

As you’ve seen, DLP is helping users and content creators to free their data from old, legacy and proprietary formats. DLP libraries are used by many well-known applications such as LibreOffice, Inkscape and Scribus, so your contributions can help millions of people around the world.

And you don’t have to be a developer! While code contributions are always welcome, you can help us by reverse-engineering and documenting file formats, or sending us sample documents to analyse and test against the DLP libraries. Any help can really make a big difference, so see this page to learn more. We look forward to meeting you!

Surpassed the 40,000 closed bugs milestone

As Tommy kindly mentioned on the QA mailing list, this week the LibreOffice project has surpassed the 40,000 resolved bugs milestone – a huge achievement demonstrating the enormous amount of effort the community puts into software quality. If we take a look at the numbers from August 2016 (the month we started to collect data from Bugzilla) up to now, 7,143 bugs have been closed during this year, with an average of 133 bugs closed each week.

Let’s see some charts for the mentioned timeframe.

Number of bugs closed each week
Accumulative number of bugs closed
Statuses of the bugs closed

Get Involved!
So, you’ve seen what the QA team is doing across the LibreOffice project – why not get involved and help out? Even if you only have half an hour of spare time each week, by confirming bugs (and fixes) you can make LibreOffice better for millions of people around the world. And in addition, you build up valuable experience working with a large project and open source community – which could be very useful for a future career! Discover more about the QA team in our video interview with QA engineer Xisco Fauli.

(Notes about this blog post: raw data can be checked here. For more stats, visit the stats page in the QA wiki.)

TDF Dashboard: an open window on LibreOffice development

Berlin, August 2nd, 2017 – Effective immediately, The Document Foundation offers a transparent overview of LibreOffice development with the announcement of a Dashboard, available at http://dashboard.documentfoundation.org, which provides a visual representation of the activity on the source code.

LibreOffice Dashboard: activities during the last 30 days

Developed by Bitergia, the Dashboard is based on information retrieved from publicly available data sources, such as Git, Gerrit and Bugzilla repositories, or mailing lists archives. All tools used to retrieve, store, analyse and visualize data from repositories are based on free, open source software. The key component is GrimoireLab, a software development analytics toolset.

“The Dashboard shows the key information about LibreOffice development in several panels, each one including different visualizations, with many actionable elements”, says Bjoern Michaelsen, one of TDF BoD members who has managed the project. “When the user interacts with the actionable elements, the information in the whole panel (or in the whole dashboard) are reconfigured, by filtering in or out some data. Following our transparency guidelines, we are therefore offering an open window on LibreOffice development”.

“Bitergia was founded by a group of Spanish FLOSS enthusiasts, with a large experience in development, research and consultancy”, says company co-founder Jesus Gonzalez-Barahona. “We are very happy to see our software deployed by The Document Foundation for LibreOffice, one of the largest and most successful free software projects”.

Other key software used to produce the Dashboard are Python (to develop most of the retrieval and analytics programs), ElasticSearch (for data storage) and Kibitter, a fork of Kibana contributed back upstream (for data visualization).

Taming the LibreOffice Help System

LibreOffice’s help system needs to evolve and be more effective for users.

LibreOffice’s help system was designed in 2003-2004 and released in 2005. Since then it has not evolved, except for the introduction of an online version hosted in a wiki server (and accessible from LibreOffice when the local help is not installed).

I worked recently to transform our ancient help system into a modern browser-based version. The partial result is available in the (temporary) website at https://helponline.libreoffice.org – please be advised that this is still work in progress.

The XML help pages are transformed into pure, almost static and responsive HTML. This approach has some advantages:

  • Works in every browser
  • Provides the current functionality of the help system
  • Preserves the current development, help authoring, release engineering and translation process as it is
  • You can read the help pages in your mobile phone or tablet
  • It’s easy to add extra markup for better search engine indexing

The disadvantage is an increase in disk storage on the server.

Transforming XML into HTML for every browser

The help pages were designed when the minimal standard HTML was version 3.2 and, since then, many developments have brought us HTML5 in all major browsers. There is little advantage now to keep the current XML, and all of its designed functionality can be replaced and improved by HTML, CSS and JavaScript, for example, adding better navigation and multimedia contents.

The new Help page layout benefits of many modern technologies

(more…)

LibreOffice Migration Workshop in Tirana

I have spent the last weekend in Tirana, the capital city of Albania, with a group of young members of the local LibreOffice/FLOSS community – Anxhelo Lushka, Augest Dalliu, Greta Doci, Jona Azizaj, Kristi Progri, Mariana Balla, Marinela Gogo, Redon Skikuli, Sidorela Uku, Silva Arapi and Suela Palushi – for a LibreOffice Migration Workshop.

As everyone can see from the picture, the LibreOffice/FLOSS community in Albania is different from any other open source community, as it has a large majority of women: in fact, the workshop was attended by seven women – Greta, Jona, Kristi, Mariana, Marinela, Sidorela, Silva and Suela (plus another two or three for a few hours) – and three men: Anxhelo, Augest and Redon.

We have planned the workshop at the end of OSCAL, the local FLOSS conference I have attended in mid-May, after a meeting with several representatives of the city of Tirana – organised by Redon Skikuli, and attended by Anxhelo Lushka, Jona Azizaj and me – during which the authorities have expressed their interest in LibreOffice.

During the two days of the workshop, we have covered a large number of topics, from the history of LibreOffice – including development, and activities focused on improving quality and reliability of the software such as Coverity Scan and OSS-Fuzz – to the Migration Protocol and the Training Protocol.

We have gone through every step of the Migration Protocol and we have focused on the different activities included in the analysis, as during the upcoming months the local team will support the city of Tirana for this stage of the project, to help understand the challenges of the migration to LibreOffice.

Last, but not least, I have presented – for the first time – the new slide deck explaining the advantages of ODF vs OOXML to end users, based on the extensive research on the subject I have done during the last six months.

All slide decks will be uploaded to TDF wiki during the next weeks (https://wiki.documentfoundation.org/Gallery_Presentations).