ntombela / excellibrary

Automatically exported from code.google.com/p/excellibrary
0 stars 0 forks source link

Empty cell custom format problem #112

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?

1.  ***This code is excellibrary example***
    //create new xls file
    string file = "C:\\newdoc.xls";
    Workbook workbook = new Workbook();
    Worksheet worksheet = new Worksheet("First Sheet");
    worksheet.Cells[0, 1] = new Cell((short)1);
    worksheet.Cells[2, 0] = new Cell(9999999);
    worksheet.Cells[3, 3] = new Cell((decimal)3.45);
    worksheet.Cells[2, 2] = new Cell("Text string");
    worksheet.Cells[2, 4] = new Cell("Second string");
    worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00");
    worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD");
    worksheet.Cells.ColumnWidth[0, 1] = 3000;
    workbook.Worksheets.Add(worksheet);
    workbook.Save(file);

2.  My problem all empty cell format " custom gg.aaa.yy " Please look 
attachments picture

3.  I want all empty cell format general, How to fix ? Best Regards

What is the expected output? What do you see instead?
I want empty cells format "General"

What version of the product are you using? On what operating system?
Microsoft Windows XP Service Pack 3

Please provide any additional information below.

Original issue reported on code.google.com by lolfacto...@gmail.com on 26 Oct 2011 at 10:30

Attachments:

GoogleCodeExporter commented 8 years ago
Yes. I have this problem too. 

Original comment by mkon...@gmail.com on 1 Dec 2011 at 12:23