Collabora Online Logo

CODE 6.4.7 enables Macros and provides Draw online

Note: Post archived from previous website - some links, images, and/or post formatting may not display correctly. Contact us using the contact page below if you have any questions about post contents.

The latest version of the Collabora Online Development Edition (CODE) 6.4.7 brings major improvements and great new features. A completely new application, Draw, has been enabled online allowing you to work with vector graphics. Inside documents (if enabled by the administrator), it is possible to run macros from the newly introduced Macro selector. With our VBA compatibility that’s particularly useful for spreadsheet formulae. This version also includes many UI improvements, for instance a reworked Style preview in the NotebookBar.

 

Please checkout the latest features – and give your feedback

CODE gives you the latest and greatest features in online collaboration earlier than our 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.

 

Draw has arrived in Online

You can now edit your .odg files online. Draw online allows working with flowcharts, technical drawings and brochures.

People familiar with Draw from the desktop, will recognize the tools for creating or editing flowcharts, technical drawings, posters, photo galleries or brochures. If you don’t know Draw yet: have a play with a vector graphic drawing online!

CODE 6.4.7 brings new elements such as the Connector Toolbox and the Vertical Textbox hosted in the ‘Home’ and ‘Insert’ tabs. Other drawing features such as Basic Shapes, Fontwork, Lines, Images, Charts and Tables were already available in Online. Currently, Draw Online is the only component allowing you to create the connectors, though re-using them in Writer, Calc and Impress is possible.

Accessing a .odg file from your file storage solution will automatically take you to Draw online. Given the shared code between Draw and Impress, you will discover similarities in the structure of the two user interfaces.

The ConnectorToolbox is available from the Home tab in Draw online

Enabling VBA compatible macros for online

CODE 6.4.7 introduces the possibility to use macros in your favourite online collaboration suite. These macros run on the server inside a secure container that is specific to your document and we are confident in our containment. However giving you control of the attack surface is important, so this functionality is hard disabled by default, and has to be explicitly enabled by admins in the loolwsd.xml configuration. Once enabled, users can choose to explicitly allow macros in the documents they are loading.

Macros extend the functionality of the office suite by accessing the programmable interface of Collabora Office. They can be useful when you have to repeat the same task in the same way over and over again.

Select & run macros from the Macro Selector in CODE 6.4.7

On the NotebookBar, users find the macros command in the “burger” menu in the top-left corner, following the path Tools > Run Macros. On the classic toolbar, the same Macro Selector dialog can be accessed via the Tools menu.

Running macros in the online documents has several limitations, most of them are due to the nature of editing the documents online. For example, the macros cannot access additional documents (other than the document edited by the user running the macro), use the Shell command, call external programs, and similar functionality. In addition the VBA APIs were never designed with collaboration in-mind, so their use is ideally limited to cases where a single user is editing a document.

All details of macros, settings, limitations, are published in this How-to post.

Run macros while editing on a mobile device (click to see animation)
Run Macro from the new NotebookBar
Run Macro from the classic toolbar
Select & Run Macro from the Macro Selector dialog

 

Style previews in NotebookBar and even more UI improvement

This version of Collabora Online adds several improvements to the appearance and usability of the user interface. In the NotebookBar the scrolling of the style preview has been improved, making it easier to recognize and pick the style you need.

The new Style preview makes it easy to recognize & pick the style you need

It is no longer necessary to click on navigation arrows, and you can navigate through the styles using the scrollbar or the mouse wheel. Various UI improvements, including a new top bar comment icon (Thank you to Umut Bayramoğlu, easy hack #202), have been developed by community members.

 

Initial canvas rework and UI improvements on mobile devices

Previous versions of Collabora Online have started to use the HTML5 canvas for rendering of spreadsheets on the desktop browser. This version takes this to the next level. The HTML5 canvas is now used for all the applications (Writer, Calc, Impress, Draw) on all the form factors (desktop, tablet, mobile).

To achieve that, large parts of Collabora Online have been completely reworked. This solved a number of corner cases in the user interface with some browser settings, and removed a large amount of legacy code re-writing it into cleaner, more maintainable TypeScript where possible. Furthermore, it also let us enable the Freeze Rows & Columns functionality on phones and tablets, while also making the rendering faster. We do expect some rough edges at the time of releasing CODE 6.4.7 – for example the pinch-to-zoom behavior is still sub-optimal, you can expect a bit of a flicker when the zoom has finished. Please do update to the latest 6.4.7 and report your findings, we will do several smaller iterations with fixes for CODE 6.4.7. Please refer to the Feedback section above to see how to help out.

Comment handling on mobile phones has also experienced a major usability improvement. These are not part of the document any more; instead, users can see a list of comments with just a single tap on the icon in the toolbar and handle them much more conveniently (thanks Rashesh Padia for all the help here).

Freeze Panes functionality on a tablet displaying the NotebookBar

 

Customize your Shapes

Shapes have become more flexible. It is now possible to customize them according to your needs.

By moving the control adjustment points you can now easily round corners, modify the diameter of arrows… or bring a smile to a sad face.

Customize your shapes using the adjustment points

 

Export Spreadsheets as CSV

It is now possible to export your spreadsheets directly to CSV, making it more convenient to work with the CSV text file format. The new export option is available through the File tab both in the new NotebookBar and the classic toolbar. Thank you to Rizal Muttaqin for the icon design (easy hack #1020).

 

Look and feel selection per-user

In previous versions, we allowed administrators to choose whether they had a classic (menu + toolbars) UI, familiar from Google Docs, or a Notebookbar UI, familiar to MS Office users.

In CODE 6.4.7 the integration that embeds Collabora Online can choose per-user as they construct the iframe, which they want to select. If you are interested in implementing an option in your integration, please check how to use UIMode in the Theming of Collabora Online part of our SDK.

Integrations can go even further, and allow the users to live-change the UI by passing the Action_ChangeUIMode postmessage from their webapp to the Collabora Online iframe. Thank you to Gabriel Masei of 1&1 for this implementation.

 

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

 

Leave a Reply

Subscribe to our newsletter:

Follow us on social media:

Learn how we helped 100 top brands gain success