The Calc Guide 7.6 is Published

The Documentation Team is proud to announce the immediate availability of the Calc Guide release 7.6.

The Calc Guide 7.6 update was coordinated by Steve Fanning, with assistance of Olivier Hallot and B. Antonio Fernandez, and is based on the Calc Guide 7.5. Many accessibility issue were addressed and is work in progress.

Steve Fanning
Steve Fanning

This book has been updated from LibreOffice Calc Guide 7.5. It covers changes that are visible in the LibreOffice Calc user interface, including the following areas:
• Detect scientific notation option on Text Import dialog (Chapters 1 & 11).
• Confirmation dialog when deleting empty sheet(s) (Chapter 1).
• Data Entry Form tool (Chapter 2).
• Sort by Color option for AutoFilters (Chapters 2 & 14).
• Poisson distribution option for random numbers on the Fill tool (Chapter 2).
• Chart data tables (Chapter 3).
• Sparklines (Chapter 3).
• Drawing styles (Chapter 5).
• Document themes (Chapters 5 & 15).
• Formula indicator and hint option (Chapters 8 & 15).
• Removed unnecessary statement about taking particular care when using date information in the GETPIVOTDATA() function (Chapter 9).
• Pivot table compact layout (Chapter 9).
• Saving solver settings to file (Chapter 10).
• General comment facility (Chapter 12).
• Error codes (Appendix B).

LibreOffice 7.6 Community also includes many other changes, including improvements in accessibility, change tracking, spell checking, and interoperability with Microsoft’s proprietary file formats.

Release Notes are here: https://wiki.documentfoundation.org/ReleaseNotes/7.6

The guide is available for immediate download in PDF format as well as in source format (OpenDocument Format). Soon it will be available as printed book by LuLu inc. and in HTML format for online reading

Download the Calc Guide 7.6 from the documentation websites at: documentation.libreoffice.org and the bookshelf at books.libreoffice.org.

LibreOffice community interview: Robert Cabane, QA project

Robert Cabane

Today we’re talking to Robert Cabane, who helps out in LibreOffice’s Quality Assurance (QA) community:

Tell us a bit about yourself!

I’m now retired (aged 71), living in Bordeaux, France. Formerly mathematics teacher, successively in Paris and Bordeaux, and as such involved in the teaching of computer science (named “informatics” in Europe).

Since my retirement, I have been an active member of the Société Informatique de France. I have also been co-author of some textbooks on mathematics.

In my free time I like to go hiking in the Pyrenées mountains.

What are you working on in the LibreOffice project right now?

I like to detect bugs and check for them in Bugzilla! When you encounter something strange using LibreOffice, it’s not immediately clear whether it’s a bug or a feature… so I first look in Ask LibreOffice or the forums.

After that, searching in Bugzilla for a specific bug is a unique experience, because LibreOffice is an enormous piece of software. You have to test various keywords in order to eventually find a more or less corresponding bug description. If the bug is referenced, consider adding useful comments; if it’s not the case, try to propose a new bug, as well-documented as possible.

Why did you choose to join the project, and how was the experience?

I started as a user with StarOffice 5.2 (1999), simply because I needed a good office suite running under Linux, and I followed with OpenOffice.org and LibreOffice since its beginning.

My experience was excellent with Calc, good with Draw, and more difficult with Writer, essentially because of two reasons: writing mathematics with Writer isn’t as easy as it is with LaTeX, and exchanging documents with people who use Microsoft Word can be very frustrating at times.

Anything else you plan to do in the future? What does LibreOffice really need?

I think that some activism is still useful at the citizen level: using LibreOffice instead of Microsoft Office is now very common in local, regional and national associations, and should increase for evident reasons. And making donations eligible to tax deductions (as is the case in Germany) would be fantastic!

Big thanks to Robert for all his contributions! Everyone is welcome to join our QA community and help to keep LibreOffice rock-solid.

Winners in the Month of LibreOffice, November 2023 – Get your free sticker pack!

Month of LibreOffice stickers

At the beginning of November, we began a new Month of LibreOffice, celebrating community contributions all across the project. We do these every six months – so how many people got sticker packs this time? Check it out…

Fantastic work, everyone! Hundreds of people, all across the globe, have helped out in our projects and communities. We’re hugely thankful for your contributions – and, of course, everyone who’s listed on the wiki page can get a sticker pack, with the stickers shown above.

How to claim

If you see your name (or username) on this page, get in touch! Email mike.saunders@documentfoundation.org with:

  • your name (or username) from the wiki page
  • along with your postal address

and we’ll send you a bunch of stickers for your PC, laptop and other kit. (Note: your address will only be used to post the stickers, and will be deleted immediately afterwards.) If you contributed to the project in November but you’re not on the wiki page, please let us know what you did, so that we can add you!

There is one more thing…

And we have an extra bonus: nine contributors have also been selected at random to get an extra piece of merchandise – a LibreOffice hoodie, T-shirt, rucksack or snazzy glass mug. Here are the winners (names or usernames) – we’ll get in touch personally with the details:

  • Kira Tubo
  • Steph1
  • @makerblock@mastodon.social
  • Joanmarie Diggs
  • PaulL1
  • Bernd Wechner
  • @hack_the_planet@fosstodon.org
  • Xandru Martino Ruz
  • Sahil Gautam
  • TXDon

Congratulations to all the winners, and a big thanks once again to everyone who took part – your contributions keep the LibreOffice project strong. We plan to have another Month of LibreOffice in 2024, but everyone is welcome to see what they can do for LibreOffice at any time!

LibreOffice in Sri Lanka

ICTer International Conference is the successor to the seminal International Information Technology Conference (IITC) held in Sri Lanka since 1998. We have been invited by the conference organizers, thanks to the connection established by Daniska Navin, a long time project member, to attend the 2023 event on November 8 and November 9, to present LibreOffice during a keynote speech, and to manage a two day workshop about LibreOffice and the Migration Protocol, on November 7 and November 10.

I attended the conference and provided the keynote speech about LibreOffice Technology, and together with Lothar Becker – Certification Co-Chair – managed the two day workshop. The conference was a huge success, as we met many interested people, including some students who asked to organize a similar workshop in 2024 at their universities in other cities of Sri Lanka. We will definitely be back next year to attend ICTer 2024, and to visit the other universities for a workshop.

During the workshop we covered many topics:

  1. Workshop Day 1: LibreOffice project’s history, the technical evolution of the development platform, LibreOffice’s six modules, with an introduction to main features, an introduction to open source software and open standards (for software and for documents), and free open-source licenses and business models.
  2. Workshop Day 2: LibreOffice Migration Protocol, fixing bugs and regressions, interoperability with proprietary document formats, conversion of document templates and macros, compatibility of VBA macros, and integration with third-party applications.

At the end of the workshop, we handed the basic LibreOffice Certified recognition to the following people (in alphabetical order by first name): BWRU Siriwardhana, CS Jayakody, DN Gunawardana, Dilani Sagarika, DMDC Kumari, Gayani Sadagiri, HK Jayarathna, HP Henegama, JKDI Thilakarathne, JRM Muthumalki, KDPM Kannangara, Malsha Katugampala, Mrs LC Karunasagara, Ms AS Gunathilake, Nisantha Ranathunga, NS Gajasinghe, R Prasanna, Rajika Dilrukshi, Renuka Matiwalakumbura, RMJM Rathnayake, Ruwan Jayalath, Sachini de Silva, Selani Ekenayake, Vimukthika Sewwuandi and WMNK Weerasooriya.

A big thank to all our hosts at the School of Computing of the University of Colombo: the Director Dr DAS Atukorale and the Deputy Director Prof Kasun de Zoysa, and all the other academic and administrative staff members who have welcomed us and made the conference memorable. A special thanks to Sanduni Thrimavithana, who made our stay as memorable as the conference. And a final thanks to all the other people we have met during the four days. See you all in 2024.

LibreOffice project and community recap: November 2023

Group photo from the LibreOffice Latin American Conference 2023

Here’s our summary of updates, events and activities in the LibreOffice project in the last four weeks – click the links to learn more…

Month of LibreOffice

  • Next up was the release of LibreOffice 7.5.8, a maintenance release for the 7.5 branch with compatibility improvements and bug fixes.

LibreOffice 7.5 banner

LibreOffice Impress and Draw guides

Screenshot of TheCAT LibreOffice extension

  • LibreOffice is free (as in freedom) software. And our friends at the Free Software Foundation Europe handed over an Open Letter “The right to install any software on any device” to the German parliament, to support sustainability and freedom in electronic products in the EU.

Tabea Rößner, Chair of the Digital Committee

The Document Foundation team photo

LibreOffice Latin American Conference 2023

LibreOffice Viewer for Android screenshots

Keep in touch – follow us on Mastodon, Twitter (aka “X”), Bluesky and Facebook. Like what we do? Support our community with a donation – or join our community and help to make LibreOffice even better!

Of reencounters in the Aztec capital – LibreOffice Latin American Conference 2023

LibreOffice Latin American Conference 2023

Daniel Rodriguez and Celia Palacios write…

The ancient Aztec city of Tenochtitlán dawns on an autumn Thursday in November, which could well be just another one and, probably for many people, it will be. But there are different threads of a great plot brewing from the roads that converge there. People come from different parts of the world, in addition to those who travel from different parts of the country to meet in this annual regional event.

It is nothing more and nothing less than the IV Latin American Congress of LibreOffice 2023, which this year was organized in close collaboration with the Division of Electrical Engineering (DIE) of the Faculty of Engineering of the National Autonomous University of Mexico (UNAM), the non-profit organizations Cuates.net, Fundación Dedica and the National University of Alto Uruguay, as well as the companies OSS Integral Institute, Collabora Online and allotropia.

There is an atmosphere of joy for the reunion; accents from different latitudes of our America and Europe can be heard, in the cases of those who try to speak in the language that unites us as a region. But also dialogues in English when the words did not flow in our language; the spirits were high and generous for this unprecedented event in the north of the American continent.

The opening took place in the “Sotero Prieto” auditorium of the Engineering Annex, where a group of volunteers from the university were waiting at their posts, whom we identified throughout the event for their willingness to provide directions and general information and, above all, to make each attendee feel welcome.

Rocío AldecoIt seems to me that the event was more successful than I thought it would be, being very close to the end of the semester. However, the students were very interested in the workshops. I think these events are important for the community to learn about free software, particularly LibreOffice, and to break these stereotypes about free software. It is not difficult, it is so open that you decide what you want to do with it.

Dr. Rocío Aldeco – Head of the Computer Science Department

We see familiar faces, greetings, badges with hurried letters and others, written in more detail, group photos; but the murmur diminishes when the opening ceremony begins with the words of Dr. Rocio Aldeco on behalf of our host UNAM, of the living legend of free software, Federico Mena, and finally, as representative of The Document Foundation, of Celia Palacios. They all take the stage to open the meeting with words of thanks to UNAM, to TDF, as well as to the members and volunteers, encouraging them to continue with the enormous work they do every day.

After the first morning, the paths temporarily bifurcate: there are those who choose to remain in the auditorium to listen to the keynote talks and those who head to the laboratory to participate more actively. In both spaces, a wide range of topics are addressed, ranging from the path taken to adopt the OpenDocument Format in Taiwan, to quality control or development with Python and LibreOffice.

Franklin WengI’m pretty impressed. First, by people there – friendly people, full of passion. I met many community members for the first time, and they all gave me a friendly welcome. Second, the conference itself is well organized, thanks to the amazing team. (Though I couldn’t understand what they are talking about, but the whole flow ran well, and some interim schedule changes didn’t cause problems.) Third, by the city – I could see the celebration of Día de Muertos everywhere. Very interesting. Some Aztec ruins, the pyramids, and in the evening people singing and dancing on the street of Mexico City.

One of my missions this time is to introduce LibreOffice Asian community members. I do hope that there are stronger connections between the Latin American and Asian communities, and we can do something together.

Franklin Weng – President of BoD, Software Liberty Association Taiwan

But the conversation does not end in the formal spaces of the agenda: groups are formed to debate, share information, exchange contacts and form networks to continue thinking and building. The story would not be complete without mentioning that in addition to the technical exchange, there were social and cultural moments.

At the end of Friday, the farewells arrived, but they are only a goodbye, even though a place to meet again for 2024 has not yet been defined.

The success of the event can be explained in many ways, but we choose this one: the hard work of the great organizing team.

Thank you, Mexico City; thank you, UNAM; thank you, Hispanic LibreOffice community!

LibreOffice Latin American Conference 2023