Opening and saving existing XLSM spreadsheet detaches macros from controls

I have an XLSM spreadsheet which contains form controls with macros attached. Opening this spreadsheet with NPOI and then saving it causes all macros to be detached from controls. I have to manuall...

Id #14081 | Release: None | Updated: Fri at 7:27 AM by mbrozdowski | Created: Fri at 7:15 AM by ZbigniewG

DOCX Header Picture

Hi, I recently updated my version to 2.2.1 and in this version picture i put in the Header corrupts the document. The same code worked without a problem until this version.

Id #14077 | Release: None | Updated: Mar 22 at 8:19 AM by mitch_gaby | Created: Mar 22 at 8:19 AM by mitch_gaby

Npoi Round Formula

Hi, I' have this round problem: the number 37803.49142 was being used in the Excel ROUND() function to 0dp. e.g. ROUND(37803.49142, 0) When executing this using the same workbook: Excel would eva...

Id #14073 | Release: None | Updated: Mar 7 at 8:43 AM by Didacus | Created: Mar 7 at 8:43 AM by Didacus

Excel Error-In the Excel File multiple Sheet with pivot Table ,Excel Write Issue

Hi All team / I have the following issue and I hope you can help / explain it to me. I Have one template of excel file ,in this excel file 1st sheet is pivot table and 2nd normal data sheet ,but ri...

Id #14062 | Release: None | Updated: Feb 22 at 4:51 AM by SuryakantThopate | Created: Feb 22 at 4:51 AM by SuryakantThopate

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: Mar 6 at 1:17 PM by Davideloper | Created: Jan 18 at 10: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 3:19 PM by Eshlomi | Created: Dec 27, 2016 at 3: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 10:20 PM by Zebrette | Created: Dec 9, 2016 at 10: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 9:50 AM by Andrey_pro | Created: Nov 20, 2016 at 9: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 6:05 AM by kenji_uno | Created: Nov 17, 2016 at 6: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 10:25 PM by Zebrette | Created: Nov 14, 2016 at 9:15 AM by obfusc8d