Lox365 extension: XLOOKUP (and more) for LibreOffice Calc

More news from the LibreOffice subreddit! User goose_pirate posted about an extension:

Hi everyone, I made this little extension for LibreOffice Calc which adds a few functions, currently FILTER, SORT, and XLOOKUP. I hope others will find this as useful as I do.

XLOOKUP is a function for finding things in a table by range or row. We asked goose_pirate for a bit of background on the extension:

I’ve been using both Excel and LibreOffice for many years and found the new(er) Excel functions like XLOOKUP to be really nice compared to the old VLOOKUP or INDEX MATCH. I wanted to use it in LibreOffice too, so I wrote this extension.

How I made it: I researched information about LibreOffice extensions, dissected a few such extensions made by others, and finally started my own. It wasn’t too bad, I was surprised no one has made something similar yet.

Great work, goose! 😊

Learn more and download here (in the “build” folder)

Crowdfund audio recording and playback in LibreOffice presentations!

LibreOffice’s presentation tool, Impress, includes a bunch of features for home and office use. But one thing that’s missing is recording and playback for audio comments in presentations.

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

YouTube privacy policy

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

This feature is important in eLearning: in contrast to video recordings, audio recordings are stored per slide, and can be adjusted to match the individual pace of the presentation. This is particularly suitable in school, academic as well as corporate environments to make learning content and product presentations more interactive.

So, how can we get this feature in LibreOffice? Well, the CH Open association, which has been promoting open systems and standards in the Swiss ICT landscape for over 40 years, is organising a crowdfunding campaign to implement the feature. The project is estimated to cost €62,000 in total – with various milestones along the way.

Click here to learn more and participate!

Projects selected for LibreOffice in the Google Summer of Code 2022

The LibreOffice Google Summer of Code projects have been selected for 2022.

  • Hannah Meeks – VBA Macros – Tests and missing APIs : We support VBA (Visual Basic for Applications) Macros in LibreOffice, but the implemented API isn’t complete and the API functions aren’t largely tested. The consequence of this is that the VBA macros in OOXML documents don’t run as intended in LibreOffice, which causes compatibility problems. The goal of this project is to add tests for the functions already implemented and then look for what functions are missing for a method or module and add them.
  • Paris Oplopoios – Extend Z compressed graphic format support: Some graphic formats are compressed with ZIP (deflate) to make them smaller, while the formats themselves don’t support compression. In LibreOffice we already support SVGZ format, but not other formats. The goal of this idea is to look at how SVGZ is implemented and extend that to other formats (EMF, WMF). The extended goal is to implement support for compressing in addition to extracting.

Good luck to the contributors – we appreciate their work on these important features and improvements! And thanks to our mentors for assisting them: Tomaž Vajngerl and Miklos Vajna (Collabora); Thorsten Behrens (allotropia).

From September 5 – September 12, contributors will submit their code, project summaries, and final evaluations of their mentors. Find out more about the timeline here, and check out more details about the projects on this page.

LibreOffice ecosystem interview: Michael Meeks at Collabora Productivity

Following our interviews with Caolán McNamara at Red Hat and Thorsten Behrens at allotropia, today we’re talking to Michael Meeks from Collabora Productivity:

Tell us a bit about yourself!

I’m Michael Meeks, a Christian, husband and enthusiastic open source developer. I run Collabora’s Office division with the assistance of an amazing team – leading our Collabora Online and Office products, and supporting customers and partners. I’ve served as a Director of the The Document Foundation from its founding until recently, and have contributed to both the OpenDocument Format and OOXML standardization.

I’d started some decades ago working on the Linux desktop in the GNOME project around the Gnumeric spreadsheet, first as a volunteer, then for Ximian – which was involved in the open-sourcing of OpenOffice.org. Since then, I’ve been involved with improving the codebase, although the name of my employer has changed from Ximian, Novell, Attachmate, Micro Focus, SUSE – and finally being spun out alongside a brave and talented subset of the SUSE LibreOffice team to Collabora Productivity some nine years ago.

What does Collabora Productivity provide in the LibreOffice ecosystem?

One big piece we do is improving the awesome LibreOffice Technology core engine / APIs, and performance for Collabora Online – which provides a real alternative to Microsoft Office 365 – with collaborative editing in the browser. We spend time working hard on integrations with popular open source products like Nextcloud, ownCloud, Seafile, EGroupware, and proprietary ones such as HiDrive, Filr – as well as helping hosting providers like Strato provide LibreOffice Technology to their users en-masse.

Around Collabora Online, we have a mission to allow you to control your documents. That means full control from open source software, open standard file formats, through to on-premise hosting, and full network control. It is encouraging to see the growing consensus these days between e.g. The European Pirate Party (enthusiastic Collabora Online users) talking positively about the importance of Digital Sovereignty, and at another pole – for instance, the head of the UK’s MI6 warning on the BBC:

“The data-trap is this: that if you allow another country to gain access to really critical data about your society, over time that will erode your sovereignty.”

For Collabora’s customers, we also take a new LibreOffice version each year and freeze this as our Long-Term Support (LTS) base; we create many hundreds of fixes and feature patches which we contribute up-stream, as well as back-porting the latest fixes to our enterprise branch: much as is done for an enterprise Linux distribution. We sell that toegher with services and support as Collabora Office. We also maintain a tool (Collabora OLE Automation Tool) to ease migration of vertical applications that use Visual Basic / OLE2 integration that makes LibreOffice behave like Microsoft Office via COM. In addition, we maintain Collabora Office and LibreOffice Windows Group Policy Templates – these make it easy to manage lots of LibreOffice machines via Group Policy.

Another strand of work is re-packaging Collabora Online / LibreOffice Technology as responsive mobile apps for Android and iOS, as well as Chrome OS. By delivering LibreOffice-based document editing to everyone’s browsers, PCs and mobile devices, we give people a real alternative that lets them choose their own document formats, security profile and threat model – real digital sovereignty.

What has Collabora been working on in LibreOffice 7.3?

We’ve been working on lots of things: some of the team have done a lot for interoperability, e.g. Miklos improving writer’s paragraph styling, or Dennis making charts more compatible, or Sarper re-working our PowerPoint header/footer interoperability. There is a constant stream of improvements based on customer feedback here.

Another big set of improvements in LibreOffice 7.3 are from Lubos and Noel around the performance of file opening, rendering, editing of documents as well as improving calculation threading. One particularly important piece here was the work done to very significantly improve performance of lots of editors in a single file – which has been back-ported to make Collabora Online very much faster in our latest releases.

We are looking forward to upgrading to LibreOffice 7.3 in the next months, and not having to carry these back-ports forward.

What new features are you particularly happy with?

I’ve been really pleased with the work we’ve done alongside AMD around Skia rendering – in LibreOffice 7.3 we make that the default for macOS (users, please report any problems), which for the first time allows us to share a single, modern rendering API between macOS, Linux and Windows for rendering – which is a huge step in the right direction.

What’s more: adding WebP support for images – interestingly, Firefox now requires this as a copy/paste format for images, and it’s long overdue to have this high quality format from Google supported.

Looking beyond this release, what else are you planning to do?

We work continuously on LibreOffice, all around the code from ongoing clean-ups, performance work, unit-tests (particularly important to avoid customer tickets regressing) and so on. We have a few things that are in the works currently.

Another thing that Tomaz, Sarper and Miklos will debut in LibreOffice 7.4 is the start of colour theme support for shapes, to allow us to re-style documents more deeply by changing the theme and palette. This should also help with interoperability and templating.

We’ve also added Sparkline support, providing a very pretty and useful way to quickly visualize data for LibreOffice 7.4.

You can read about the history of these from Edward Tufte.

Lubos has been working hard on jumbo sheets – allowing much larger number of columns in sheets (and more rows too) which should make interoperability much smoother for people with large spreadsheets.

And of course lots more – we’re expecting LibreOffice 7.4 to be packed with new and enhanced feature / function from the whole community – and Collabora.

Find out more

Build up your skills, and learn exciting new things!

LibreOffice is made by a worldwide community of volunteers, certified developers and many other people. Every summer, we participate in the Google Summer of Code programme: this is focused on introducing contributors to open source software development, and last year LibreOffice received a bunch of new features and improvements thanks to the work of several contributors.

We’re super happy to announce that LibreOffice, once again, is part of this year’s Summer of Code (GSoC). If you’re a contributor, want to improve your programming skills and receive a financial stipend to implement new features in LibreOffice, get involved! You can get in contact with us, show us that you’ve learnt the basics by working on an Easy Hack from the category “difficultyInteresting”, and then propose your project(s). We’re looking forward to hearing from you and seeing your work!

Click here to get started

Tender to clean up and further improve ODF conformance (#202202-01)

The Document Foundation (TDF) is the charitable entity behind the world’s leading free/libre open source (FLOSS) office suite LibreOffice.

We are looking for an individual or company to clean up and further improve ODF conformance.

The default file format of LibreOffice is ODF, the Open Document Format. We have successfully tendered two projects on the current version 1.3 recently:

The scope of this tender is to further improve the ODF conformance in LibreOffice. Note however that the majority of the items mentioned below are unrelated to ODF version 1.3, and have existed before support of this version was introduced in LibreOffice.

Deliverables

  1. Get ODFAutoTests (https://gitlab.com/odfplugfest/odfautotests) to run again. Note: This item does not ask to setup a publicly available website.
  2. Address one or more of the following high priority issues:
    1. “svg gradient” – Bugs 48392, 76682. Bug 48392 is prerequisite for Bug 76682.
    2. “list indent” – Bugs 78510, 92762, 114287, 83532, 82179, 145318
    3. “Math inline in text box” – Bug 129061. From user point of view it has highest priority.
    4. “numbered paragraph” – Bug 62032, 108868. The internal work is done. But a UI is missing. The expected UI needs to be specified.
    5. “ODF conformance part 1” – These are those errors, which are in most cases not visible for users, and therefore likely never included in a customer contract. Bug 53992, 101758, 103602.

    Please propose a subset and prioritization of these bugs, that do not exceed the person days factored in for this tender, see below.

  3. Address one or more of the following lower priority issues:
    1. “ODF conformance part 2” Bug 106934, Bug 91472, 97706, 107253, 108536, 113404, 113554, 116321, 131148
    2. “Trailing space in cell text not encoded as <text:s/>” – Bug 113726
    3. “FILEOPEN PPTX: equation not displayed because Impress doesn’t support inline formulas”, in particular the as-char embedded object – Bug 129061
    4. “ODF database mime-type confusion” – Bug 45854
    5. “table: evaluates <text:variable-set> in body of float and void cells, but not of string cells” – Bug 68024
    6. “Implement ODF attribute fo:hyphenate to exclude a portion of text from hyphenation” – Bug 106733
    7. “FILESAVE: Form: incorrect ‘time’ type” – Bug 131127
    8. “FILESAVE: Date form: unexpected attribute ‘form:input-required’ – Bug 131148, cf. also https://issues.oasis-open.org/browse/OFFICE-4121

    Please propose a subset and prioritization of these bugs, that do not exceed the person days factored in for this tender, see below.

The work has to be developed on LibreOffice master, so that it will be released in the next major version.

A key item of the deliverables for this tender is extensive documentation, about the approach chosen to implement the above items. We expect bidders to provide documentation on both the code and the non-code parts of this tender, e.g. methodology, structure and technical aspects. The Document Foundation will publish this under a free and open source license and make it available to the general public.

Required skills

  • Extensive knowledge of C++
  • Experience working on the LibreOffice source code

Other skills

  • English (conversationally fluent in order to coordinate and plan with members of TDF)

We use free, libre and open source (FLOSS) software for development wherever possible, and the resulting work must be licensed under the Mozilla Public License v2.0.

TDF welcomes applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age.

Bidders will get a preference for including a partner or independent developer who has not been involved in a successful tender before.

As always, TDF will give some preference to individuals who have previously shown a commitment to TDF, including but not limited to certified developers and/or members of TDF. Not being a member, or never having contributed before, does not exclude any applicants from consideration.

The task offered is a project-based one-off, with no immediate plans to a mid- or long-term contractual relationship. It is offered on a freelance, project basis. Individuals and companies applying can be located anywhere in the world.

When budgeting, we anticipated that this project (all items combined) to take in the region of 40 days of work. Should bidders’ assessment result in a significantly different number, please reach out to us before sending your bid, so we can clarify upfront.

TDF is looking forward to receiving your applications for one or more of the aforementioned tasks, your financial expectations and the earliest date of your availability, via e-mail to a committee at tender20220201@documentfoundation.org no later than March 31, 2022.

Applicants who have not received feedback by April 29, 2022 should consider that their application, after careful review, was not accepted.

All bidders are invited to ask their questions on this tender until March 24, 2022. Questions and answers will be made public in a collected and anonymized form.