顯示具有 ODF 標籤的文章。 顯示所有文章
顯示具有 ODF 標籤的文章。 顯示所有文章

2019年9月15日 星期日

今年 LibreOffice Conference 精彩回顧

今年度的 LibreOffice 年度論壇於 9/10~9/13 在西班牙的 Almeria 舉行。以下是我看到/聽到的一些精彩回顧:
  • 在 Community meeting 中提到 LibreOffice 的翻譯平台從 Pootle 轉移到 Weblate,新站台已經上線測試中,6.4 以後的翻譯將會從 Weblate 取用,6.3 以前的則仍在 Pootle 上更新。
  • ODF 1.3 版規格書已經整理完畢即將送 OASIS,一切順利的話將於 2020 年底發布。
  • 議程第一天(9/11)時大會(才)公布,在 AULA 08 (Aulario IV)  教室內的議程,因為教室內的投影設備只限接在教室內的電腦,而教室內的電腦未安裝 LibreOffice,所以要求講者準備 PDF 檔。
    • 但孫老大要講的是簡報技巧,只用 PDF 檔是不夠的。所以我們兩個在第一天議程結束後跑去教室內試電腦,結果發現:
      • 教室內電腦的 Windows 系統連系統設定都鎖起來了,不能安裝軟體也不能設定。
      • 但是可以使用 LibreOffice Portable
      • 然後雖然 Windows 系統鎖了那麼多東西,但 BIOS 沒有鎖,所以用 ezgo 隨身碟可以開進 ezgo 系統內。
  • 9/11 一場(對我們從台灣來的人來說算滿普通的)大雨,造成西班牙東南部嚴重災情(請參考 FB 上的頁面)。我們當時只覺得這雨還好而已,沒想到有六個人死亡(在此致上關懷之意)。
  • 議程第二天一大早,孫老大跟我就跑去把教室內的電腦佈置一下。我用隨身碟安裝了 LibreOffice Portable,確認可以執行後,第一個議程就使用 Portable 版的 Impress 直接進行。然而因為前一天的大雨,第一個議程進行沒多久學校的電力系統就出現跳電的狀況。折騰了一陣子之後,在 AULA 08 的議程直接用筆電進行。


    至於其他間的議程據說都無法進行下去。
  • 接下來第二個議程是孫老大的重頭戲,還好沒有再跳電。孫老大展示了動畫與聚焦技巧,還借用阿拉丁神燈來表達三個對 Impress 改進的期待。
  • 接著轉移陣地到 SALA DE GRADOS ,林冠廷跟王小武(?)兩位年輕人以小武自身賽德克族的經驗,來介紹運用 LibreOffice 保存台灣原民語言與文化的計劃,引起在場聽眾不錯的迴響。來自巴西、法國等地的參與者都表示有興趣,下午冠廷與小武並與來自巴西的 Gustavo 討論相關計劃。
  • 中午之後孫老大、來自中油的文科跟我先蹺課,跑去 Almeria 古堡一遊(因為我只有這天下午有時間出去晃晃...)後來傳來了消息,下午的議程又出現跳電,然後恢復供電以後,因為我的隨身碟還插在電腦上,電腦就直接開進 ezgo 了。在場的人都搞不清楚為何開機會開進中文的系統中 😆😆 
  • 第二天晚上是年會傳統 Hack Night。晚上七點半大家就進入飯店的會議室裡,卻傳出訂的 pizza 要九點才會到(晴天霹靂!)。晚上安排冠廷、小武跟 LibreOffice 資深開發者,也是董事會成員的 Eike Rathke 討論如何為台灣原住民族增加系統在地化資料庫(locale)的問題。台灣團都跟著加入了討論。
  • 第三天早上是認證委員會的 Workshop。第一天晚上我就接到通知。認證委員會的共同主席 Italo 與 Lothar 要邀請孫老大加入認證委員會,問我可不可行。此時不推坑更待何時?我當然一口答應,拍胸脯保證沒問題。孫老大順便露了一手,給在場的社群朋友看他的講義做法,以及我們如何推廣 ODF/LibreOffice。
  • 事後孫老大還特地為了這幾位義大利的朋友補課,因為他們沒能來聽第二天孫老大的議程。
  • 最後的高潮就是宣布明年 10/20 的活動了!明年是 LibreOffice 10 週年,也是自由辦公套裝軟體(i.e., OpenOffice.org)的 20 週年慶。所以會在明年的 7/18~7/19 在伊斯坦堡或安卡拉舉行 Free Suite 20th Anniversity,並宣布明年的年度論壇與 10 週年慶將在德國的紐倫堡舉行。

    嘛,我仍然是第一時間就知道投票結果(知道太多秘密也不好,沒有驚喜感...)

2016年10月10日 星期一

OOXML / 微軟舊封閉格式轉成 ODF -- 為何不要用微軟的 Office 來做這件事?


雖然國發會的說明會投影片中告訴大家微軟也支援 ODF,但是就幾個手上的例子,還有我跟國際社群實際接觸觀察到的現象,在此分享給大家。

先說結論:想要將微軟格式轉成 ODF,最好還是用新一點版本的 LibreOffice (5.1.x, 5.2, 5.3...) 轉出來的結果成功率較高。不要用微軟的 Office 來另存新檔。

進入正題:

1. 大約半年多前,我請目前台灣 ODF 第一把交椅的講師幫我用微軟 Office 2010,將幾個簡單到略微複雜的微軟 docx/pptx/xlsx 另存成 ODF 檔給我測試。不過當時因為國發會想要找到的是一個可以驗證 ODF 格式合法性的工具,所以我拿到這些檔案的主要目的是要測試這個:

https://odf-validator.rhcloud.com/

我拿這兩者做對照實驗:

第一組:講師給我的微軟 Office 原檔與直接另存新檔產生的 ODF 檔

https://goo.gl/qAGYlP
第二組:2016 年宜蘭縣政府 ODF 教育訓練公開招標文件,這時經過去年我們對宜蘭縣政府一年的教育訓練與工作導入輔導後,他們直接採用 LibreOffice 產生的 ODF 檔

https://goo.gl/y3vHxL

測試方式:選擇 ODF 1.2 Extended conformance 並開起 Log verbose

結果:

第二組中,LibreOffice 直接產生的 6 個檔裡有一個未通過。我以此發了一個 bug issue:

測試結果:https://goo.gl/TH80vM

而第一組中,微軟 OffiCe 存成的 ODF 則全軍覆沒,沒有一個檔案通過。
(測試結果附在壓縮檔裡)

另外有興趣的朋友可以自己用微軟 2010 或 2013 來試試看。直接拿微軟開啟微軟自己產生的 ODF,跟拿 LibreOffice 開啟微軟產生的 ODF ,結果是否有所不同。我自己沒有微軟的 Office,所以沒做過這方面測試。但講師測過,結果相信也不需要我多說。

2. 去年九月微軟台灣葉光釗技術長在 COSA 舉辦的開放系統論壇上親自承認微軟存成 ODF 時有加料。我人在現場,也有懂這方面的社群朋友在場。雖然他的投影片裡並沒有放這部份,而是只講到這裡:



實際上 ODF 並非 "provides no extensibility mechanism". 它們有一套流程,在你使用 extension 後必須與 OASIS 申請,經由數道程序的討論後,進入 ODF 標準中。這裡是 LibreOffice 目前所使用的所有 extension:

https://wiki.documentfoundation.org/Development/ODF_Implementer_Notes/List_of_LibreOffice_ODF_Extensions

舉一個比較新的例子,大家可以搜尋 Core commit 9c2a80,對此 issue 經過一番討論之後,最後投票決定接受為 RESOLVED 並進入 ODF 1.3。

至於微軟有沒有遵循這個規範?

我剪一小段我跟另一位 LibreOffice 核心開發者,也是這次推動英國政府以 ODF / LibreOffice (GovOffice) 為規範的推手 Michael Meeks 跟我的一小段對話。因為英國政府曾經下令要求微軟儲存 ODF 時必須遵循英國政府所使用的 ODF 規範(含 extension),而:

Me: (And I'm very curious, do Microsoft *really* obey this list and export only the extensions list here?)
Michael: Certainly not =)

3. ODF Committee 成員 Jos van den Oever,也是荷蘭政府在 ODF Committee 的代表,跟我討論今年 ODF Plugfest 時說,微軟每年都會參加 plugfest,但從未下海做過任何測試。
這封信的部份原文(前面是關於我參加今年 ODF plugfest 的事)如下:

At the plugfest we usually have a talks part and a testing part. At thelast plugfest we wrote a long report with interoperabilty issues [1]. Weappreciate if attendees contribute tests. You can send them to mebeforehand and I'll make sure the issues will be discussed.Ideally, we'll run the issues through our testing system. If you havesoftware which you want to have hooked up into that let me know.If you join, it would be great to have talk by you of about 20 minutesabout the status in Taiwan. 
Microsoft employees have attended a few times but usually do not join inthe the technical part and neither do employees from Apple or Google.This is a clear message from them that they do not care aboutinteropability. 
Microsoft does attend the weekly ODF standardization teleconference.They are usually simply observing. You are right to advise people to notuse MS Office for ODF. Google Docs is even worse.

再拿葉技術長的投影片來打臉一下:



可知他們對所謂的 "主動舉辦和參與 ODF interoperability" 是怎麼一回事情。

其實我在所有我所主講的說明會場合都說得很清楚,撇開預算問題不談,只要微軟能確實遵循 ODF 1.2 規範,儲存成的 ODF 檔不會造成其他軟體讀取與編輯的困擾,那麼大家使用微軟另存 ODF 是沒有關係的。這是最理想的狀況,只是目前微軟並未採取此一友善政策。

所以,目前為止,還是請大家如果有轉檔需求,請直接使用 LibreOffice(新版的當然表現會比舊版好一點),而不要採用微軟 Office 另存新檔成 ODF 的方式。

2016年9月27日 星期二

LibreOffice Conference 2016


This year LibreOffice Conference 2016 was held again (yes, again) in Brno.  I said "again" because that two years before I also went to Brno for Akademy 2014.  But Brno is a cute city (more like a town to me) and I like there very much, and this year we had three people going there together.

The scene in Praha and Brno kept making me recall my memory, like the train station and locked restrooms.



In the morning of the community workshop I planned to go to the city center around Brno train station with my partners Jeff Huang and Mark Hung.  However I met Italo in the hall of the hotel and he asked me if I would like to attend the certification meeting.  It was my honor and I was happy to, so I  kicked my partners out and attended the meeting.

Certification Meeting

In the meeting Italo mentioned that the ODF/LibreOffice migration in Taiwan is important because it proves that ODF/LibreOffice is not only suitable to European and American countries.  We also talked about some important issues like to make trainer's certification more localized, and to make sure that being a TDF member is NOT a need to apply for certification.

This year the venue was very beautiful.  Actually it is the most beautiful venue among all the conferences I have ever attended.

The venue of LibreOffice Conference 2016

In the welcome party we met friends from Japan, Naruhiko and Shinji.  But poor Naru spent some day in the hospital... Fortunately he is okay eventually.

Jeff, Mark, Shinji and Naruhiko

This year I gave two talks.  One is about the LibreOffice macros.  I told people how I found the documents and then realized that we need some more tutorials which are appropriate for newbie macro coders.

My first talk

My second talk was still about the progress of ODF/LibreOffice migration in Taiwan.  Since my presentation last year more and more city/county governments started their training courses and communication phases.

My second talk

ODF migration map in Taiwan

The most exciting thing in this conference for me was that Italo showed this slide:


Our hard work of promoting and migrating ODF in Taiwan was seen in the world.  I hope that in a few years the migration map can be all green, and the world can see that ODF and LibreOffice are the most appropriate choices.

So, I'll keep going my work on this, and wish I can give you more good news in Rome next year!


2015年11月3日 星期二

Taiwan Launched a 3-year Project In Order To Adopt Open Document Format



Although the central government in Taiwan had worked out a national file format standard named CNS-15251 in 2009, they didn't push and force government bodies to use it. Nevertheless, since UK government selected Open Document Format to meet user's needs in July 2014, the National Information and Communications Initiative Committee (NICI), a working group composed with many departments under Executive Yuan in Taiwan, started a series of meetings and made a resolution to include ODF into the national standard (named ODF-CNS15251, which is actually ODF 1.2) and actively migrate this national standard in all government units.

In NICI's resolution, they defined "open files" as "files which don't need to rely on a certain software to open." They also mentioned that all the government bodies should use ODF-CNS15251 for editable document file, and PDF or HTML for uneditable document file.

Therefore, National Development Council (NDC), a first level unit under Executive Yuan, launched a 3-year project and split the migration into three stages:

Stage 1: Before the bottom of 2015, all the downloadable files on web sites which belongs to any government unit, should use ODF-CNS15251 or PDF file format. All the old files on web sites should be converted to ODF-CNS15251 or PDF too.

Stage 2: Before the bottom of 2016, all the files provided and exchanged between government bodies, or between government units and non-government units or enterprises should use ODF-CNS15251 or PDF file format.

Stage 3: Since 2017, ask all the government bodies to use software which can create and edit ODF-CNS15251 and can be downloaded freely forever.

This project was launched in August 2015. NDC entrusted the Software Liberty Association Taiwan (SLAT), which is an NPO targeting on promoting free and open source software, and Gjun information Co., Ltd., which is a software cram school, to execute this project. In this project, 13 explanation sessions are held in different counties and cities of Taiwan, including outside island counties like Penghu, Kinmen and Lienchiang (aka Matzu). Lecturers and open source community members from SLAT are responsible to explain why and how to migrate to ODF. Besides, many real training courses are held too. The FOSS experts from SLAT are responsible for planning the course guidelines and examples in these training courses, and training lecturers in Gjun. Then lecturers of Gjun will be responsible all the training courses.

Besides NDC's project, there have been several successful stories migrating OpenOffice and LibreOffices all over Taiwan. Coretronics is a successful example for big enterprises to migrate LibreOffices. In the project of Coretronics, OSS Integral Institution Company, which was founded by a senior open source community and is experted in Open Office and LibreOffice customization and service, is responsible for helping them since 2010. Fo-Guan-Shan, which is a very big Buddist group, also migrated to OpenOffice successfully in 2014. Eric Sun, the execute secretary of Open Source Software Application Consulting Center, which is a project under the Ministry of Education and executed by SLAT, helped Fo-Guan-Shan to migrate OpenOffice. Finally, in March 2015, Yi-Lan County government also launched a project to migrate from Microsoft Office to LibreOffice. This project is led by the Office of Information Administration, Planning Department in Yi-Lan County, and is executed by Sunjun Information Service Company, which was founded by many open source community members and experts. In LibreOffice Conference 2015, Franklin Weng, the President of Board of Directors in SLAT, shared the successful stories of Yi-Lan County and Coretronics in Migration track, also shared the status about the ODF migration in Taiwan.

SLAT will then cooperate with The Document Foundation, to help this migration project.

2015年10月28日 星期三

Yi-Lan County Announced That No More Microsoft Office Will Be Purchased



The above image is an official document from Yi-Lan County, Taiwan.  The subject of this document is to reiterate that all the users in Yi-Lan County, including teachers in schools, employees in the offices in all the villages and cities in Yi-Lan, and colleagues in Yi-Lan County Government, need to send documents in ODF or PDF format instead of Microsoft Office's format.  

Yi-Lan County Government also announced in this document that they will not buy and install Microsoft Office in newly purchased computers.  All the new computers need to install LibreOffice which can be downloaded in the inner file server in Yi-Lan County Government.




Besides Yi-Lan County, Yun-Lin County Government in Taiwan also took actions to warn those users who still upload or send out documents in OOXML or other non-ODF formats.  The red part of the above image said, "This attached file does not comply with the formal national standard format ODF-CNS15251" where ODF-CNS15251 is identical to ODF 1.2.

The above incidents show that Taiwan goes a bit further on the road to fully migration of ODF.  Let's applaud and cheer on them!