The Document Foundation Planet


September 25, 2018

TDF Infrastructure Status

LibreOffice - monitoring

Resolved - 2018-09-25 21:09:59 UTC

LibreOffice check failed (server time: 2018-09-25 21:09:31 UTC)

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

by The Document Foundation's Infrastructure Status at September 25, 2018 09:09 PM

September 24, 2018

TDF Infrastructure Status

piwik - monitoring

Resolved - 2018-09-24 01:09:16 UTC

piwik check failed (server time: 2018-09-24 01:05:16 UTC)

Expected HTTP response status: 200, got: 502

by The Document Foundation's Infrastructure Status at September 24, 2018 01:05 AM

September 23, 2018

Andreas Mantke

Communication Is Always An Interesting Topic

You could always learn a lot about the body of an organization, if you start a communication about transparency and in this context the publishing of numbers. I asked for such numbers about the current financial situation of the organization and got the answer that they will not be published monthly but only quarterly, because the publication process is very time consuming for the staff. I had again a look onto the wiki site today, where this data were published and ‘trara’ the latest monthly data for July 2017 were published one day after the email conversation. And if I remember correctly the third quarter of a year doesn’t end with the month July. But maybe that’s my fault 😉

by Andreas Mantke at September 23, 2018 09:37 AM

September 22, 2018

Official TDF Blog

LibreOffice at droidcon Vienna

LibreOffice is available for Android smartphones and tablets – albeit as a “Viewer” application, for checking documents on the go. There is an experimental editing mode, but it still needs more work, and we’d love to have more help and feedback to improve it!

So to spread the word amongst potential contributors, Christian “Cloph” Lohmaier (LibreOffice’s release engineer) and Mike Saunders attended droidcon Vienna on 21st and 22nd of September.

Organised by AndroidHeads and the Google Developer Group Vienna, droidcon is made up of 20 sessions on various topics. On the first day, Cloph gave a talk titled “Struggles with a large native app, LibreOffice’s attempts at Android”, describing the first stages of development of the LibreOffice Viewer, challenges faced along the way, and the next steps to take. Full slides from the talk are here.

At the end of the talk, there were some questions from the audience about the build process and testing. As Cloph explained, the Viewer app doesn’t have many user interface elements to test, so the main issues are related to the “lifecycle” – ie when users open and close the app, rotate their devices, and so forth. And regarding the build system, Cloph noted that it’s much better today, compared to the early days of the app.

Meanwhile, one of the recurring topics at the conference was Kotlin, a “statically typed programming language for modern multiplatform applications” that runs on the Java VM. Kotlin is growing in popularity, so if you’re interested in the language and the possibility of converting the LibreOffice Android apps (including the Impress Remote), give us a hand! Our wiki has information on building the apps, and you can also talk to our developer community on IRC and mailing lists too.

Finally, after the first day of droidcon, there was an evening party with more opportunity to share ideas and meet people. So thanks to the organisers, and now we move on to the LibreOffice Conference 2018 in Tirana, which is just a few days away…!

by Mike Saunders at September 22, 2018 08:49 AM

September 21, 2018

Collabora Community

LibreOffice Conference 2018 – Talks from Collabora

We are looking forward to the LibreOffice Conference 2018, starting on September 25 in Tirana, Albania! Just like at the previous LibreOffice conferences, there will be talks from people that work at Collabora Productivity, talking about LibreOffice desktop and Online development, new features, security, testing, use cases and a lot more!

You can find more detailed info on the talks from Collabora, ordered by date and time, below:

Reducing Build Time

The LibreOffice code base is large, complex and takes a long time to build. The aim of his talk is to present the various ways developers can use to reduce the time spent building, ranging from usage of various build tools like icecream and ccache to somewhat dirty but definitely working tricks. Aimed primarily at less experienced developers but there should be some tricks for the advanced ones as well.

Speaker: Luboš Luňák
Room: Track Room 2
Day: Wednesday, September 26
Start: 14:30
End: 15:00

Improving LibreOffice as a MSO replacement for Automation and VB Clients

LibreOffice has for a long time contained support for clients on Windows connecting through Automation (previously known as ‘OLE Automation’). However, there were several missing features in that functionality. Also, in real life, the common use case would probably be a client written to work against Microsoft Office, that a customer would want to use unchanged against LibreOffice instead. That requires LibreOffice to provide an interoperable API to the extent that client needs. Much of such API is already present in LibreOffice, as VBA compatibility for Basic macros. Collabora Productivity has worked on improvements to the Automation support in LibreOffice and implemented a tool called COLEAT (for Collabora OLE Automation Translator) that goes in-between for instance a VB6 client and LibreOffice. It translates the client’s use of MSO APIs, that was fixed when the client was compiled, into the more dynamic late binding approach that LibreOffice supports. The tool can also be used to trace the APIs used by the client against an actual MSO instance, to find out what needs to be added to LibreOffice.

Speaker: Tor Lillqvist
Room: Track Room 2
Day: Wednesday, September 26
Start: 15:00
End: 15:30

Image Handling Rework

The life-cycle of images in LibreOffice had a flaw which could potentially lead to image loss. This flaw was fixed in LibreOffice 6.1, so that at any time it is known if the image is used somewhere in the system or not with a standard reference counting technique. At the same time, it was also necessary to change certain algorithms as the life-cycle change completely changed how certain aspects of image handling (swapping in particular). In this talk, he will describe the life-cycle problem in details, how this was solved and eventually implemented. He will also explain what enhancements can be done in the future to make handling of images even better, faster and consume less memory.

Speaker: Tomaž Vajngerl
Room: Main Room
Day: Wednesday, September 26
Start: 16:30
End: 17:00

New features in the Online since the last conference

Come and hear what has happened in the Online since the last conference! The dialog routing has been implemented, bringing in a lot of existing dialogs, new functionality in the toolbar, new translation mechanism saving work of the l10n team, scripting of the Online from Python and more.

Speaker: Jan Holesovsky
Room: Track Room 2
Day: Wednesday, September 26
Start: 16:30
End: 17:00

PDFium for better PDF rendering and editing

PDFs are complex documents. Rendering them accurately, let alone editing them, can be quite challenging. PDFium is a world-class PDF rendering and parsing library. With it, LibreOffice will render PDFs far more accurately than before and allow for improved editing experience for the user. This is an overview of the first steps towards that end and the challenges met and those outstanding.

Speaker: Ashod Nakashian
Room: Main Room
Day: Wednesday, September 26
Start: 17:00
End: 17:30

Improving Calc parallel calculations

Last year Calc gained a fourth method of calculation in addition to OpenCL, so-called software interpreter and the normal single-threaded calculation: Multithreaded formula group calculation. This talk will present progress of this method, the challenges and problems of this approach, ways to handle them and the resulting improvements in Calc performance.

Speaker: Luboš Luňák
Room: Main Room
Day: Wednesday, September 26
Start: 17:30
End: 18:00

Interoperability challenges: working with tables in Word and Writer

In Writer, the experience of working with documents containing tables originating from Word is often less than ideal, especially when certain table property settings are involved, one of the most problematic ones being the Wext wrapping: Around property. The talk will go over the differences in table handling between Word and Writer, what the current pain points are, what has been done to mitigate them, and what could be done to further improve the situation. The target audience is QA/end users with some technical inclination.

Speaker: Aron Budea
Room: Track Room 1
Day: Wednesday, September 26
Start: 17:30
End: 18:00

Central Configuration Management for LibreOffice in Windows networks

This talk is dedicated to different aspects of administering LibreOffice deployments to multiple boxes in corporate environments, where administrators face needs of doing company-wide changes to configurations, or maintaining different configurations for different teams across the company; and they need doing that efficiently both in terms of their effort, and of users’ experience (and without noticeable downtimes).

Speaker: Mike Kaganski
Room: Track Room 2
Day: Wednesday, September 26
Start: 17:30
End: 18:00

Database migration in LibreOffice

LibreOffice Base can store HSQL database files inside its file structure.
However, this feature is deprecated. The talk will walk through the steps of creating a library capable of converting HSQLDB databases into Firebird or any other formats supported by LibreOffice. Further possibilities for improvement, the most painful problems, and upcoming bugs will also be discussed.

Speaker: Tamas Bunth
Room: Main Track
Day: Wednesday, September 26
Start: 18:00
End: 18:30

Meet the Engineering Steering Committee

LibreOffice’s more significant engineering decisions are made each week
during a conference-call packed with engineering talent and experience. The meetings are public, and minutes and agendas posted to the project lists. Come and meet the people who show up there, raise whatever topic you like. They will discuss how they can get more people involved in what they do,
and any hot topics of the day.

Speaker: Michael Meeks
Room: Main Track
Day: Thursday, September 27
Start: 09:30
End: 10:30

Shrink and Load: Optimizing for speed and footprint

Responsive loading of documents is key to the best user experience. With larger documents, this can become challenging. Even when the amount of data to load is large, being responsive and giving the user the initial glimpse of the is often critical. In addition, scalability is vital to integrator and hosts, who want their cloud solutions to serve more users with more documents on a given hardware. To that end reducing the memory consumption improves both scalability and, often, performance in general. This talk is about improvements on both fronts.

Speaker: Ashod Nakashian
Room: Main Track
Day: Thursday, September 27
Start: 11:00
End: 11:30

Economics, Marketing & LibreOffice

How can we make LibreOffice a fun and rewarding place for volunteers, and companies? How can we explain how things work easily to our millions of users and hundreds of contributors to set the right expectation and to build the best office suite ever together. Come and hear an outline sketch of several models, some strengths and weaknesses of how the LibreOffice model works currently, and how we can improve that.

Speaker: Michael Meeks
Room: Track Room 1
Day: Thursday, September 27
Start: 12:00
End: 12:30

Level 3 support case studies

TDF recommends deploying LibreOffice in production environments with the backing of certified professionals, providing development, migration and training support. Having a Level 3 support contract (for fixes at the source code level) is truly beneficial not only for the organization who pays for new features or bug fixes but for the entire community. In the talk, a few examples of the benefit of real support will be demonstrated.

Speaker: Andras Timar
Room: Track Room 1
Day: Thursday, September 27
Start: 15:30
End: 16:00

Profiling with Callgrind

Callgrind is a Valgrind tool for profiling that records call history among functions in a program’s run. This data can be viewed and analyzed in the KCachegrind application. The talk will focus on explaining how to use the tool and how to understand the information they provide and practical examples of how it can be used to identify bottlenecks in LibreOffice code.

Speaker: Luboš Luňák
Room: Main Track
Day: Thursday, September 27
Start: 16:30
End: 17:00

Latest improvements in PPTX support

Szymon will present changes made since the last year in fields like: document theming, animations support and providing better quality of exported files without broken content.

Speaker: Szymon Klos
Room: Main Track
Day: Friday, September 28
Start: 11:00
End: 11:30

Editing ReqIF-XHTML fragments with Writer

The LibreOffice Writer HTML filter is one of Writer’s oldest import/export filters, created long before XHTML was invented. There was an earlier effort to create a separate XHTML export based on XSLT, but that has a number of limitations. A new approach is to add XHTML mode to the HTML import and export that works with XHTML files, including its Requirements Interchange Format (ReqIF) subset. The talk will walk through a number of situations where improvements have been done and present the results. Come and see where we are, what still needs to be done, and how you can help.

Speaker: Miklos Vajna
Room: Main Track
Day: Friday, September 28
Start: 11:30
End: 12:00

Adding support for grouping header entries in Calc Online

The goal of providing to the user the ability of grouping rows or columns in Calc Online required several changes. On the core side that meant to add group information to the usual headers data fetched by the client. We switched from a data entry for each displayed row/column header entry to a single data entry for each range of rows/columns of the same size and belonging to the same group. This feature improves both document loading time and minimizes data traffic between the core and the client. On the client side instead of creating row/column header entries and group tree-like structure as HTML elements, we render them through Canvas drawing primitives. This solution provides us with more flexibility and better performance.

Speaker: Marco Ceccheti
Room: Main Track
Day: Friday, September 28
Start: 12:00
End: 12:30

Async dialog execution – what is that and why it’s needed

The last year, we started routing dialogs from the LibreOffice core to Online, extending the Online’s functionality dramatically. It all worked fine, with one exception – when multiple users have opened the same dialog concurrently, the changes couldn’t be applied to the
document until after all the users have closed the dialog. The solution to this problem is asynchronous dialog execution. This talk will summarize the general concept, several dialog conversions to async, and the caveats of such conversions.

Speaker: Jan Holesovsky
Room: Main Track
Day: Friday, September 28
Start: 12:30
End: 13:00

Recent Mac-specific bug fixing and possible future Mac-specific work

Using proceeds from the sales of LibreOffice Vanilla on the Mac App Store, Collabora has been able to spend some time on fixing Mac-specific bugs in LibreOffice. This talk will provide a brief overview of some of those, and Tor will also look into some potential areas for Mac specific work in the future.

Speaker: Tor Lillqvist
Room: Main Track
Day: Friday, September 28
Start: 14:30
End: 15:00

The post LibreOffice Conference 2018 – Talks from Collabora appeared first on Collabora Productivity.

by Jona Azizaj at September 21, 2018 01:01 PM

September 20, 2018

Andreas Mantke

A Quick Test With Plone 5.2 And Python 3.6.5

I created an buildout from the Plone corebot Github repository. I used the current development version 5.2 and run it on a Python 3.6.5 virtual environment. The buildout of the Plone instance took some time, but everything went well and I could create a new Plone site. I added the multilanguage addon to it and played a bit with the site. I added second language to the site, created a new page and tested the translation framework that came with the addon. It worked as expected and I got a page with a linked translation.

Then I tried out how the website of the Documentation would look like in a pure (not specially branded) Plone environment. I did a quick and dirty copy and paste of the homepage of TDF and the new Plone page was done in 1 minute. The page uses the default Plone layout and there were no issues with different screen size.

Document Foundation Homepage on Plone 5.2
Document Foundation Homepage On Plone 5.2 – Mobile Device Screen Size

by Andreas Mantke at September 20, 2018 07:38 PM

September 19, 2018

TDF Infrastructure Status

AskBot - monitoring

Resolved - 2018-09-19 15:18:20 UTC

AskBot check failed (server time: 2018-09-19 15:08:22 UTC)

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

by The Document Foundation's Infrastructure Status at September 19, 2018 03:08 PM

Jean Hollis Weber

LibreOffice 6.0 Getting Started Guide published

Cover of Getting Started with LibreOffice 6.0In September 2018 Friends of OpenDocument published the printed edition of the LibreOffice 6.0 Getting Started Guide, written by the LibreOffice Documentation Team. Free PDFs and ODTs are available from the LibreOffice website. Purchase printed copies from our store at

by Jean at September 19, 2018 09:06 AM

TDF Infrastructure Status

Planned Jenkins (CI) outage

Our Jenkins instance will briefly become unavailable while we're upgrading the OS.

Update (00:50 UTC): Upgrade successful, Jenkins is back up.

by The Document Foundation's Infrastructure Status at September 19, 2018 12:00 AM

September 18, 2018

Official TDF Blog

#IDAD, International Day Against DRM

Today we are celebrating the International Day Against DRM.

DRM, or Digital Rights Management, is a set of access control technologies for restricting the use of proprietary hardware and copyrighted works, by controlling the use, modification, and distribution of copyrighted works. Instead of educating users, companies prefer to restrict them from exercising their legal rights under the copyright law, such as backing up copies of CDs or DVDs, lending materials out through a library, accessing works in the public domain, or using copyrighted materials for research and education under the fair use doctrine.

DRM is an epidemic spreading across the Web, infiltrating homes, classrooms, workplaces, and just about everywhere else users can go. Tools, technologies, books, games, movies, and music are coming to us locked down with DRM, whether they are streaming or claim to be locally hosted.

DRM can be associated to document lock in by means of pseudo-standards. They are both hidden to users and reduce their freedom as they make sharing contents – even when fully legitimate – completely or partially impossible.

The Document Foundation supports the International Day Against DRM as part of its daily fight to make content sharing available to all individuals, and to educate them to adopt open standards to foster innovation.

by Italo Vignoli at September 18, 2018 10:50 AM

September 17, 2018

Official TDF Blog

Documentation: Getting Started Guide 6.0 released

LibreOffice’s Documentation Team releases the Getting Started Guide 6.0, the introductory text for all LibreOffice applications and more.


Covering spreadsheets, presentations, texts, drawings, databases and the equations editor, as well as other important concepts in LibreOffice, the guide updates the previous book for LibreOffice 5.2 with the features implemented up to the 6.0 release. As it’s an introductory text, some advanced topics were left out, and are to be addressed in the other specialized modules guides, such as the Writer Guide 6.0. This turns the Getting Started Guide into a light reading on all of LibreOffice’s most important features and concepts.

“We are pleased to announce the release the new Getting Started Guide 6.0, bringing the contents closer to the latest version of the software. With this effort we also want to improve the documentation development process, and deliver the next update in much shorter time frame” said Dave Barton, member of the Documentation team. “We will begin the Getting Started 6.1 Guide project shortly” he added.

“The Guides update has been a very long process and revealed issues especially with revision, which is a very time consuming task and hard to carry out. A delicate balance is necessary between contribution and revision. We would like to try a time-based release of the next guide” said Olivier Hallot, Documentation Team Coordinator. “We will announce new methods and tools to speed up the authoring and release of the Guides”, he added.

The Guide was assembled using the techniques of the LibreOffice master document, a container of linked individual chapters, allowing the update of the chapters to be carried out automatically for the final document. The master document was then the source for exporting the Guide in PDF,  EPUB and ODT formats for download.

The Getting Started Guide 6.0 is available for download in the documentation website at and the individual chapters and master document are in the TDF wiki at .

LibreOffice 6.0’s Getting Started Guide is also available as a printed book from Lulu, by Friends of Open Document Inc., an Australia-based volunteer organization with members around the world, which will be using profits from the sale to benefit the LibreOffice community.

by Olivier Hallot at September 17, 2018 03:46 AM

TDF Infrastructure Status

piwik - monitoring

Resolved - 2018-09-17 01:24:16 UTC

piwik check failed (server time: 2018-09-17 01:01:16 UTC)

Expected HTTP response status: 200, got: 502

by The Document Foundation's Infrastructure Status at September 17, 2018 01:01 AM

September 16, 2018

Andreas Mantke

Working On A New Python-Script For Extension Evaluation

I started my work on a new Python script to evalute LibreOffice extensions. It’s currently in a very early state and I’m going to use only very limited spare time to update it. I’m going to concentrate on more healthy activities than sitting in front of PC. Thus don’t be surprised if this and other task will not be finished immediately. I’ll adapt my workflow / workload to the favored range of the open source project, particularly it’s only pure volunteer work.

by Andreas Mantke at September 16, 2018 07:07 PM

Another Workshop Invitation For SmartCity Duisburg

I got a further invitation for a workshop of the project SmartCity Duisburg.  It focus on creative ideas for the economic development and takes place at September, 27. I’m looking forward to open discussion.

by Andreas Mantke at September 16, 2018 11:45 AM

September 14, 2018

Collabora Community

FLOSS Weekly Interview – LibreOffice Online

On Sept. 13 we were featured at FOSS Weekly where Michael Meeks presented Collabora’s work to bring LibreOffice to the browser. If you want to know more about how it works, the distinctive features etc – check out the interview.

The post FLOSS Weekly Interview – LibreOffice Online appeared first on Collabora Productivity.

by Jona Azizaj at September 14, 2018 05:02 PM

Michael Meeks

2018-09-14 Friday

  • Pleased to my chat with Randal & Dan at FLOSS Weekly published.
  • Booked travel to DINAcon 2018 will be available to do some LibreOffice hackfest'y stuff, and a talk on "How best to migrate to LibreOffice".

September 14, 2018 04:51 PM

Collabora Community

Updated LibreOffice growth infographic for 2018

We have updated our LibreOffice growth infographic for 2018 (previous versions: 2014, 2015, 2016 & 2017), recollecting the most interesting LibreOffice figures and visualizing them in an easy to read and share infographic.

Numbers are growing and the Collabora Online Development Edition (CODE) is very popular now, with currently over 7.5 million Docker image pulls! Also, this year we are the top code contributors to LibreOffice with 5302 code commits.

We are looking forward to seeing you at the LibreOffice Conference 2018 (September 25 to September 28), where you can meet us and attend one of our many interesting talks!

Check out the updated LibreOffice growth infographic on 2018 here:

The post Updated LibreOffice growth infographic for 2018 appeared first on Collabora Productivity.

by Jona Azizaj at September 14, 2018 03:16 PM

September 13, 2018

Michael Meeks

2018-09-13 Thursday

  • Mail; distracted by a bit of hacking for a customer. Marketing & Sales call, ESC call, early dinner, interview.
  • Pleased to see Jona publish our latest LibreOffice Infographic giving an update on what we're doing.

September 13, 2018 09:00 PM

Andreas Mantke

First SmartCity Duisburg Workshop eGovernment

I got an invitation to the eGovernment workshop of the SmartCity Duisburg innovation initiative some days ago and attended this workshop today. It’s an initiative from the city Duisburg.

The events purpose was the opportunity for the citizens to participate in the process and add new / further ideas to the list of proposals. There were round tables for different topics and everyone has the opportunity to work in two of this rounds (not at the same time). I joined the topic about the service for the citizens first and later the one about communication. It was a great brainstorming and we discussed some new ideas. The groups presented some of this ideas in the end.

The project team will work through this ideas and the other ones that has been written down on the brown paper on the tables.

There will be a following up of this workshop, scheduled for February 2019. I’m going to participate that second eGovernment workshop of SmartCity Duisburg too.

by Andreas Mantke at September 13, 2018 07:25 PM

Official TDF Blog

LibreOffice 6.1.1 released, for early adopters, technology enthusiasts and power users

Berlin, September 13, 2018 – The Document Foundation announces LibreOffice 6.1.1, targeted at early adopters, technology enthusiasts and power users, which provides over 120 bug and regression fixes for the recently announced LibreOffice 6.1.

LibreOffice users can benefit from some of the interesting new features introduced in August:

  • Colibre, the new icon theme for Windows based on Microsoft’s icon design guidelines;
  • The reworked image handling feature, which is significantly faster and smoother thanks to a new graphic manager and an improved image lifecycle;
  • The reorganization of Draw menus with the addition of a new Page menu;
  • The new Online Help pages enriched with text and example files to guide the users through features;
  • Several improvements to all modules of LibreOffice Online, with changes to the user interface to make it more appealing.

Enterprise deployments

LibreOffice 6.1.1 represents the bleeding edge in term of features for open source office suites, and as such is targeted at technology enthusiasts, early adopters and power users.

For any enterprise class deployment, TDF maintains the more mature LibreOffice 6.0.6, which should be sourced from a company providing a Long Term Supported version of the suite (they are all members of TDF Advisory Board, and are listed here:

Also, value-added services for migrations and trainings, to support enterprise class deployments in large organizations, should be sourced from certified professionals (list available here:

LibreOffice is deployed by large organizations in every continent. A list of some large or significant migrations announced in the media is available on the TDF wiki:

Availability of LibreOffice 6.1.1

LibreOffice 6.1.1 is immediately available from the following link: Minimum requirements for proprietary operating systems are Microsoft Windows 7 SP1 and Apple macOS 10.9. Builds of the latest LibreOffice Online source code are available as Docker images:

LibreOffice Online is fundamentally a server service, and should be installed and configured by adding cloud storage and an SSL certificate. It might be considered an enabling technology for the cloud services offered by ISPs or the private cloud of enterprises and large organizations.

LibreOffice users, free software advocates and community members can support The Document Foundation with a donation at

LibreOffice 6.1.1 is built with document conversion libraries from the Document Liberation Project:

by Italo Vignoli at September 13, 2018 11:17 AM

September 12, 2018

Michael Meeks

2018-09-12 Wednesday

  • Admin; consultancy customer feedback process bits, mail. Band practice with H. in the evening.

September 12, 2018 09:00 PM

September 11, 2018

Michael Meeks

2018-09-11 Tuesday

  • J. out for new counselling course. Mail chew; sync with Andras, mail & admin. Lunch. Picked E. up from school. Built ESC agenda.
  • Thrilled to get a call from the airline letting me know that my flight had one leg cancelled for 'technical reasons' (its good to be able to predict plane failure a week+ in advance). Offered lots of unhelpful flights that arrive at the wrong time. Re-booked on BA arriving in Tirana a day earlier; fun. Attempted a fix of a sax parser, threading cleanup on exceptions fix during the various calls.

September 11, 2018 09:00 PM

Official TDF Blog

Four ways you can make LibreOffice even better

Every new major release of LibreOffice includes new features and updates – but they don’t happen by magic! They’re created by a worldwide community, and you too can join in and help to improve the software. See the graphic below for some ideas – and then visit our site to learn more!

by Mike Saunders at September 11, 2018 12:14 PM

September 10, 2018

Michael Meeks

2018-09-10 Monday

  • Out for a run with J. - locked us out; spent some time re-leading & puttying in the glass pane broken while attempting removal - bother. Mail chew.
  • Occasionally I have to use skype: the customer is always right. When I do - I wonder why they recommend searching for "Echo / Sound Test Service" - rather than providing a helpful built-in link somewhere, and/or why they didn't restratin the rather large number of unhelpful people calling random accounts the same thing - to the point that it's impossible to test your sound; amazing. All the lonely people - where do they call come from ? Luckily skype provides a friendly 'location' breakdown so it's easy to see.

September 10, 2018 09:00 PM

Olivier Hallot

Hovering icons in Help pages

Last week I implemented a feature in our help pages using a modern CSS (Cascade Style Sheets) technique when hovering the mouse pointer on icons displayed in the page: the hovered icon is enlarged twice its size.

Almost every icon in the help pages are sized 0.22 in x 0.22in (~0,5cm x 0,5cm) which is sometimes a bit too small, especially with minimalistic designed icons such as the Colibre icon family. Enlarging the icons helps user to visualize and since it was implemented in CSS, there was no need to change the icons dimensions in the source help pages.

To see it working, please check this page and hover the mouse on icons.

Normal size

Enlarged on hover

Comments and suggestions are welcome.

Happy icon hovering!

by Olivier Hallot ( at September 10, 2018 07:41 PM

September 07, 2018

LibreOffice QA Blog

QA Report: August 2018

Reported Bugs

599 bugs have been reported by 335 people.

Top 10 Reporters

  1. Telesto ( 53 )
  2. andreas_k ( 25 )
  3. Regina Henschel ( 19 )
  4. Xisco Faulí ( 13 )
  5. Gabor Kelemen ( 12 )
  6. Albert Acer ( 11 )
  7. Jim Raykowski ( 10 )
  8. Oliver Brinzing ( 10 )
  9. Diogo G. Sousa ( 9 )
  10. Mike Kaganski ( 8 )

Triaged Bugs

509 bugs have been triaged by 72 people.

Top 10 Triagers

  1. Xisco Faulí ( 143 )
  2. raal ( 29 )
  3. Timur ( 27 )
  4. Heiko Tietze ( 27 )
  5. Dieter Praas ( 24 )
  6. Roman Kuznetsov ( 20 )
  7. Buovjaga ( 20 )
  8. V Stuart Foote ( 19 )
  9. Julien Nabet ( 19 )
  10. Alex Thurgood ( 18 )

Fixed Bugs

145 bugs have been fixed by 31 people.

Top 10 Fixers

  1. Caolán McNamara ( 29 )
  2. Mike Kaganski ( 12 )
  3. Justin Luth ( 11 )
  4. Eike Rathke ( 10 )
  5. Julien Nabet ( 9 )
  6. Jim Raykowski ( 8 )
  7. heiko tietze ( 7 )
  8. Maxim Monastirsky ( 6 )
  9. Xisco Fauli ( 5 )
  10. Miklos Vajna ( 5 )

Verified Bugs

69 bugs have been verified by 47 people.

Top 10 Verifiers

  1. Xisco Faulí ( 6 )
  2. Telesto ( 5 )
  3. Jim Raykowski ( 4 )
  4. Roman Kuznetsov ( 3 )
  5. Aron Budea ( 3 )
  6. Luke ( 3 )
  7. Alexander Polkhovskiy ( 2 )
  8. Marco A.G.Pinto ( 2 )
  9. Dom Walden ( 2 )
  10. Gabor Kelemen ( 2 )

Categorized Bugs

328 bugs have been categorized with a metabug by 20 people.

Top 10 Categorizers

  1. Xisco Faulí ( 106 )
  2. Thomas Lendo ( 97 )
  3. Dieter Praas ( 38 )
  4. V Stuart Foote ( 14 )
  5. Telesto ( 14 )
  6. andreas_k ( 13 )
  7. Aron Budea ( 9 )
  8. Roman Kuznetsov ( 9 )
  9. Olivier Hallot ( 7 )
  10. Buovjaga ( 4 )

Bisected Bugs

101 bugs have been bisected by 9 people.

Top 10 Bisecters

  1. Xisco Faulí ( 74 )
  2. raal ( 9 )
  3. Aron Budea ( 8 )
  4. Justin L ( 3 )
  5. Telesto ( 2 )
  6. Buovjaga ( 2 )
  7. am_dxer ( 1 )
  8. Terrence Enger ( 1 )
  9. Muhammet Kara ( 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: August 2018 appeared first on LibreOffice QA Blog.

by x1sc0 at September 07, 2018 01:53 PM

Miklos Vajna

Custom user profiles with unoconv

Background: I was benchmarking Online vs jodconverter vs unoconv the other day for Collabora’s document conversion page. One problem with measuring unoconv performance was that it provided no ways to run multiple unoconv processes in parallel, while the underlying soffice binary obviously allows this.

So while unoconv is not capable of launching the soffice process in a chroot (improves security), nor is capable of forking an already pre-initialized soffice process (improves performance, both are things Online can do for you), there is no real reason why you should not be able to run multiple unoconv processes in parallel. The previously mentioned benchmarking would be quite unfair if even this kind of multiprocessing would be ignored, but unoconv had no way to specify a custom user profile, which has to be different for each soffice process.

So I filed a GitHub pull request on 1st Jun, and finally it was merged on 10th Aug.

Here is how you can use it for example:

unoconv --user-profile /tmp/tmpf_yreswi -f pdf --port 2002 test.txt
It’s your responsibility to give --port a unique value, but that’s not too hard: if you use a thread pool to launch the unoconv processes, then you can add the thread index to a base port and that will give you a unique port.

So this is available in unoconv master (towards unoconv 0.8.2+1), you can grab the sources from git and try it out right now. :-)

September 07, 2018 07:57 AM

September 06, 2018

September 05, 2018

>Marius Popa Adrian

Firebird has now automatic Windows builds with AppVeyor

Firebird has now AppVeyor CI builds, like we have them with travis, but AppVeyor is for Windows related compilers (Visual Studio)

by Adrian Marius Popa ( at September 05, 2018 03:09 PM

August 29, 2018

Andreas Kainz

Context Menubar

I need feedback for a Context Menubar update. Discussion please at bugzilla.

The overall idea was written in tdf#119398 where I also add an screenshot of the first 5 context menues to get an overview.

1. Graphic context menu tdf#119412

Contextmenu Change Request_01_graphic.png

Left is always LibreOffice 6.1 and right is the proposal change.

2. Draw context menu tdf#119506

Contextmenu Change Request_02_draw.png

3. Media context menu tdf#119532

Contextmenu Change Request_03_media.png

4. OLE context menu tdf#119580

Contextmenu Change Request_04_oleobject.png

5. Form context menu tdf#119532

Contextmenu Change Request_05_form.png


Structure of all 5 context menus are similar

  1. cut, copy, paste
    is always the same (tdf#119581 switch to copy, cut, paste)
  2. “EDIT” group
    for graphic edit graphic with crop, save, …
    for draw edit points
    for media nothing, cause play, pause isn’t available
    for OLE nothing
    for form Control, Form and Replace with
  3. Dialogue group
    position, line, area
    position is importend for draw and impress, in writer and calc ordinary not
    line and area if available
  4. Arrange and Transform group
    Anchor, Wrap, Align, Arrange, Rotate or Flip, Transformations, Convert
    sorting is always the same
    Transformations and Convert are available in Draw and Impress
  5. Description and Style group
    Will show Caption, Properties, Name, Style, …
    in writer it’s Insert Caption
    in calc it’s assign Macro
    in draw it’s Name to rename items for better navigation in the navigator
    in impress it’s interaction
    draw and impress support “simple” style functions.

If you’d like my work and be part of the story become a Patreondownloads_wordmark_white_on_coral2x.jpg

by kdeonlinux at August 29, 2018 08:39 AM

August 26, 2018

Andreas Kainz

Contex menu

The last week(s) I played around with the different xml files in popupmenu for the different LibreOffice apps.

First I had to learn a lot, cause I found out that Jay did a lot in the past and LibreOffice is not a “playground” project anymore. There are millions of users out there and they need stabilisation and no renewal for each release. So good news.

On the other Hand, I start learn how it work and found out some missing app consistency so I’d like to submit patches to show our users that LibreOffice consist of severall apps but the behavior is the same everywhere.


You can follow the discussion by add you to the Context Menu Meta bug. Discussion for Draw and Graphic contextmenues.

by kdeonlinux at August 26, 2018 03:44 PM

August 22, 2018

Olivier Hallot

Compress Images

I just submitted a patch for LibreOffice Help to document the Compress Image feature.

The Compress Image feature is active when an image is selected and you want to change the data size of the image, at the expense of a optional and controllable loss of quality set in a dialog box.

The Compress Image dialog

Compressing is useful if you insert a high resolution image in a document. For example a 4000x4000 pixel image in bitmap format (BMP) is approximately of  48MB size, which can turn you document edition hard in constrained-resources computers. By compressing the image with the right format and quality index you can reduce the size of the picture with no loss of visual quality and have the document file much lighter to edit.


by Olivier Hallot ( at August 22, 2018 11:41 AM

August 21, 2018

Collabora Community

Meet us this weekend in Berlin, Germany!

The Nextcloud Conference

Collabora will be attending the Nextcloud conference – an annual conference that brings the global Nextcloud Contributor Community together for a week of coding, design, discussion, talks & fun. The conference will be held from 23 to 30 of August 2018 in Berlin, Germany – at the Mathematics building of the Technical University of Berlin.

During the hackweek days participants will get together to code, write Nextcloud apps, improve design etc. On the weekend of August 25 and 26, will be different talks, keynotes, and workshops. Our own Tor Lillqvist will be there to talk about Collabora Online. His talk will be on August 25 at 11:32 AM and will present the work we have done on Collabora Online during the last year.

Check out the agenda for more details.

Nextcloud conference - group photo

The Enterprise Day

August 27, will be the Enterprise Day that takes place the day after the Nextcloud conference and features a track of technical sessions covering a wide range of enterprise use cases. Michael Meeks will have a talk about Collabora Online – if you want to know more about us feel free to attend his talk at 11:30 – Park Inn at Berlin Alexanderplatz.

Say hi to us!

Do you have any questions, feedback or you just want to hack with us? Let’s meet in Berlin at the Nextcloud conference – drop us an email at and we would be very happy to meet you there.

The post Meet us this weekend in Berlin, Germany! appeared first on Collabora Productivity.

by Jona Azizaj at August 21, 2018 09:15 AM

Jean Hollis Weber

Writer 6.0 Guide published

Writer Guide 6.0 coverThe LibreOffice Documentation Team has published the Writer Guide for version 6.0. It is available for free download (PDF) from the LibreOffice website or can be purchased from the Friends of OpenDocument store at

by Jean at August 21, 2018 01:41 AM

August 16, 2018

Naruhiko Ogasawara

One-day trip for COSCUP x GNOME.Asia x openSUSE.Asia 2018

Last weekend (precisely, Aug. 11th and 12th 2018), COSCUP x GNOME.Asia x openSUSE.Asia 2018, one of the largest FLOSS-related conference in Eastern Asia this year, has done with huge success, gathered many attendees not only from Asian regions but also outside of Asia.

I had only attended the Sunday the conference because of unfortunate reason, but I really had enjoyed the day!

The slide of my presentation for openSUSE.Asia track is here.

As the title mentions, I would like to tell average Linux users to use the modern packaging system (in this context, Flatpak or AppImage) instead of using TDF rpm/deb packages with dnf, zypper or apt, if you want to follow a latest Fresh version of LibreOffice.  Some reasons it couldn't attract many people, It was a good opportunity for me to summarize these systems.
Right now I haven't switched them from distro-official one (LibO 6.0) on my Ubuntu bionic desktop yet because of my laziness, but I'll move to Snap or Flatpak, not using classical PPA build.

Shinji Enoki also from Japan had a talk to summarize LibreOffice CJK issues status and said so many thanks to Mark Hung, who is solved several CJK issues in LibO 6.1.  Of course, I also would like to say thanks to him :).
In this session, we had a little time to discuss how to encourage each language community (for us from Japan and Daehyun Sung from South Korea, or else).  Of course, it's a difficult question to answer, but we can do something together to do so I guess.  What we can do with is a good discussion point in Tirana I guess ;).

[UPDATE 2018.8.16] I forgot to mention one more thing which is important for Japanese users; Support new era (next to Heisei) of the Japanese calendar.  Mark Hung also tell us this has been already (almost) done and may need a small modification after the new era will be decided.  Here is a commit  Thanks, Eike!

And we have a small booth to introduce Japanese FLOSS communities (to me, LibreOffice and Selenium users community JP) for (mainly) Asian people.
Advertisement: Selenium world conference SeleniumConf 2019 will be in Tokyo. We are preparing the site for now, and Call for proposal for sessions will be opened soon.

I only had one day (because my flight 10th evening was canceled and the extra flight departed 11th evening) but really had a great time.  Thanks, friends who I met and see you around!

by Naruhiko Ogasawara ( at August 16, 2018 02:03 PM

August 12, 2018

Ekansh Jha

Google Summer of Code — Final Submission

Image result for libreoffice gsoc

For the last three months, I’ve been working with Libreoffice, an open source organisation selected for the Google Summer of Code program. Working at LibreOffice has been a great experience for me. It has been really steep learning curve this summer under Google Summer of Code. This has further enhanced my interest towards open source.

Project Motivation and Overview

SmartArt is a nice feature that allows users to quickly add charts/diagrams to presentations. LibreOffice has a partial implementation as an experimental feature, my project was to implement as many features and to correctly render the smartart. Interested folks can click here.

All GSoC related Patches

In chronological order(Some of them are under review at this point of time):

  1. Unit test for Line algorithm

2. tdf#117761 Corrected Snake Algorithm

3. Smartart: Corrected Line Algorithm

4. coverity#1436015 UNUSED_VALUE

5. Smartart : test documents

6. Unit test for Snake Algorithm

7. Unit test for Chevron Smartart and modified Unit test for Line algorithm.

8. Support txAnchorVert parameter

9. Node layout information

10. Support parTxRTLAlign parameter

11. Support ctrShpMap(Center Shape Mapping) Paramter

12. Smartart Pyramid: Support Inverted Pyramid

13. Unit test: Smartart-Chevron

14. Smartart Inverted Pyramid Unit test

15. Unit test: Smartart Pyramid

16. Composite algorithm: support parameter ar

17. Composite Algorithm: Adding constraint value support

18. Smartart Right to left Chevron

19. Unit test: SmartArt Chevron right to left

20. Smartart: Added Hierarchy Algorithm

21. Support autoTxRot parameter in Text algorithm

22. Support autotxRot

23. SmartArt Pyramid: Now lays out shapes

Future work

There is still a lot of features to implement to correctly render all the smartarts after which, creating of dialogue box to directly create smartart into the document can be done to ease users and increase the productivity.

There was so much to grasp during GSoC and I would like to thank the LibreOffice community for continuously helping and supporting me to complete the project.

Thank you Google for such an awesome summer program.

Quick Links

If you want to contribute to LibreOffice : Get involved

Summer of Code Project Page:

Ideas Page:

Week wise reports:

by Ekansh Jha at August 12, 2018 07:21 PM

Saurav Chirania

GSoC final report - UI logger


The idea of this GSoC project was to implement a feature which logs the interaction of users with the UI elements in an interpretable Domain Specific Language (DSL), and an interpreter which converts the log into a file into something which will help in replaying the user actions. The project involved working with the UI elements and the UI testing framework of LibreOffice.


  • The logger -

    The logging for the following is currently supported -
    1. The UI elements of Visual Component Library like Buttons, Checkboxes, Radio-buttons, Listboxes, Comboboxes, Spinbuttons, etc.
    2. Keys pressed in different UI elements
    3. UNO commands sent with parameters
    4. Selection of Objects
    5. Opening of Sidebar/Deck

    Some application-specific events can also be logged -
    1. Writer - Goto Page, Set Zoom, Text Selection
    2. Calc - Autofilter Launch, Selection of cells/range of cells, Switching of Sheet
    3. Math - Selection of elements from the element selector panel
    4. Impress - Set Zoom

    Additionally, the opening and closing of some dialogs is also logged according to the DSL.

  • The UI Testing Framework -

    We already had a framework for UI testing before the start of the project. Efforts were made to ensure that we can utilize this for the replay of actions to the greatest extent possible. The wrapper classes for a couple of VCL classes were completed. A function to execute UNO commands with parameters was also implemented.

  • The log interpreter -

    The logger logs events in the following grammar -

    <Keyword> <EventDescription> [<Parameters>]

    where EventDescription tells the ID, parent, etc. of the UIObject and Parameters are the parameters of the action user performs in a format directly readable by mkPropertyValues.
    The interpreter starts reading the log file line-by-line and tries to convert the statements into a UI test case. The code for the interpreter can be found in core/uitest/

Merged Patches

  1. uitest logger: support for buttons, dialog, command and key logging
  2. uitest logger: ListboxSelect and ListboxFocus logging
  3. WIP: uitest: complete combobox, tabcontrol wrapper
  4. uitest: interpreter for log files
  5. uitest logger: print parent when logging keys
  6. uitest logger: some changes in log statements
  7. uitest interpreter: add more features
  8. uitest interpreter: let's use argparse to parse arguments
  9. uitest interpreter: add support for starting apps
  10. uitest interpreter: handle when parent is empty string
  11. uitest interpreter: support opening existing document
  12. uitest logger: log the events calling CallEventListeners()
  13. uitest: complete wrapper for SpinField and SpinButton
  14. uitest logger: log key according to DSL inside dialogs too
  15. uitest: support parameters when sending UNO commands
  16. uitest logger: log more events
The list of all my merged patches can be found with this Gerrit search.

Using the logger

As written in the UI Test wiki, the following needs to be done to log the UI actions -

1. Launch LibreOffice like

LO_COLLECT_UIINFO="test.log" instdir/program/soffice

2. Simulate what you want to do with the mouse
3. Close LibreOffice
4. Open the resulting file in instdir/uitest/test.log

The following command can be used to convert to log to UI Test Case:

python3 <path_to_log_interpreter> <path_to_log_file> <path_to_a_new_python_file>

where <path_to_log_interpreter> should be replaced with something like SourceDirectory/core/uitest/
and <path_to_log_file> should be replaced with something like SourceDirectory/core/instdir/uitest/test.log
and <path_to_a_new_python_file> can be a location of your choice where you would like to see the generated code.

Remaining Tasks

  1. Not all UI elements and dialogs are supported by the interpreter/logger/UI testing framework. Eg. - Color selection palette in color Calc -> Format cell.
  2. Enhancement suggestion - After this commit, it will be helpful for the interpreter to locate a UI Object if the logger prints the entire parent hierarchy of the UI object instead of just printing the top window. This would help in resolving UI ID conflicts, as well as in other cases when the interpreter might not locate the object properly otherwise.

Thank You!

Thank you for giving me the opportunity to work on this project. I learned a lot from this project. I will definitely like to spend more time with LO community in future whenever I get time.

PS: The links given to the patches in the post contain a commit message to explain what the patch does. An additional effort to document the UI Test logger can be found at An overview of how UI logging works in LibreOffice.

by Saurav ( at August 12, 2018 11:57 AM

An overview of how UI logging works in LibreOffice

Logging in LibreOffice is mainly handled by a class called UITestLogger, defined here. The logger class logs the user actions only if the member flag mbValid is set to true. The flag can be turned on by setting the environment variable LO_COLLECT_UIINFO to a file name where the logs should be collected (see the constructor of UITestLogger, defined here).

We maintain a pointer to an instance of UITestLogger class here. To use the logger object, the static function getInstance can be used to get access to the pointer.

The function logAction, defined in the same class, is used to log events from the classes which extend the class vcl::Control. The log statements corresponding to a particular class can be found in the function get_action of the UI wrapper classes. Most of the wrapper classes can be found with this OpenGrok search. The log statements get generated when VCL events get broadcasted. A list of the VCL events can be found in the enum class VclEventId here.

For other classes, we have functions named collectUIInformation spread in different places of the code (This OpenGrok search might be helpful). These functions collect information about an event and store it in a struct EventDescription (defined here) and pass it to another function of UITestLogger, called logEvent. The logEvent function constructs a log string using the information provided by the given event description, and finally logs the statement using the file stream maStream.

The log interpreter (made here) can be used to convert the log file into a UI test case. It interprets the log file line-by-line and converts every line into a python dictionary. The dictionaries are then used to generate statements readable by the UI testing framework.

PS: This blog post is an effort to document (and provide code-pointers for) the UI Test logger, parts of which were developed during GSoC 2018. The final report of the GSoC project can be found at GSoC final report - UI logger.

by Saurav ( at August 12, 2018 11:53 AM

August 10, 2018

Jean Hollis Weber

LibreOffice 6.1 released

The Document Foundation has announced LibreOffice 6.1, with a significant number of new and improved features:

  • Colibre, a new icon theme for Windows based on Microsoft’s icon design guidelines, which makes the office suite visually appealing for users coming from the Microsoft environment;
  • A reworked image handling feature, which is significantly faster and smoother thanks to a new graphic manager and an improved image lifecycle, with some advantages also when loading documents in Microsoft proprietary formats;
  • The reorganization of Draw menus with the addition of a new Page menu, for better UX consistency across the different modules;
  • A major improvement for Base, only available in experimental mode: the old HSQLDB database engine has been deprecated, though still available, and the new Firebird database engine is now the default option (users are encouraged to migrate files using the migration assistant from HSQLDB to Firebird, or by exporting them to an external HSQLDB server);
  • Significant improvements in all modules of LibreOffice Online, with changes to the user interface to make it more appealing and consistent with the desktop version;
  • An improved EPUB export filter, in terms of link, table, image, font embedding and footnote support, with more options for customizing metadata;
  • Online Help pages have been enriched with text and example files to guide the users through features, and are now easier to localize.

by Jean at August 10, 2018 02:57 AM

August 09, 2018

Andreas Kainz

LibO svg icon themes

If you need the breeze or colibre icon theme in svg you can download them:

As the svg images are called like the one with png search at your operation system after the zip file and replace (backup first) the png with the svg one.

by kdeonlinux at August 09, 2018 09:24 AM