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!

Video tutorials for LibreOffice Writer, Calc and Impress

On the LibreOffice subreddit, we became aware of some useful tutorial videos created by Steven Davids. These cover various components of the suite, and show how to achieve common tasks.

We asked Steven about how he chooses the topics for his videos, and how he makes them:

My video tutorials come to me – I do not go and look for them. If I have a problem, I search for a solution on the web. I always assume I am not unique, and that many other people had or have the same problem. If I do not find a solution or one that is readily available, I struggle my way out to a solution. Then I share that solution via video! Why video? Because it seems to me people are lazy to read and video illustrations are just easier to understand.

The videos are very low budget and homemade. There are no costs for the software since I use free public open-source programs for the screen recorder and video editor. There are many such programs, but OBS Studio and Shotcut serves me very well. I often use LibreOffice Presentation to assist in presenting the material. The hardware is also low cost. I already have a laptop and mobile phone so there are not extra costs there. A mid-range microphone from Samson is indispensable and basically the only additional cost.

Click here to view the playlist on YouTube!

The Latin American LibreOffice 2022 Conference was a success!

Female volunteering, interoperability, professional training, migration, Python based macro development and much more were highlighted themes at the event held at the Catholic University of Brasilia in the capital of Brazil.

Daniel A. Rodriguez writes:

The Latin American LibreOffice Conference gathered around 400 people, among them students and IT professionals, and was opened to the public on Thursday August 25th in a ceremony presided by Prof. Wesley Sepulvida, representing UCB, Lothar Becker (formerly on the Board of Directors of The Document Foundation) and Olivier Hallot representing the LibreOffice community.

The conference was organized entirely by volunteers, and followed up on the first event held in the city of Asunción in Paraguay in 2019. Brasilia was chosen to host the conference in 2022 because of its importance in the Latin American context and its excellent infrastructure. The lectures and workshops were given by members of the LibreOffice community from Italy, Spain, Mexico, Brazil and Argentina, on August 25 and 26 at the Catholic University of Brasília, on the Taguatinga campus.

Italo Vignoli (Italy – TDF) and Olivier Hallot (Brazil – TDF), founding members of The Document Foundation, opened the lectures, presenting the sustainability of free software projects and the history of LibreOffice in Brazil, respectively. At the end of the morning, the participants took the official photo of the event.

In the early afternoon, Daniel Rodriguez (Argentina – TDF / UNAU) spoke about the implementation of a version of LibreOffice Online at the Alto Uruguay National University in Argentina, and Rafael Silveira (Brazil) presented the migration project to LibreOffice at Nuclebrás Equipamentos Pesados (NUCLEP). Simultaneously, in the computer lab Henderson Matsuura Sanches (Brazil – TDF) gave a workshop with practical tips about how to do an End of Course Paper in LibreOffice.

Xisco Fauli (Spain – TDF) presented the testing procedure of LibreOffice, followed by Lothar Becker (Germany – TDF) who talked about entrepreneurship with free software. Roberto Salomon (Brazil – Chief architect for Latin America at SUSE) spoke about the future that opens up with the technological innovations that are arriving in Brazil. In the closing of the first day, Prof. Andre Lima (UCB) spoke about open source solutions for LGPD compliance. In the workshops, Rafael Lima (Brazil – TDF) led the work on python scripting with a full room.

On the second day, Gustavo Pacheco (Brazil – TDF) shared with the audience details about the importance of being careful when investing in cryptocurrencies and how LibreOffice can help in decision making. He was followed by Olivier Hallot who presented the different ways of documenting software projects. Tulio Macedo (Brazil – TDF) presented the challenges of more accessible documentation. Simultaneously, Xisco Fauli led the session on software bug identification and confirmation. At the same time, Felipe Marra, Rafael Osiro and Giovanni Favorim from UCB led a workshop on software versioning control with the git tool. Prof. Remis Balaniuk (UCB) gave an introductory workshop on python.

In the afternoon, Italo Vignoli spoke about digital sovereignty. Followed by Olivier Hallot who presented migration strategies between office suites. Eliane Domingos (Brazil – TDF) talked about female volunteering in the LibreOffice project. At the same time, Mauricio Baeza (Mexico – TDF) gave a workshop about creating extensions for LibreOffice. In parallel, Prof. Cleto Spotto (UCB) analyzed snippets of LibreOffice code in a C++ workshop.

Henderson Matsuura showed how to install and use Mendeley in Writer, followed by Olivier Hallot who covered first steps in developing code for LibreOffice. Jackson Junior (Brazil – TDF) presented his experiences in standardizing documents at the Secretariat of Environment and Urban Planning (SEMAPU) of Olinda, Pernambuco, and Prof. Cleto Spotto (UCB) conducted an introductory workshop on LibreOffice Math. Finally, Prof. Hially Vaguetti (UCB) showed how to make academic presentations in LibreOffice Impress.

The conference was closed by Prof. Wesley Sepulvida, who thanked The Document Foundation and the LibreOffice community for their presence. In return, Olivier Hallot thanked the Catholic University of Brasilia for its hospitality and the volunteers and speakers for their participation in this first face-to-face event after the pandemic.

Now we look forward to meeting more people at the LibreOffice Conference 2022 in Milan, at the end of this month!

Membership Committee Election 2022: Q+A sessions with the candidates

The Document Foundation is the non-profit home of LibreOffice, and its Membership Committee (MC) administers membership applications and renewals following the criteria defined in the Foundation’s Statutes.

The election process for a new MC is underway, and we’ve had three live Q+A sessions with the candidates! Check them out in this playlist, using the icon in the top-right to switch videos (and we’ll put them on PeerTube very soon):

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.