Conditional formatting on CODE Server is laggy

User Support
1

Hi!
I recently was looking for a self-hosted alternative to Google Sheets and found Collabora Online.
So I installed a local Server (i5-3320m) with Ubuntu, Nextcloud and Collabora Online. Everything works so far.

I made a new Spreadsheet and started to develop my table.
The table should have a bigger area (100-1000 cells) with conditional formatting.
The background of the cells should change dependent on the entry with around 10 different rules.

There i find limitations.
The menu for conditional formatting is laggy, scrolling and selecting conditions does not work reliably.
In the dialog I can generate new Styles for the conditions but I can not edit existing Styles.

The cpu usage on the server and the laptop is low (<20%).
The behaviour is browser independent (Chrome, Firefox and Brave tested).
The behaviour can be reproduced at webo hosting, a parter of Collabora Online.
The behaviour can be reproduced with another laptop (i7-7500U).
The behaviour on a local Libreoffie is much smoother (or usable at all) and I can modify existing Styles.

Does this behaviour change if i upgrade to a Collabora Business Account? I do not have a clear understanding of the functional differences between my self hosted CODE Server and a Collabora Business Server.
My workaround so far is to use a local Libreoffice and edit the document offline but i would prefer to fully work with the document online.

Any suggestions? It is my first self-hosted IT project and I am not sure if I miss something obvious.

Regards,
Michael

2

Hey @mwagner,

Welcome to the forum + thanks for posting.

I recently was looking for a self-hosted alternative to Google Sheets and found Collabora Online.

Fantastic. :slight_smile:

The table should have a bigger area (100-1000 cells) with conditional formatting.
The background of the cells should change dependent on the entry with around 10 different rules.

Hmmm, is this still an issue on the latest Collabora Online?

What is your exact:

  • Help > About info?

If it’s still very slow, could you please:

  • Attach a sample ODS document.

Side Note: There has been some focus on better performance in recent Collabora versions, so perhaps today’s runs these menus+Conditional Formatting better than February’s.

In the dialog I can generate new Styles for the conditions but I can not edit existing Styles.

We are talking about the:

  • “Format” tab

then press on:

  • “Conditional” button > “Condition…”

Right?

If so, it looks like this specific menu still needs to be converted to a “JSDialog”. To follow the latest status, follow this issue in Github:

One of the developers is currently working on upgrading it (as of a few months ago).

Any suggestions? It is my first self-hosted IT project and I am not sure if I miss something obvious.

If you click on that Github link above, you can follow this feature.

Once that Conditional Formatting menu gets upgraded for JSDialog (making it work much better in the browser), the menu should work much smoother/better… and look nicer too!

Does this behaviour change if i upgrade to a Collabora Business Account?

No, I don’t believe so.

I do not have a clear understanding of the functional differences between my self hosted CODE Server and a Collabora Business Server.

If you visit the Collabora Pricing page, you can see a little comparison between the different versions.

The paid versions are geared more towards businesses with multiple/many users.

You’ll also get extra features like:

  • Long-Term Support
  • Hosted versions
    • Collabora can host using their servers if needed.
  • Updates
  • […]

At the highest tiers, you also get:

  • Desktop+Mobile support
  • + customized UIs / icons / logos
  • + ability to report private/sensitive bugs
    • Developers can work directly with you to solve specific issues or add new features.
  • […]

Where CODE, the personal version, is mostly for users to test on their own.

You can use it in your small network, or sharing and editing documents among friends… but you’ll be the one who has to dig through all the Documentation + config files + be in charge of downloading all the latest and greatest patches.

It’s all using the same Collabora (+ LibreOffice’s technology) under the hood though. :slight_smile: