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. 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.

All features available in a single menu in the classic UI

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

Move and Copy Sheets in Collabora Online

Moving and copying of sheets can now be done directly in spreadsheets in Collabora Online. This possibility has been added to the most recent update, version 6.4.2!

 

Use the Context Menu options or the full Dialog

  • The first new option is moving sheets to a position left or right, with the context menu of the sheets tab.

  • Most possibilities are offered by the dialog, that we know from Collabora Office on desktop too. You start it from the context menu of the sheets tab.

 

All details about Collabora Online update 6.4.2

You can read all the details about the 6.4.2 update in the Collabora Online Release Notes.

 

Working to make Online even richer in features and more powerful

Collabora Online is known for reliability and security and in close cooperation with partners, customers and community we keep extending possibilities and improving the software. The Collabora Online 6.4 announcement together with the release notes give you all details. If you are new to Collabora Online, we expect that you may be interested to test the features.. Do ask our sales team all possibilities or get a full demo version now ..

 

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

Intuitive and easy use of large spreadsheets with Freeze Rows and Columns in Collabora Online

The latest major release of Collabora Online 6.4 introduces the really handy feature to Freeze Rows and Columns. In Collabora Online this works very easy and intuitive. In this blog we show the use, to further improving your experience working with large spreadsheets!

Freezing the first Row and Column

In most common cases users will want to freeze the first rows or columns, which often include the data labels or descriptions. Doing this is simple:

 

  • Press the Freeze First Row or Freeze First Column button on the Sheet tab of the user interface.
  • Press both buttons, if you would like to freeze both the first row and column.

Now, when you navigate through your larger sheet, the first row and/or column will always stay visible.

  • In your spreadsheet: A broader light gray line between the first and second row or column will be visible
  • In the user interface: The Freeze Rows and Columns button is highlighted (see the screenshot to the left)

 

Notice! One of the handy features of the Freeze First Row/Column button is, that you can also activate it when you have already scrolled way through the sheet to bring the first row or column back.

 

Freezing and unfreezing any Row or Column

The Freeze Rows and Columns does not only display if the Freeze Panes function is activated, it is also used to freeze any row or column in your spreadsheet.

  • Select the cell right of column or below any row you want to freeze.
  • Click on the Freeze Rows and Columns button.

All the rows above the cell and left of the cell will stay visible until you click the button again to unfreeze all elements. See some examples below.

Select cell A3 & click on Freeze Rows and Columns to freeze the first two rows
Select cell C3 & click on Freeze Rows and Columns to freeze the first two columns and two rows
Select cell C1 & click on Freeze Rows and Columns to freeze the first two columns

 

Bringing more functionalities to Online

Collabora Online is in constant development. We are working closely with our partners and customers to keep improving the software. Check out the announcement blog of Collabora Online 6.4 to learn about the latest developments. Would you like to test the latest version of Collabora Online? Please request a free demo!

 

 

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 Office 6.4 Released

Cambridge, August 4th, 2020 – Today we release Collabora Office 6.4 providing businesses and professionals with the best features, interoperability, LTS and custom support in open source while respecting user privacy and company data security. Changes in Collabora Office 6.4 also support new and enhanced features in Collabora Online.

Excellent Interoperability and World Class Support

Collabora Office 6.4 offers excellent interoperability with all major office formats. Import text documents, spreadsheets and presentations from MS Office files or the Open Document Format and save them just as easily. We maintain the world’s largest team of certified LibreOffice developers and offer our customers a long-term supported version of LibreOffice. Version branch 6.4 of Collabora Office will be supported until August 2023 at least.

New Features in Version 6.4

In addition to improving performance and interoperability, Collabora Office 6.4 brings a number of practical improvements to your work. The newly implemented functions can be found all over the suite. The following are some outstanding examples.

 

Adding Visible Signatures to Existing PDF Files

Collabora Office already had the capability to add a digital signature to an existing PDF file. This still works the same. That signature however is (and was) only visible on the status bar and in file properties; there is no visible signature in the PDF file. Now in Collabora Office 6.4 adding a visible signature has been made possible. You start this new feature by selecting the PDF file with File > Digital Signatures > Sign existing PDF.

 

Addding visible signatures to existing PDF files
Ad visible signatures to existing PDF files

Read all details in this blog post.

 

Send Encrypted PDF Files with Mail Merge

One of the very handy and well established features of Collabora Office Writer, is Mail Merge that directly sends out PDF files. In version 6.4 this function has been extended so that you now can send encrypted PDF files. This enhances the privacy options of your workflow. Find more details in our blog.

 

Encrypt your PDF when sending them with Mail Merge

 

Padded Numbering Up to 5 Characters

Padded Numbering allows you to work with list numbering using a prefix. This is now possible up to four zeros. The feature that was introduced in an earlier version was limited to prefixes of two zeros.

 

A Padded Numbering list with a prefix of two zeros in Writer

 

Set Distance of Shapes to the Bottom of the Page

It can be very handy to specify the vertical position of a shape in text documents by setting the distance at the bottom of the page content area. Until now, this was not possible, although you can do so with the distance at the top of the page content area. If you tried to do the same from the bottom, the shape would be pushed below the margin. Collabora Office 6.4 now fixes this. You can set a negative value for the position to the bottom of the page content area, and the shape will stay in that position. Also when for example the page size is changed, or when other content is added or moved. More details are described in this blog.

 

 

Export Larger Pages from Draw using PDF 1.6

Using PDF 1.6, exported PDFs can now be larger than 508 cm (200 inch). Before the size was limited because of the possibilities of the PDF 1.5 specification. Since PDF files from Collabora Office, or more specifically from Draw, can be used to create banners, a limitation of 5 meters only is of course, impractical. More background on this can be found in this blog.

 

Export large PDF from Draw

 

Semi-transparent Text in Writer

Collabora Office 6.4 supports semi-transparent text, as it is also supported by Microsoft Word for DOCX files. So this again represents an interoperability improvement. In this blog you can find more details.

 

Interoperability improvement. Semi-transparent text in Writer

 

Upstream LibreOffice and more…

Collabora Office is based on the stable LibreOffice branch with extra features and fixes. Collabora Office 6.4 has the capabilities as described in the LibreOffice 6.4 release notes, of which quite some, especially these for our customers, have been introduced in earlier versions of Collabora Office. Of the 6.4 features, quite some have been added by our Collabora Productivity team. As an outstanding example, we feature the Full PDF Export for Spreadsheets.

Full-Sheet Previews option on the PDF Export Dialog
Full-Sheet Previews option on the PDF Export Dialog

 

About

Collabora Office is the LibreOffice-technology based suite for professional, mobile, and online use. Collabora Office 6.4 provides businesses and professionals with the best features, interoperability, LTS and L3 support.
Collabora is privileged to work with so many great contributors to the LibreOffice project and appreciates all the amazing work done by so many that is also included into Collabora Office 6.4. This, our annual release, contains much work that was contributed to LibreOffice 6.3 and then LibreOffice 6.4. These cover all manner of areas from significantly improved filters, performance improvements, 95+% of online features and improvements, rendering along with a powerful redaction feature.
Please do find the full credits here.

Migrate with our demo of Collabora Office 6.4

You can try Collabora Office 6.4 yourself! Just head to the Collabora Office page and request your demo today, or just click the button below.

Try the Demo

Read More