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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
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
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Collabora Online (CODE)
  3. Missing options in the Collabora Package

Missing options in the Collabora Package

Scheduled Pinned Locked Moved Solved Collabora Online (CODE)
12 Posts 2 Posters 2.5k Views 2 Watching
  • 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 Offline
      nebulonN Offline
      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 Offline
        nebulonN Offline
        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
        • nebulonN 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.

          avatar1024A Offline
          avatar1024A Offline
          avatar1024
          wrote 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 Offline
            nebulonN Offline
            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
            • nebulonN nebulon

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

              avatar1024A Offline
              avatar1024A Offline
              avatar1024
              wrote 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 Offline
                nebulonN Offline
                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
                • nebulonN 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.

                  avatar1024A Offline
                  avatar1024A Offline
                  avatar1024
                  wrote 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
                  • nebulonN 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.

                    avatar1024A Offline
                    avatar1024A Offline
                    avatar1024
                    wrote 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 Offline
                        nebulonN Offline
                        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
                        • nebulonN 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 😉

                          avatar1024A Offline
                          avatar1024A Offline
                          avatar1024
                          wrote 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
                          Reply
                          • Reply as topic
                          Log in to reply
                          • Oldest to Newest
                          • Newest to Oldest
                          • Most Votes


                          • Login

                          • Don't have an account? Register

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