This project has moved. For the latest updates, please go here.

NumberFormat, Danish currency and XML problems

Feb 3, 2012 at 7:59 AM

I am trying to format the contents of a cell into Danish currency. According to the styles.xml in the xlsx file, the argument to NumberFormat should be

""kr."\ #,##0.00"

When I save my xlsx file, the corresponding value in the styles.xlsx file is

""kr."\ #,##0.00"

I know that the & is not allowed as a value in XML, but I don't think it should be escaped when already used as part of escaping the quotes.

How can I format a number into Danish currency and is the escaping a bug in EPPlus?

Feb 3, 2012 at 8:07 AM

OK, I guess that I shouldn't escape the quotes my self:

@"""kr.""\ #,##0.00"

I guess I just needed to post to realize :)