LibreOffice Conference 2017 – Talks from Collabora

We are looking forward to the LibreOffice Conference 2017, starting on October 11 in Rome, Italy! 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:

Filing better interoperability bugs – from users to development

An essential aspect of LibreOffice is that it can work with documents coming from other office suites. During that, however, we are bound to run into interoperability issues. This talk aims to give techniques that can be used by end users and QA people alike to take a closer look at these issues and process the documents causing bugs, without much information about the formats (eg. to create minimal examples), to provide more relevant details to developers in the bug reports.

Speaker: Aron Budea
Room: Sala della Commissioni
Day: Wednesday, October 11
Start: 16:00
End: 16:30

LibreOffice Code Overview

The LibreOffice code-base is huge. Finding the relevant source code for your bug or feature can be challenging initially. The talk will walk though a number of key modules in our codebase and will give a brief summary on them. Also code documentation techniques used in our code (doxygen, per-module README files) will be presented as well. Come and see how to get from the user interface to the relevant source code, what still lacks documentation and how you can help.

Speaker: Miklos Vajna
Room: Sala della piccola Protomoteca
Day: Wednesday, October 11
Start: 16:30
End: 17:00

Quantum computing with VBA

VBA, the programming language of Excel and other Microsoft Office programs, is also interpreted by LibreOffice with more or less success. Among others, the company D-Wave, the world’s first quantum computing company, decided to use LibreOffice for running their VBA script, using its VBA support. The talk will walk through the improvements made on LibreOffice in order to be able to run the above mentioned macro and improve the efficiency of interpreting vba scripts.

Speaker: Tamas Bunth
Room: Sala della piccola Protomoteca
Day: Wednesday, October 11
Start: 18:30
End: 18:30

LibreOffice Online – new features since the last year

LibreOffice Online is an exciting technology that allows people to edit documents and collaborate on them in a web browser. It is rapidly developing, and has improved a lot since the last year. Come and see all the new exciting features that did not exist in the LibreOffice Online one year ago – like the collaborative editing, user friendly comments, resizing cells in spreadsheets, and much more.

Speaker: Jan Holesovsky
Room: Sala della Commissioni
Day: Thursday, October 12
Start: 9:30
End: 10:00

Pivot Charts

Pivot charts are a new feature available in LibreOffice 5.4, which introduces the ability for charts to use the output of the pivot table as its source of data. With pivot charts it is very easy to visualize the data and extract the desired information by modifying the pivot table. This talk explains how to create and use the pivot charts, and the experience during development.

Speaker: Tomaz Vajngerl
Room: Sala della Commissioni
Day: Thursday, October 12
Start: 10:00
End: 10:30

Per-Paragraph Signatures in Writer

As security becomes increasingly more important in a highly digital world, signing and validation of digital documents becomes critical. This talk presents a new feature that allows the signing and verification of individual paragraphs in Writer using a cryptographically secure certificate. The signatures are stored as RDF metadata in the document and visually represented by text fields, which shows the signer, date and validity state.

Speaker: Ashod Nakashian
Room: Sala della Protomoteca
Day: Thursday, October 12
Start: 11:30
End: 12:00

Per-Improved interoperability of Writer’s features

Presentation of newly implemented features which are improving interoperability with other office suits. Including: DOCX AutoText import, custom Watermarks, better handling of embedded documents (OLE) and solved problems in the Writer with developer’s comment.

Speaker: Szymon Klos
Room: Sala della Protomoteca
Day: Thursday, October 12
Start: 12:30
End: 13:00

Mail merge Writer data source

A group of users got used to select name and address data for mail merge from a table in a text document, in another office suite. When these users were migrated to LibreOffice, they wanted the same feature, but it was missing. The presentation will show the details how a Writer data source driver was added to connectivity module of LibreOffice.

Speaker: Andras Timar
Room: Sala della Protomoteca
Day: Thursday, October 12
Start: 13:00
End: 13:30

Native comments and change tracking support in LibreOffice Online

An overview of the journey of moving from the tiled comment rendering in LibreOffice Online to native comments in javascript with the help of comments API exposed by LibreOfficeKit. We’ll also look into native change tracking support making your experience of editing and reviewing documents much more smoother.

Speaker: Pranav Kant
Room: Sala della Protomoteca
Day: Thursday, October 12
Start: 15:00
End: 15:30

LibreOffice Online Extensibility

LibreOffice Online is an exciting technology that allows people to edit documents and collaborate on them in a web browser. LibreOffice Online can be integrated into any web service simply via a combination of an iframe and the WOPI protocol.
To make the integration smoother, there are various extensions possible, like adding your own buttons to the toolbars, reacting on various events from the LibreOffice Online, or using some handy WOPI extensions. Come and hear what is possible, and how to achieve the level of integration you need.

Speaker: Jan Holesovsky
Room: Sala della Protomoteca
Day: Thursday, October 12
Start: 15:30
End: 16:00

Tunneling dialogs to LibreOffice Online

This talk would discuss how instead of reimplementing the same functionality available in various dialogs by writing thousands of lines of code in javascript, we are routing the dialogs from LibreOffice core to LibreOffice Online. I’ll talk about the implementation, routing to LibreOffice Online, and present a demo of the current state. Towards the end, we’ll look into future improvements, scope and further challenges.

Speaker: Pranav Kant
Room: Sala della Protomoteca
Day: Thursday, October 12
Start: 16:00
End: 16:30

Unit testing in online

Come and hear how we do unit testing for Collabora Online – vital if you want to add a feature, or implement a fix. Understand how the system of ‘hooks’ allows cheap, yet invasive message & fault injection. Understand the several layers of old & new testing methods, and see how you can get involved.

Speaker: Michael Meeks
Room: Sala della Protomoteca
Day: Thursday, October 12
Start: 16:30
End: 17:00

OOXML support maintenance

When I meet with users in person the most frequently mentioned issue is that LibreOffice (LO) messes up Microsoft Office (MSO) documents. Well, I understand how frustrating it is, but let’s talk about why it’s this hard to be compatible with MSO. In these days OOXML formats are used most often, so it’s important to have our OOXML filters upodated.
I’ll speak about my experiences about working with OOXML filters. I’ve done some development with different LO components during the last year, so I’ll bring examples from these different areas (Writer, Impress, Calc). The OOXML support of LO has limitations, sometimes it comes from missing features, sometimes it comes from the bad design of filter code. While showing the examples I’ll mention where the code can be improved, what issues you should be aware of while developing this part of the code and also mention some entry points for interested developers.

Speaker: Tamas Zolnai
Room: Sala della Commissioni
Day: Thursday, October 12
Start: 18:00
End: 18:30

Approaching the 1M columns / rows limit in Calc Online

The goal of providing to the user the ability of working with a 1 million rows spreadsheet in Calc Online requires several improvements. Some of these improvements have already been achieved and involves special handling of the row/column header, scrolling and document navigation. For row/column header that means fetching only the header heighs/widths for the current visible section of the document. This feature improves both document loading time, minimizes data traffic between the core and client and more responsive row/column operations, such as insertion, deletion or resizing. In this talk will be illustrated how this result has been achieved by the synchronization of header data fetching with mouse/key scrolling and through caching the current cell position.

Speaker: Marco Cecchetti
Room: Sala della piccola Protomoteca
Day: Friday, October 13
Start: 10:30
End: 11:00

LibreOffice in a UK Hospital

Come hear a case-study of how LibreOffice was deployed in a UK Hospital. Hear how the project was planned, the cost-savings, the trials and successes, the benefit of real support – with new features & bug fixes implemented, improving LibreOffice for everyone.

Speaker: Michael Meeks
Room: Sala della Commissioni
Day: Friday, October 13
Start: 10:30
End: 11:00

Making Calc Calculate in Parallel

It seems clear that in the future computers will become more powerful not so much any more by increasing the per-core processing power, but by increasing the number of cores available per processor chip. To take advantage of that in LibreOffice Calc, doing large formula group calculations in parallel is an obvious solution. Earlier, increased parallelism has been approached through the use of OpenCL. This has worked in some ways, and in other ways perhaps been less succesfull than was hoped. This talk describes a new approach which uses plain C++ level multi-threading.

Speaker: Tor Lillqvist
Room: Sala della piccola Protomoteca
Day: Friday, October 13
Start: 11:00
End: 11:30

Brute force clang plugins

If we place nice with the hardware, it will make our lives easier. In the old days, we expended considerable effort to make our global analyses more efficient, especially when dealing with large codebases like LibreOffice. However, with the advent of modern hardware and software tools this has become largely necessary. This talk will focus on some pragmatic design choices that lead to being able to run global analysis passes across the LibreOffice codebase, without breaking the bank on hardware or waiting days for results.

Speaker: Noel Grandin
Room: Sala della piccola Protomoteca
Day: Friday, October 13
Start: 12:30
End: 13:00

How to stop blocking and learn to love non-blocking sockets

The challenge of converting blocking sockets to non-blocking in the production-ready LibreOffice Online, while maintaining quality and stability, was met for the 2.0 release earlier this year. This talk is an overview of the journey from discovering the limitation of blocking socket, and the mechanisms and methods used to build a non-blocking framework and converting the codebase over. The details of how the highly threaded, thread-synchronization-laden design was de-threaded into a simple, single polling-thread model, with callback-scheduling, ownership, life-time management, and thread-affinity is presented.

Speaker: Ashod Nakashian
Room: Sala della Protomoteca
Day: Friday, October 13
Start: 15:00
End: 15:30

LibreOffice: SharePoint integration. A year of progress

The talk is targeted to discuss the previous state of the SharePoint support in LibreOffice, the issues that were solved during this time, and some of remaining problems/goals that LibreOffice is still facing.

Speaker: Mike Kaganski
Room: Sala della Protomoteca
Day: Friday, October 13
Start: 16:00
End: 16:30

A year in LibreOffice’s PDF support

The LibreOffice PDF filter got multiple updates during the past year. The introduction of PDF signature verification, signing existing PDF files, rendering PDF images with pdfium and various general PDF export fixes all happened in this period. A new testsuite has been added to catch PDF export regressions early. 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: Sala della Protomoteca
Day: Friday, October 13
Start: 16:30
End: 17:00

Read More

ownCloud webinar: Increase Productivity – everywhere for everybody!

On September 12 – which is tomorrow – our partner ownCloud will give a webinar aimed at CIO’s, with the title: “Increase Productivity – everywhere for everybody!“.

One of the key challenges in companies today is the need for seamless digital collaboration across devices, storage systems and geographical locations with internal and external users. The increasing mobile workforce needs enterprise-grade tools for secure collaboration that is compliant with current rules and regulations, but still as easy to use as consumer collaboration software. In everyday work this means that options like Network Drive integrations, FTP or VPNs are not the go-to systems anymore. Users today demand better performance, simpler use and more collaborative functionalities.

In the fourth entry of ownCloud’s CIO Agenda webinar series they will introduce you to solutions for this task. In the 10-minute webinar ownCloud experts will not only showcase how full text search over all data storages accelerates productivity, but also demonstrate online editing and collaboration on documents in real time, using Collabora Online, and data sharing to internal and external parties in a secure way.

In this webinar ownCloud will introduce:

  • How full text search over all data storages accelerates productivity to a maximum.
  • Online editing and collaboration on documents in real time.
  • Sharing data to internal and external parties in a secure way.

Webinar data:

Date: September 12, 2017 4.00-4.15 pm CEST / 10 -10.15 am EDT
Speaker: Matthias Schmid, Head of Presales, ownCloud GmbH
Language: English

Sign up

Sign up for the webinar at ownCloud’s website.

Read More

LibreOffice interview with Michael Meeks

LibreOffice has published a very interesting interview with Michael Meeks, the general manager of Collabora Productivity, where he talks at FOSDEM 2017 about some of the great work Collabora is doing alongside the LibreOffice community.

The following questions were asked:

  • How has LibreOffice improved since the early days of the project back in 2010?
  • How easy is it to get an overview of how the components fit together?
  • Can you give us some backgrounds on LibreOffice Online?
  • How difficult was it to take LibreOffice and make it usable in a web browser?
  • What’s in the pipeline for LibreOffice Online?
  • For your day-to-day work, what text editor do you use?
  • You gave a talk at FOSDEM this year – what was it about?
  • Finally, how do you see LibreOffice growing over the next few years?

Check out the video below:

Read More

LibreOffice now uses pdfium to render inserted PDF images

Collaboran Miklos Vanja has written a post about his work on making LibreOffice use pdfium to render inserted PDF images. Check it out:

pdfium is the rendering library used in Chromium’s pdf viewer. It’s based on the foxit pdf renderer and its rendering quality is much better compared to the pre-existing “convert PDF to ODG, then to an image” code when it comes to just viewing a PDF file. First, thanks to PMG who made this work possible.

Let’s look at a few samples that compare the old pdfimport rendering result and the new pdfium-based one. One important feature is that embedded fonts are handled. This is how this inserted PDF looked like previously:

Compare it with the new result:

To continue reading and see more examples, check out the blog post on the website of Miklos Vanja.

Read More

Pivot charts in LibreOffice – part 2

Last week we informed you about the blog post of Collaboran Tomaž Vajngerl, about his work on Pivot charts in LibreOffice, funded for by Nantes Métropole and Ville de Nantes in France. Now he has published an update – Pivot charts in LibreOffice – part 2.

This time I’ll present some necessary changes to make pivot charts actually useful and one unique feature that pivot charts have and normal charts don’t – field buttons.

Pivot chart creation
If you watched the first video, you should notice that I showed the pivot chart was already created from the start. The reason for this was that the functionality to create a new pivot chart from the pivot table wasn’t implemented yet. I have fixed this, so it is now possible to create a new pivot chart if you position the cursor on the pivot table, and select from the menu to create a new chart. The chart creation code will detect the pivot table and create a pivot chart instead of a normal chart.

Continue reading on tomazvajngerl.blogspot.com.es


(image and video by Tomaž Vajngerl)

Read the complete post at tomazvajngerl.blogspot.com.es

Read More