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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

8.4.0.10. xlsio cellstyle issue

Thread ID:

Created:

Updated:

Platform:

Replies:

97555 Dec 9,2010 08:12 AM UTC Dec 10,2010 04:21 AM UTC ASP.NET Web Forms (Classic) 4
loading
Tags: XlsIO
miki
Asked On December 9, 2010 08:12 AM UTC

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

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()

wb.SaveAs("d:\SyncTest.xlsx")
wb.Close()

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?



SyncTest_fbe5991.zip

miki
Replied On December 9, 2010 08:59 AM UTC

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?



Sample_ab26c197.zip

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

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.

Regards,
Zakeer Ahamed.S



miki
Replied On December 9, 2010 11:05 AM UTC


Zakeer Ahmed S [Syncfusion]
Replied On December 10, 2010 04:21 AM UTC

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.

Regards,
Zakeer Ahamed. S



CONFIRMATION

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.

Warning Icon 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.Close Icon

;