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

Free Support Forum - aspose.com

Save Error

Our application creates a SpreadsheetML file and then uses Cells to convert that to Excel:

Aspose.Cells.License lic = new Aspose.Cells.License();
lic.SetLicense(“Aspose.Cells.lic”);

Aspose.Cells.Workbook e = new Aspose.Cells.Workbook();
e.Open(tmpXmlFile, Aspose.Cells.FileFormatType.SpreadsheetML);

System.IO.Stream resultStm = new MemoryStream();
e.Save(resultStm, Aspose.Cells.FileFormatType.Excel2000);

I have a cell in the spreadsheet that used to be just a hyperlink to a cell in another workbook. I need to change it to be a formula and a hyperlink (the formula would not display the text for the hyperlink if the other workbook doesn’t exist). When I do this, it errors on the formula. If I remove the hyperlink, the formula works fine. If I remove the formula, the hyperlink works fine. The two together error.

The XML for that cell is:

<ss:Row ss:Index=“8” ss:AutoFitHeight=“1”>
<ss:Cell ss:Index=“2”
ss:Formula="=IF(ISERROR(‘Tab 2’!RC[-1]),"",“Go To Tab 2”)"
ss:HRef="#‘Tab 2’!A12">
<ss:Data ss:Type=“String”></ss:Data>

</ss:Cell></ss:Row>

Please help. =)
-Bre

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Could you provide us the SpreadsheetML file that can reproduce the error? We will check it soon.

Thank you.