Developers Day: September 30th

COOL Days 2021 starts very soon with a Developers Day. Meet other developers at this event. It is free to join, virtual this year, and we expect the very first of many COOL Days to come! Reserve your seat by filling the form.

Developers Day features more than 40 sessions with included breaks for Q&A. All talks will be short, from 5 to 15 minutes, this in turn will allow you to watch more cool stuff and perhaps participate in Q&A slots! The full schedule will be released soon, but here is a test.

Starting off with the opening keynote at 09:30 CEST then a couple of talks ranging from insight on Localization of Collabora website; walk-through the Notebookbar structure; Updates on newly FreeBSD port; HowTo session on the Cypress tests and ending the morning session with Canvas for rendering UI.

Q&A ( max 15 min) followed by lunch break (1 hour), during the conference you will have multiple opportunities to participate during these Q&A time slots.

In the afternoon session, attendees will receive an update on the latest Calc canvas improvements followed by a presentation on Performance wins; Editing simulation; Android and iOS new features; Scaling improvements and Dialog improvements.

Q&A break (max 15 min)

See some of the Mobile design improvements; Get to know the ins and outs of bisecting; Collabora Online forum update; Learn how to get involved with translation; Stability and cleanup improvements; How 1&1 embeds COOL and right before the break Kubernetes setup & deployment.

Q&A break (max 15 min)

At 20:00 attendees will hear about all of the effort on the New sidebar and dialog backend. The proceeding talks will touch a variety of challenges and improvements: Async-save design; VBA macro support; OOXML document analysis; Rendering wasteage; Document searching; Multi-page PDF viewing; Text/JSON protocol performance improvement; Fuzzing / asan / string-vectors; User sentiment reporting; Setting up your own Collabora Online; SDK: creating a new integration.

Q&A break (max 15 min)

The last Collabora Online related talks centers on integration pieces and the latest development on that front. From the New Nextcloud/richdocuments pieces and New ownCloud integration pieces to the Moodle integration or the New Mattermost integration ending with a talk on how to contribute and the closing session.

The event as a whole is a great opportunity for people who are familiar with Open Source and Collabora Online. People who just want to learn more about the technology free of cost also have a great opportunity to experience the openness of COOL and the event itself.

Join us to celebrate the 1st COOL day on September the 30th, it’s free of charge:

Reserve your seat


If you have more of a business interest in deploying Collabora Online in the enterprise
then perhaps you should attend the Business Day? Early booking: 50% off before September 18!

Read More

Collaboran talks at the LibreOffice Conference 2021

An online conference all about LibreOffice technology

Hosted by The Document Foundation, the LibreOffice Conference 2021 (LibOCon) will be an online event. The live-streaming of the talks and workshops will be taking place from September 23rd to September 25th. Collabora developers will give interesting talks on LibreOffice technology, Collabora Online and the ecosystem on all three days, providing profound insights around the latest features and developments. This article gives you an overview of our presentations. Meet us at LibOCon 2021 and just one week later at our COOLdays!

Day 1: Thursday, September 23rd 2021

Michael Meeks

 13:00 – 13:30 – Room 1

Collabora Keynote

Michael Meeks, Managing Director of Collabora Productivity and member of the LibreOffice Board, looks at the latest developments around LibreOffice from an organizational and ecosystem perspective.

See details  Save to calendar

Noel Grandin

 15:00 – 15:30 – Room 1

I feel the need… The need for speed…

Optimization is a lengthy process. But also an adventure that requires a bit of detective instinct and plenty of exploratory talent. Discover which adjustments are being made to make LibreOffice even faster and better performing.

See details  Save to calendar

Marco Cecchetti

 16:00 – 16:20 – Room 1

Some improvements for the SVG export filter

Marco Cecchetti reports on progress around the use of SVG in presentations and the improvements in performance and storage requirements on export.

See details  Save to calendar

Tomaž Vajngerl

 16:30 – 17:00 – Room 1

Improved document searching with LibreOffice

Collabora developer Miklos Vajna introduces the latest enhancements to LibreOffice and Collabora Online search that visualize hits across different documents.

See details  Save to calendar

Mike Kaganski

 17:00 – 17:30 – Room 1

Multi-column support in LibreOffice 7.2

The new feature, its relevance, obstacles and implementation status. Mike Kaganski shares his experience, how interesting was it to work on this.

See details  Save to calendar


Day 2: Friday, September 24th 2021

Cor Nouws

 12:00 – 12:30 – Room 1

A year of COOL …

Find out about the improvements that LibreOffice technology in the browser experienced. Hear about success stories and new features in Collabora Online!

See details  Save to calendar

Michael Meeks

 12:30 – 13:00 – Room 1

COOL performance

Recently, we have been focusing our Collobora Online development on improving the feel and slickness of document editing. Come and hear about the things that we’ve found and fixed, both in COOL and also in the LibreOffice core to improve the experience!

See details  Save to calendar

Sarper Akdemir

 13:00 – 13:05 – Room 2

PPTX footer export & import interoperability

Sarper Akdemir outlines the challenges around the export & import of Footers in PPTX and how they have been mastered.

See details  Save to calendar

Miklos Vajna

 13:30 – 13:50 – Room 1

Gutter margin in Writer page styles

LibreOffice was already capable of handling various margins in Writer page styles. A missing piece was the support for the gutter margins. Find out, how this was implemented!

See details  Save to calendar

Tomaž Vajngerl

 14:00 – 14:30 – Room 1

Built-in “Xray” like UNO object inspector

When developing macros and extensions in LibreOffice, it is very useful to have an object inspector. The Document Foundation put up a tender to create a built-in Xray-like UNO object inspector. It was awarded to Collabora, and we are now in the process of implementing it. Hear about the progress!

See details  Save to calendar

Tomaž Vajngerl

 15:30 – 16:00 – Room 1

PDF annotations support

The LibreOffice technology in Draw is key to PDF annotations, and the support of a recently added review-based workflow. Find out, how this has been implemented!

See details  Save to calendar


Day 3: Saturday, September 25th 2021

Szymon Kłos

 13:00 – 13:15 – Room 1

JSDialogs improvements over the past year

JSDialogs is a LibreOffice component used to share UI elements with Collabora Online. Hear about the most recent updates added.

See details  Save to calendar

More interesting talks on LibreOffice technology at the COOLdays


We’re excited to announce the COOL Days 2021 – just one week after the LibOCon. The online conference will take place on September 30th and October 1st and feature a vast range of topics around Collabora Online’s technological and commercial development. The 30th of September – Development Day – is focused on developers to share their experiences. The 1st of October – Business Day – concentrates on commercial topics. Discover the COOL Days program.

 

 
 

Read More

Collabora Online 6.4.6 – Gutter Margins enhance text documents, Fontwork text art, many improvements

Collabora Online 6.4.6 makes it easier to produce professionally printed materials and at the same time more fun to work with. The two new features responsible for this are the Gutter Margins, currently only available in Online, the newly added Fontwork objects and more fixes. These features, first released in CODE 6.4.6, have been tested extensively and are now also available in the business-hardened version of Collabora Online. You can find additional information on GitHub and inside the Collabora Online 6.4 release notes.

 

Professional page formatting with Gutter Margins

Writer now features improved support for gutter margins. This is often requested for government documentation and really popular among our users in Asian countries. Mind that this new feature is not yet available for Writer on desktop. You can test it on desktop though, with the unstable snapshot of our supported Collabora Office version. This work is of course also being committed to the next LibreOffice release.

How to use the new gutter margins

This margin type can be specified explicitly, and it is also possible to select whether the gutter should be located on the left or at the top. The feature works with mirrored margins as well and is very useful for printed publications. To utilize this feature, access the Page Style dialog through the Layout tab. In the Page dialog you will find a new Gutter option below the Margin settings. On the right-hand side there is a drop-down menu that lets you choose the Gutter position (left or top). The small page icon in the dialog renders a preview of the margin size.

Microsoft Word also includes a gutter margin option, so this feature is also an interoperability improvement. When importing or exporting documents, this feature is now supported with DOCX, DOC, ODP, and RTF formats. While the feature has been primarily developed for Collabora Online, it is also available in the desktop version. If you are interested in more, and technical, details of this implementation, please take a look at the blog by developer Miklos Vajna.

1. Define the size of the gutter margin
2. Choose the position of the gutter margin
3. A preview of the gutter margin’s size and position is rendered in the dialog

Fontwork – graphical text art for your documents

Fontwork objects are fun to work with and are a good way to add some visual highlights to your documents. Using them in Collabora Online is very straightforward. After choosing a Fontwork object from the gallery, double-click the object to update the text. When selected, the colour, transparency, and the orientation of the graphical text can be adjusted through the Sidebar. The new Fontwork panel makes it easy to work with the characters’ height, or change the alignment and the character spacing. If you are using Collabora Online via your mobile phone’s browser you will benefit from the mobile-friendly interface, as shown in these images.

The main colour of the Fontwork object is defined by the Area colour, similar as to when working with Shapes. You can also choose from different types of fills (e.g. colour, gradient, bitmap, pattern) and set the transparency. Secondary or tertiary colours of Fontwork can be defined through the Line or Shadow colour.

Mobile optimized Fontwork interface. Click to enlarge!
1. Choose Fontwork from the Galery
2. Edit shape, letter height and alignment in the Sidebar panel.
3. Define Colour, Type of fill & transparency level in the Area panel

 

New configuration option for integrators

Collabora Online now does support the FileUrl property of WOPI. This is a URI to the file location that the WOPI client uses to get the file and can be used to get the file instead of a GetFile request. FileUrl brings better performance in some configurations and has been implemented in cooperation with partners.

 

 

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

CODE 6.4.6 Introduces Fontwork, Gutter Margins and More Improvements

The latest version of the Collabora Online Development Edition (CODE) 6.4.6 introduces new features and improvements. The newly introduced Fontwork feature, allows you to create the well known graphical text art objects inside Collabora Online. The feature can be accessed via the Insert tab, both on the NotebookBar and in the classic UI. The Fontart Gallery allows you to choose from a set of different text art objects, each of which can be customized via the Sidebar. It is now also possible to define gutter margins. And of course there is more!

Use the latest features now – and do give your feedback

CODE gives you the latest and greatest features in online collaboration earlier than the supported version Collabora Online. Of course, we would love to hear about your experiences. Please leave your feedback on CODE in the community forum or report any possible issues on GitHub.

How to use the attractive Fontwork objects

Working with Fontwork in Collabora Online is very straightforward. After choosing a Fontwork object from the gallery, double-click the object to update the text. When selected, the colour, transparency, and the orientation of the graphical text can be adjusted through the Sidebar. The new Fontwork panel makes it easy to work with the characters’ height, or change the alignment and the character spacing. If you are using Collabora Online via your mobile phone’s browser you will benefit from the mobile-friendly interface, as shown in these images.

The main colour of the Fontwork object is defined by the Area colour, similar as to when working with Shapes. You can also choose from different types of fills (e.g. colour, gradient, bitmap, pattern) and set the transparency. Secondary or tertiary colours of Fontwork can be defined through the Line or Shadow colour.

Mobile optimized Fontwork interface. Click to enlarge!
1. Choose Fontwork from the Galery
2. Edit shape, letter height and alignment in the Sidebar panel.
3. Define Colour, Type of fill & transparency level in the Area panel

 

Easier and better page formatting in Writer with Gutter Margins

Writer now features improved support for gutter margins. This is often requested for government documentation and really popular among our users in Asian countries.
Mind that this new feature is not yet available in the Writer on desktop. You can test it on desktop though, with the unstable snapshot of our supported Collabora Office version. And the work is of course also committed for the next LibreOffice release.

How to use the new gutter margins

This margin type can be specified explicitly, and it is also possible to select whether the gutter should be located on the left or at the top. The feature works with mirrored margins as well and is very useful for printed publications. To utilize this feature, access the Page Style dialog through the Layout tab. In the Page dialog you will find a new Gutter option below the Margin settings. On the right-hand side there is a drop-down menu that lets you choose the Gutter position (left or top). The small page icon in the dialog renders a preview of the margin size.

Microsoft Word also includes a gutter margin option, so this feature is also an interoperability improvement. When importing or exporting documents, this feature is now supported with DOCX, DOC, ODP, and RTF formats. While the feature has been primarily developed for Collabora Online, it is also available in the desktop version. If you are interested in more, and technical, details of this implementation, please take a look at the blog by developer Miklos Vajna.

1. Define the size of the gutter margin
2. Choose the position of the gutter margin
3. A preview of the gutter margin’s size and position is rendered in the dialog

 

New configuration option for integrators

Collabora Online now does support the FileUrl property of WOPI. This is a URI to the file location that the WOPI client uses to get the file and can be used to get the file instead of a GetFile request. FileUrl brings better performance in some configurations and has been implemented in cooperation with partners.

About CODE

CODE is the Collabora Online Development Edition. It contains the latest developments and is perfect for home users. It enables them to regain control of their own online documents and to host them themselves in a secure and private environment. For tech-enthusiasts, it is a low-threshold way to get involved and familiar with our online office solution. CODE will be improved continuously and our next supported and maintained Collabora Online product will be built from it. All of our code is Open Source, and a vibrant community in participating in growing Collabora Online. Would you like to be part of the story? Join the community!

 

Get CODE 6.4

 

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