Bug with Open XML SDK - Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)
- Dominant language
- C#
- Stars
- 4.6k
- Forks
- 605
- PR merge metrics
- No merged PRs in 30d
Description
**Describe the bug**
We are getting the "Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)" while opening Excel. I have used DocumentFormat.OpenXml Nugget package in C#. The template Excel (.xlsm) is Macro Enabled one. We are collecting the data from Microstation OPM (Bentley software) dgn and writing the data to .MDB and then picking up the data from MDB and writing to Excel using DocumentFormat.OpenXml Nugget package.
**Screenshots**
**To Reproduce**
I can show the issue. The Excel formulas looks fine, we checked them using the Formulas tab in Excel.
Steps to reproduce the behavior:
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error
**Observed behavior**
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)
**Expected behavior**
Excel should open with out any error
**Desktop (please complete the following information):**
- OS: Windows 10 Pro 21H2 64-bit operating system, x64-based processor
- Office version: Office 365 (16.0.16501.20228)
- .NET Target: .NET Framework 4.6.2
- DocumentFormat.OpenXml Version: v2.20.0
**Additional context**
Client is chasing me to fix the issue and any help is appreciated.
Contributor guide
Assessment
This issue has not been assessed yet.