Welcome to The Document Foundation Planet

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.

25 October, 2019

[en] Michael Meeks: 2019-10-25 Friday.

21:00 UTC

  • Mail chew, fixed timezone issue in Online - to use localtime properly. Lunch, Board call, customer call, patch review & merging.

文件基金會一直以來都反對使用專利來限制自由軟體的開發與使用。GNOME 基金會是我們諮詢委員會的成員,目前是專利蟑螂 Rothschild Patent Imaging LLC 的目標,針對的是 Shotwell 的維護與散佈,這是一套 GNOME 桌面環境下的自由開放原始碼個人照片管理軟體。

GNOME 基金會拒絕和解,並已向法院遞交三份不同的文件:駁回該案的動議、對索賠的答覆與對抗專利蟑螂的決定,這樣才能避免其他使用者或開發者被該組織或類似組織起訴的風險。

您可以在此閱讀 GNOME 基金會總覽目前狀況的部落格文章:https://www.gnome.org/news/2019/10/gnome-files-defense-against-patent-troll/。文件基金會邀請所有 LibreOffice 社群成員與 GNOME 基金會站在同一陣線,向全世界表達我們自由軟體社群會對抗任何濫用專利制度的行為。

新聞來源:The Document Foundation supports GNOME Foundation fight against a patent troll

24 October, 2019

[en] Michael Meeks: 2019-10-24 Thursday.

21:00 UTC

  • Mail, lots of admin, chewed back through the mailbox to some depth; monthly all-hands call.

23 October, 2019

  • Mail, TDC call, drove home, customer call, admin until late.

22 October, 2019

[en] Michael Meeks: 2019-10-22 Tuesday.

21:00 UTC

  • Lots of admin, tech mgmt call & minutes.


The LibreOffice Quality Assurance ( QA ) Team is happy to announce LibreOffice 6.4 Alpha1 is ready for testing!

LibreOffice 6.4 will be released as final at the beginning of February, 2020 ( Check the Release Plan ) being LibreOffice 6.4 Alpha1 the first pre-release since the development of version 6.4 started in the beginning of June, 2019. Since then, 4600 commits have been submitted to the code repository and more than 720 bugs have been set to FIXED in Bugzilla. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 6.4 Alpha1 can be downloaded from here 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 Telegram.

Happy testing!!


21 October, 2019

[en] Michael Meeks: 2019-10-21 Monday.

21:00 UTC

  • Sync with Szymon, started up the mail backlog cliff, wow. Network somewhat flaky. Suffering from lost key-events (mostly modifiers) somehow, most annoying.
  • Poked at calc rendering, got some nice unwanted deltas out of adjacent tiles and diffed them - spot the jumping pixels.


Writer now has a new "continuous endnotes" compatibility setting in its layout, allowing rendering endnotes in a way which is closer to what Word users expect.

First, thanks TU Dresden who made this work by Collabora possible.

Here is how it looks:

Figure 1. Writer, new ContinuousEndnodes layout flag enabled
Figure 2. Reference rendering
Figure 3. Writer, old separate endnote page layout

What you can see is that endnotes unconditionally start after the end of the document content in Word, while endnotes are unconditionally on separate endnote pages in Writer. The new ContinuousEndnotes layout compatibility flag in Writer allows rendering endnotes the Word way.

This new flag is enabled by default for DOC files, disabled otherwise.

All this is available in LibreOffice master (towards 6.4), so you can try it out right now, if interested.

20 October, 2019

[en] = Andreas Kainz: AutoCorrect Dialog

21:50 UTC


I add an additional item on my (very long) todo list:

  • Update LibreOffice Dialogs

One Dialog is finished AutoCorrect tdf#127773 (left 6.3, right 6.4)

In addition to an better placement the Word Completion Tab should be now easier to understood.

Character Dialog tdf#127927, Paragraph Dialog tdf#128239 and > 100 Dialogs are on my todo list. If you like my work, become a


[en] Michael Meeks: 2019-10-20 Sunday.

21:00 UTC

  • Up late, off to Jennyfields Evangelical Church; good Gospel presentation; home for lunch - out for a walk with M. and J. slugged variously, bed.

19 October, 2019

[en] Michael Meeks: 2019-10-19 Saturday.

21:00 UTC

  • Interesting sessions in the morning; flight to LHR. Worked on the trains home variously. Picked up by J. in Knaesborough - back to M&D's, H. and N. arrived back late from dancing with D.

18 October, 2019

[en] Michael Meeks: 2019-10-18 Friday.

21:00 UTC

  • Checked out, moved hotel, met up with Florian & Thorsten nearby. Caught up with people, an interesting tour of a local castle: Nymphenburg, though more a palace than a castle. Back, had a drink with Thorsten, dinner with a Ceph chap, wandered, bed.

是的,我們又有另一批從最近在西班牙阿爾梅里亞舉辦的 LibreOffice Conference 2019 演講影片。讓我們先從 Tor Lillqvist 的演講“LibreOffice as an iOS app on the iPad”開始:

然後是 Marco Cecchetti 的“Chart editing in Online”:

Michael Meeks 的“Online: copy/paste”:

Ashod Nakashian 的“Bringing the Sidebar Online”:

Philippe Hemmel 的“Integrating LibreOffice Online in Alfresco”:

Eduard Ardeleanu 的“LibreOffice adoption into 1&1 Mail & Media ecosystem”:

最後是 Thorsten Behrens 的“Improving the LibreOffice PDF export”:

新聞來源:Seven more videos from the auditorium at LibreOffice Conference 2019


Self-publishing with LibreOffice Writer 6My new book, Self-publishing using LibreOffice Writer 6, is now available in paperback or PDF.

Printed copies are available from Lulu.com for US$15.00. Pay at Lulu.com.

Download PDF here. Cost is US$5.00, on the honor system. Please pay using the button below (Paypal or credit card). If you buy a printed copy, you are welcome to a free copy of the PDF.


Have you ever wanted to have a way to see the full content of a spreadsheet document in a pdf form, without the usual slicing of the sheets into printable pages?

Why would I need that?

Here is the screenshot of a sheet containing some data and graphics: Sample Sheet And this is how it looks like when exported to pdf in the old/usual way: Usual PDF Output

Also read the blog on the Collabora-website for more explanation.

How do I use it?

  • Open your spreadsheet document in LibreOffice Calc
  • From the menu, select File - Export as PDF…
  • On the General tab of the PDF Options dialog, check the option named Full-Sheet Previews
  • Click the Export button, and choose a location for your preview pdf
  • Enjoy your pdf file of full sheet previews

Full-Sheet Preview PDF

Option on the dialog

Full-Sheet Previews option on the PDF Export Dialog

Also available in the LibreOffice/Collabora Online api

If you happen to use the LibreOffice/Collabora Online REST api for document conversions, here is a command to get a preview output of your sheet:

curl --insecure -F "data=@YourSpreadSheetDocument.ods" -F "FullSheetPreview=true" https://localhost:9980/lool/convert-to/pdf > out.pdf

More info about the REST api

Where and when?

The feature was developed on the cp-6.2 branch of LibreOffice code-base (which is basicly Collabora Office 6.2), and is already available in Collabora Office snaphots. And is being backported to LibreOffice master, so it will be also available in LibreOffice development builds and soon in the Collabora Office snapshots.

For more info and the snapshot


  • Currently, this option disregards most of the other options on the pdf export dialog
  • Preview pages will have different sizes (same as the source sheets)
  • This is not meant for printing
  • The export dialog remembers your last choice, so better not forget to uncheck this option next time you would like to get a regular (for-printing) output

Dev Notes

  • The PDF export dialog’s UI description is in filter/uiconfig/ui/pdfgeneralpage.ui
  • The class for the dialog is named ImpPDFTabGeneralPage
  • To introduce a new option, you need to add the widget to the .ui file, then add a proper item to the class, and connect the two in the constructor
    • In our case, the id of the new checkbox on the ui file is singlepagesheets

      <object class="GtkCheckButton" id="singlepagesheets">
                  <property name="label" translatable="yes" context="pdfgeneralpage|singlepagesheets">Full-Sheet Previews</property>
                  <property name="visible">True</property>
                  <property name="can_focus">True</property>
                  <property name="receives_default">False</property>
                  <property name="use_underline">True</property>
                  <property name="xalign">0</property>
                  <property name="draw_indicator">True</property>
    • And the corresponding member in the ImpPDFTabGeneralPage class is named as mxCbSinglePageSheets

      std::unique_ptr<weld::CheckButton> mxCbSinglePageSheets;
    • We connect the two via this line in the constructor of the class:


And here is a list of related commits if you would like to see what other changes were done:

  1. Add ‘SinglePageSheets’ option to the PDF export dialog
  2. Handle SinglePageSheets option for pdf export
  3. Add FullSheetPreview support for convert-to endpoint of online
  4. Rename

17 October, 2019

[en] Michael Meeks: 2019-10-17 Thursday.

21:00 UTC

  • Breakfast, some more 'byes. Taxi to Nice; flight to Munich and the GSOC Mentor summit. Interesting Taxi ride with Philippe from nexB, checked into the nearby hotel and spent an evening enjoying the company of lots of mentors and others. Among many others, really lovely to see Karen again.

九月的時候我們在西班牙的阿爾梅里亞舉辦了 LibreOffice Conference 2019。我們還在上傳演講的影片,這裡又有一批新的!首先是 Stephan Bergmann 的“Janitor of Sanity”:

然後是 Luboš Luňák 的“On making code more readable”:

Yunusemre Şentürk 的“Internal CI system with Jenkins”:

Thorsten Behrens 的“Getting LibreOffice KDE5 support production-ready”:

Miklos Vajna 的“Bottom to top, left to right writing direction in Writer”:

Iván Sánchez Ortega 的“Getting on key”:

Xisco Fauli 的“QA: 1 year recap”:

最後是 Jan Holesovsky 的“Reusing LibreOffice Online as an Android app”:

新聞來源:Eight videos from the auditorium at LibreOffice Conference 2019

[tw] 黃柏諺: LibreOffice 6.2.8 釋出

13:50 UTC

文件基金會於10月17日釋出了 LibreOffice 6.2.8,這是 LibreOffice 6.2 的第八個錯誤修正版本,所有 LibreOffice 6.2 系列的使用者都應該更新到此版本以增強安全性,並準備好升級到將在12月提供的 LibreOffice 6.3.4。

新聞來源:LibreOffice 6.2.8 is available, the last release of the 6.2 family

16 October, 2019

  • Up; another lovely buffet meal, and to the hub to run a booth - demoing Collabora Office and/or Online to passing Collaborans with updates on progress.
  • Enjoyed a little windlands and admired the great work getting so many Steam games running under Linux with the latest Vive, as well as great OpenHMD/Monado bits.
  • Relaxed & talked to tons of great devs and mgmt. Team photo in a packed cinema, secured a solid bottom place in the Tux carting championship; lots of fun.

15 October, 2019


On Monday September 16th, Richard Stallman, long-time president and founder of the FSF, has resigned from both his position at the FSF, and the MIT.

There’s a plethora of reporting around that – if you’re short on time, then I recommend reading Thomas Bushnell’s rather excellent medium piece in full.

Many things can be said about this event, but immediately coming to defend RMS as a principled old man, who was the victim of a witch hunt, is not it. I fundamentally disagree with Michael here, and like to point out (though its obvious), that his point of view is not shared nor endorsed by The Document Foundation, albeit aggregated on their planet.

This is what I posted last night to the TDF board, when we discussed the implications on Michael’s post being on that planet:

Dear board,

Björn wrote:

Or to put it much better argumented and better informed than I ever could:
View at Medium.com

Please do read the linked article in full. It echos my thoughts
exactly, but with much more authority & eloquence than I could have.

If you have some extra time, the entire story is many years, and
probably thousands of pages worth of words - but it's not a happy
story (it includes, at various occasions, RMS endorsing child
pornography and pedophilia).

For me, the sticking point is a slight remix of one of Thomas'
sentences: Michael treated the problem as being “let’s make sure we
don’t criticize RMS unfairly”, when the problem was actually, “how can
we come to terms with a decades-long history of RMS’s own mistreatment
of women and held views incompatible with broad societal norms &

In light of the above, I reject, in the strongest possible terms,
being seen near a statement that starts with "Really disappointed to
see the outcome with RMS". The blog post is offensive to women, the
victims in particular, tone-deaf to the wider issues at stake, and
harmful for TDF's reputation when issued by a board member on a
TDF-imprinted site.

It would have been better to stay silent.

Can someone please fix this?


-- Thorsten

Update 2019-09-23: Perhaps not entirely unambiguous – I wasn’t suggesting here that Michael would fully endorse RMS, but coming to his defense at this incident. Also adding the real name of my fellow TDF director, whom I was responding to in the mail above.

Update 2019-10-15: Bradley Kuhn’s statement after leaving the FSF is worth reading in its entirety, and well reflects what I believe leaders should aspire to.


LibreOffice 6.4 está siendo desarrollado por nuestra comunidad mundial y su lanzamiento está previsto para principios de febrero de 2020 – puedes ver las notas de lanzamiento que describen las nuevas características. Por supuesto, estamos en la fase inicial …

LibreOffice 6.4 預計將於2020年2月上旬釋出,包含了許多新功能,已經實作的部份可於 release notes 頁面上看到,當然,還有更多新功能。

QA 團隊將會在10月21日舉辦 LibreOffice 6.3 的第一個臭蟲狩獵會議,其將會檢查 LibreOffice 6.4 Alpha 1,會在活動的前幾天放上預發佈伺服器,並可供 Linux(提供 deb 與 rpm 軟體包)、macOS 與 Windows 使用,而其設定檔將會另外存放,所以可與您目前使用的版本一同安裝。

在10月21日當天,導師會在 UTC 早上7點至晚上7點(亦即臺灣時間的21日下午3點至22日的凌晨3點),經由 QA 團隊的 IRC 頻道Telegram 群組協助經驗較少的志願者分類臭蟲。當然,您也可以在其它時間協助測試 LibreOffice 6.4.0 Alpha1,其將會在預發佈伺服器上放到11月中。

這次的臭蟲狩獵季所有的詳細資訊都在 wiki 上

新聞來源:Coming up on October 21: First Bug Hunting Session for LibreOffice 6.4!

14 October, 2019


在 LibreOffice 專案中做出重要技術決策的人是誰?在這個從最近在西班牙舉辦的 LibreOffice Conference 影片中,工程指導委員會(Engineering Steering Committee,簡稱 ESC)介紹了他們的任務並提供了近況更新:

新聞來源:LibreOffice Conference 2019: Meet the Engineering Steering Committee

12 October, 2019

這是在西班牙阿爾梅里亞舉辦的 LibreOffice Conference 2019“Sala de Grados (Aulario IV)”空間最後一組影片。當然,我們還會貼出其他空間的影片!(注意:為了取得較好的音訊,請使用耳機)

首先是 Thomas Viehmann 的“Neural Machine Translation for LibreOffice”:

Christian Lohmaier 的“Weblate public test feedback round”:

Masaki Murakami 的“Experiment for large-scale operation of LibreOffice Online, 2019 Edition”:

Cor Nouws 的“LibreOffice Online new features”:

Jan Holesovsky 的“Online integration success stories”:

Italo Vignoli 的“10/20 Anniversary Planning”:


新聞來源:Six extra videos from the LibreOffice Conference 2019

10 October, 2019

我們已經上傳了最近在西班牙阿爾梅里亞舉辦的 LibreOffice Conference 2019 的更多演講影片。其中有許多 LibreOffice 與其他辦公室軟體的互操作性議題。首先是 Marina Latini 的“Sharing is caring”:

 Gabriele Ponzo 的“TDF community and membership: how to get in”:

Leo Moons 的“LibreOffice community and the SDG”:

Gábor Kelemen 的“Interoperability as core feature”:

Svante Schubert 的“Interoperable office collaboration”:

Mike Kaganski 的 “Interoperability improvements in the last year”:

Mert Tümer 的“Watermarking: a secure way to share documents”:

Balázs Varga 的“Interoperability of Charts between LibreOffice and Microsoft Office”:

新聞來源:Nine more videos from the LibreOffice Conference 2019

09 October, 2019


Promuovere e diffondere la cultura, le tecnologie e le applicazioni del FOSS (Free and Open Source Software) per alimentare percorsi di condivisione della conoscenza con un’attenzione particolare al mondo della scuola di ogni ordine e grado. Sono questi gli obiettivi alla base dell’accordo stipulato tra Microtech – azienda italiana specializzata nella realizzazione di dispositivi hi-tech […]

07 October, 2019

我們已經上傳了最近在西班牙阿爾梅里亞舉辦的 LibreOffice Conference 2019 的更多演講影片。首先是 Jeff Huang 的“Generating ODF reports on server side”:

再來是 Andras Timar 的“How best to migrate to LibreOffice”:

Wen-Ke Huang 的“Grow out of nothing”:

Björn Michaelsen 的“Agile LibreOffice: how not to lead an open source project”:

Ilmari Lauhakangas 的“Recruiting is hard, let’s go shopping”:

Gabriele Ponzo 的“TDF’s Membership Committee: how does it work”:

Gustavo Buzzatti Pacheco 的“Handling TDF membership applications with the mcm-script”:

Naruhiko Ogasawara、Shinji Enoki 與 Jun Nogata 的“LibreOffice Asia Conference 2019 Tokyo: what we achieved, and what’s next”:

Kuan-Ting Lin 與 Xiao-Wu Wang 的“Making LibreOffice a lifesaver for dying languages in Asia”:

最後是 Gustavo Buzzatti Pacheco 的“The challenge of a regional LibreOffice Conference PDF”:


新聞來源:10 more videos from the LibreOffice Conference 2019

06 October, 2019



If you think nothing happens in LibreOffice, that’s not true. I for example prepair some new Templates and Galleries for LibreOffice.

GUI Widgets for LibreOffice (Draw)

If you are interested, join the LibreOffice Design Team.

04 October, 2019


General Activities

  1. LibreOffice 6.3.1 and LibreOffice 6.2.7 were released on September 5
  2. LibreOffice 6.3.2 was released on September 26
  3. The PPT/PPTX Team was created and announced publicly.
  4. The Macro Team was created and announced publicly.
  5. Roman Kuznetsov changed fonts in Help installer to Segoe UI 9 pt
  6. Many problems with bullets and numbering in DOCX files were fixed: tdf#64222 (Michael Stahl, Samuel Mehrbrodt CIB) tdf#95848 (Michael Stahl) Timur was able to close many reports as duplicates of the fixed bugs
  7. Caolán McNamara (Red Hat) did a massive amount of UI work under the hood, for example renovating the wizard dialogs
  8. Caolán McNamara (Red Hat) removed the gtk+2 backend from master
  9. Miklos Vajna (Collabora) solved a cluster of issues related to textbox alignment and spacing in DOCX files https://bugs.documentfoundation.org/show_bug.cgi?id=124600
  10. Tünde Tóth (NISZ) fixed a bunch of OOXML hyperlink issues
  11. László Németh (NISZ) improved the workflow of manipulating tables in Writer tdf#84806 and tdf#118311
  12. Balazs Varga (NISZ) keeps improving OOXML Charts interoperability
  13. Xisco Fauli fixed some SVG issues
  14. Björn Michaelsen keeps fighting against the SwClient monster. Check his last update

Reported Bugs

627 bugs, 87 of which are enhancements, have been reported by 394 people.

Top 10 Reporters

  1. NISZ LibreOffice Team ( 33 )
  2. andreas_k ( 16 )
  3. nd101 ( 14 )
  4. Regina Henschel ( 12 )
  5. Mike Kaganski ( 12 )
  6. Nicolas Christener ( 11 )
  7. Thomas Lendo ( 9 )
  8. Eyal Rozenberg ( 9 )
  9. pedro.silva ( 8 )
  10. Roman Kuznetsov ( 8 )

Triaged Bugs

608 bugs have been triaged by 82 people.

Top 10 Triagers

  1. Xisco Faulí ( 152 )
  2. Dieter Praas ( 66 )
  3. Heiko Tietze ( 45 )
  4. V Stuart Foote ( 41 )
  5. Julien Nabet ( 36 )
  6. Oliver Brinzing ( 30 )
  7. Timur ( 26 )
  8. m.a.riosv ( 21 )
  9. Roman Kuznetsov ( 21 )
  10. Alex Thurgood ( 13 )

Resolution of resolved bugs

551 bugs have been set to RESOLVED.

Check the following sections for more information about bugs resolved as FIXED, WORKSFORME and DUPLICATE.

Fixed Bugs

166 bugs have been fixed by 43 people.

Top 10 Fixers

  1. Caolán McNamara ( 22 )
  2. Julien Nabet ( 9 )
  3. Heiko Tietze ( 9 )
  4. László Németh ( 8 )
  5. Tünde Tóth ( 8 )
  6. Xisco Fauli ( 6 )
  7. Michael Weghorn ( 5 )
  8. Tamás Zolnai ( 5 )
  9. Miklos Vajna ( 4 )
  10. Michael Stahl ( 4 )

List of critical bugs fixed

  1. tdf#127695 CRASH: Inserting textbox in a particular document ( Thanks to Caolán McNamara )

List of crashes fixed

  1. tdf#127258 Impress Crash after Presentation Finished ( Thanks to Stephan Bergmann )
  2. tdf#127272 odt document + UI “registers” etc.: Writer crashes when UI will be set to “registers” etc. resp. after this when odt file should be opened ( Thanks to Sumit Chauhan )
  3. tdf#127461 data provider crashes LibreOffice when clicking “Apply Changes” ( Thanks to Julien Nabet )
  4. tdf#127546 Calc Crashes if I click in to the Range-select fied of the ‘Define Label Range’ dialog (gen) ( Thanks to Caolán McNamara )
  5. tdf#127646 GTK3 crash when create new macro ( Thanks to Caolán McNamara )
  6. tdf#127652 After deleting some text the LibreOffice Writer crash ( Thanks to Michael Stahl )
  7. tdf


Writer now has a new "allow overlap" shape property for anchored objects, which can ensure that objects with overlapping positioning properties don’t actually overlap.

First, thanks TU Dresden who made this work by Collabora possible.

Here is a video showing how it works:

Figure 1. Allow-overlap shape property in Writer

Under the hood, this is a full new Writer feature, since previously shapes were always allowed to overlap with each other:

  • macros get a new AllowOverlap shape property (true by default)

  • layout takes this into account if you set the property on the UI

  • both DOCX and ODT filters serialize and load this property (ODT proposal)

All this is available in LibreOffice master (towards 6.4), so you can try it out right now, if interested.

<- Current blog entries