LibreOffice power feature: join text boxes after importing PDFs

Although PDF is primarily used as a read-only format, there are tools for editing PDFs – and indeed, many people pay quite a bit of money for these tools, such as Adobe Acrobat Pro.

But there are alternatives! LibreOffice Draw provides a powerful PDF editor, for free, and since LibreOffice 6.4 it has a great feature to speed up editing: the ability to consolidate (join) multiple text boxes. This is especially useful if you’ve imported a PDF, and the text content is spread across multiple text boxes, making it hard to work with.

Let’s see it in action. Imagine you’ve opened a PDF document in LibreOffice Draw, and there are lots of separate text boxes, like this:

This is fiddly to work with – wouldn’t it be great if you could join all of these text boxes together, to edit them as a single chunk of text? Well, in LibreOffice 6.4, you can. Just select all of the text boxes, using the shift key while selecting them, then right-click and choose Consolidate Text in the context menu:

Now, the three text boxes are joined into one, so you can edit the text as a single item:

Download LibreOffice and try it out!

See the online help for more tips and guides, and Ask LibreOffice if you have any questions!

Our new extensions and templates page is getting ready!

Our old Extensions and Templates Website has worked well over the years. It is one of the key and most frequented websites of the LibreOffice project, as it enables users to enhance the functionality of LibreOffice with add-ons and plug-ins, while providing an easy way for authors to improve LibreOffice.

We’d like to express a special thanks to Andreas Mantke for implementing, designing and maintaining it in first place! It was his initiative to come up with such a website and he has spent countless hours over the past years to maintain the site to the benefit of our community. Kudos and thank you so much for your help and dedication!

As we look forward, we’ve been thinking about how to progress, while building on some of the other technologies we use.

After research and evaluation of various options, we’ve made the decision to update the website and base it on SilverStripe, the content management system we use for the main LibreOffice website. Our goals include:

  • Streamlined design
  • Improved usability for authors and users
  • Make extensions very prominent
  • Make it easy to localise in many languages

In the last few months, we’ve been working on a new site and workflow, and today we’d like to share the current progress, and provide some information on what’s going on under the hood. Christian Lohmaier talks about the new website, which will be available soon…


Initial setup

We decided to use a much more reduced and simplified setup for this. With fewer tools to maintain, the easier it is to add improvements along the way.

We’ve made the decision to go with SilverStripe, since that is a CMS we are already familiar with since we are already using it for our main website. It has a Model View Controller design that is easy to grasp and extend by anyone who knows some PHP and html and CSS.

The separate backend (administrative interface) and frontend (what a visitor using the site sees) allows us to streamline the workflow and improve error handling.

Having the data completely decoupled from the representation will allow us to revamp the site as new ideas come along or potential problems will surface. One of our goals is to simplify the user interface and also allow for translation and localization of both the extensions as well as the whole site from the very beginning. Extension maintainers can translate their listing into the language of their main target language.

Discoverability

Similarly, users told us that they wanted their extensions to be even easier to discover, so for this we decided to go with a curated list of tags as the main categorization/classification. We learned from other tag-using systems (like ask) that freeform tags would require a high level of discipline from content creators to not create too specific or too similar tags to make for a useful search tool.

Having a curated list of tags also allows for translation of the tags, further improving the experience for our non-English speaking endusers. This also will allow us to get rid of the rather arbitrary split into templates and extensions, but rather have a more targeted listings.

And since we’re already using SilverStripe in combination with TDF’s Single Sign-On solution, current users of our SSO can easily access the new site.

Creating and editing

To illustrate the keep-it-simple approach, here is what an extension maintainer would see once logged in to edit or create an extension entry:

And here’s what creation of a new entry would look like:

While some people might think that this is not the most exciting user interface, and that it also boxes the user in, well: that is the whole point about it!

Just like on the current site, we kept the concept of having a main extension entry along with individual releases that might be limited to a certain language or a specific operating system:

Moderation

The new sites provides some features also for extension moderators with a more expansive admin interface in which they would have access to reports and where they can add and maintain the list of available tags, and do other similar tasks.

In the next post we’ll dig a little deeper into the more technical stuff like the data model and templating systems. That will then provide the required knowledge to not just give feedback on the current design (both visual as well as from a low-level perspective), but already provide concrete improvements in form of patches.

As we’re a volunteer-driven, community project, we really appreciate any help – so if you want to give us a hand, join our website mailing list and drop us a line. We look forward to hearing from you!

10 great LibreOffice-only features

LibreOffice is the successor project to OpenOffice, which had its last major release (4.1) back in 2014, as you can see in this timeline – click to enlarge. And, of course, it’s still free and open source:

We release a new major version every six months – so let’s check out some of the great features our community and certified developers have added in recent years!


1. Improved compatibility – .docx export

LibreOffice Writer, the word processor, can export documents in .docx format (OOXML), as used by Microsoft Office. Many other compatibility improvements have been added too.


2. NotebookBar user interface

Since LibreOffice 6.2, we have an alternative user interface option called the NotebookBar. To activate it, go to View > User Interface > Tabbed.


3. EPUB export

Want to create e-books from your documents? With LibreOffice, you can! Click File > Export and choose EPUB, which can be read on many e-book devices.


4. Document signing

For improved security, you can use OpenPGP keys to sign and encrypt ODF, OOXML and PDF documents. (ODF is the OpenDocument Format, the native format of LibreOffice.)


5. Pivot charts

Calc, LibreOffice’s spreadsheet, lets you create charts from pivot tables. This helps you to summarise data sets in complex spreadsheets.


6. Document watermarks

LibreOffice 5.4 introduced custom watermarks, which can be added to page backgrounds.


7. Major spreadsheet performance boosts

Calc has benefited from multi-threading support, dramatically boosting performance on computers with multi-core CPUs.


8. Attractive presentation templates

Impress, LibreOffice’s presentation tool, includes a selection of hand-crafted templates, so you can focus on content rather than design.


9. Documentation improvements

LibreOffice’s help system has been improved to be more user-friendly, while many guidebooks have been updated too.


10. Safe Mode

To improve reliability, LibreOffice 5.3 introduced a Safe Mode, which temporarily disables your user configuration and extensions. This helps you to pinpoint any issues which may affect your setup.


Like what you see? Download LibreOffice and try it out – it’s free!


Those are just some of the features – but of course, our community has grown, we’ve started the Document Liberation Project and we have professional support options for using LibreOffice in businesses. And there’s much more still to come – join us!

LibreOffice presentations at FOSDEM 2020 – learn about the technology behind the software

FOSDEM is the biggest European get-together of free and open source software (aka FOSS). And, of course, the LibreOffice community and certified developers were there!

Indeed, many developers and community members gave talks about their recent work – check out these links for the videos and slides…

Main track

Open Document Editors devroom

Collaborative Information and Content Management Applications

30,000 followers on Twitter!

Yes, our Twitter account now has over 30,000 followers. A big thanks to everyone in the community for supporting us, sharing and liking our tweets, and helping to spread the word about LibreOffice and free software!

Of course, we understand that not everyone wants to use Twitter, so we’re active on other platforms as well. For instance, our Mastodon account has 3,400 followers and gaining more every week. Check it out!

LibreOffice in Luxembourg: Ready for work

LibreOffice is available in over 100 languages, giving billions of people access to high-quality productivity tools, all across the globe. And now we’re adding Luxembourg to the list, with a new spell-checker extensions for Luxembourgish (Lëtzebuergesch).

The extension is available to download on this page.

Michel Weimerskirch, the extension’s maintainer, explains more: “My goal is to provide good quality spell-checking tools for the Luxembourgish language. LibreOffice is available on all major platforms for free, and also has the necessary programming interfaces I needed to even implement a phonological rule that could now be implemented using standard spell checking libraries. Over the past few years LibreOffice has grown to become a very mature office suite, so nowadays there is definitely no reason to not use it in a professional environment.

Paolo Vecchi, a local LibreOffice supporter – and recently elected as member of the Board of Directors of The Document Foundation – worked with Michel Weimerskirch to publish the new dictionary on the LibreOffice extensions portal, and will coordinate with the local Government and European institutions established in Luxembourg to help them upgrade to the
most complete and professional open source office suite.

Many local governments, organisations and companies around the world use LibreOffice every day – check out a selection here.