文档基金会正在招募一名全职 C++ 程序员,从事 LibreOffice 中从右到左RTL、复杂文字布局 RTL、中日韩 CJK 语言相关代码的开发。职位申请截止日期为2024 年 1 月 8 日。
This is a feed aggregator that collects what LibreOffice and Document Foundation contributors are writing in their respective blogs.
To have your blog added to this aggregator, please mail the website@global.libreoffice.org mailinglist or file a ticket in Redmine.
文档基金会正在招募一名全职 C++ 程序员,从事 LibreOffice 中从右到左RTL、复杂文字布局 RTL、中日韩 CJK 语言相关代码的开发。职位申请截止日期为2024 年 1 月 8 日。
Para aquellos que prefieren ver, escuchar y aprender, el siguiente video es muy claridoso para hacer el remplazo de tipos de letra:
Porf favor acepta las cookies de YouTube para reproducir el video. Al aceptarlas podrás acceder al contenido de
Berlín, 7 de diciembre de 2023 – LibreOffice 7.6.4 Community y LibreOffice 7.5.9 Community están disponibles inmediatamente en es.libreoffice.org/descarga para Windows (procesadores Intel/AMD/ARM), macOS (procesadores Apple Silicon e Intel) y Linux [1].
LibreOffice 7.6.4 Community es la versión más avanzada …
Berlin, December 7, 2023 – LibreOffice 7.6.4 Community and LibreOffice 7.5.9 Community are immediately available from www.libreoffice.org/download for Windows (Intel/AMD/ARM processors), macOS (Apple Silicon and Intel processors), and Linux [1].
LibreOffice 7.6.4 Community is the most advanced version of the office suite, and offers the best in terms of productivity functions and interoperability with Microsoft Office proprietary formats.
LibreOffice 7.5.9 Community is the most thoroughly tested version of the suite, for productivity applications in the enterprise environment, but has now reached the end of its life, so users are invited to plan the upgrade to LibreOffice 7.6.4 Community, which has also been tested and sought after enough for production environments.
For enterprise-class deployments, TDF strongly recommends the LibreOffice Enterprise family of applications from ecosystem partners – for desktop, mobile and cloud – with a large number of dedicated value-added features and other benefits such as SLA (Service Level Agreements): www.libreoffice.org/download/libreoffice-in-business/.
LibreOffice 7.6.4 Community and LibreOffice 7.5.9 Community are available from www.libreoffice.org/download/. Minimum requirements are Microsoft Windows 7 SP1 and Apple macOS 10.14. LibreOffice Technology-based products for Android and iOS are listed here: www.libreoffice.org/download/android-and-ios/
The Document Foundation does not provide technical support for users, although they can be helped by volunteers on user mailing lists and on the Ask LibreOffice website: ask.libreoffice.org
LibreOffice users, free software advocates and community members can support The Document Foundation with a donation at www.libreoffice.org/donate
[1] Change log pages: wiki.documentfoundation.org/Releases/7.6.4/RC1 and wiki.documentfoundation.org/Releases/7.5.9/RC1
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
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.
忘记了ods电子表格文档的密码,怎么办?如果你大概知道自己当时设置的密码的规律(比如,密码的长度,密码中包含哪些字符,是纯数字还是数字字母组合),那么可以通过编程的方式通过依次尝试的暴力破解方式找到密码。
Today we’re talking to Robert Cabane, who helps out in LibreOffice’s Quality Assurance (QA) community:
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.
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.
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.
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.
This post is part of a series to describe how Writer now gets a feature to handle tables that are both floating and span over multiple pages.
This work is primarily for Collabora Online, but is useful on the desktop as well. See the 9th post for the previous part.
Previous posts described the hardest part of multi-page floating tables: reading them from documents, so we layout and render them. In this part, you can read about UI improvements when it comes to creating, updating and deleting them in Writer.
Regarding testing of the floating table feature in general, the core.git repository has 89 files now which are focusing on correct
handling of floating tables (filenames matching floattable-|floating-table-
). This doesn't count
cases where the document model is built using C++ code in the memory and then we assert the result
of some operation.
Here are some screenshots from the improvements this month:
Improved insertion of floating tables
The first screenshot shows that the underlying LibreOffice Insert Frame dialog is now async (compatible with collaborative editing) and is now exposed in the Collabora Online notebookbar.
There were other improvements as well, so in case you select a whole table and insert a new frame, the result is close to what the DOCX import creates to floating tables. This includes a default frame width that matches the table width, and also disabling frame borders, since the table can already have one.
The next screenshot shows an inserted floating table, where the context menu allows updating the properties of an already inserted floating table, and also allows to delete ("unfloat") it.
Several of these changes are shared improvements between LibreOffice and Collabora Online, so everyone benefits. For example, inserting a frame when a whole table was selected also cleared the undo stack, which is now fixed. Or unfloating table was only possible if some part of the table was clipped, but now this is always possible to do.
If you would like to know a bit more about how this works, continue reading... :-)
As usual, the high-level problem was addressed by a series of small changes:
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.
If you see your name (or username) on this page, get in touch! Email mike.saunders@documentfoundation.org with:
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!
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:
LibreOffice 24.2 will be released as final at the beginning of February, 2024 ( Check the Release Plan ) being LibreOffice 24.2 Alpha1 the first pre-release since the development of version 24.2 started in mid June, 2023. Since then, 4271 commits have been submitted to the code repository and more than 787 bugs were set to FIXED in Bugzilla. Check the release notes to find the new features included in this version of LibreOffice.
LibreOffice 24.2 Alpha1 can be downloaded for Linux, macOS and Windows, and it can be installed alongside the standard version.
In case you find any problem in this pre-release, please report it in Bugzilla ( You just need a legit email account in order to create a new account ).
For help, you can contact the QA Team directly in the QA IRC channel or via Matrix.
LibreOffice is a volunteer-driven community project, so please help us to test – we appreciate it!
Happy testing!!
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:
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.
Here’s our summary of updates, events and activities in the LibreOffice project in the last four weeks – click the links to learn more…
El IV Congreso Latinoamericano de LibreOffice, celebrado los días 9 y 10 de noviembre de 2023, fue todo un éxito. Lo llevamos a cabo en la gloriosa Universidad Nacional Autónoma de México, gracias a la generosidad y colaboración de la …
Ever wondered how to create a LibreOffice extension? Here I discuss how to do that via Python programming language. It is possible to run and debug the resulting Python code in an IDE, and then package the content as an extension.
If you have used LibreOffice extensions, you know that many exciting things can be done with extensions. Extensions can open LibreOffice applications, create new documents, read and write text and images inside the documents, and convert them to all possible formats. They can have their own menus and toolbar buttons, and have nice looking GUIs to interact with the users.
To write an extension, the easiest way is to use LibreOffice BASIC language. You can refer to this tutorial for such an approach here:
But with Python, you will have access to a big set of packages, that is one of the many strengths of the Python programming language. You can do almost anything possible with a software with those packages. Furthermore, LibreOffice has its own Python interpreter! In this way, installing and using a Python extension would be much easier.
First of all, you should know about context, and you should be able to have that variable to be able to use LibreOffice API.
There can be at least 3 different possibilities for running a Python program with LibreOffice:
In each of these possibilities, the way to get the context and use them is different.
Extensions are essentially zip files that have specific files known to LibreOffice inside them. This is the structure of a Python extension:
META-INF/
: required folderMETA-INF/manifest.xml
: Specification of the script(s), menu/toolbar and language filespkg-description/pkg-description.en
: Description of the extension in text, which can be also in languages other than English
registration/
: required folderregistration/license.txt
: License of the extensiondescription.xml
: Description of the extension in XML format, as displayed in the extension managermain.py
: The main script. Then name can be anything but it shouldMETA-INF/manifest.xml
Most of the contents of the files are re-usable, so you can use the skeleton extension, and build your extension around that. But, the Python script is important and we will talk about it here.
From the above 3 possible situations for LibreOffice, in order to be able to use the code as extension, you should add these this 2 lines should be in the Python file
g_ImplementationHelper = unohelper.ImplementationHelper() g_ImplementationHelper.addImplementation(MainJob, "org.extension.sample.do",("com.sun.star.task.Job",), )
In addition, this import is also required:
from com.sun.star.task import XJobExecutor
Then, a Python class with this definition is needed:
class MainJob …
With the release of LibreOffice 7.6.3, the LibreOffice Viewer app for Android has been made available in the Google Play Store.
LibreOffice Viewer is a lightweight version of LibreOffice for Android smartphones and tablets for viewing Open Document Format (.odt, .ods, .odp) and Microsoft Office (.docx, .xlsx, .pptx) documents. It is built on the same LibreOffice technology as the LibreOffice desktop app for Windows, macOS and Linux, so it displays documents in exactly the same way.
LibreOffice Viewer also has experimental editing features that can be enabled in the application’s settings, but are not considered ready for production use. As we’re a volunteer-driven, community open source project, we’d appreciate help to improve the editing support.
LibreOffice Viewer has been available on Google Play in the past, but due to lack of maintenance it was withdrawn in 2020. Since then, more than two hundred changes have been made to improve the app, increase its stability and usability, support current Android versions and better integrate with the system.
Since the beginning of this year, LibreOffice Viewer has been updated to the latest versions in F-Droid. With the re-release of the app on the Google Play Store, LibreOffice Viewer is now widely available to Android users.
Feedback and bug reports are welcome to help the community improve the quality of the app. You can report bugs and attach files here: bugs.documentfoundation.org
Developers interested in helping improve the app can find more information about LibreOffice development in general and the Android version in particular on the wiki.
Con el lanzamiento de LibreOffice 7.6.3, la aplicación LibreOffice Viewer para Android está disponible en Google Play Store.
LibreOffice Viewer es una versión ligera de LibreOffice para teléfonos inteligentes y tabletas Android que permite visualizar documentos en formato Open …
Berlin, November 23, 2023 – LibreOffice 7.6.3 Community, the third minor release of the 7.6 family of the volunteer-supported free office suite for Windows (Intel/AMD and ARM processors), macOS (Apple and Intel processors) and Linux is now available from our download page.
At the same time, the LibreOffice Viewer app for Android is back in the Google Play Store, to view documents based on the standard Open Document Format and the proprietary Microsoft Office format. It joins the F-Droid version which has been available for some time.
LibreOffice is the only open source office suite for personal productivity which can be compared feature-by-feature with the market leader. LibreOffice offers the highest level of compatibility in the office suite market segment, with native support for the Open Document Format (ODF) – beating proprietary formats for security and robustness – to superior support for Microsoft Office files, along with filters for a large number of legacy document formats, to return ownership and control to users.
Based on the advanced features of the LibreOffice Technology platform for personal productivity on desktop, mobile and cloud, LibreOffice provides a large number of new features targeted at users sharing documents with or migrating from Microsoft Office to ensure their digital independence from the commercial strategy of vendors. These users should check new releases of LibreOffice on a regular basis, as the progress is so fast, that each new version improves dramatically over the previous one.
LibreOffice for Enterprises
For enterprise-class deployments, TDF strongly recommends the LibreOffice Enterprise family of applications from ecosystem partners – for desktop, mobile and cloud – with a number of value-added features and benefits such as SLA (Service Level Agreements): see this page.
Every line of code developed by ecosystem companies for their enterprise customers is shared with the community on the master code repository, and improves the LibreOffice Technology platform.
The Document Foundation has developed a Migration Protocol to support enterprises moving from proprietary office suites to LibreOffice, which is based on the adoption of an enterprise optimized version of LibreOffice, plus migration consultancy and training sourced from certified professionals who offer value-added solutions and services to match proprietary offerings: www.libreoffice.org/get-help/professional-support/.
Indeed, LibreOffice – thanks to its mature codebase, rich feature set, strong support for open standards, excellent compatibility and LTS options from certified partners – is the ideal solution for businesses that want to regain control of their digital independence, and free themselves from vendor lock-in.
Availability of LibreOffice 7.6.3 Community
LibreOffice 7.6.3 Community is available from: our download page. Minimum requirements for proprietary operating systems are Microsoft Windows 7 SP1 and Apple macOS 10.15. LibreOffice Technology-based products for Android and iOS are listed here: www.libreoffice.org/download/android-and-ios/.
For users who don’t need the latest features, and prefer a version that has undergone more testing and bug fixing, The Document Foundation maintains the LibreOffice 7.5 family, which includes several months of back-ported fixes. The current version is LibreOffice 7.5 …
Imprint Privacy Policy | |
The Document Foundation is not responsible for the content on planet.documentfoundation.org. However - if you have any concerns about content please contact act Uwe Altmann for moderation. Copyright information: Unless otherwise specified in the author's blog, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the "Mozilla Public License v2.0". "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy. |
![]() |
this site runs a modified version of planet.opensuse (https://github.com/openSUSE/planet.opensuse.org) © 2010 Pascal Bleser and the openSUSE Community. |