Hi All,
When creating or editing a document in collabora and saving it all is fine. However when I open this document in office Excel it always opens up with 240% zoom instead of just 100%
Is this a bug? Only happens with documents edited with collabora.
1 Like
rpear
August 1, 2022, 12:50pm
2
Hi ckruijntjens, I believe this is a known issue, something to do with how high resolution screens are managed. I read about it here in the forums or on github, I can’t find it now. Is your screen 4K / very high resolution?
Hi,
Yes it’s high resolution.
bearon
August 18, 2022, 10:28am
4
Yes, the issue is tracked here:
opened 11:26PM - 20 Feb 22 UTC
bug
**Describe the bug**
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.
**To Reproduce**
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.
**Expected behavior**
After editing a file in Collabora, it should re-open in Libre at the previously chosen zoom, normally 100%. And at the last viewed row of the sheet.
**Actual behavior**
Collabora saved sheets re-open in Libre at 200% zoom. And do not preserve the last viewed row location...
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.
**Screenshots**
Test files:
[Collabora Test Libre save.ods](https://github.com/CollaboraOnline/online/files/8105133/Collabora.Test.Libre.save.ods)
[Collabora Test Collab save.ods](https://github.com/CollaboraOnline/online/files/8105134/Collabora.Test.Collab.save.ods)
**Desktop (please complete the following information)**
- OS: [e.g. iOS] Windows 10, or current Arch Linux
- Browser: [e.g. chrome, safari] (not involved)
- Version: [e.g. 22]
**Smartphone (please complete the following information)**
- Device: [e.g. iPhone6] iPhone SE2020 or iPad Pro 12.9 5gen
- OS: [e.g. iOS8.1] iOS 14, 15
- Browser: [e.g. stock browser, safari] (not involved)
- Version: [e.g. 22]
**Additional context**
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.
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.
Is there some way to make this friendlier?
Any news on that?
The issue is now open for nearly a year and it does not seem that anyone is working on that. Also the latest version 23.05.6.5 of Nextcloud Office is still affected by this bug. Did any developer at least check that problem?