We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Unable to change borders on cells

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,

Hi,

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

Thank you.

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.