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,
Could you provide us the SpreadsheetML file that can reproduce the error? We will check it soon.
Thank you.