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.
A new edition of FOSDEM (Free and Open source Software Developers‘ European Meeting) just ended. Our CIB LibreOffice team this year was represented by Thorsten Behrens, Michael Stahl and Marina Latini. The event is held annually during the first weekend of February, at the „Université Libre de Bruxelles„. For our team, attending FOSDEM means to be … CIB visiting FOSDEM 2019 weiterlesen
Der Beitrag CIB visiting FOSDEM 2019 erschien zuerst auf CIB events.
With the release of 6.2 I read a lot of comments on the different threads. Several issues are listed. One was that Ribbons waste vertical space.
With default settings the standard toolbar need 110 px vertical space (menubar + 2 toolbar height), tabbed toolbar need 100 px and groupedbar compact 72 px. So the default toolbar need most vertical space.
Yes MSO Ribbons need a lot of vertical space, which is an issue on laptops. Therefore you can show the tabbs only. In LibreOffice we have different UI’s for different workflows, but also for different screen’s. For example on your 32 inch office screen you’d like to work with standard toolbar but on mobile you prefer tabbed compact toolbar (which will be released with 6.3).
On windows the difference between LibreOffice tabbed toolbare and MS Office ribbons is
94 px vs. 110 px
If you like my work, become a 
Pure Elixir database driver for Firebird https://github.com/nakagami/firebirdex
Firebird 4.0 is using Ubuntu xenial on travis . https://travis-ci.org/FirebirdSQL/firebird .travis.yml looks a lot simpler after this change. ps: Here is official Travis CI announcement: Ubuntu Xenial 16.04 is available
Firebird 4.0 implemented Built-in logical replication is now merged Here is the pull request https://github.com/FirebirdSQL/firebird/pull/182 We know that is a long standing feature request Wow! @firebirdsql team implemented a feature that I asked 10+ years ago!https://t.co/tRrg9YvkWW"Built-in logical replication"Thank you guys.— Daniele Teti (@danieleteti) January 25, 2019
As we know, Karasa Jaga, an icon theme derived from the Oxygen theme successfully entered the last fresh release of LibreOffice (6.1) on August. Since its inception for the first time, Karasa Jaga has been very complete and can even be said to have nearly 5,000 icons, because it has exceeded the number of icons that Galaxy and Colibre have had since first entering Karasa Jaga already has extra large icon support (32px * 32px).
But the work did not stop there, there were many things that should be improved. Moreover, in the next 6.2 release there are so many new icons that should be made especially to support the Notebookbar Tab interface. In addition, the existing icons also need to be adjusted, plus I want to add more SVG support.
Now I would like to show you the improvements that have been landed to Karasa Jaga. Although in this period I was more preoccupied with improving the elementary icon theme, I did not leave the mandate to improve Karasa Jaga, just like I took care of my own child. :) I admit that for this period the improvement were not as massive as previously released, but significant enough to be discussed as well. Let's see side by side
LibreOffice Writer
 |
| Standard Toolbar |
 |
| View Menu |
 |
| Mail Merge Toolbar |
 |
| Data Source |
 |
| Standard Toolbar |
 |
| Row Right Click Menu |
 |
| Column Right Click Menu |
 |
| Sheet Menu |
 |
| Data Tab |
 |
| Tool Tab |
 |
| Standard Toolbar |
 |
| Slide Transition |
 |
| New Tab Interface |
 |
| Shape Menu |
 |
| Table Properties |
 |
| Sidebar Component |
 |
| Flip Action |
 |
| Data Table |
Base – the database editing program of LibreOffice – offers several features when it comes to external database connection. One interesting feature is that Base lets you connect to an external database not only with ODBC and JDBC but with native connectors too. Using the native connector instead of a standard like JDBC sometimes has a positive impact on performance.
Considering that MySQL is one of the most used database management systems worldwide it is clear that the support of connecting to a MySQL database is an unavoidable part of Base. Currently there are three ways supported to connect to a MySQL database: with ODBC, JDBC and using a native connector. However, the last option was only available as an extension, and it is the part of the core project only since November 2018.
Why was it only an extension at the first place? The native connection was implemented by using the C++ connector of MySQL, which is licensed under GPL. Because of that it could not be put into the core project. So what is the solution then?
Because of the above mentioned problem we, at Collabora decided to use the connector of MariaDB instead. MariaDB is a fork of MySQL which has the same database structure and indexes as MySQL. It has a C API which can be used to connect to MySQL and MariaDB databases too. What is more, the connector is LGPL licensed, which means that it can be used in the core project too. So the next task was to use this API to implement the sdbc driver.
Some parts of the implementation is pretty straightforward. It is pretty easy to create a connection and pass options through the function “mysql_options”. It was also clear to me how to pass things like user and password to the DBMS.
There were a few things though which were a bit more challenging. The XDatabaseMetadata interface for example – which is responsible for providing information about the current state and capabilities of the database – could not be implemented with only a few function calls. In order to implement them, I had to construct SQL queries for most of the methods. Database information are available in the schema called “INFORAMTION_SCHEMA”. That task took some time since the interface has more than a hundred methods which had to be implemented.
Another challenge was a bug about parallel execution of result sets. The C API does not support the usage of two result sets simultaneously, but the sdbc standard supports it. The solution was to store the result of a query and free the mysql resources afterwards. That way a new result set can be fetched with the C API while the previously fetched data is stored in memory.
Having the native MySQL connector in the core project has several advantages. First, it is easier for the user to install it. It is bundled with the core project, there is nothing to do there. Also, it improves maintainability, because it does not have to …
688 bugs have been reported by 351 people.
Top 10 Reporters
709 bugs have been triaged by 71 people.
Top 10 Triagers
235 bugs have been fixed by 55 people.
Top 10 Fixers
List of critical bugs fixed
Firebird 3.0.x introduced 48-bit internal transaction IDs that are publicly (via API and MON$ tables) represented as 64-bit numbers. This makes the new limit roughly equal to 2.8*10^14 transactions, later it could be extended up to the 2^63 limit. Related notice in Firebird 3.0.x release notes.Related article about Posgtresql : How long will a 64 bit Transaction-ID last in PostgreSQL?
Tomorrow LibreOffice 6.2 will be released. Time to give you some information what will come in LibreOffice 6.3.
My work in process is an huge update of the sifr icon theme
Sifr icon theme todo:
If you like my work, become a
(via cor4office)
The next step in the recent SmartArt story is my Improving SmartArt import in Impress talk at FOSDEM 2019, in the Open Document Editors devroom. The room was a bit far away from the popular places, but the livestream worked out nicely.
There was also a hackfest before the conference, I looked at RTF export of rotated Writer pictures.
Well – obviously. At least, their current actions tell that: they deprecated CRT MSMs (which is reiterated in VS 2019 RC2 release notes), a technology designed to allow MSI-based installers to install the CRT libraries in a centrally-managed manner; and the only recommended way now is using vcredist executable, which is not MSI-compatible.
What else, if not deprecation, might it mean, when an installer technology made unable to deploy applications created using vendor’s own flagship development tool?
Well – I thought: maybe that was an oversight? Why not inform them about the problem that MSI-only installers would be left without any viable option?
So I did. And I got the answer that to me was a clear confirmation:
Sorry that our current plan is like this, if there are a lot of customer complain about this new change, we will revisit this issue
So – “yes, our plan is to make it impossible for MSI; this is not a problem in our eyes; only if we will experience pressure, may we re-think about it”.
Sad.
Every once in a while I start pondering ways to get rid of the slowness and overwhelming complexity of the autotools machinery, in particular autoconf and libtool. GNU Make has been a great companion for 20 years, and automake helps with some of the complexity in getting compiler generated…
The LibreOffice Quality Assurance ( QA ) Team is happy to announce LibreOffice 6.2 RC3 is ready for testing!
LibreOffice 6.2 will be released as final in a week from now and LibreOffice 6.2 RC3 represents the last pre-release before the final release since the development of version 6.2 started in mid May, 2018. See the release plan for more information.
You can find the list of bugs fixed in this pre-release here and the list of new features included in LibreOffice 6.2 in the release notes.
LibreOffice 6.2 RC3 is already available for downloaded in this link, for Linux, MacOS and Windows.
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!!
…
The keyboard layout on Apple computers is special and some keys are missing. For example there is no Insert key to toggle between insert and overtype. LibreOffice supports the function and you can switch by clicking the respective panel on the status bar.…
The post Overwrite on macOS appeared first on LibreOffice Design Team.
Oh, the Council was impressed, of course
Could he bring balance to the Force?
— The Saga Begins, Weird Al Yankovic
As you might have seen, we have now run four C++ sessions to get started with C++ and LibreOffice development. The origin of this actually happened already at the last LibreOffice Hackfest in Munich where Izabela, Mike, Anxhelo and me conspired on the idea. We also started to recruit LibreOffice developers as mentors right there and Xisco joined us soon.
As the lectures discuss the basics of data structures and C++ I started to create some patches against LibreOffice to show how to start with simple things in the LibreOffice build based on the examples from the lecture, but in the environment of LibreOffice and with some of its framework and conventions:
Some background and discussion about these can be found in the videos linked in the commit messages of these and on the C++ lectures wiki page. I hope these small examples are helpful to someone starting with C++ and LibreOffice even if you might have missed the first C++ lecture sesssions.
Why am I posting this? Now? Well, tomorrow the LibreOffice FOSDEM 2019 Hackfest starts in Bruessls. As you can see from the above, awesome things often take off there! You dont have to take my word for it: Izabela and Anxhelo wrote about their experiences too! If reading their report (or the story about how the lectures started) make you curious, please feel invited to join us in Bruessels at FOSDEM — or if you cant make that, the next Hackfest!
Until recently, Chromebooks could browse the Web and run dedicated ChromeOS and Android applications, and that was that. But things are changing now since Google announced Crostini, a technology to run arbitrary Linux applications on ChromeOS.
What you get, in short, is a Linux distribution running in a virtual machine. It is sandboxed, but with some channels set up between the virtual machine and the surrounding ChromeOS, so that e.g., icons of applications installed in the Linux VM show up in the ChromeOS launcher, and windows opened from within the VM are integrated with the overall ChromeOS desktop.
The default Linux distribution provided by Google is a Debian 9, and one should be able to also plug other flavours of Linux, at least in theory. But we can install applications as flatpaks there, at which point the exact Linux distribution becomes rather irrelevant, anyway.
How to set up your Chromebook to install flapaks is detailed elsewhere, so just follow those instructions. You can then browse flathub for the applications of your choice. But when you click on the “install” button for an app, things start to get a bit rough. The ChromeOS browser downloads a ….flatpakref file, but doesn’t know what to do with it, so stores it in the Downloads folder. The Linux VM can’t see it there (thanks to the sandboxing around that VM), so you first need to use the Files app to copy the ….flatpakref file from “Downloads” to “Linux files”. The latter is just the home directory of the Linux VM user, so when you switch to the Terminal app (which provides you with a shell for that Linux VM user), you can type flatpak install ….flatpakref to finally install the application.
But there is also a more polished solution that doesn’t require falling back to the flatpak command line: Just go back one more time to the Terminal shell to install GNOME Software in the Linux VM, sudo apt install gnome-software gnome-software-plugin-flatpak. Then you can run the Software application from the ChromeOS launcher (it may hide in a “Linux apps” collection). Search for LibreOffice, install it, launch it, and enjoy.
After a fresh build Android Viewer on Ubuntu 18.04 with LibreOffice 6.3.0 just wanted write a valid instruction list. (note to myself)
0- Install build dependencies:
$ sudo apt-get build-dep libreoffice
If there are throuble about packages please read build dependencies instructions for your distribution: https://wiki.documentfoundation.org/Development/BuildingOnLinux#Build_dependencies
1- Install Android Studio.
2- Open Android Studio -> Find SDK Manager and make sure following versions were checked:
Planned for the LibreOffice 6.3 release
If you have something I can improvements, so UI and design related stuff, … bugs.documentfoundation.org
If you like my work, become a
Done in LibreOffice 6.2
Test out LibreOffice 6.2 and give us feedback at bugs.documentfoundation.org
If you like my work, become a
"And my final test as to whether or not Debian succeeded was: could the founder step away from the project and could the project keep going because that is the only point at which you know that the project has basically taken a life of its own." ~ Ian Murdock
The LibreOffice Quality Assurance ( QA ) Team is happy to announce LibreOffice 6.2 RC2 is ready for testing!
LibreOffice 6.2 will be released as final at the beginning of February, 2019, being LibreOffice 6.2 RC2 the forth pre-release since the development of version 6.2 started in mid May, 2018. See the release plan. Check the release notes to find the new features included in this version of LibreOffice.
LibreOffice 6.2 RC2 can be downloaded from here, and it’s available for Linux, MacOS and Windows.
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 ) so it can get fixed before LibreOffice 6.2 final is released.
For help, you can contact us directly in our IRC channel.
Happy testing!!
…
I recently dived into the SmartArt support of LibreOffice, which is the component responsible for displaying complex diagrams from PPTX. I focus on the case when only the document model and the layout constraints are given, not a pre-rendered result.
In this post I would like to present the progress done last month regarding the above mentioned diagram types — these are used in many documents.
The improvement (as always) come in small incremental steps:
Continuous Block Process now reads space width from constraints.
Accent Process now has the missing bullets and fixes an incorrect large paragraph-level indent.
Organization Chart now has an initial implementation of the hierRoot and
hierChild algorithms.
Organization Chart now handles multiple employees for a manager.
With all these fixed, we reach a much better state for the mentioned diagram types.
The SmartArt test documents from sd/qa/unit/data/pptx/ is what I used for testing this work.
Here is how the baseline, the current and the reference rendering of Accent Process looks like:
smartart-accent-process.pptx, baseline
smartart-accent-process.pptx, current
smartart-accent-process.pptx, reference
And here is how the baseline, the current and the reference rendering of Organization Chart looks like:
smartart-org-chart.pptx, baseline
smartart-org-chart.pptx, current
smartart-org-chart.pptx, reference
This is not not perfect yet, but it’s clearly a large improvement, all text is now readable from the diagrams and bullets are no longer missing!
All this is available in master (towards LibreOffice 6.3), so you can grab a daily build and try it out right now. :-)
560 bugs have been reported by 347 people.
Top 10 Reporters
570 bugs have been triaged by 77 people.
Top 10 Triagers
208 bugs have been fixed by 49 people.
Top 10 Fixers
List of critical bugs fixed
The LibreOffice Quality Assurance ( QA ) Team is happy to announce LibreOffice 6.2 RC1 is ready for testing!
LibreOffice 6.2 will be released as final at the beginning of February, 2019, being LibreOffice 6.2 RC1 the third pre-release since the development of version 6.2 started in mid May, 2018. See the release plan. Check the release notes to find the new features included in this version of LibreOffice.
LibreOffice 6.2 RC1 can be downloaded from here, and it’s available for Linux, MacOS and Windows.
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 ) so it can get fixed before LibreOffice 6.2 final is released.
For help, you can contact us directly in our IRC channel.
Happy testing!!
…
LibreOffice has the capability to add references to a document and finally a bibliographical index, which is essential for scientific publications. The style of references depend on the journal and the discipline. So it is common to just add numbers in square brackets like [1] in engineering whereas humanities show name and year like (author, year).…
The post Save the bibliography? appeared first on LibreOffice Design Team.
Am 15.12.2018 wurde die neueste Special Edition des Linux Pro Magazine mit dem Thema #LibreOffice veröffentlicht. CIB ist als kompetenter Partner und langjähriger Supporter von LibreOffice natürlich in der Ausgabe vertreten und gleich mit zwei Anzeigen dabei. On 15.12.2018 the latest special edition of the Linux Pro Magazine concerning #LibreOffice has been published. As a … LibreOffice powered by CIB @ Linux Pro Magazine weiterlesen
Der Beitrag LibreOffice powered by CIB @ Linux Pro Magazine erschien zuerst auf CIB events.
| 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 Simon Phipps 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. | |
