A Search Engine for Creative Commons Content

I am a great lover of Creative Commons licensed content, and you may have noticed that all of my own content is Creative Commons licensed, so I am completely consistent. And I have written a few articles here on places that I have found that offer Creative Commons content. Now I am pleased to find that a search engine has been created to facilitate searching for and finding CC content. It is called Openverse, and it already indexes over 700 million creative works, so far consisting of stock photos, images, and audio content. Sources include the Smithsonian, the Cleveland Museum of Art, NASA, Flickr, Europeana, and the New York Public Library. But they are looking to expand both the sources they index and the types of content. You can see more about some of the sources they index at https://openverse.org/sources. They estimate that there are 2.5 billion CC-licensed items of all types, and they plan to eventually include texts, 3-D Models, and more.

Openverse is the latest incarnation of CC Search, which was developed by Creative Commons, and then adopted by WordPress. They are looking for contributors, of course, like most projects.

 Save as PDF

Error Codes in LibreOffice Calc

Sometimes you might see an error when using LibreOffice Calc, which would look like “Err:” followed by a number. You can see what the error is at this page: https://help.libreoffice.org/latest/en-GB/text/scalc/05/02140000.html

 Save as PDF

LibreOffice 7.0 Released!

Today, August 5, 2020, we saw the announcement that LibreOffice 7.0 is now released for all platforms, though it may take a few days to roll out, and for those of us on Linux platforms it may be a while longer before it shows up in our repos. Nevertheless, this is an exciting milestone release. I personally tend to lag a bit in getting new releases because I use Kubuntu LTS releases, and those only update slowly. So right now I am using LibreOffice 6.0 from 2018 on my Kubuntu 18.04 release. I expect that I will be offered a chance to upgrade my Kubuntu version pretty soon since that typically happens after the first major update, and that is scheduled for the base Ubuntu platform tomorrow (August 6), and it may take a few days for Kubuntu to follow suit. But we can get some ideas of the new LibreOffice release from the press release, and here are some of the major points of interest.

ODF 1.3

The new version of LibreOffice includes support for ODF 1.3. ODF stands for Open Document Format, and it specifies an XML-based file format for all of the documents containing text, spreadsheets, charts, and graphical elements. What an XML-based file format means is that what looks like a single file containing your document, spreadsheet, etc. is actually a container, and you can see this by opening the document with a utility like Ark or some other zipping/unzipping utility. I did this with a Writer document, and had this result.:

LibreOffice Writer file opened in Ark
LibreOffice Writer file opened in Ark

So my XML-based file is 7 files at the top level, and 6 directories with sub-directories and files inside them as well.

ODF1.3 was approved by the Open Document Foundation as an OASIS specification. OASIS is the Organization for the Advancement of Structured Information Standards, which began as SGML Open in 1993. It exists to promote the development. convergence, and adoption of open standards for security, Internet of Things, energy, content technologies, emergency management, and other areas. So OASIS is much broader than just office software, but it is an important body for promoting open standards.

Some of the features of the ODF1.3 specification are:

  • Digital signatures for documents and OpenPGP-based encryption of XML documents.
  • Improvements in Change tracking.
  • Improvements in the description of elements in first pages, text, numbers and charts.

Skia graphics library

The Skia graphics library is an open-source 2-D graphics library that provides a common set of APIs that work across a variety of platforms. It is the graphics engine for Chrome, Chrome OS, Android, Flutter, Firefox, and Firefox OS, among others. It is sponsored by Google, which is the lead developer, but is licensed under the BSD Free Software License. It is available on platforms such as:

  • Windows 7, 8, 8.1, 10
  • macOS 10.10.5 or later
  • iOS 8 or later
  • Android 4.1 (JellyBean) or later
  • Ubuntu 14.04+, Debian 8+, openSUSE 13.3+, or Fedora Linux 24+

Skia can be used for drawing text, shapes, and images, and is now the default on Windows for faster performance. The implementation in LibreOffice is due to sponsorship from AMD.

Vulkan API

The other big graphics news is that the Vulkan API is supported. Vulkan is an alternative to other graphics APIs such as DirectX and OpenGL. It offers high-performance 3-D graphics with low overhead and supports better parallelization on multiple cores.

So between Skia and Vulkan, some pretty good graphics improvements for both 2-D and 3-D graphics.

Compatibility improvements

It is no secret that Microsoft Office is the largest player in the Office space, and interoperability is key. I have mostly not had any problems for sometime now moving between MS Office and LibreOffice, but there are always corner cases where things can get ugly. The latest LibreOffice handles things even better. If you want to save a Writer document in the Microsoft Docx format, you can now save in native 2013, 2016, and 2019 modes, whereas previously you were restricted to a 2017 compatibility mode. In Calc, you can export to Excel with sheet names longer than 31 characters now. And the Powerpoint Import and Export filters were improved as well.

LibreOffice is really the only choice if you want interoperability across platforms and applications. They are not trying to lock you in, unlike Microsoft.

Summary of Other New Features

GENERAL

  • New icon theme, the default on macOS: Sukapura
  • New shapes galleries: arrows, diagrams, icons and more…
  • Glow and soft edge effects for objects

WRITER

  • Navigator is easier to use, with more context menus
  • Semi-transparent text is now supported
  • Bookmarks can now be displayed in-line in text
  • Padded numbering in lists, for consistency
  • Better handling of quotation marks and apostrophes

CALC

  • New functions for non-volatile random number generation
  • Keyboard shortcut added for autosum. Autosum is probably the single most used function in spreadsheets, so this is a welcome development.

IMPRESS & DRAW

  • Semi-transparent text is supported here too
  • Subscripts now return to the default of 8%
  • PDFs larger than 500 cm can now be generated

Who to thank

This new release of LibreOffice contains work from a number of companies. 74% of the commits come from companies on the Advisory Board, of whom Red Hat may be the best known, but also heavily involved were Collabora and CIB Software. I mention these companies because they are great examples of how an ecosystem can grow in open source. Both of these companies built a business around LibreOffice technology and both are giving back and helping it grow. Collabora is the home of Michael Meeks, and any long-time followers of LibreOffice should recognize him as a major developer in this project. Now he is the Managing Director of Collabora, and they are making money by selling a service, LibreOffice in the cloud.

CIB Software is located in Munich, and provides integrated document management solutions that include LibreOffice. And I find it interesting that Munich has reversed course yet again and is now planning to move back to open source software. The coalition agreement between the Green Party and the Social Democratic Party in Munich was finalized in May and says: “We will adhere to the principle of ‘public money, public code’. That means that as long as there is no confidential or personal data involved, the source code of the city’s software will also be made public.” And since the coalition should be in power until 2026, there is a good chance for significant progress there. And then in June Hamburg joined the movement to open source as well, adding to a growing movement in German cities and states.

Of course, companies are not the only supporters. 26% of commits came from individuals. And even if you are not a coder, there are ways you can help. I have also participated in the documentation area (writing, proof-reading, updating, etc.), and I know they have volunteers helping with publicity. Personally, every time I download a new version of LibreOffice I donate $10 to the Open Document Foundation, which sponsors LibreOffice development. I mean, ten bucks for a full-featured office suite? That has to be the deal of the century, right? So I encourage everyone else to join me in this.

Listen to the audio version of this post on Hacker Public Radio!

 Save as PDF

LibreOffice Tutorials Offered

I have received a very generous offer from Bernard J. Poole, a professor at the University of Pittsburgh. He has a series of LibreOffice Tutorials and has asked me to publicize that they are available free of charge to all of our LibreOffice fans here and on Hacker Public Radio. You can find his tutorials on his web site at http://www.pitt.edu/~poole/. He is particularly aiming his tutorials at educators who might use LibreOffice in the classroom.

Please note that these files are available for free, but he does ask that you let him know if you are interested in using his tutorials, particularly in the classroom. And there are some LibreOffice files that accompany the tutorials which are available by writing to him.

Listen to the audio version of this post on Hacker Public Radio!

 Save as PDF

Turning Off Comments

I wish I didn’t have to do this, but the fact is that virtually every comment that is submitted on my site is spam. Until now I have manually screened every comment, but it is taking up more time as the volume in increases. And I get so few legitimate comments that it does not seem worth the effort. So if you are a real person, you can probably figure out how to contact me. But I am now working to disable comments everywhere on my site.

 Save as PDF