xls conversion problems with formulas - Githubissues

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.

https://www.onlyoffice.com

GNU Affero General Public License v3.0

4.48k stars 1.04k forks source link

xls conversion problems with formulas #2702

Open silversword411 opened 1 month ago

silversword411 commented 1 month ago

This issue is unique.

[X] I have used the search tool and did not find an issue describing my bug.

Operating System

Windows 10 / 8.1 / 7

Version information

8.0.1.31

Expected Behavior

xls cell references are changing from things like IY3+IZ3... See attached spreadsheet. Black columns are data entry, red are calculated fields.

Actual Behavior

Excel shows different than onlyoffice.

2024-04-10_153545 - editors_04_Monthly_Totals_APRIL_2024cleaned xls_-_ONLYOFFI

2024-04-10_153809 - EXCEL_04_Monthly_Totals_APRIL_2024cleaned xls__ Compatib

04 Monthly Totals APRIL 2024cleaned.xls

Reproduction Steps

No response

Additional information

No response

rsnegirev commented 1 month ago

Hi @silversword411

I can confirm, this is the bug number 67544. When some fixes will be done I'll text you here in this issue.

And we're moving this issue to DocumentServer repo, since it's our base product and problem actual there too.

Thank you for the report!

rsnegirev commented 1 month ago

Hi @silversword411

The bug was fixed in this commits: https://github.com/ONLYOFFICE/core/commit/af226ceb67e347a8690f5cdd073b0763a3a348f4, https://github.com/ONLYOFFICE/core/commit/7f791ad265e06d8cd1c52e4522a19f778fee2c75

Fixes will be released in the next major version.