Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Calc (Android) modifies an existing formula in .xlsx file #10930

Open
Leonovana opened this issue Jan 14, 2025 · 2 comments
Open

Calc (Android) modifies an existing formula in .xlsx file #10930

Leonovana opened this issue Jan 14, 2025 · 2 comments
Labels
24.04 bug Something isn't working

Comments

@Leonovana
Copy link

Describe the Bug

In a file, created with MS Excel 365, there are a number of formulas in the columns R, S, T, U, W, X, Y, Z and AA. All formulas work perfectly in Excel. If I open this file in CollaboraOffice for Android and enter new values anywhere in columns C - F, H - K or M - P, the formulas in columns W, X, Y, Z and AA are changed to a matrix formula from row 4 onwards. The next time I open it in Excel, these formulas no longer work and the status #VALUE! is displayed in Excel. It does not matter whether sheet protection is switched on or not.

Steps to Reproduce

  1. Open file in CollaboraOffice for Android
  2. Click on e.g. cell C6 and enter 9:00 as a time value
  3. Click on e.g. cell D6 and enter 130 as a numerous value
  4. Click on e.g. cell E6 and enter 80 as a numerous value
  5. Click on e.g. cell F6 and enter 60 as a numerous value
  6. Save and close the file
  7. Open the file in Excel
  8. Check the values of the rows W - AA

Expected Behavior

All formulas should work as expected and show the calculated results if at least one set of values is given in the columns C - F, H - K or M - P of the same row.

Actual Behavior

All formulas in columns W - AA are converted into matrix formulas, i.e. the complete formula in each cell is placed in curly brackets { formula }.

Screenshots

correct_Excel_view
Excel_view_after_edited_with_CollaboraOffice(Android)

Desktop

(Please complete the following information)

  • Excel version: [365]
  • OS and version: [Windows 11]

Smartphone

(Please complete the following information)

  • Device: [Motorola G7 power]
  • OS: [Android 13]
  • Collabora version: [24.04.9.2]

Additional Context

Add any other context about the problem here.

@Leonovana
Copy link
Author

The modification is done on all sheets in the file, even on them where no new values are entered.
Please find attached a demo file.
Excel-Bug_Demo.xlsx

@Ezinnem
Copy link
Member

Ezinnem commented Jan 14, 2025

I can confirm using the sample file

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
24.04 bug Something isn't working
Projects
Status: No status
Development

No branches or pull requests

3 participants