online icon indicating copy to clipboard operation
online copied to clipboard

scrolling sheet in collabora Calc in Nextcloud iOS app is unusable

Open jack-sprat opened this issue 10 months ago • 24 comments

I'm using Collabora Calc in the iOS NextCloud app v6.2.5.1, against Nextcloud server 28.0.7 - or at least trying to!

No amount of dragging at the screen will induce the sheet to scroll - it moves maybe a couple of lines and then, when I lift my finger away from the screen it scrolls back to the top.

An almost viable workaround is to pinch and zoom out and then try to jab at the correct tiny cell, but that's so hit and miss I've taken to ... writing things down and then transcribing into desktop/browser app when I'm back on a PC.

Steps to Reproduce

  1. open ODS file from NextCloud 'Files'
  2. try to swipe page upwards to access rows further down the sheet
  3. watch it struggle upwards briefly
  4. ... and then slide back to top of page.

Expected Behavior

The page should scroll

Actual Behavior

The page doesn't scroll

Smartphone

  • Device: iPhone 8
  • OS: iOS 16.7.10
  • Nextcloud app/server: 6.2.5.1; 28.0.7

It seems similar to issue reported on Nextcloud help, which was claimed as solved by in this case

jack-sprat avatar Feb 13 '25 00:02 jack-sprat

(history is suggesting I added label 24.04 - I didn't, it was just there, and I see no way to remove it)

jack-sprat avatar Feb 13 '25 00:02 jack-sprat

@Ezinnem could you check this?

jazevedo-coll avatar Feb 13 '25 10:02 jazevedo-coll

I can confirm this issue using the Nextcloud app.

I can scroll the same file using the same Collabora Online version in the browser.

Tested on Nextcloud Hydrogen for iOS 6.2.5.1 Nextcloud server 31.0.0 RC4 Uisng COOLWSD version: 24.04.13.0(git hash: fcd383990c (E)) LOKit version: Collabora Office 24.04.13.0(git hash: 456c22a9c2)

Ezinnem avatar Feb 17 '25 05:02 Ezinnem

I have the same issues on the Nextcloud Android app. Any attempt to scroll makes everything extremely laggy. Pintching to zoom instead is very responsive, and that is the only thing at the moment I can use to navigate the documents from the mobile app.

The problem appears also by browsing Nextcloud directly from the browser on the phone. Browsing from Desktop has no issues.

COOLWSD version: 24.04.13.1 (git hash: 3dc280be53 (E)) LOKit version: Collabora Office 24.04.13.1 (git hash: 0eee8d0a65) Served by: Debian GNU/Linux 12 (bookworm) Server ID: 92dface8 WOPI host: nextcloud 30.0.6.2 - richdocuments 8.5.4

marco-calautti avatar Mar 04 '25 07:03 marco-calautti

Interestingly. Once I am able to finally able to scroll, if I do not lift my finger from the screen, I can keep moving around the document indefinitely without issues. Once I lift the finger it is like it takes some seconds to "settle" before moving my finger around can have any effect again.

marco-calautti avatar Mar 04 '25 07:03 marco-calautti

Same here (but on Android), it feels like the issue lies in the rendering of the "smooth scrolling / momentum" behavior, e.g. when you flick while scrolling (so it still scrolls slowly once you have lifted the finger.).

I can consistently reproduce it with flicking:

https://github.com/user-attachments/assets/ae76cbe4-6a66-483d-9aac-41aabc5a02c6

I have attached a video where you can see the inputs of the scrolling movement. It seems every time, there is still momentum / velocity left after I lift my finger ("flicking", can be seen by the red line at the end of my movement and the Xv & YV values at the top) the rendering seems to hang or get unstable.

Hopefully this or something similar is also the cause for the iOS version so it can be fixed if it really is the culprit. ;)

TekkertheChaot avatar Mar 20 '25 12:03 TekkertheChaot

I had a similiar issue when scrolling a file with a hiden column. That column contained cells with formating (color). Showing all hiden columns solved the issue for me. That been said, it is still a bug. It shouldn't flicker because of hiden columns.

hubide avatar Mar 20 '25 14:03 hubide

My file has no hidden columns, and still have the issue.

marco-calautti avatar Mar 20 '25 14:03 marco-calautti

I can confirm the problem with Android and iOS Nextcloud Server 31.0.2 Collabora CODE 24.04.13.2 Nextcloud iOS App 6.4.0.10 @ iPadOS 18.3.2 Nextcloud Dev Android App 20250309 @ VollaOS 14-20250302-STABLE

The problem seams to be more present at iOS.

mario-spitze avatar Mar 23 '25 16:03 mario-spitze

This indeed feels very similar to this issue which was recently solved in 24.04.6.

I now also have this issue again with:

  • Nextcloud 29.0.14
  • richdocumentscode/Collabora Online - Built-in CODE Server 24.4.1302
  • Nextcloud Android 3.31.1

The issue is not present in the Collabora Office Android app version 24.04.12.4. So it seems that this issue started in 24.4.13?

siccovansas avatar Apr 10 '25 13:04 siccovansas

I just updated the Collabora Office Android app from 24.04.12.4 to 24.04.13.3 (via Collabora Office F-droid Repo). Before and after I updated, I opened an .ods spreadsheet in Calc and scrolled/flicked around, results:

  • 24.04.12.4: No issues with scrolling/flicking.
  • 24.04.13.3: Flicking around results in this issue.

I hope this narrows down where this bug/regression got introduced and that it can be fixed soon 🙏. This bug makes Collabora Calc near impossible to use on a smartphone.

siccovansas avatar Apr 16 '25 06:04 siccovansas

Just to add to the above comments. The issue also occurs in the Nextcloud integration app for Collabora. I guess that shares the same base used by the Android app.

marco-calautti avatar Apr 16 '25 06:04 marco-calautti

Same problem here, but also with the Writer app. It also works correctly if I do not lift my finger from the screen.

Configuration :

Nextcloud AIO 31.0.3 Collabora Online Development Edition 24.04.13.2 ded56d8ff7 Iphone 13 pro with IOS 17.4

Surfict avatar Apr 23 '25 22:04 Surfict

@Minion3665 ^^

jazevedo-coll avatar Apr 24 '25 13:04 jazevedo-coll

On web version we saw the same, but noticed if you use the scrollbars, instead of mouse scroll button/touchpad gestutr, it was a whole lot smoother.

DavyLandman avatar Apr 26 '25 17:04 DavyLandman

Same problem in mobile browser and both simple or complex sheets: Nextcloud AIO 31.0.3 Google Pixel 7 / Chrome Fully updated

In addtion, scollbars on chrome laptop : Laptop Chrome 135.0.7049.114 Using the horzontal or vertical scrollbar on a sheet seems to badly recalculate the scrollbar size many times ( or estimated sheet dimensions ) while dragging the scrollbars. The userinterface then stutters and hangs for seconds. Often leaving the scrollposition way off. Sometimes jumping hundreds of columns off desired destination.

Also: Maybe not related, but dragging a row to a new position just deletes the content of the row.

martinb14 avatar Apr 29 '25 12:04 martinb14

same here after updating the docker collabora image to collabora/code:24.04.13.3.1 After a rollback to image: collabora/code:24.04.12.1.1 ✅ it works again, so defenitely a regression. I didn't want to test every image so maybe a newer one will work just fine, too

e1ke avatar Apr 29 '25 22:04 e1ke

same here after updating the docker collabora image to collabora/code:24.04.13.3.1 After a rollback to image: collabora/code:24.04.12.1.1 ✅ it works again, so defenitely a regression. I didn't want to test every image so maybe a newer one will work just fine, too

I confirm that reverting to 24.04.12.1.1, things improve. The UI does not freeze anymore when scrolling on the mobile version. However, it is still not very smooth, and it clearly could perform better, but it is at least usable now.

marco-calautti avatar Apr 30 '25 06:04 marco-calautti

@Minion3665 any news about this? This bug has been around for quite some time.

marco-calautti avatar May 20 '25 05:05 marco-calautti

When this bug is beeing fixed, I highly recommend a solution where all or most of animations and css transitions are removed.

When working in a sheet, snappy simple consistent UX is super important and primary. No need at all for decorations, ornaments, shadows, raster effects, animations etc.

Everything points to a bug which is present in all browsers and apps. All downstream systems are affected, Can this please be prioritized?

martinb14 avatar May 20 '25 08:05 martinb14

I could reproduce the issue with Collabora online version 24.04.13.3 b7ba9a23ba accessing that from an Android phone (Android 14). Jump problems in both directions with a simple spreadsheet with just two columns and approx 10 lines.

martinwildam avatar May 23 '25 11:05 martinwildam

Some of the movement problems are likely from #11828 - particularly I'd expect some of the freezing shown in the video in https://github.com/CollaboraOnline/online/issues/11153#issuecomment-2740245582 to be fixed by https://github.com/CollaboraOnline/online/pull/11825 ... it looks like there might be something else here too... I agree that the scrolling back definitely makes the smooth scrolling suspect

Please may you try some of the newer releases and/or betas mentioned in that issue? In particular the most recent android snapshot, the iOS testflight and CODE release 25.04.2.1 should help with this...

...I'm not necessarily expecting them to fix everything, but I suspect they will fix some of your issues with touch movement - regardless, please let me know how you get on! Thanks!

Minion3665 avatar May 23 '25 11:05 Minion3665

Thanks @Minion3665 🙏!

I just installed collabora-office-mobile-25.04-snapshot-arm64-v8a-2025-05-25.apk and the issue is fixed for me! Scrolling/flicking around in an empty spreadsheet is smooth again and doesn't jump around the spreadsheet anymore.

siccovansas avatar May 26 '25 09:05 siccovansas

I just installed 25.4.202 (richdocumentscode) in Nextcloud and it fixes the issue. Also Collabora Office 25.04.1.1 on Android fixes the issue.

siccovansas avatar Jun 01 '25 14:06 siccovansas