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

Free Support Forum - aspose.com

Formatting Corrupted When using DeleteRow or DeleteRows

See attached template. When I execute the following code:


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(6)
ws.Cells.DeleteRow(6)
wb.Save(ms, SaveFormat.Xlsm)

Response.BinaryWrite(ms.ToArray())
Response.End()

Column “R” (labelled “General Conditions Value”) turns black. Note - this does not happen when I manually delete a row or rows in excel. The same happens if I use the DeleteRows method, and the number of rows deleted seems to have no effect. Note - Worksheets(6) refers to the tab labelled “6-E2 Depreciation Analysis”.

Hi,

Thanks for the template xlsm file.

I have reproduced the issue as you have mentioned using your sample code.

I have logged your issue into our issue tracking system with an id: CELLSNET-20248. We will figure it out soon.
Thank you.

Hi,

Please try the attached version. We have fixed the issue now.

Thank you.

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


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.