Nausherwan,
A belated thank you..!
I've tried again, but still am having problems. To replicate this:
a) Create a spreadsheet. Rename the first worksheet 'test', set the formula for A2 to '=A1', and set the conditional format for A2 to 'red if greater than 0'.
b) Run the following code:
Dim appExcel As New Aspose.Cells.Workbook
appExcel.LoadData(Server.MapPath("documents") & "\template\Test.xls")
Dim oWorksheet As Aspose.Cells.Worksheet
oWorksheet = appExcel.Worksheets("test")
oWorksheet.Cells(0, 0).PutValue(1)
appExcel.Save("test.xls", Aspose.Cells.SaveType.OpenInExcel, Aspose.Cells.FileFormatType.Default, Response)
When I run this, and examine the new spreadsheet, the cell A2 is not red (or even have any conditional formatting)
Am I doing something wrong here?
Cheers,
Steve