Shape of the comment box changes to a giant Curved Arrow

As mentioned in some java posts, comment boxes are changing shape by themselves when saving XLSX. Here is one bugzilla link: https://bz.apache.org/bugzilla/show_bug.cgi?id=55410 And MS link: https:...

Id #14045 | Release: None | Updated: Jan 18 at 11:25 AM by Davideloper | Created: Jan 18 at 11:24 AM by Davideloper

Append a cell / raw to saved/existing xls file

Hi Team /All. I'm new to NPOI, I had started today and I must say well done !. I have the following issue and I hope you can help / explain it to me. I would like to write 10 different cells to a...

Id #14025 | Release: None | Updated: Dec 27, 2016 at 4:19 PM by Eshlomi | Created: Dec 27, 2016 at 4:19 PM by Eshlomi

DataValidation Explicit Values Extra Quotes

When setting data validation to an explicit list in excel, say 1 and 2, NPOI reads the datavalidation formula enclosed in an extra double quotes: ""1,2"" instead of "1,2", resulting in the Explicit...

Id #14021 | Release: None | Updated: Dec 9, 2016 at 11:20 PM by Zebrette | Created: Dec 9, 2016 at 11:20 PM by Zebrette

FillForegroundColor is slow

I have a template and after filling it with values I set a background color but for a small file (about 6000 rows) it takes about 4 minutes. Without setting background color it takes only 8 seconds...

Id #14016 | Release: None | Updated: Nov 20, 2016 at 10:50 AM by Andrey_pro | Created: Nov 20, 2016 at 10:48 AM by Andrey_pro

Table1[Data1] can be resolved?

Hi. Sheet sample: |Data1|Data2|Data3| |-----|-----|-----| | 1| 2| 3| | 4| 5| 6| | 7| 8| 9| Name Data1 is represented as Table1[Data1]. I can get actual cell range =Shee...

Id #14014 | Release: None | Updated: Nov 17, 2016 at 7:05 AM by kenji_uno | Created: Nov 17, 2016 at 7:02 AM by kenji_uno

NPOI.XSSF - SetAutoFilter results in missing/unreadable xml in XLSX

Getting warning: "We found a problem with some content in 'SimpleReport '. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes." when opening sav...

Id #14012 | Release: None | Updated: Dec 9, 2016 at 11:25 PM by Zebrette | Created: Nov 14, 2016 at 10:15 AM by obfusc8d

NPOI.HSSF AutoFilter Issue: "File error: data may have been lost"

Getting "File error: data may have been lost" when opening saved Excel after setting auto-filter. Example files attached. Attempt to add data filter over all columns of Excel file using HSSFWorkb...

Id #14011 | Release: None | Updated: Dec 9, 2016 at 11:27 PM by Zebrette | Created: Nov 14, 2016 at 10:09 AM by obfusc8d

The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is it really an excel file?

I am using NPOI to process data in Excel 2003 (xls) file. This is my code if (excelFormat.Equals(Constants.XLS_EXCEL_FORMAT)) { using (FileStream file = new FileStream(filePath, FileMode.Open, ...

Id #13997 | Release: None | Updated: Oct 18, 2016 at 5:17 AM by tungsomot | Created: Oct 18, 2016 at 5:17 AM by tungsomot

EvaluateAllFormulaCells error

Im' using the version 2.3.1 and when I call the HSSFFormulaEvaluator.EvaluateAllFormulaCells I get error: Unexpected eval class (MissingArgEval) in NPOI.HSSF.UserModel.HSSFFormulaEvaluator.Eval...

Id #13992 | Release: None | Updated: Oct 7, 2016 at 10:06 AM by mictenu | Created: Oct 7, 2016 at 10:06 AM by mictenu

RecordFormatException: Unable to construct record instance

Getting this error while accessing the Password Protected Excel file.. Inner Exception: {"Unknown encryption info 4"}. Adding the code I have used to process this.. FileStream fil...

Id #13988 | Release: None | Updated: Sep 26, 2016 at 1:34 PM by PrabhatYarlagadda | Created: Sep 26, 2016 at 1:34 PM by PrabhatYarlagadda