This project is read-only.

Dont work xlsx for russian windows regional settings

Feb 24, 2014 at 1:53 PM
Edited Feb 25, 2014 at 4:55 AM
Dont work xlsx for russian windows regional settings
Probably blame decimal separator
You must use XmlConvert before recording a numerical value

You create an invalid xml
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<worksheet xmlns="" xmlns:r="">
   <dimension ref="A1"></dimension>
      <sheetView tabSelected="1" showRuler="1" showOutlineSymbols="1" defaultGridColor="1" colorId="64" zoomScale="100" workbookViewId="0"></sheetView>
   <sheetFormatPr defaultRowHeight="15"></sheetFormatPr>
   <pageMargins left="0,7" right="0,7" top="0,75" bottom="0,75" header="0,3" footer="0,3"></pageMargins>
Mar 6, 2014 at 12:40 PM
this is fixed in the most recent code on github.

The last issue I found was in SetCellValue in the XSSF namespace
        public void SetCellValue(double value)
                _cell.t = (ST_CellType.n);
                // fixed for any culture
                _cell.v = (value.ToString(CultureInfo.InvariantCulture));
Using the current NPOI code + this fix your XML files should always be generated correctly.
Mar 9, 2014 at 8:16 PM
which version are you using? I need to track the issue impact
Mar 10, 2014 at 7:10 AM
Mar 13, 2014 at 9:10 PM
try the latest github source code and let me know if it's fixed.
Mar 15, 2014 at 3:22 PM
Hi, sorry my english

Workbook created OK
I try write decimal value- error <v>1,5</v>

IWorkbook workbook = new XSSFWorkbook();
ISheet sheet = workbook.CreateSheet("Sheet1");
FileStream sw = File.Create("test.xlsx");

<?xml version="1.0"?>
<worksheet xmlns:r="" xmlns="">
<dimension ref="A1" />
<sheetView tabSelected="true" workbookViewId="0" />
<sheetFormatPr defaultRowHeight="15" />
<row r="2">
<c r="B2">
<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3" />

2014-03-14 0:10 GMT+04:00 tonyqus <[email removed]>:

From: tonyqus

try the latest github source code and let me know if it's fixed.

Read the full discussion online.

To add a post to this discussion, reply to this email ([email removed])

To start a new discussion for this project, email [email removed]

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at