Unable to change borders on cells

Aspose.Cells Product Family
1

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

2

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

3

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,

4

Hi,

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

Thank you.

5

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.