Description
Read and complete the full issue template
Do not randomly delete sections. They are here for a reason.
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
0.104.999.3773
Version of OpenXml
3.1.0
What is the current behavior?
I have a workbook with multiple sheet containing formulas.
My goal is to edit the workbook to replace the formulas of the sheet by their calculated values and then delete the intermediary sheet which i dont need.
When i try to read the CachedValue of a cell, it return me blank (whereas there is value computed when open the workbook with excel)
When i try to read the value of a cell, it take a lot of time finish with this Exception "The method or operation is not implemented.'"
When i try to call RecalculateAllFormulas on the sheet, it take so much time i stop after one hour
What is the expected behavior or new feature?
have the correct Value computed in the CachedValue property of the cell
Is this a regression from the previous version?
no, it was the same with 0.102 version and OpenXml 2.20 (i just migrate when i see this error, i check with old version and i had the same errors)
Reproducibility
- checkout the project https://github.com/julienGrd/ConsoleAppTestClosedXml
- copy the xlsx file StatdcK4-Trame_CAMSP_2023_VF_avec_fonctions-ORiGiNAL.xlsx which is at the root of the project in bin/debug/net8 folder
- run the app and wait it finish
- open bin/debug/net8/StatdcK4-Trame_CAMSP_2023_VF_avec_fonctions-ORiGiNAL_clean.xlsx, compare the Enfants_accompagnes_AGR sheet with the one of the original file, you will see the values are not reported
For the investigation, take care that many sheets are hidden in the workbook thats why you don't see them in excel
- I attached a sample spreadsheet. (You can drag files on to this issue)