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

No referenced cell's number format becomes 'Percentage'.

Apr 23, 2014 at 9:20 AM
Hi,

I ran the below code with updating my template workbook by EPPlus 4.0 Beta 2.

Then, I opened the saved workbook by excel 2010 , its cell format became 'Percentage' by all entire columns except updated column 'A' ,referenced column 'E' and having non-default width columns .
Dim exp As New ExcelPackage(fi)  'open my Template workbook
Dim wb As ExcelWorkbook = exp.Workbook
Dim sh1 = wb.Worksheets(1)

Console.WriteLine("Check Formula before update: {0}", sh1.Cells(1, 5).Style.Numberformat.Format) 'Reference columns 'E'

sh1.Cells(1, 1).Value = Now ' Update column 'A'

fis = New System.IO.FileInfo("NewPath")
exp.SaveAs(fis)
It does not occurs using workbook created newly by Excel 2010 .
So , I would like to upload my template file . But I could not find the way.