You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
using var fs=new FileStream(@"C:\Users\DELL\Desktop\fund.xlsx", FileMode.Open,FileAccess.ReadWrite,FileShare.None); IWorkbook wb = new XSSFWorkbook(fs); var sht = wb.GetSheet("2-银行存款盘点表"); sht.GetRow(0).GetCell(11).SetCellValue(DateTime.Today.ToShortDateString()); using var fs1= new FileStream(@"C:\Users\DELL\Desktop\fund.xlsx", FileMode.Create, FileAccess.ReadWrite, FileShare.None); wb.Write(fs1); wb.Close();
Issue Description
When I execute the above code, I just change the date of one cell,the formulas in the purple cells in the chart will disappear and the cells will be numeric.
The text was updated successfully, but these errors were encountered:
I should have upgraded the NPOI version. Can I only use version 2.6.2 now?
Yes, if 2.6.2 works for you, you have to. The regression will be fixed in 2.7.1. But the release date is still TBD. Usually, it takes 3-4 month to release a new version since this is not a commercial project. The contributors are using their spare time to work on it.
NPOI Version
2.7.0
File Type
Upload the Excel File
fund.xlsx
Reproduce Steps
using var fs=new FileStream(@"C:\Users\DELL\Desktop\fund.xlsx", FileMode.Open,FileAccess.ReadWrite,FileShare.None); IWorkbook wb = new XSSFWorkbook(fs); var sht = wb.GetSheet("2-银行存款盘点表"); sht.GetRow(0).GetCell(11).SetCellValue(DateTime.Today.ToShortDateString()); using var fs1= new FileStream(@"C:\Users\DELL\Desktop\fund.xlsx", FileMode.Create, FileAccess.ReadWrite, FileShare.None); wb.Write(fs1); wb.Close();
Issue Description
When I execute the above code, I just change the date of one cell,the formulas in the purple cells in the chart will disappear and the cells will be numeric.
The text was updated successfully, but these errors were encountered: