After editing calc sheet in iPad Collabora, it opens in Windows Libre at 200%

User Support
1

I use Libre Office on Windows. Just got a new iPad Pro 12.9, and happened across Collabora. The calc documents live in iCloud, accessible on both. If I edit one in Collabora, it gets saved looking the same size as it opened. But when I next open it in Libre, it opens with the zoom slider at 200%. And showing cell A1 instead of the last line where I just entered new data.

Not a huge problem, but a repeating hassle… I have no idea what might be getting changed to cause this. The Windows machine uses Microsoft screen scaling at 200%, but Libre deals with that properly. The iPad uses extra large type, but again I’ve never seen that affect any other app.

There must be some bit of data in the file that Libre and Collabora interpret differently. Is this the right place to explore that? Should I report it as a bug?

2

Hi Loren, it sounds like a bug and you can reproduce it too, I think it would be very helpful if you reported it. I might try to reproduce it tomorrow, if I can reproduce it I will add a comment to your bug report, i.e. it is reproducible on other devices and not a configuration issue on your setup, have a great weekend, Rob

3

I tried an experiment, using Libre Calc in Arch Linux instead of Windows. Found exactly the same behaviour. Save a sheet in Libre, it reopens in Libre at the bottom row with the last chosen zoom setting. Open it in Collabora, on iPhone or iPad, and it opens at row 1, at a normal zoom. Save and re-open in Collabora and it looks exactly the same. Re-open it in Libre, in Linux or Windows, and it opens at row 1 at 200% zoom.

Surprisingly, this is not a problem for Excel, at least my 2016 version that refuses to authorize any more. It opens the Collabora file at 100% zoom.

For the test file, the Libre save is 9,884 bytes, Collabora save is 7,220 bytes. For a larger file, 370 lines with two columns, the difference is 48,925 bytes to 27,913 bytes! The re-save in Libre takes it back to 49K bytes

Peeking at a diff of the two files, the Libre save begins with “PK … a?ST?l9?.” and has 34 instances of “ST”. The Collabora save begins with "PK … “QT?l9?.” and has 34 instances of “QT”. Does “QT” refer to QT5? Might that matter?

The majority of the content lines show differences… Far beyond my ability to guess what they mean.

Just opened a bug:

1 Like
4

Welcome @LorenAmelang and thanks for testing and reporting it ! Will check this

5

Hi Loren, fyi this bug was discussed at the weekly meeting Collabora Online Weekly Meeting #61

6

Any news on that? The bug is now known for nearly a year and is still present in the latest version 23.05.6.5 of Nextcloud Office based on CODE. Did any developer at least check this issue? It seems nobody is working on that at all.

7

Hey @LorenAmelang + @awelzel ,

Thanks for bumping this topic.

I did bring this up a few weeks ago during the Collabora Community Weekly meeting.

And, just today, I was talking to a Collabora developer + randomly made him aware of this zoom issue. (He seemed very interested!) :slight_smile:

Edit: Looks like he posted his findings:

Good news too, Calc is going to be a major focus for the next major version of Collabora Online, so many devs will be adding new features + digging through the Calc/spreadsheet backlog. :slight_smile:

(As always, see the Github for the latest changes. But now that I’m aware of issue 4250… when it gets fixed/squished, I’ll repost info here.)