Formula openxml gets corrupted after opened and saved by NPOI 2.7.0 about npoi HOT 12 CLOSED

@Bykiev
This issue does not occur in 2.6.2. It only occurs in 2.7.0.

from npoi.

template.xlsx
@tonyqus
Hi, maybe you can try this template, sheet3 have "SUM" formula.

from npoi.

Fixed in #1291

from npoi.

@Bykiev Why do you believe this issue is fixed by #1291? I don't see the clues.

from npoi.

@Quark321 Without the original Excel file, it's very hard to figure out what the issue is.

from npoi.

@Bykiev Why do you believe this issue is fixed by #1291? I don't see the clues.

The issue is not reproduced in 2.6.2 and the same /xl/calcChain.xml corruption occured. 100% sure it's a shared formula bug, which was fixed. I believe we should release a patch version ASAP.

from npoi.

@Quark321 Without the original Excel file, it's very hard to figure out what the issue is.

Hi Tony,

Unfortunately I can't share the file as macros and data are IP of the company. To be honest I am not a familiar with the OpenXML format but if you navigate me to the required xml nodes within the excel file, I can review those and share only affected fragments.

from npoi.

We are encountering the same issue.
We set "SUM(A1:A2)" at position A3, "SUM(B1:B2)" at position B3, and "SUM(C1:C2)" at position C3 in sheet 3, and use it as a template.
Then, we use NPOI to write data to sheet1 and sheet2, instead of sheet 3. The exported Excel file ends up having a corrupted /xl/calcChain.xml. Additionally, the formula in the C3 column of sheet 3 is lost.

from npoi.

Can you guys reproduce this issue with 2.6.2?

from npoi.

Can you please check with main branch?

from npoi.

I think it can be a regression bug. But I need an original Excel to help reproduce this and figure out what's changed.

from npoi.

This regression is caused by a change in #913 fix

from npoi.