Home » LibreOffice » Page 109

Category: LibreOffice

Calc Guide 6.4 is Released! – Download Now!

The LibreOffice Documentation Team announces the release of the LibreOffice Calc Guide 6.4, the complete handbook for the spreadsheet tool of LibreOffice. The guide was updated from the existing release 6.2 and include all the improvements developed since then.

LibreOffice Calc is the spreadsheet module of LibreOffice, capable of creating and edit complex spreadsheets, from simple calculations to ‘What if…’ manner by changing some of the data and observing the results without having to retype the entire spreadsheet or sheet. Other features provided by Calc include

  • Functions, which can be used to create formulas to perform complex calculations on data.
  • Database functions to arrange, store, and filter data.
  • Dynamic charts, including a wide range of 2D and 3D charts.
  • Macros for recording and executing repetitive tasks; scripting languages supported include LibreOffice Basic, Python, BeanShell, and JavaScript.
  • Ability to open, edit, and save Microsoft Excel spreadsheets.
  • Import and export of spreadsheets in multiple formats, including HTML, CSV, PDF, and PostScript.

The release of the Guide is an effort of the documentation team of the LibreOffice Community, a group of skilled individuals that contributes to create the best reference guides for all LibreOffice modules, including word processor, spreadsheet, presentation, drawing, database and math equations.

“This guide achieves a very important milestone for the whole LibreOffice community since Calc documentation is the most demanded by the end user. I’m sure this great work will be very much appreciated.” said Daniel Rodriguez, Member of The Document Foundation Board of Directors.

“Building on the great work that went on during 2019 to complete the major update necessary to align the Calc Guide with LibreOffice 6.2, the update to 6.4 was a more modest task. However, I am delighted that the Team has completed this task because it gives an excellent platform for the subsequent update to 7.0 . From a personal perspective it was an enjoyable challenge and I was delighted to have a chance to make a useful contribution during our period of lockdown in the UK. Many thanks to all those who contributed to this update, especially Leo Moons, Kees Kriek, Gordon Bates, Drew Jensen and Randolph Gamo” said Steve Fanning, Calc Guide Coordinator.

Steve Fanning picture
Steve Fanning
Randolph Gamo picture
Randolph Gamo

The Calc Guide 6.4 is available in PDF for download from the new Extension website, at the following address: https://extensions.libreoffice.org/en/extensions/show/876.

The source files in Open Document Format (ODT)can be downloaded from this address: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide .

And indeed, the documentation community appreciates help in all languages – plus, contributing is a good way to build up skills for a possible career in technical writing. See here to get started!

Online events in the LibreOffice Hispanic community

Everyone loves to meet in person, share ideas, work on the software and have a good time. Of course, “real life” meetings have been difficult in the last few months, so many communities in the LibreOffice project have chosen to go online. Daniel A. Rodriguez gives us an update:

Yesterday, the Hispanic community of LibreOffice celebrated the second of a series of online events that was broadcast live on YouTube. The activity started at 17:00 UTC and lasted about 3 and a half hours. The virtual assistants benefited from the presence of several members recognized for their participation and collaboration in the project:

  • Xiomara Céspedes, from Costa Rica, provided an overview of the use of styles.

This was, of course, an open event – free of charge and aimed at anyone interested in the FOSS office suite par excellence. Also, we thank our friend Servio from the Latin Community of Free Technologies, who managed the live transmission through YouTube.

Community Member Monday: Jwtiyar Ali

Today we’re talking to Jwtiyar Ali, who is helping to localise LibreOffice into Kurdish…

To start with, tell us a bit about yourself!

Hey! I live in the Kurdistan region, in the north of Iraq – the city of Sulaymaniyah. I have an MSc in Physics, but I love computer science too. Currently I am working in the Cement Quality Control Department at a cement factory, as a physicist.

I do translations for many open source projects such as Ubuntu, Gimp, Firefox etc., leading these translation projects. My hobbies are following new open source projects and seeing how they can be more competitive. I also like football, walking, and reading Python programming courses in my free time.

What are the opportunities and challenges for promoting/using free software and LibreOffice in your region?

In my country, promoting open source apps and systems is a very big challenge because most people – maybe 90% – use proprietary apps, because they don’t hear about or know about open source alternatives.

So we in the team at www.chawg.org decided to make a website to introduce many open source projects. We created a wiki platform and a forum for that reason – and now we have Facebook groups and pages.

In my opinion, an opportunity is to provide users with more guides, and make a comparison between LibreOffice with other apps. Show users what LibreOffice can do that others apps can’t. Also, show people that LibreOffice can do the same things – or even more – with their daily work, and send them articles to educate them about the software.

What are you doing in the LibreOffice project right now?

I am translating LibreOffice. I hope to see LibreOffice in my language – that would be perfect. Also, it would help users to interact with LibreOffice more often than before.

How did you get involved in LibreOffice, and what was the experience like?

My love for open source projects made me engage with LibreOffice and the big community behind it. Being in the community made me feel that I wasn’t working in a specific part of the world – but people around the world can benefit from what I do.

The experience was amazing, because I didn’t know beforehand that we have a great app like LibreOffice.

Anything else you want to add?

I want to thank everyone who helped me to join this great community. My passion for LibreOffice has no borders, and I hope to see other open source projects grow faster than ever. The best part of the community is that we all trust in open source and teamwork.

Thesedays, I am promoting LibreOffice to my colleagues and friends. Also, I help them to fix any problems that they may face it during installing or when using the suite.

Thanks to Jwtiyar for all his contributions! Our native language communities are always open for more help – so if you want LibreOffice and its website localised in your language, give us a hand!

Documentation updates: Czech Guide for LibreOffice Math

Math is LibreOffice’s formula editor, and can be invoked in your text documents, spreadsheets, presentations and drawings, enabling you to insert perfectly formatted mathematical and scientific formulas. Your formulas can include a wide range of elements, from fractions, terms with exponents and indices, integrals, and mathematical functions, to inequalities, systems of equations, and matrices.

We have an English guidebook for Math in LibreOffice 6.4, and now our Czech community has completed a translation, thanks to Zdenek Crhonek, Petr Kubej, Eliska Rolfova and Roman Toman. Click here to read it!

Meanwhile, they’re working on the Getting Started Guide and Calc Guide. If you speak Czech, give them a hand! You can also follow the Czech LibreOffice community on Twitter.

And indeed, the documentation community appreciates help in all languages – plus, contributing is a good way to build up skills for a possible career in technical writing. See here to get started!

openSUSE + LibreOffice Conference Update

The organisers of the openSUSE + LibreOffice Conference have slightly adjusted the conference dates, from the original of October 13 – 16 to the new dates of October 15 – 17.

The new dates are Thursday through to Saturday. Participants can submit talks for the online conference until July 21 when the Call for Papers is expected to close.

The length of the talks for the conference have also been changed. There will be a 15-minute short talk, a 30-minute normal talk and a 60-minute workgroup session to select. Organisers felt that shortening the talks were necessary to keep attendees engaged during the online conference. The change will also help with the scheduling of breaks, social video sessions and extra segments for Questions and Answers after each talk.

The live platform that will be used will allow presenters with limited bandwidth to play a talk they record, should they wish not to present a live talk. The presenter will have the possibility to control the video as well as pause, rewind, fast-forward, etc., which is built into the system.

Organizers have online, live conference sponsorship packages available. Interested parties should contact ddemaio (at) opensuse.org for more information.

Community Member Monday: Andreas Heinisch

Today we’re talking to Andreas Heinisch, who recently became a member of The Document Foundation, the non-profit entity behind LibreOffice…

Tell us a bit about yourself!

I am from South Tyrol, and live near the city of Meran/Merano on the mountain side. I studied computer science, and teach informatics, physics and mathematics at the local high schools. In my spare time, I like to go hiking, climbing, and of course programming 🙂

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

At the moment I am part of the Macro team, and try to solve some of the bug reports. I don’t remember exactly, but I think that I contributed to about over a dozen of them. Personally, I think macros are not without controversy due to the security concerns, but they are widely used in order to automate some easy tasks.

Why did you decide to become a member of TDF?

In my teaching activity, there’s only a small part where I can really program or solve some challenging problems. So I decided to join an open source project in order to contribute to the community, get in touch with current software lifecycle technologies and to improve or contribute to existing widely used software. To be honest: LibreOffice was the first product which came to my mind.

In addition, I think that local public administrations should not invest only in proprietary software solutions, which abuse their market position.

Anything else you plan to do in the future?

In the future I want to promote LibreOffice for our local high school, and to encourage more students to contribute to open source software. For this reason, I think that the help pages of LibreOffice should be revisited and simplified in order to attract more people to improve and contribute to such a great product.

Thanks to Andreas for all his work! Everyone in the LibreOffice project is welcome to apply as a member of TDF – check out this short video for more info…

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.

Press Releases

Announcement of LibreOffice 25.8.4

Berlin, 18 December 2025 – LibreOffice 25.8.4, the fourth minor update to the free office suite developed by volunteers for…

Open Document Format

The Future of Open Standards and the Importance of ODF

Open standards don't make headlines. Instead, they work quietly behind the scenes to define how information is created, shared and…