Android 26.04.3.1 cannot open password-protected XLSX files

[carmfar]

Android 26.04.3.1 cannot open password-protected XLSX files

Device: Samsung Galaxy Tab A8 (SM-X200)
Android: 14
Collabora Office: 26.04.3.1
Online git-hash: 20a46c332c
Core git-hash: 20a46c332c38

Steps to reproduce:

1. Create an ordinary XLSX spreadsheet.
2. Confirm that it opens normally in Collabora Office Android.
3. Password-protect the XLSX file.
4. Transfer the protected file to the Android tablet.
5. Open it in Collabora Office and enter the correct password.

Actual result:
Collabora displays “Loading document” briefly and then returns to the Recent Files screen. No error message is displayed.

Entering an intentionally incorrect password produces exactly the same behaviour.

Expected result:
The spreadsheet should open after entering the correct password. An incorrect password should produce an appropriate incorrect-password message.

Additional test:
The identical XLSX file opens normally in Collabora before password protection is added. After password protection is added, it no longer opens in Collabora.

If need be I am ready to forward a copy of the XLXS file and relative password.

[darshan]

Welcome to collabora online forum @carmfar

Thank you for the detailed report @carmfar

• Collabora Office 26.04.3 was published to Google Play today, see Collabora Office 26.04 Now Available on Android and iOS. Please confirm your app is the Play Store build (Settings > About
  should show 26.04.3.1) and retry once.

• If it still fails, please open an issue with [mobile] in the title at Issues · CollaboraOnline/online · GitHub, with the device, Android version, app version and the steps you wrote above. A similar report for a password-protected ODS is already at Problem with password-protected ODS files. · Issue #16186 · CollaboraOnline/online · GitHub, so please mention it there.

• Yes, the sample XLSX and password would help a lot. Attach them to the issue if they can be public. If not, say so in the issue and we will arrange a private channel.

• One quick check: does a password-protected ODS or DOCX also fail? That tells us whether it is the password handling or the XLSX format.

Thanks
Darshan

[carmfar]

thank you for your email.

[mobile] Android 26.04.3.1 cannot open password-protected XLSX files

Device: Samsung Galaxy Tab A8 (SM-X200)
Android: 14
Collabora Office: 26.04.3.1
Online git-hash: 20a46c332c
Core git-hash: 20a46c332c38

Steps to reproduce:

1. Create an ordinary XLSX spreadsheet.
2. Confirm that it opens normally in Collabora Office Android.
3. Password-protect the XLSX file.
4. Transfer the protected file to the Android tablet.
5. Open it in Collabora Office and enter the correct password.

Actual result:
Collabora displays “Loading document” briefly and then returns to the Recent Files screen. No error message is displayed.

Entering an intentionally incorrect password produces exactly the same behaviour.

Expected result:
The spreadsheet should open after entering the correct password. An incorrect password should produce an appropriate incorrect-password message.

Additional test:
The identical XLSX file opens normally in Collabora before password protection is added. After password protection is added, it no longer opens in Collabora. A passworded docx file did not open either, so the problem is with password handling.

password of the attached file is 123456789

(attachments)

Movie List.xlsx (20.5 KB)

[darshan]

Thanks @carmfar I’ve filed a GitHub issue for it as well: [mobile] Android 26.04.3.1 cannot open password-protected XLSX files · Issue #16209 · CollaboraOnline/online · GitHub

Will keep u posted on this

Thanks
Darshan