Bug?: Relative Hyperlinks in TM1 Websheets

image2x · Post by **image2x** » Mon Jan 18, 2010 7:00 pm

I ran into this today and would like someone else to confirm as a universal bug. Running 9.4.1. HF16 on Windows Server 2003. ClearType loaded on IIS.

Websheets with hyperlinks (inserted with Excel) that are relative (i.e. /path/to/file.html instead of http://server.com/path/to/file.html) cause an immediate Operation Failure response when accessed. This is logged on the server:

System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Applix.TM1.Web.WebControls.Websheet.TM1WebHyperLink.setCellRowColIndex(String rangeStr)
at Applix.TM1.Web.WebControls.Websheet.TM1WebHyperLink.ResolveSheetReference(String SheetRefStr)
at Applix.TM1.Web.WebControls.Websheet.TM1WebHyperLink.set_HRef(String value)
at Applix.TM1.Web.WebControls.Websheet.TM1WebSheet.ReadXmlNodeTable(XmlNode tabNd, Hashtable styles)
at Applix.TM1.Web.WebControls.Websheet.TM1WebSheet.ReadXmlNodeWorksheet(XmlNode nd, Hashtable styles)
at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.LoadExcelData()
at Applix.TM1.Web.WebControls.Websheet.TM1WebBook.Initialize()
at Applix.TM1.Web.WebControls.Websheet.TM1WebBookCollection.Open(String FileName, objectType type, String publishUrl)