We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again. xlsio cellstyle issue

Thread ID:





97555 Dec 9,2010 03:12 AM Dec 9,2010 11:21 PM ASP.NET Web Forms (Classic) 4
Tags: XlsIO
Asked On December 9, 2010 03:12 AM

Hi everyone.
I'd like to ask a question about cell styles in

i generated attached document using following code:

Dim x As New ExcelEngine
Dim app As IApplication = x.Excel
Dim wb As IWorkbook = app.Workbooks.Create(1)
wb.Version = ExcelVersion.Excel97to2003
Dim sheet As IWorksheet = wb.Worksheets(0)
Dim xlst As IStyle

xlst = wb.Styles.Add("TestStyle")
xlst.WrapText = True
xlst.Color = Color.AntiqueWhite
xlst.HorizontalAlignment = ExcelHAlign.HAlignCenter
xlst.VerticalAlignment = ExcelVAlign.VAlignCenter
xlst.Borders.LineStyle = ExcelLineStyle.Thin
xlst.Borders(ExcelBordersIndex.DiagonalDown).ShowDiagonalLine = False
xlst.Borders(ExcelBordersIndex.DiagonalUp).ShowDiagonalLine = False
xlst.Font.FontName = "Tahoma"
xlst.NumberFormat = "dd.MM.yy hh:mm"

sheet.Range(1, 1).CellStyle = xlst
sheet.Range(1, 1).Value = DateTime.Now
sheet.Range(1, 1).AutofitColumns()


The problem is that now cell A1 cannot be formated by user when file is opened in Excel (tried opening attached file in 2010 and 2003, failing both times).
On the other hand, if i create Excel2010 file, cells with style applied can be formatted by user.

Any ideas what am i doing wrong?


Replied On December 9, 2010 03:59 AM

attached document is built from documentation (Format_Cells_2010 project) and "Antony Jose" cell cannot be formatted by user.

Am i missing something here or is this a bug?


Zakeer Ahmed S [Syncfusion]
Replied On December 9, 2010 05:14 AM

Hi Miki,

Thanks for using Syncfusion products.

We were able to reproduce the reported issue at our side and we suspect this could be a defect. Could you please open a direct trac and create an incident for further updates on this issue.

Please let us know if you have any clarifications.

Zakeer Ahamed.S

Replied On December 9, 2010 06:05 AM

Zakeer Ahmed S [Syncfusion]
Replied On December 9, 2010 11:21 PM

Hi Miki,

Thanks for the update.

Could you please follow the incident(75091) for further updates regarding this issue.

Please let us know if you have any clarifications.

Zakeer Ahamed. S


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.