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

OnlyOffice spreadsheet throws an invalid circular reference error #3095

Open
1 task done
Git-GT opened this issue Jan 4, 2025 · 1 comment
Open
1 task done

OnlyOffice spreadsheet throws an invalid circular reference error #3095

Git-GT opened this issue Jan 4, 2025 · 1 comment
Labels
confirmed-bug Issues with confirmed bugs

Comments

@Git-GT
Copy link

Git-GT commented Jan 4, 2025

This issue is unique.

  • 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.2.2.22 (x64 exe)

Expected Behavior

I expect the document to be opened without any issue.

Actual Behavior

When I open my xlsx file OnlyOffice shows me a warning "There are one or more circular references where a formula refers to its own cell either directly or indirectly..."
After the popup the calculation of the spreadsheet is not performed.

Reproduction Steps

I have a complex xlsx, but I managed to extract the formulas that produce the issue in this sheet:
Test.xlsx
There are just two formulas on the cells B2 and B3 and none of them has a circular reference

Additional information

No response

@Dmitry-Kov
Copy link

Hello @Git-GT,

I created bug 72610 for your problem.
When some fixes will be done we'll text you here in this issue.
Thank you for the report!

Problem can be reproduced in DocumentServer.

@Rita-Bubnova Rita-Bubnova added the confirmed-bug Issues with confirmed bugs label Jan 21, 2025
@Rita-Bubnova Rita-Bubnova transferred this issue from ONLYOFFICE/DesktopEditors Jan 21, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
confirmed-bug Issues with confirmed bugs
Projects
None yet
Development

No branches or pull requests

3 participants