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

Infinite loop of FormulaErrorException while saving a loaded file #2341

Open
3 of 6 tasks
swenp76 opened this issue May 16, 2024 · 0 comments
Open
3 of 6 tasks

Infinite loop of FormulaErrorException while saving a loaded file #2341

swenp76 opened this issue May 16, 2024 · 0 comments

Comments

@swenp76
Copy link

swenp76 commented May 16, 2024

Do you want to request a feature or report a bug?

  • Bug
  • Feature
  • Question

Did you test against the latest CI build?

  • Yes
  • No

If you answered No, please test with the latest development build first.

Version of ClosedXML

all versions starting with 0.100.0

What is the current behavior?

Opening and just saving of the attached Excel file ends in an infinite loop of exceptions: "ClosedXML.Excel.CalcEngine.Exceptions.FormulaErrorException" in ClosedXML.dll

I read the release notes an migration guide for 0.100.0 and noticed that there are some changes regarding the error/exception handling.

What is the expected behavior or new feature?

Up to an including 0.97.0 the file can be saved. However there are also exceptions:
"ClosedXML.Excel.CalcEngine.Exceptions.NameNotRecognizedException"
"System.NotImplementedException"
"System.ArgumentException"

Is this a regression from the previous version?
no

Reproducibility

It is reproducable by changing version from <= 0.97.0 to something >= 0.100.0

Code to reproduce problem:

public void Main()
{
  var workbook = new ClosedXML.Excel.XLWorkbook("RMI_CMRT_6.4.xlsx");
  workbook.SaveAs("out.xlsx");
  workbook.Dispose();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant