XLSio Currency Format in cell

I am using XLSio but not able to set the format of cell to currency type as to display $4000
It just gives a "file Error: some number formats may have been lost"

Code:

sheet.Range("B3").NumberFormat = "Currency"
sheet.Range("B3").Number = 4000


The code file is also attached herewith as a .zip

code11.zip

2 Replies

SD Saurabh Dua November 17, 2006 06:40 AM UTC

Searched on the forum and found solution:

sheet.Range("B3").Number = 55250
sheet.Range("B3").NumberFormat = "$#,##0_);($#,##0)"

thanks anyways for making this forum


AD Administrator Syncfusion Team November 17, 2006 02:58 PM UTC

Hi Saurabh Dua

Thanks for your interest in XlsIO. Let has know if you have any difficulties in using XlsIO. We promise you a solution with in 24 hours.

With Regards
Chella.

Loader.
Up arrow icon