Get the best of LibreOffice Calc with the Calc Guide 26.2

The LibreOffice documentation team is proud to announce the immediate availability of the Calc Guide 26.2.

Whether you’re a beginner or an expert, this guide covers all aspects of the LibreOffice Calc spreadsheet module—from creating simple shopping lists to performing advanced data analysis and complex calculations.

“We examine the Calc guide from the end user’s perspective—covering step-by-step instructions, explanations of the spreadsheet’s internal workings, and illustrating the use cases where each feature applies” said Olivier Hallot, Documentation Coordinator and Guide Lead for Calc.

(more…)

Document Freedom Day: because the format is the message

 

Every year, on the last Wednesday in March, the open-source community celebrates Document Freedom Day. It’s an excellent opportunity to pause for a moment and ask a question that seems technical but is actually deeply political: who controls your documents?

The answer depends almost entirely on the file formats you use.

A freedom that is easy to overlook

When you write a letter, draft a report or create a spreadsheet, you are producing something that belongs to you: your words, your data, your work. But if that content is locked into a proprietary format, whose specifications are controlled by a single vendor, subject to change without notice and readable only by software that vendor chooses to certify, then your ownership is, at best, conditional.

Open document standards exist to remove this restriction. Open Document Format (ODF), the ISO standard adopted by LibreOffice and the wider free software ecosystem, ensures that your documents remain yours: today, tomorrow and twenty years from now, regardless of the software vendor or subscription model.

This is no minor convenience. It is a structural guarantee of autonomy.

The political dimension

Document Freedom Day is not just a celebration for developers and system administrators. It is a reminder that the documents underpinning the infrastructure of public communication, and their format, carry political weight.

When a public authority sends a document in a format that requires proprietary software to open correctly, it is making a biased technical choice, and is implicitly imposing the use of a specific vendor’s product at the citizen’s expense. When a school requires all pupils to submit assignments in a format tied to proprietary software, it is normalising dependence from a very young age.

Open standards break this chain of dependency, and transform the document – and the information it contains – into a shared resource that no single actor can control.

A step forward to celebrate

This year there is another reason to celebrate: the Deutschland-Stack, which makes ODF and PDF/UA standards mandatory in public administration. And this is not a pilot project or a recommendation, but a binding requirement based on the recognition that digital sovereignty begins with the formats a state uses to carry out its work.

Germany’s move is significant not only in itself, but also as a signal to other European governments that the issue has been resolved. ODF is mature, interoperable and ready for large-scale institutional implementation, so the question is no longer whether open standards work, but how much longer other administrations can justify not using them.

What still needs to be done

Progress is real, but the work is far from finished. Proprietary formats still dominate much of the public sector, education and business environments across all continents. Interoperability remains a daily struggle for users who receive documents that do not display correctly with free software, not because ODF is deficient but because some vendors continue to treat format compatibility as a competitive weapon rather than a public asset.

The FOSS community has a fundamental task: to produce the best possible implementations, document migration paths, support public administrations in the transition, and present the political argument clearly and without excuses. The choice of format is not a preference; it is a political decision with long-term consequences for democratic access to information.

A reason to keep going

Document Freedom Day reminds us all that the infrastructure of a free society must be built on open foundations. The use of LibreOffice in public administration, ODF requirements in procurement policies, and citizens being able to open a government document without having to buy a proprietary software licence are not small victories, but the gradual construction of a digital public space that belongs to everyone.

This deserves to be celebrated. And then back to work.

The Document Foundation supports Document Freedom Day and the global campaign for truly open document standards. To find out more, visit The Document Foundation’s website.

The Brazilian law that changes everything for schools, and why LibreOffice is the right answer

Brazil’s Lei 15.211/2025, also known as the Estatuto Digital da Criança e do Adolescente (EDCA), came into force on 17 March 2026. It is one of the world’s most comprehensive digital child protection laws, with profound implications for the Brazilian education system.

School administrators, IT managers, and education policymakers now have a legal obligation to consider every technology product deployed in classrooms. LibreOffice, the FOSS office suite developed and maintained by The Document Foundation, is uniquely positioned to meet these obligations by design.

What the law actually requires

The EDCA establishes that every IT product or service directed at children and adolescents – or “likely to be accessed” by them – must guarantee their integral protection, prioritise their best interests and maintain the highest level of privacy and data security (Art. 3). Among the law’s key requirements are:

  • Privacy by default and by design. Products must operate at the highest available level of data protection as a default setting, and any reduction in protection must require explicit, informed consent (Art. 7).
  • No behavioural profiling. Any form of automated or manual profiling of minors based on behaviour, preferences, economic status or location is subject to strict limitations (Arts. 2(V) and 26).
  • No predatory commercial exploitation. Techniques that profile children for advertising purposes are explicitly prohibited, as are design patterns intended to encourage prolonged use (Arts. 22, 17).
  • Digital citizenship education. The promotion of the safe, responsible and critical use of technology is listed as one of the foundational principles for all IT products used by minors (Art. 4, VIII).
  • Transparency and accountability: Technology providers must be auditable and have a legal representative in Brazil, as well as publishing transparency reports (Arts. 31 and 40).

Educational software is not exempt from this law. Any office suite, productivity tool or learning application running on school devices is an IT product as defined in Art. 1, and the access standard is deliberately broad.

Why LibreOffice fits natively

LibreOffice was not designed to exploit the attention of its users. It is not a cloud service. It does not collect usage telemetry by default. It does not profile users. It does not display adverts. There are no engagement algorithms optimised to keep students on the platform.

In the language of the EDCA, it is a product whose architecture embodies the principle of privacy by design (Art. 7), and not because it has been retrofitted to comply, but because there is no commercial incentive for it to do otherwise.

Specifically:

No data leaves the classroom without explicit configuration. LibreOffice runs locally on the desktop, and documents are stored wherever the school chooses. There is no background synchronisation with a vendor’s cloud and no automatic transmission of usage patterns to a third party. It is the school, and not a foreign corporation, that controls the data environment.

It is auditable to the source code. According to the EDCA, technology products must be evaluated for their potential impact on the health and safety of children and adolescents (Art. 8, I). LibreOffice’s source code is publicly available under the Mozilla Public Licence, and can be inspected by any school, researcher or public authority. There is no black box.

There are no manipulative design patterns. The law explicitly prohibits features that artificially extend or sustain product use by minors, such as autoplay, reward programs, non-essential notifications and personalised recommendation systems (Art. 17, §4). LibreOffice has none of these features. It opens a document, it helps the user to work with it, and then it closes. This is what neutral, instrumentally focused software looks like.

It supports digital citizenship education. Art. Article 4, Section VIII of the EDCA establishes the promotion of “digital citizenship and critical thinking for safe and responsible technology use” as a foundational principle. Using LibreOffice in schools is a pedagogical act in itself as it teaches students that software is a tool and not a service that monitors them; that their documents belong to them and are stored in open standard formats (ODF), which any compatible application can read; and that technology infrastructure can be based on transparency rather than restriction.

Open Document Format is digital sovereignty. ODF, LibreOffice’s native format, is an ISO-certified open standard. Documents created by Brazilian students today will be readable ten years from now by any application that respects the standard without requiring vendor permissions or subscription fees, and data being routed through a foreign corporate infrastructure. This is not an incidental feature but a material expression of the EDCA’s guarantee of meaningful access to digital technologies (Art. 5, §2).

In plain terms, schools deploying LibreOffice do not need to read a 200-page data processing agreement to understand what happens to their students’ data. They do not need to complete a vendor questionnaire and wait for a legal team in the US to respond, or to negotiate a contractual carve-out for LGPD (Lei Geral de Proteção de Dados) compliance, or worry about whether a new product feature silently changes the default privacy configuration.

The architecture answers the question. Local software, open code, no telemetry, no profiling and no engagement design are not compliance claims that need to be verified. They are structural properties that can be confirmed by any competent system administrator.
Under the EDCA, transparency is not optional. It is what the law demands.

A Call to Action for Brazilian Education

The EDCA came into force on 17 March 2026. Schools and municipalities that have not yet reviewed their technology stack now have a legal obligation, rather than just a policy recommendation, to do so. The Document Foundation invites Brazilian educators, school administrators and public procurement officers to:

  1. Audit existing deployments of proprietary cloud platforms against the EDCA’s requirements for privacy by default, data minimisation and prohibition of behavioural profiling.
  2. Evaluate LibreOffice as a classroom productivity solution, including the enterprise-ready LibreOffice Technology ecosystem for schools requiring centralised administration and support.
  3. Adopt the OpenDocument Format (ODF) as the institutional open standard for document formats to ensure that student work remains portable, open and free from vendor dependency.
  4. Engage with the community. LibreOffice is developed by a global community of active contributors, including many in Latin America. Brazilian schools that adopt LibreOffice are not just consumers, but they can help to shape the tool that their students use.

The Lei da Criança e do Adolescente is a law that protects children in digital environments, and LibreOffice is a software that was never designed to exploit children. This is not a coincidence, but the consequence of a shared understanding of what technology should be in a democratic society: a tool for users, not the other way around.

The Document Foundation is the non-profit organisation behind LibreOffice. LibreOffice is free to download, deploy and use. For information on enterprise deployments and certified support providers, visit https://www.libreoffice.org or write to info@documentfoundation.org.

Coming up: Document Freedom Day in Noida, India

Document Freedom Day logo

The Software Freedom Law Center of India writes:

Ever lost access to a file because the software stopped working? That’s what happens when your data is trapped in proprietary formats.

Proprietary formats give corporations the power to decide how and when you access your own data. Open Standards take that power back by keeping your documents accessible, portable, and free, no matter what software or company comes and goes.

This March 29, join us to celebrate Document Freedom Day 2026 – a global movement for the right of every individual and organisation to own and control their digital data, without lock-ins or restrictions. 📄💪

Join The Document Foundation and SFLC.in for an afternoon of community, conversation, and celebration! 🎉

📍 Essentiadev, Noida | 🕐 1 PM | 📅 29 March 2026

Register via this link

Please note that the last date for submitting a proposal is 26th March 11:59pm IST

The Turkish Documentation Community joins LibreOffice Bookshelf

The Turkish documentation community is now publishing their LibreOffice documentation in the Turkish language in the LibreOffice Bookshelf.

Muhammet Kara, Turkish community member, says:

The Turkish documentation community is delighted to make LibreOffice resources more accessible to the Turkish people. We believe our ongoing efforts to popularize LibreOffice depend on comprehensive documentation, and we are committed to further expanding these valuable resources for our users.

The LibreOffice Bookshelf is a website for quick access to the several LibreOffice guides and related publications. It is accessible from books.libreoffice.org – or directly from inside LibreOffice by choosing menu Help > User Guides.

Readers interested in the source code of the bookshelf website can visit git.libreoffice.org/infra/bookshelf/.