LOWN/5/ru

Новый проект от Document Liberation
Напомним, Document Liberation Project призван обеспечить возможность открывать устаревшие или "закрытые" (проприетарные) форматы файлов. Когда эти форматы перестают поддерживаются фирмой, которая создала их, спасение пользователя приходит, благодаря библиотекам, сделанным The Document Liberation Project. Пользователи могут восстанавливать содержимое своих документов и сохранять его в современном с долгосрочной поддержкой формате ODF.

Мы заметили, что новая дополнительная библиотека, названая, стала доступна в версии 0.0.1. Она позволяет открывать документ Aldus/Adobe PageMaker. Так как эта библиотека все еще находится в состоянии пре-альфа тестирования, только основные формы и их атрибуты можно прочитать на данный момент, но мы ожидаем, улучшения в будущем. Благодарим Anurag Kanungo, Brennan Vincent, David Tardon, and Fridrich Strba за эту инициативу!

Как и все библиотеки Document Liberation Project, она разработана с целью работать в LibreOffice, но может быть использоваться и в других проектах.

Улучшение в экспорте XHTML
Andrew Sayers, новый участник LibreOffice, в середине августа сделал 17 патчей для улучшения фильтра экспорта LibreOffice Calc XSLT.

Конвертер документов
Вскоре после создания LibreOfficeKit, Olly Betts выпустил проект под названием lloconv, использующий LibreOfficeKit и позволяет вызывать библиотеку непосредственно при использовании рендеринга в LibreOffice. В результате, нам не нужно баловаться с UNO, чтобы заставить работать LibreOffice быстрее.

В июле, Riccardo Magliocchetti выпустил обёртку cffi на Python для LibreOfficeKit. Эта обёртка обеспечивает простой способ для разработчиков Python при конвертации документов в своих приложениях, написанных на Python.
 * Обертка по сути функция, которая вызывает другие, но в данном случае, она создаёт мост между Python и LibreOfficeKit.
 * cffi - акроним от C Foreign Function Interface for Python (Внешние функции интерфейса СИ для Python). Это указывает на то, что она является интерфейсом, который обеспечивает надежный способ использовать C кода из Python.

Версия для Android
The Document Foundation решила выделить бюджет для разработки базового программного каркаса с основными возможностями редактирования для Android версии LibreOffice. Компании, способные соблюдать требования, описанные в объявленном конкурсе, и возможность подготовить проект к февралю 2015, приглашаются сделать заявку и обеспечивать оценку сроков и стоимости. Этот конкурс с предложением действует до 6 октября 2014.

Remove inheritance on std::map и std::vector
На этой неделе, благодаря Takeshi Abe, более определенный прогресс в устранении наследования контейнерных классов std:  и  Наследование от контейнерных классов стандартной библиотеки на самом деле плохая практика, вместо этого мы должны использовать композицию или слабое агрегирование.

''Контейнерные классы стандартных библиотек позволяют наследование. Ничто не мешает вам наследоваться от них. Вам не будет угрожать ошибка во время компиляции, если вы будите поступать так. Но они не предназначены, чтобы разрушить ваш объект производного класса через указатель базового класса. Если вы хотите использовать наследование в таком сценарии (динамический полиморфизм) контейнеры стандартных библиотек явно не предназначены для этого.''

Почти закончен перевод комментариев на немецком
Перевод немецких комментариев в исходном коде всё ещё продолжается, и мы приближаемся, наконец, к удалению всех 100% таких комментариев. На самом деле, трудно предсказать далеки мы или нет, так как, насколько мы знаем, никто не вычислил, как много осталось немецких комментариев.

Если вы хотите помочь, сценарий, ищущий немецкие комментарии в коде, до сих пор расположен в.

Но комментарии не единственное место, где мы можем видеть немецкие языковые включения. Некоторые переменные во внутренней UNO API LibreOffice по-прежнему написаны на немецком языке. Сообщение об этой ошибке открыто со дня рождения проекта LibreOffice, и мы начинаем видеть некоторый прогресс в этом отношении, благодаря Jennifer Liebel.

Возможно ещё несколько устаревших UNO::Writer API
UNO методы Writer  и   могут быть устаревшим, так как мы в состоянии получить ту же часть информации другими способами, и все они связаны с реализации. Программно столбцы всего лишь иллюзия: табличная модель состоит из строк с клетками внутри других строк. В связи с этим, на уровне пользовательского интерфейса мы в праве говорить о колонках, но на уровне API, вероятно, лучше не говорить так.

Некоторые новости о сборке в macOS
До сих пор LibreOffice использовал поставляемую с macOS стандартную библиотеку C++  из набора компиляторов GCC 4.2. GCC 4.2 устарел и не обновляется Apple, как и все UNIX-подобные инструменты этой операционной системы (binutils, bash, и т.д.) по причинам лицензирования: эти проекты перешли на GPLv3, так как Apple до сих пор использует их GPLv2 версии. Поскольку LibreOffice мигрирует на платформу 64-разрядной версии macOS и использует все больше и больше C ++ 11 код, использование  стало необходим требование.

Последние фиксации в LibreOffice 4.4 собираются с macOS SDK >= 10.8, и если флаг настроек  явно не используется, будет использоваться   вместо.

Так как дисплеи Retina™ теперь представлены на всех устройствах Apple (исключая MacBook Air) и 64-битная версия LibreOffice для macOS теперь стандартная, флаги  и   будут удалены и эти настройки войдут в конфигурацию по умолчанию.

Теперь необходимо иметь по крайней мере macOS 10.8 для создания версии под macOS, Это нужно для поддержки компонентов OpenGL и C++ 11, которые начинают широко использоваться в исходном коде LibreOffice.

Tinderbox 53, строящий сборку для macOS, теперь собирается с новым коннектором Maria DB, который был разработан не давно. Следующие флаги будут добавлены в конфигуратор tinderbox:,   и.

Bibisect location for 4.4 has changed
As a reminder, the "bibisect" repositories of (binary) LibreOffice builds let you locate with some precision the time when a regression appeared. You do not need to build LibreOffice; this has already been done for you. Simply do a dichotomic search and you will find the commit—to the precision of the bibisect repository—responsible for the bug.

The repository of binary builds for the 4.4 branch has moved from Bitbucket and is now on The Document Foundation-owned server infrastructure.

If you were previously using  for your bibisections, please update the repository URL in your   to the new one:. Thanks Miklos Vajna!

LibreOffice 4.3 is not usable on < SSE2 CPU
Since the 4.3 branch, it has been reported LibreOffice cannot run on a Windows Platform if the processor does not support at least SSE2.

This is due to the fact LibreOffice is now using Visual Studio 2012 to produce binaries for Windows. Visual Studio 2012 is using the default compilation flag. The idea if we want to support older CPUs is to change this flag to "-arch:SSE".

Some arguments have started regarding the need to be able to compile LibreOffice on such old hardware, here an AMD K7 whose production started in mid-1999 and was discontinued in 2005, 9 years before LibreOffice 4.3 was released.

The solution chosen was to get back to SSE1 compiler and improve algorithms and OpenCL usage. The latter will anyway detect and use the CPU feature automatically.

While the flag has been merged in master, the bug is still not marked as solved, because it is not completely fixed. Michael Stahl precised some external library might not take the  flag into account, so that we got sometimes exception, especially in   from the Extension Manager. The solution to narrow the issue is to have a tool which inspects all LibreOffice ddl to see if some SSE2 extensions are present.


 * To disassemble on Windows, we found . The syntax is.
 * On Linux, as  can only work with ELF, the trick is to use MinGW which has an   version adapted to the PE format. On Arch Linux, simply install the   package and use  . The syntax is.

Then, we simply need to grep any SSE2 opcode on the command output from this list, if we got result, the exe/dll is using SSE2. A Perl script has already been created by the Gentoo community, you just need to change the l58 to reflect the exact MinGW objdump location on your system.

A new tool for Vimmers
If you are using YouCompleteMe, a rather new Vim plugin replacing omnicomplete, supertab, etc., you should be pleased to learn a small tool  has been merged in the LibreOffice repository, in master a month ago allowing you to use LibreOffice code with that extension.

Basically, YouCompleteMe has several completion engines, the C-family completion engine requires you to have a file which contains the flags you need to build your project. These flags are used to locate headers and thus classes, method definitions, etc. This file is thus mandatory for YouCompleteMe to work properly. The tool that has been merged actually creates the needed flags for that file. Thanks to Markus Mohrhard for this initiative he performed while he was actually sick in his bed.

Beyond ODF: macros and automation
Macros are an interesting topic as they go beyond the direct representation of document contents. As a reminder, for those who do not know because they are not using them, macros are actually instructions, functions and routines used to control the software in an automated way.

As a simple example with LibreOffice, if you want to make a particular operation on each line of a document, but using a simple shortcut, it is impossible as the action is actually made of several ones, a macro could come in handy that time. You write your instructions either using the macro recorder or using the LibreOffice API, and bind the macro to a keyboard shortcut, allowing you to perform a long task at the speed of light.


 * The macro recorder converts actions made in LibreOffice into limited BASIC code; but this does not cover the whole interface and complicated actions might not be possible. This is why this option is advertised as limited. This solution uses UNO slots but takes you away from using the API which is much more evolved, but a bit more complicated to use for some tasks.
 * By default the macro recorder is not enabled, you have to check the checkbox  in . Then, to use the recorder, simply go to, perform your actions, and click on   from the floating dialog box that appeared, choose a macro name and click on.

Option VBASupport 1 Option Compatible
 * The LibreOffice API allows you to interact completely with LibreOffice either using the LibreOffice own scripting language, LibreOffice BASIC, or using one of the supported language which has a binding for LibreOffice: C++, Python, Java, and OLE Automation. But you can write your own UNO language binding to control LibreOffice with your favorite language too.
 * Access2Base, we can consider it as an extension to the LibreOffice API, and since LibreOffice 4.2, even as a subset of the API as it is now bundled into LibreOffice. Access2Base simplifies the use of the API when trying to access and communicate with databases in Base in particular;
 * VBA (Visual Basic) macros are at the same time a language and an office object model which are saved inside Microsoft Office documents only (this means VBA cannot be saved in ODF documents: odt, ods,...). LibreOffice incorporates limited direct support for VBA. By default LibreOffice expects to have LibreOffice BASIC code, so you must start your code by
 * if you want to use VBA script.

Although macro are saved in the user profile (or Normal.dotm in Microsoft Office), some can be saved inside the document itself and VBA macro are in all cases saved into the Office document structure itself.

After having explained above the steps to write macros, we can easily understand that writing macro requires to discuss with an SDK whose features depend heavily on the internal implementation of the product we want to control: LibreOffice, Microsoft Office, Calligra, etc. So the objects we call in a macro might (and mostly will) not exist in another product.

We need to differentiate the document format from macros: the document (here ODF) saves and organises the data into a well structured archive while macros are processes, designed to help the user, locked against a particular piece of software. We can make an analogy with web browser extensions. These depend also heavily on the platform for which they were crafted: you cannot use an extension created for Firefox on Chromium for example. This is why you will not see these macros standardized in either the ODF or OOXML document format specification.

This is why you could potentially replace all macro you use by an extension. Since it requires coding skills, the better way for interoperability is yet to not use them, or at least, if they cannot be avoided, storing them in the user profile instead of the file itself and using textual macros rather than operating system specific COM or ActiveX components.

New contributors
We welcomed 7 new contributors to the LibreOffice project: Please note that basing our number of contributors on the number of license statements is a bit unfair, as some have provided patches but not published a statement yet, while others have published one but have left the project afterwards. Also this only concerns the development team, contributors doing user support, Q/A, etc. do not need a license statement and they are not counted in this report. But let thank them anyway, they are doing a valuable work.
 * Giuseppe Bilotta (Oblomov)
 * Sudarshan Rao (Sudarshan18)
 * Boris Egorov
 * Marco Lechner (mlechner)
 * Michael Jaumann
 * Tobias Madl
 * Michael Weghorn


 * Robert Antoni Buj i Gelonch, who published his statement in June 2014, has recently published on our gerrit instance a bunch of patches to clean Java stuffs we still have. Thanks to him!
 * Stefan Weiberg, a new contributor, for who we reported the license statement last week, is now publishing his first patches related to the  easy-hack  , congrats!
 * Matthew J. Francis, a new contributor from last week published his first patches too.
 * Jan-Marek Glogowski, a contributor who published a license statement in November 2013, recently published his first patches. Thanks for being back!
 * Jennifer Liebel, reported last week too, published her first patched too. Congrats!

Bye bye mailing list
During the last monthly IRC meeting, held on August 31th, the design team decided they will drop the mailing list in favour of Redmine After a month of test, if there is no opposition, the design and ux-advise mailing list will be removed.

The main work platforms used by the Design team are
 * the wiki to keep track of design propositions, user experience principles, artwork resources and track of previous IRC meetings
 * the aforementioned Redmine project to keep tracks and discussion about design bugs
 * and the  IRC channel for the monthly meetings.

LibreOffice Base gets a new German guide
Robert Großkopf has reported the previous 4.2 German guide has been updated to LibreOffice 4.3 expanding the number of pages by 50 pages. You can see the changes here.

A guide to understand the plethora of Base guides
LibreOffice has currently 3 guides for Base:


 * Getting Started with Base which is the chapter 8 from the book Getting Started with LibreOffice
 * LibreOffice Base Handbook
 * LibreOffice Base Guide

The reason that there's both a Guide and a Handbook is that the German documentation team got tired of waiting around for the English team to finish the Base Guide, so they took the draft chapters, translated them, and rewrote (Robert Großkopf) some parts from information available in mailing list and forums, finished the book, and published it as the Base-Handbuch. That document was then translated back into English as the LibreOffice Base Handbook. The English draft was renamed into LibreOffice Base Guide and left as-is, without much attention.

This is why contrary to the newcomer belief, according to the meaning of the word "handbook" which suggests a reasonably comprehensive book that covers most simple use cases to nudge the user in the right direction, without going too much into the details and according to the meaning of "guide" which should be a complete manual covering all use cases, the Handbook is not intended to be shorter than the Guide.

The difference is that the German version of the Handbook is finished and updated to the version 4.2 of LibreOffice, while the English version is finished too, but still for LibreOffice 3.5.

Alan Cook is now updating the English Handbook from the more up-to-date German version whose translation to English has been performed by Hazel Russman.

Dan Lewis reported he is currently reviewing the chapter 2 of the Base Handbook. His work might overlap with the work Alan Cook is doing. The old unmaintained Base guide might even be removed in the future.

During these holidays, Thomas Taylor, a retired engineering technician, Linux user and LibreOffice mailing list moderator, proposed his help.

As an answer to any new contributor wanting to get involved in the documentation team, the Base Handbook is the clearly the content requiring the most of work from now, especially proofreading. Indeed, even if the German LibreOffice Base Handbook is considered as completed, Alan Cook discovered some issues.

Completing the screenshots is a huge task that needs to be performed. For license reasons, only GNU/Linux screenshots are allowed, publishing screenshots with macOS or Windows is risky on the legal point of view.

Translation of LibreOffice Guides with OmegaT
Milos Sramek, who gave a presentation about this subject at the LibreOffice conference from Bern, proposed that the documentation team uses OmegaT to improve the efficiency when translating manuals. This tools addresses what Alan Cook is doing (see the above subject): he is currently translating a new version of some text by taking advantage of the translation of an old version. In order to not break the current workflow, Alan decided to keep the tools he is currently using, but, maybe in the future, for the next round of translations, he will reconsider using this tool.

Sophie Gautier gave it a try but is expecting to write a tutorial because the installation and learning process is not so easy for a newcomer

Draw Guide for LibreOffice 4.3
Chapter One was uploaded and is ready for review.

Writer guide gets updated
The Writer guide for LibreOffice 4.2 has been delayed due to lack of contributors. As a reminder, you do not have to throw away the documentation guides when their based-on version is outdated. The documentation team is indeed skipping some LibreOffice versions and updates the handbooks and guides after some time, when it is needed and changes in the interfaces require it.

Jean Weber recently updated the chapter 16. Only chapters 13, 14, and 15 need to be proofread and, if needed, updated before we could release this new updated guide.

If you want to contribute, the best way is to follow this guide, especially the document Joining the LibreOffice Documentation Team from the First steps with the Documentation team section. Below, you will see the main way to contribute to the documentation team is to subscribe to the ODFAuthors website, hosted, here, at The Document Foundation. This website consists in writing documentation for projects making use of the ODF standard and is not limited to LibreOffice.

Keep in mind the workflow the documentation team uses is to add content to the English version, then when it is finished, translate the content to other languages. Keeping a list of the changes performed in the English version allows the translator to directly focus their translation skills to specific location in his translation without spending much time in rereading all the text. The first translation usually takes a lot of time, while updates are relatively way less time consuming.

Wanted: team coordinator dead or alive (preferably alive)
Out of this joke, the LibreOffice documentation team is currently having a coordination problem, and this is not the only team impacted, other LibreOffice teams and even other FOSS projects are also impacted. Up to now, Jean Weber "de facto" fulfilled this function due to her huge implication into the project. However her intentions were never to do it consistently. Although she warned the team she will be doing even less in the future, nobody came up with a solution or applied to this function.

The problem we have is not attracting new contributors (see above), keeping them involved, and, in addition, active, is another and even more difficult challenge. Also, keeping objectives achieved for a well defined deadline is against the definition of volunteering.

Sophie Gautier has volunteered to do this coordination work and has been accepted by the team. As a first step she will reorganize the wiki and document some tools which could be used by the translators.

Sophie, nicknamed as sophi on IRC, is one of The Document Foundation founders. On a paid basis she is coordinating the releases and is an administrative assistant for the Foundation. As a volunteer, she is mainly active in the French translation: localizing the UI, help and FAQ is what she loves most, she does some Quality Assurance (bugs triaging/hunting) too.

Number of guides sold
Sales figures for the printed books and eBooks sold by Friends of OpenDocument, Inc. via Lulu.com from January 1, 2011 to September 10, 2014 are available. This is rather interesting to see which books are most popular, allowing the team to focus on a version in particular if needed.

Total 994
 * 478 Getting Started
 * 198 Writer Guide
 * 93 Calc Guide
 * 87 Base Handbook
 * 50 Impress Guide
 * 57 Draw Guide
 * 31 Math Guide

The LibreOffice Magazine is becoming wider
The next LibreOffice Magazine (it will be already the 13th issue! congratulations!) is now calling for papers. Since the scope of languages has been widened from Portuguese to Spanish and English, and if you have tutorials, migration cases, achievements and tips, please submit them as ODF with a small picture and your resumé before October 6, 2014 to redacao@undefinedlibreoffice.org.

Profesionalizing our communication
In our last edition, we noticed the Brazilian video trying to promote LibreOffice, we have some good news since an English translation has been made available. This is not yet perfect as the application menus we can see in the video are still in Portuguese, but this is a great start.

Brazil Conference
Eliane Domingos de Sousa, a contributor from the Brazilian LibreOffice Community, who is also in charge of the LibreOffice Magazine, announced that the second National LibreOffice Meeting will be held this year from September 26, to 27 2007 iin the state of São Paulo at the UNESP University. More information is available here.

OpenSUSE.Asia summit
SUSE is a member of the Advisory Board and is providing developers for LibreOffice. SUSE is also promoting the development of the community-supported OpenSUSE GNU/Linux distribution, and is therefore sometimes doing events like LibreOffice. Obviously since OpenSUSE is somewhat related to LibreOffice, they are calling for papers and participants. If you want to join feel free to answer this announcement.

Seattle LibreFest
Robinson Tryon, our remote backdoor to the USA, is organizing a community event about LibreOffice (LibreFest) around, or at the same time of the SeaGL, a grassroots technical conference dedicated to spreading awareness and knowledge about GNU/Linux and FOSS software and hardware in general, on October 26th 2014.

This LibreOffice related event, will introducte the LibreOffice project and community, explain how to use Bugzilla and do some bug triages.

Toulouse Hackfest
As a reminder, Arnaud Versini is organizing a LibreOffice hackfest on November 15th and 16th, 2014.



Munich hackfest
This bug squashing party is hosted and sponsored by the LiMux project, the project that created a GNU/linux distribution for the Munich Municipality, in order for them to have a tailor-made distribution fitting perfectly the needs of the Munich city.

See this page for Doodle and coordination.

Document Foundation boards
To get a refreshed view of the boards constituting The Document Foundation, please read this summary first.

A new member for the advisory Board
ITOMIG, a company founded as a spin-off the of the German Tübiingen University in 2004, has developed an open source expertise, offered to French and German enterprises, and focused on free open source office suites, mainly LibreOffice. This expertise consists in migration support and development consulting. ITOMIG will provide the Advisory Board with consultants giving technical advices to the Board of Directors.

Search in multiple documents
Last week we raised an issue regarding the inability, on GNU/Linux at least, to be able to search in multiple document at one. After one week of intensive serach, Maurice, the user who asked initially the question, finally found a solution.

The idea is to create a master document, using the navigator feature to add sub document, save the master document and then you will be able to search for content in all subdocuments at one. For details, simply read here.