Solved Missing options in the Collabora Package

[avatar1024]

Hello,

The collabora package seem to have an issue (using 6.4.0-14). I don't if it's only since the update to 6.4.0 but I think so (I cannot go back before 6.4.0 that point on my app backups).

When opening a spreadsheet I'm missing the option to insert of remove cells. The option is missing both from the mouse right click and from the tool bar. Screenshots from collabora does show the tool bar icon for version 6.4. On mine this icon is missing.

I also cannot protect or unprotect sheets anymore (No more tool > protect sheet option; nor right on sheet name > protect sheet)

Last the config option to switch to the new tool bar introduced in 6.4 is missing from the Cloudron app config file loolwsd.xml.

I have tested on three different cloudron instance, one of which is a completly fresh install.

I have looked for these bugs upstream but couldn't find anyone reporting any of these.

[nebulon]

Apparently you can also use right-click on the row/column headers or use the "Sheet" menu. However the new toolbar style is indeed missing in the loolwsd.xml

One option is to open a webterminal into the app and add the following to the /app/data/loolwsd.xml then restart the app:

<user_interface>
      <mode type="string" desc="Controls the user interface style (classic|notebookbar)" default="notebookbar">notebookbar</mode>
</user_interface>

Overall it is not ideal that the loolwsd.xml is set in stone during app install by being copied over to /app/data/ for a start I will update the app package, but in the long run we should come up with a better way to make it customizable while being also able to add new config options automatically via an update.

[nebulon]

So the new app package is out, however for the new toolbar to be enabled, you would have to reinstall the app! Luckily it is anyways stateless, so if you re-install it in the very same location, it should just work, since nextcloud only relies on the app origin.

[avatar1024]

@nebulon Thanks a lot for looking into this (and for already releasing a new package!). That works well for the new tool bar.
Regarding the other issue, I was talking about adding / removing cells, not rows or columns (for which indeed there is the menu or cell / column headers). There is still not the option to add or remove cells (I did a fresh install of the app). It should normally be accessible on right click or in the sheet menu section (same setion as for adding entire rows or columns).

[nebulon]

Oh I see, I didn't even know one can remove a cell as such. Have to check again.

[avatar1024]

@nebulon Thanks! Removing a single cell is quite rare, but a range/array of cells is quite common. You can see the function on desktop version of LO, excel or on Google Sheets

[nebulon]

Indeed I can't find any button in the toolbar, but also no setting for this. You can, also for multicell, right-click and "Clear contents..." or after selecting the cells simply press "delete" on the keyboard.

[avatar1024]

@nebulon Yes you can do that to clear content but that doesn't do the same job as when you remove / add cells (my previous message meant to say Removing / Adding btw), it shifts (up/down right/left) the rest of the cells in a sheet, so it really is a different function than clearing the content (plus that trick would have only kind worked if the intention is to remove cells, not to add some).

Its very weird as this is a very basic spreadsheet function and is documented in Collabora, and I am 99% positive it was there in previous Cloudron package.

Btw, I did another search for this missing feature in reported issues upstream and could not find anything.

[avatar1024]

@nebulon Actually hold on a bit with this. I have noticed in a screenshot that the options seem to have disappear so I'll report upstream first.

[avatar1024]

Missing options for add / remove cells and protect / unprotect sheets will now be fixed upstream. Both commits have now been submitted.

For add/remove cells one can use the Ctrl+ / Ctrl- shortcut already

[nebulon]

Interesting notes. To be honest, I basically never use spreadsheets so I mostly don't really know the functionality of such apps in the first place

[avatar1024]

@nebulon I wish my coding skills would be good enough so I could replace my sophisticated spreadsheets with some slick and efficient code, and too not worry, or even know, about such functionalities