npoi
npoi copied to clipboard
nissl-lab
a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
When Evaluating formula `=IF(ISREF(INDIRECT(Investment.DepositPensionSchemes.1.BankName)),Investment.DepositPensionSchemes.1.BankName,"")` `Indirect.EvaluateIndirect` takes the String value of the cell, and tries to find the DynamicReference of the Value instead of the Name. Gets an object reference error...
At first, I use attached sheet ("Before.png").  The point is that string "Test" in line 13 and out of printing area. (Last row break position is in line 11.)...
Can I replace text in docx without changing the format? Can I read the checkbox style in docx?
**Issue** The min-width and max-width for XSSFDataBarFormatting seems to default to 10% filled for min and 90% filled for max and using the WidthMin and WidthMax properties does not seem...
### NPOI Version 2.7.0 ### File Type - [ ] XLSX ### Upload the Excel File [fund.xlsx](https://github.com/nissl-lab/npoi/files/15374420/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);...
This is a pull request for fixing #1260 for discussion on this change. (resolves #1260) In short there are two changes: 1. When writing CT_Text to XML \n is replaced...
Fixes https://github.com/AdamWhiteHat/BigDecimal/issues/45
Adding rows of data into existing xlsx file with pivot tables and charts result with unusable file.
### Discussed in https://github.com/nissl-lab/npoi/discussions/1292 Originally posted by **rafinewman** March 13, 2024 hi, i have designed am excel file XLSX with a table of data in sheet1 and pivot table ,...
