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.
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 ..
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 .
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!
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 .
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.
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
Updates & Security advisories
News on all 6.4-updates are in the release notes. And for security updates, pls check this page.
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.
Cambridge, December 20, 2019 – Today we release Collabora Office 6.2.0 providing businesses and professionals with the best features, interoperability, LTS and custom support in open source as well as respecting user privacy and company data security. Changes in Collabora Office 6.2 also support new and enhanced features in Collabora Online.
The Best of Features, Interoperability, and Support in Open Source
We’ve selected the following of the new possibilities and improvements, available in the new release of our office productivity suite.
Writer 6.2
Better language support and exchange with Word documents including support for bottom-top left-right text direction.
Extended support of the legacy type Microsoft form fields.
Table-size actions involving column/row size now behave more in line with expectations.
There are many improvements in interoperability, of which quite some may look as minor, but that all together make a real difference.
User interface
There is a rich choice in toolbar layouts – a solution for every need and each preference via menu View > User Interface.
Nice and clear new icon sets.
Mobile improvements 6.2
We only mention a few items here: better support for HiDPI displays, improved performance, enhanced Document signing with Verisign.
Most important are a huge amount of improvements that show in better integration on small devices, more powerful features online, better look and user-friendliness. We recommend our information on Android, Apple iOS and CODE 4.2.0 (showing what will be in Collabora Online).
About
Collabora Office 6.2 provides businesses and professionals with the best features, interoperability, LTS and L3 support. Based on upstream LibreOffice 6.2 source code, the project in which we are happy to cooperate and where all our code is contributed, and extended with improvements and backported stable features from newer releases, or features for our customers that are not yet available in the stable upstream branches.
Migrate with our demo of Collabora Office 6.2
You can try Collabora Office 6.2 yourself! Just head to the Collabora Office page and request your demo today, or just click the button below.
