WeekDay Function Uses Monday=1 Instead of Sunday=1

Excel default weekday start is Sunday=1 but NPOI uses Date.DayOfWeek() which follows ISO with Monday=1. The value displayed in excel hence is not the same as the value given by NPOI once the workbo...

Id #14114 | Release: None | Updated: Jun 29 at 11:07 AM by Zebrette | Created: Jun 29 at 11:07 AM by Zebrette

Document with links corrupted

MSO write that document corrupted and remove hyperlinks from /xl/worksheets/sheet1.xml LibreOffice 5.2.5.1 open document fine and links work but after resaving links missed too. Document sample att...

Id #14102 | Release: None | Updated: May 12 at 10:37 AM by quazi_node | Created: May 12 at 9:10 AM by quazi_node

Could not install package

Could not install package 'NPOI 2.3.0'. You are trying to install this package into a project that targets '.NETPortable,Version=v4.5,Profile=Profile78', but the package does not contain any assemb...

Id #14097 | Release: None | Updated: May 9 at 5:35 PM by ponchautf | Created: May 4 at 3:47 PM by amalroshand

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: Mar 24 at 7:27 AM by mbrozdowski | Created: Mar 24 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