Comments (12)
@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.
Related Issues (20)
- fixed "Cannot add more than 65535 shapes" HOT 10
- fixed AutoFilter record size with multibyte strings. HOT 1
- fixed System.ArgumentException: 'Invalid CellReference: 'Sheet1' HOT 2
- Validation cannot handle double quote
- fixed System.InvalidOperationException: 'The hyperlink for cell A1 references relation rId1, but that didn't exist!'
- CICD script doesn't update the version number of the nuget package after updating to 2.7.1
- NPOI setting a new workbook ThemesTable copied from another workbook ThemesTable does nothing HOT 1
- ExcelToHtmlConverter dont assign class to tr tag
- GitHub: Missing release info/changelog for 2.7.1 HOT 3
- CreateColumn return System.ArgumentOutOfRangeException: Index was out of range
- The backport of POI Bug 60370 introduces a bug with PromptBox and ErrorBox text encoding HOT 1
- ByteArrayOutputStream is not disposed in NPOI.Util.IOUtils.ToByteArray method. Potential Memory leak HOT 2
- Reading Docs With DesignType,throw POIXMLException Error
- Wrong picture size in merged cell after picture.Resize() was invoked.
- Security vulnerabilities in SixLabors.ImageSharp HOT 4
- XSSFWorkbook write issue
- Remove picture...
- npoi-examples not available HOT 4
- 安装了最新版的库,处理同样多的数据,变慢了一半! HOT 4
- Inconsistent new lines in worksheets
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from npoi.