# After editing calc sheet in iPad Collabora, it opens in Windows Libre at 200% **URL:** \ **Category:** User Support\ **Created:** [February 17, 2022, 5:33am UTC](https://forum.collaboraonline.com/t/after-editing-calc-sheet-in-ipad-collabora-it-opens-in-windows-libre-at-200/888 "2022-02-17T05:33:41Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![LorenAmelang](https://avatars.discourse-cdn.com/v4/letter/l/3bc359/32.png) [@LorenAmelang](https://forum.collaboraonline.com/u/LorenAmelang)\ **Post date:** [February 17, 2022, 5:33am UTC](https://forum.collaboraonline.com/t/after-editing-calc-sheet-in-ipad-collabora-it-opens-in-windows-libre-at-200/888/1 "2022-02-17T05:33:41Z")
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? ---
**Author:** ![rpear](https://avatars.discourse-cdn.com/v4/letter/r/b5ac83/32.png) [@rpear](https://forum.collaboraonline.com/u/rpear)\ **Post date:** [February 19, 2022, 1:02pm UTC](https://forum.collaboraonline.com/t/after-editing-calc-sheet-in-ipad-collabora-it-opens-in-windows-libre-at-200/888/2 "2022-02-19T13:02:11Z")
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 ---
**Author:** ![LorenAmelang](https://avatars.discourse-cdn.com/v4/letter/l/3bc359/32.png) [@LorenAmelang](https://forum.collaboraonline.com/u/LorenAmelang)\ **Post date:** [February 20, 2022, 11:35pm UTC](https://forum.collaboraonline.com/t/after-editing-calc-sheet-in-ipad-collabora-it-opens-in-windows-libre-at-200/888/3 "2022-02-20T23:35:26Z")
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: > > > \*\*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? ---
**Author:** ![pedro.silva](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/pedro.silva/32/4_2.png) [@pedro.silva](https://forum.collaboraonline.com/u/pedro.silva)\ **Post date:** [February 21, 2022, 2:12pm UTC](https://forum.collaboraonline.com/t/after-editing-calc-sheet-in-ipad-collabora-it-opens-in-windows-libre-at-200/888/4 "2022-02-21T14:12:23Z")
Welcome @LorenAmelang and thanks for testing and reporting it ! Will check this ---
**Author:** ![rpear](https://avatars.discourse-cdn.com/v4/letter/r/b5ac83/32.png) [@rpear](https://forum.collaboraonline.com/u/rpear)\ **Post date:** [February 24, 2022, 12:12pm UTC](https://forum.collaboraonline.com/t/after-editing-calc-sheet-in-ipad-collabora-it-opens-in-windows-libre-at-200/888/5 "2022-02-24T12:12:47Z")
Hi Loren, fyi this bug was discussed at the weekly meeting [Collabora Online Weekly Meeting #61](https://forum.collaboraonline.com/t/collabora-online-weekly-meeting-61/909) ---
**Author:** ![awelzel](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/awelzel/32/997_2.png) [@awelzel](https://forum.collaboraonline.com/u/awelzel)\ **Post date:** [January 11, 2024, 7:57am UTC](https://forum.collaboraonline.com/t/after-editing-calc-sheet-in-ipad-collabora-it-opens-in-windows-libre-at-200/888/6 "2024-01-11T07:57:56Z")
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. ---
**Author:** ![Tex](https://avatars.discourse-cdn.com/v4/letter/t/eb8c5e/32.png) [@Tex](https://forum.collaboraonline.com/u/Tex)\ **Post date:** [February 4, 2024, 7:53am UTC](https://forum.collaboraonline.com/t/after-editing-calc-sheet-in-ipad-collabora-it-opens-in-windows-libre-at-200/888/7 "2024-02-04T07:53:11Z")
Hey @LorenAmelang + @awelzel , Thanks for bumping this topic. > [@awelzel](#): > > Did any developer at least check this issue? It seems nobody is working on that at all. 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!) 🙂 **Edit:** Looks like he posted his findings: - [Collabora Calc save re-opens in Libre at 200% zoom · Issue #4250 · CollaboraOnline/online · GitHub](https://github.com/CollaboraOnline/online/issues/4250#issuecomment-1925680690) * * * 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. 🙂 * * * (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.)