Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

Missing options in the Collabora Package

Scheduled Pinned Locked Moved Solved Collabora Online (CODE)
12 Posts 2 Posters 546 Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • avatar1024A Offline
    avatar1024A Offline
    avatar1024
    wrote on last edited by avatar1024
    #1

    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.

    1 Reply Last reply
    0
  • nebulonN Online
    nebulonN Online
    nebulon Staff
    wrote on last edited by
    #2

    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.

    avatar1024A 1 Reply Last reply
    1
  • nebulonN Online
    nebulonN Online
    nebulon Staff
    wrote on last edited by
    #3

    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.

    1 Reply Last reply
    1
  • avatar1024A Offline
    avatar1024A Offline
    avatar1024
    replied to nebulon on last edited by
    #4

    @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).

    1 Reply Last reply
    0
  • nebulonN Online
    nebulonN Online
    nebulon Staff
    wrote on last edited by
    #5

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

    avatar1024A 1 Reply Last reply
    0
  • avatar1024A Offline
    avatar1024A Offline
    avatar1024
    replied to nebulon on last edited by avatar1024
    #6

    @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

    1 Reply Last reply
    0
  • nebulonN Online
    nebulonN Online
    nebulon Staff
    wrote on last edited by
    #7

    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.

    avatar1024A 2 Replies Last reply
    0
  • avatar1024A Offline
    avatar1024A Offline
    avatar1024
    replied to nebulon on last edited by avatar1024
    #8

    @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.

    1 Reply Last reply
    0
  • avatar1024A Offline
    avatar1024A Offline
    avatar1024
    replied to nebulon on last edited by
    #9

    @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.

    1 Reply Last reply
    1
  • avatar1024A Offline
    avatar1024A Offline
    avatar1024
    wrote on last edited by
    #10

    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

    1 Reply Last reply
    0
  • nebulonN Online
    nebulonN Online
    nebulon Staff
    wrote on last edited by
    #11

    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 😉

    avatar1024A 1 Reply Last reply
    0
  • avatar1024A Offline
    avatar1024A Offline
    avatar1024
    replied to nebulon on last edited by
    #12

    @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 😉

    1 Reply Last reply
    0

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.