I'm using the following code on the attached file and no borders are being changed:

Dim lo As New LoadOptions(LoadFormat.Auto)

Dim wb As New Workbook("d:\code\NationalParks\Output\1\template.xlsm")

Response.Clear()

Response.AddHeader("Content-Type", "application/vnd.ms-excel; charset=windows-1251")

Response.AddHeader("content-disposition", "attachment; filename=""" & "priority.xlsm" & """")

Dim ms As New IO.MemoryStream

Dim ws As Aspose.Cells.Worksheet = wb.Worksheets(5)

Dim s As Aspose.Cells.Style = ws.Cells("C6").GetStyle

s.Borders.SetColor(System.Drawing.Color.Aquamarine)

s.Borders.SetStyle(CellBorderType.Thick)

ws.Cells("C6").SetStyle(s)

wb.Save(ms, SaveFormat.Xlsm)

Response.BinaryWrite(ms.ToArray())

Response.End()

 

This issue seems to go beyond just borders...none of the styles I attempt to set seem to take...background color, etc, etc.

Hi Christopher,

We are able to reproduce the issue. The issue has been logged into our issue Tracking System with ID CELLSNET-19764. We will update you as soon as possible.

Thanks,

---

Sincere Regards,

Salman Shakeel
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

Please try the attached version. We have fixed your mentioned issue.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

The issues you have found earlier (filed as 19764) have been fixed in this update.

---

This message was posted using Notification2Forum from Downloads module by aspose.notifier.