Collabora Online 6.4.4 – making presentations more beautiful with shadowed tables

Collabora Online 6.4.4 is adding the handling of shadows for tables in Impress

Besides various performance improvements, Collabora Online 6.4.4 also brings a few new features. You can now add shadows to the tables in Impress, enhancing your presentations and also improving the interoperability with Microsoft PowerPoint documents. Furthermore, Collabora Online now supports the latest ODF 1.3 format and all its improvements. Have a look at the 6.4 release notes for a detailed overview of this important update.

How to add shadows to tables in Impress

When a table is selected, you can access the new feature through the Tables Properties button on the Tables tab – or in the menu Table for the Classic Toolbar. Inside that dialog choose the Shadows tab and mark the Use Shadows checkbox to activate the feature.

The shadow option is available through Table Properties in the Tables tab

 

To customize the appearance of the shadow, you can:

  • specify the direction,
  • choose a colour from the various palettes the colour picker,
  • set the distance from the object,
  • and define the percentage of the transparency of the shadow.

 

 

About Collabora Productivity

Collabora Productivity is the driving force behind putting LibreOffice in the cloud, providing Collabora Online and a range of products and consulting to enterprise and government. Powered by the largest team of certified LibreOffice engineers in the world, it is a leading contributor to the LibreOffice codebase and community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term, multi-platform support. Collabora Productivity is a division of Collabora, the global software consultancy dedicated to providing the benefits of Open Source to the commercial world, specializing in mobile, automotive and consumer electronics industries. For more information, visit www.collaboraoffice.com or follow Collabora Office on Twitter .

Read More

Powerful spreadsheet features arrive for tablets

 

Pivot Tables, Managing Names and Statistical Tools and more available for tablets in Collabora Office 6.4.3

Version 6.4.3 brings features for working with spreadsheets on Android tablets of iPads. You can now insert or edit Pivot Tables, Define and Manage Names and use and use the powerful Collabora Office Statistical Tools. Writer gains the ability to Insert Bookmarks and Reference Fields. Please be aware, that these new features can currently not be accessed through the UI on phones. However, many UI and UX improvements have been implemented in this version, making the apps both easier to use and fun to work with. Find a description of the new Calc features in our earlier released Collabora Online 6.4.3 announcement.

 

Staged releases on Android devices

Since the upgrade to the new major branch Collabora Office 6.4 for mobile, we moved to a staggered release schedule. This means that new versions are made available to users gradually. Version updates will be rolled-out to users in sequential waves, so some will see version 6.4.3 sooner than others.

 

Available on Chromebooks

Together with the update of our mobile apps version 6.4.3 of Collabora Office is now also available for Chrome OS. Users of Chromebooks are entitled to all the above mentioned features. Since Collabora Office for Chrome OS is distributed via the Play Store, it is also available as a staged release.

 

Download Collabora Office 6.4.3

Collabora Office is available through the Play Store and App Store. We also provide the latest .apk for Android! Collabora Office is also available on F-Droid via a third-party repository to add.

 

About Collabora Productivity

Collabora Productivity is the driving force behind putting LibreOffice in the cloud, providing Collabora Online and a range of products and consulting to enterprise and government. Powered by the largest team of certified LibreOffice engineers in the world, it is a leading contributor to the LibreOffice codebase and community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term, multi-platform support. Collabora Productivity is a division of Collabora, the global software consultancy dedicated to providing the benefits of Open Source to the commercial world, specializing in mobile, automotive and consumer electronics industries. For more information, visit www.collaboraoffice.com or follow Collabora Office on Twitter .

 

Read More

Important new spreadsheet features and many other improvements in Collabora Online 6.4.3

Pivot Tables, Managing Names and Statistical Tools – new in Collabora Online 6.4.3

Version 6.4.3 brings powerful features to Calc online. You can now insert or edit Pivot Tables, and can now Define and Manage Names and use new Statistical Tools in spreadsheets. AutoFilter works more smoothly as well. Writer gains the ability to Insert Bookmarks and Reference Fields and there are many improvements to make Collabora Online better looking, easier to use and to offer more functionality. The full overview is in the release notes page.

Using Pivot Tables in Collabora Online

Pivot Tables are a flexible and powerful analysis tool for mixed data sets. The Pivot Table icon on the Data tab starts the wizard to create a Pivot Table in three steps. Editing the lay out of an existing Pivot Table, can be started with the same button. To create a new Pivot Table, do the following:

    1. Select the source (use the current selection or define one)
    2. Define the layout by dragging the available fields to the desired part of the Pivot Table
    3. Make final adjustments like defining the destination (new tab, or a position on the current one) of the Pivot Table and other options.

 

Select the data source for the Pivot Table
Step 1: Select the data source for the Pivot Table
Defining a Pivot Table layout in Collabora Online
Step 2: Drag and drop the available fields to define the layout of the Pivot Table
Pivot Table wizard in Collabora Online
Step 3: Make final (optinal) adjustments, like e. g. destination of the Pivot Table
Filtering data and adjusting the finest details to get the perfect result, with a rich set of sub-dialogs familiar from the desktop!

 

Defining and managing Range Names in Calc Online

Define Names allows you to specify easy to use names for selected areas. Access this function via the Data tab in Calc (or the Insert tab in later versions). Once one or more ranges are defined, they can be managed through the Manage Names function. While calculation in Online always used these names, the ability to manage them online is very convenient.

Defining range names in Collabora Online
Manage range names in Collabora Online
Mind that via the Options in Define Names, you can also define a Print Range. Print ranges are essential to configure and print useful PDF documents from a spreadsheet focused on the areas of greatest interest. Another great win in this new Collabora Online version!

 

 New look of AutoFilter in Collabora Online

The AutoFilter feature has been redesigned and is now using natively themed dialogs. It generates a rich combo box on the data columns of a range, that allows you select the data to be displayed and as well start the dialog for the even more flexible Standard Filter dialog.

 

Statistical tools for data analysis

Calc offers more than a dozen powerful statistical tools. Those are now available in Collabora Online via tab Data, tab. For statistical analysis you can access:

  • Sampling
  • Descriptive Statistics
  • Analysis of Variance (ANOVA)
  • Correlation
  • Covariance
  • Exponential Smoothing
  • Moving Average
  • Regression
  • Paired t-test
  • F-test
  • Z-test
  • Chi-square Test

A more detailed description about the statistical tools is available in the Collabora Online documentation. The Fourier Analysis can also be found inside the Statistics menu.

 

Improved document jail performance

Then there is an important improvement in performance for some users in Collabora Online 6.4.3. The details are rather technical. Collabora Online isolates each document into a secure jail. This is done by falling back through a series of options to ensure performance and security. The fastest approach (tried first) is bind-mounting, after which Collabora Online tries to use capabilities like cap_fowner to hard-link system files in. Unfortunately, in the 6.4.x series an intersection with systemd namespaces crippled this hard-linking optimization. In 6.4.3 this is now solved by copying files out of the system to a place that can safely and quickly hard-linked so then they can be shared. This is far faster than the ultimate fallback: raw copying of the data. The developers further accelerated the raw copying case by avoiding copying dictionaries too. For some systems this should give a significant performance win for document thumbnailing and load times, we also warn when hitting this slowest code-path too.

 

More new features in Collabora Online 6.4.3

Collabora Online is in permanent development, steadily introducing safe new features into our stable releases and constantly improving interoperability and user experience. Please check-out our release notes to find out about the latest features and improvements. Would you like to test the latest version with all new features? Then simply request a free demo!

 

 

How to access the new features in the classic UI

The new icons are only available in the new NotebookBar UI. However, if you are using the classic UI you will also be able to access the Pivot Table, AutoFilter, Define Name & Manage Names via the Data tab. On mouseover, a dropdown menu will give you access to the features.

About Collabora Productivity

Collabora Productivity is the driving force behind putting LibreOffice in the cloud, providing Collabora Online and a range of products and consulting to enterprise and government. Powered by the largest team of certified LibreOffice engineers in the world, it is a leading contributor to the LibreOffice codebase and community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term, multi-platform support. Collabora Productivity is a division of Collabora, the global software consultancy dedicated to providing the benefits of Open Source to the commercial world, specializing in mobile, automotive and consumer electronics industries. For more information, visit www.collaboraoffice.com or follow Collabora Office on Twitter .

 

Read More

Collabora Online 6.4.0-released

New major version of Collabora Online brings improved user experience and compatibility

Cambridge, United Kingdom, November 2, 2020Collabora Productivity is excited to announce a new, major release of our product Collabora Online, version 6.4.0. This release adds a new easier to use interface with a notebook bar as well as excellent display of Microsoft file format documents. This release not only brings a fresh look, enhanced usability, improved interoperability, and extra functionality. It also marks a harmonization of our version numbering. Collabora Online jumps from 4.2 to 6.4, to align with our other Collabora Office products: for the desktop and mobile devices. Collabora Online offers privacy as well as the only truly open-source solution for working with and collaborating on rich documents in the cloud.

Attractive and easy to use NotebookBar option in Collabora Online

Collabora Online 6.4 comes with a cool and modern NotebookBar providing another easy to use and pretty access to all rich features. The easily identifiable buttons allow users to quickly select functions and the thematic organization of the tabs is intuitive. Users will of course recognize much of the NotebookBar from the desktop version.

Version 6.4 – A huge leap in user-friendliness… and numbering

The new Collabora Online with the NotebookBar marks a big step forward in usability. The version number also makes a big leap with a jump from 4.2 to 6.4. The previous numbering of Collabora Online reflected the release cycles of our online products, first released in 2016. To simplify things we make the numbering similar to Collabora Office for the desktop. This more accurately reflects the level of development, since much of the technology is shared by both products. Our mobile apps Collabora Office for Android, ChromeOS and iOS will also catch up in numbering soon.

Saving space and other NotebookBar details

When the user needs to save space, a single click on the active tab will collapse the NotebookBar. All the tabs are still there to use.


The hamburger menu also packs some important tools for e.g. collaboration and language.

Use the hamburger menu to access more options

How to keep the classic mode

The new NotebookBar is set as the default interface in this new release, however we have no plans to remove the classic menu and toolbar UX – some users and deployments clearly prefer it. To change this back you can select ‘classic’ for the user_interface key in loolwsd.xml, and some integrations will provide their own admin UI for this, to configure it for the whole server.

The new look of Writer, Impress and Calc

In Collabora Online 6.4 the new NotebookBar adapts to the users needs. With each type of document all available features are nicely sorted into clear tabs. The following images are taken from Writer, Impress and Calc.

Quick access, flexible interface option

Our developers worked effortless to provide the user interface that is both feature rich, and also flexible and small… if the user needs that. The following images present some possibilities with text, presentations and data.

New Spreadsheet rendering: freeze rows and columns

Spreadsheet rendering has been re-written from scratch in CODE 6.4! It continues to improve rapidly, please be patient as we work on performance tuning here. One big new feature is that users can now freeze rows and columns with the button on the tab Sheet or the entry in the menu View. Then, when the users scrolls/moves down in the spreadsheet, the chosen rows and columns will stay visible on top and the left. This is similar to the feature that is available in the desktop version of Collabora Office under View > Freeze Rows.

Collaborating with annotations to PDF files

Collabora’s products already have many powerful features supporting the increasing use of PDF documents. Collabora Online 6.4 allows users to collaborate around PDF documents by including a new feature to add annotations to PDF documents.

Various Collabora Online integrations let users open PDF files with Collabora Online, for example with a command in the file’s detail menu (More or simply ). After that, a comment can simply be added with Insert > Comment.

 

Interoperability improvements & consistent rendering

Collabora Online’s interoperability with Microsoft’s OOXML file formats, is as excellent as in our desktop product, since all share a large part of the underlying LibreOffice code base. This 6.4 release again adds dozens of improvements in Microsoft OOXML rendering for presentations, smart art, charts and more from the whole community. Some examples are given below:

Text can be set semi-transparent

A new feature in CODE 6.4 is the use of semi-transparent text, that can be set on the tab Font Effects. Therefore, now semi-transparent text from OOXML files is shown.

Improved import of SmartArt

With the release of Collabora Online 6.4 the import of SmartArt in MS Office documents has been further improved.

The slide displays an imported SmartArt diagram turned Shape in Collabora Online 6.4

Gradient backgrounds in slides

The pitfalls of interoperability nowadays lie in small details. For example, colour gradients in the background of slides used to be lost with the import of Microsoft PPTX files. With version 6.4, this is now fixed.

Updates & Security advisories

News on all Online 6.4-updates are in the release notes. And for security updates, pls check this page.
 

About Collabora Online

Collabora Online 6.4 is the first release (regularly updated) of our next development series, suitable for large scale deployment, and comes with SLA, enterprise support with signed security updates as well as interaction with product management, helping to direct our development priorities. Collabora Online integrates flawlessly into Nextcloud, ownCloud, Seafile, and many of the major file sync & share, groupware and hosting solutions. It is ideal for organizations that want to collaborate on documents, without losing control over them, or compromising on privacy. With the ability to host it on your own hardware or to integrate it into a trusted environment, Collabora Online is the ideal online office suite for digital sovereignty. Enterprises interested in using Collabora Online can check out our home page for more information on partner integrations and online demos. Hosting and Cloud businesses that wish to add Collabora Online to their product portfolio can become a partner. For any questions or tailored solutions, do not hesitate to contact hello@collaboraoffice.com.

Thanks to the community!

Collabora has invested significantly in bringing a host of new features and functionality to this latest release, and accounts for the overwhelming volume of contributions. However we want to acknowledge all of our friends and colleagues who helped to contribute not only to this, but also to the underlying LibreOffice technology, you can check out LibreOffice community credits. We cannot thank everyone involved enough for their passionate work. All of our code is open source, and available to the public on GitHub. Would you like to be part of the Online-story? Check the new website for Onlinewith information, easy hacks and a forum for Online, and participate today!

Read More

Collabora Online Shines at the Nextcloud Conference

#nextcloudconf2020

 

The Nextcloud Conference 2020 took place on October 3rd and 4th – typically for this year as a virtual event. Participants were able to follow the compact presentations in the livestream and then ask questions to the speakers online. On behalf of Collabora Michael Meeks spoke about all the latest developments for Collabora Online.

Watch Michael Meeks Talk at the Nextcloud Conference 2020

Showing some highlights

Documents always stay on your server, and on your server alone

Data security is one of the top features of Collabora Online. The application lets the edited document never leave the server; only images of the documents, pixels, are transmitted to the viewing and editing parties. This differs from other approaches for online cooperation and editing, where centralized keys or even the sending and receiving of the actual file at all devices are used. On top of that, the use of watermarks make the handling of the content of your documents even more secure.

New UI – Experience options

An absolute novelty is the new user interface, which was presented only a few days before in Collabora Online Development Edition release 6.4. The new intuitive NotebookBar arranges the most important functions in clearly arranged tabs, and can also be folded up to maximize the workspace. The user interfaces can be selected in the admin area. For Nextcloud users, the classic toolbar is currently the default setting.

Collaborating with annotations to PDF files

Collabora Online offers more features for PDF files. When a PDF is opened in Collabora Online, from the three dots menu of the file, users can now search the text and also add annotations. Allowing easier cooperation on PDF documents.

Questions from the Nextcloud Community

After the streaming of the talk viewers of the Nextcloud conference had the possibility to address questions to Michael Meeks. We give you the (slightly shortened) answers below with timecoded links to the full answer in the recording of the stream.
Michael Meeks answering questions from the Nextcloud community

How to you get the new NotebookBar?

There are two answers to that. We are working on putting a UI into Nextcloud to make that extremely trivial through a check button so that it will become really easy for people to check on it, play with it and see if they like it. This is to be incorporated soon with the stable release. Currently, you can edit your loolwsd.xml file – soon to be renamed into coolwsd.xml. You’ll find the UI settings in there. All the details are available in the announcement post of Collabora Online Development Edition 6.4. (watch full answer)

Can you use custom colour pallets and corporate design colours in documents?

In terms of documents, we have a very powerful style engine in the ODF file format to create all kind of elements in different colours. You can drop that into a template and use it in Nextcloud right today. In terms of UI colours it is quite an easy thing to push elements into the iframe. We invite people to get involved on GitHub & Telegram and play around we can help you extend the range of what is possible there. (watch full answer)

When will CODE 6.4 turn into an enterprise version?

That depends on the feedback. We want to make sure that it is really ready and fully baked. I’m seeing Collabora Online 6.4 released in a matter of 3 to 4 weeks. (watch full answer)

Thanks!

We’d like to thank the Nextcloud team for the invite and the community for the awesome work it is doing in the project. Since Nextcloud Hub 19 there is an easy to install built-in server option available in Nextcloud. Of course, you can also check on the quick try-out with docker. Fancy a closer look at the slides? Please find the download link below.

Read More