New formulabar in Collabora Online

I still continue conversion of various UI components in Collabora Online to "native" HTML widgets. This helps us to get better user experience especially on touch / mobile devices. This time I converted formulabar which is used to edit data in cells in the spreadsheets.

Previous "tunneled" approach had some disadvantages like blurry look under some conditions and cursor position setup depending on a pixel based coordinates. Now it become edit field which is rendered by the browser - so we have always crisp text. Position of the carret is represented as a logical value and also handled by the browser - so on touch devices it is much easier to type.

Here you can see how it looks on a smartphone:

FOSDEM 2022 - Building Collabora Online UI using LibreOffice Components

Last weekend I participated in online event - FOSDEM 2022. Well known conference in the Open Source community, as described on the webpage: "FOSDEM is a free event for software developers to meet, share ideas and collaborate.".

I've presented my work from the recent year. Video and slides can be found here:
https://fosdem.org/2022/schedule/event/lotech_buildingcoolui/

Sidebar converted to „native” HTML controls

In the past I’ve converted sidebar into contextual menus for mobile version of Collabora Online. Since that time I was waiting for a moment when it will be possible to do similar thing for the desktop version of Collabora Online, the one that you use in the browser on your laptop. It is a good step to make UI unified and more convenient for a user.

In the new approach we use HTML controls with „native” listboxes and spinfields instead of pictures generated by the server. The data transfer from the server to the browser for fields invalidation should be reduced as we don’t have to send images. Widgets can be now styled using the same CSS like other UI components what will improve look of the sidebar. Thanks to the conversion for a desktop I also improved the mobile menus and did few optimizations.

Sidebar is still under development but looks promising:

LibreOffice & OpenSUSE Conference 2020

Recently I participated in the annual LibreOffice conference. This year it was different: first because it was done together with OpenSUSE community and second it was online event. I had two talks about features I implemented last year: mobile tool palette and notebookbar on desktop.

Notebookbar

Mobile tool palette - reused sidebar from the desktop application.

Here you can see my slides:

Native widgets on mobile for Online - prototype

In the desktop suite we have the sidebar which is a context dependant feature improving user performance eg. in chart editing. Unfortunately it's not the perfect UI for a mobile clients, so the new concept is to tunnel the UI description to the browser and create native widgets there. I did some prototyping work in this area and I can see first results:

As we can see all basic widgets and layout are preserved. All sections are visible, it will be possible to create an UI where user will see only one section at time for better mobile experience. Complex controls like color selectors are not available yet (I'm going to use our color selector present in the toolbar). The development takes place in the feature branch.

LibOCon 2019 Almeria - How to debug the Online conveniently

Szymon Kłos showing how to debug conveniently 💪 #collaboraonline #libreoffice #libreofficeonline @LibOCon #debug pic.twitter.com/EXrqk0WvCM

— Collabora Office (@CollaboraOffice) 13 września 2019

Hackerspace 3city - August with Open Source

This year in local Hackerspace in Gdańsk there was a series of meetups about Open Source related topics. I participated in one of them - IoT workshop about The Things Network and LoRaWAN by Inżynier Domu.
To be short: LoRaWAN is an open network for IoT devices which provides possibility to communicate eg. with a server side application. Interesting standard, but unfortunately not so popular in Poland yet (only one gateway in hs range - at Gdansk University of Technology).

Links to remember:
http://www.inzynierdomu.pl/lora-i-lorawan-czesc-1/
http://www.inzynierdomu.pl/lora-i-lorawan-czesc-2/
Photos from: https://www.facebook.com/pg/hackerspacetrojmiasto/posts