public void Test53734() { XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("53734.xlsx"); XSSFHyperlink link = wb.GetSheetAt(0).GetRow(0).GetCell(0).Hyperlink as XSSFHyperlink; Assert.AreEqual("javascript:///", link.Address); wb = XSSFTestDataSamples.WriteOutAndReadBack(wb) as XSSFWorkbook; link = wb.GetSheetAt(0).GetRow(0).GetCell(0).Hyperlink as XSSFHyperlink; Assert.AreEqual("javascript:///", link.Address); }
public void Test53282() { //since limitation in .NET Uri class, it's impossible to accept uri like mailto:[email protected]%C2%A0 XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("53282.xlsx"); XSSFHyperlink link = wb.GetSheetAt(0).GetRow(0).GetCell(14).Hyperlink as XSSFHyperlink; Assert.AreEqual("mailto:[email protected]%C2%A0", link.Address); wb = XSSFTestDataSamples.WriteOutAndReadBack(wb) as XSSFWorkbook; link = wb.GetSheetAt(0).GetRow(0).GetCell(14).Hyperlink as XSSFHyperlink; Assert.AreEqual("mailto:[email protected]%C2%A0", link.Address); }
public void Test52716() { XSSFWorkbook wb1 = XSSFTestDataSamples.OpenSampleWorkbook("52716.xlsx"); XSSFSheet sh1 = wb1.GetSheetAt(0) as XSSFSheet; XSSFWorkbook wb2 = XSSFTestDataSamples.WriteOutAndReadBack(wb1) as XSSFWorkbook; XSSFSheet sh2 = wb2.GetSheetAt(0) as XSSFSheet; Assert.AreEqual(sh1.NumberOfComments, sh2.NumberOfComments); XSSFHyperlink l1 = sh1.GetHyperlink(0, 1); Assert.AreEqual(HyperlinkType.Document, l1.Type); Assert.AreEqual("B1", l1.GetCellRef()); Assert.AreEqual("Sort on Titel", l1.Tooltip); XSSFHyperlink l2 = sh2.GetHyperlink(0, 1); Assert.AreEqual(l1.Tooltip, l2.Tooltip); Assert.AreEqual(HyperlinkType.Document, l2.Type); Assert.AreEqual("B1", l2.GetCellRef()); }
public void TestCreate() { XSSFWorkbook workbook = new XSSFWorkbook(); XSSFSheet sheet = workbook.CreateSheet() as XSSFSheet; XSSFRow row = sheet.CreateRow(0) as XSSFRow; XSSFCreationHelper CreateHelper = workbook.GetCreationHelper() as XSSFCreationHelper; String[] urls = { "http://apache.org/", "www.apache.org", "/temp", "file:///c:/temp", "http://apache.org/default.php?s=isTramsformed&submit=Search&la=*&li=*" }; for (int i = 0; i < urls.Length; i++) { String s = urls[i]; XSSFHyperlink link = CreateHelper.CreateHyperlink(HyperlinkType.Url) as XSSFHyperlink; link.Address = (s); XSSFCell cell = row.CreateCell(i) as XSSFCell; cell.Hyperlink = (link); } workbook = XSSFTestDataSamples.WriteOutAndReadBack(workbook) as XSSFWorkbook; sheet = workbook.GetSheetAt(0) as XSSFSheet; PackageRelationshipCollection rels = sheet.GetPackagePart().Relationships; Assert.AreEqual(urls.Length, rels.Size); for (int i = 0; i < rels.Size; i++) { PackageRelationship rel = rels.GetRelationship(i); if (rel.TargetUri.IsAbsoluteUri && rel.TargetUri.IsFile) { Assert.AreEqual(urls[i].Replace("file:///", "").Replace("/", "\\"), rel.TargetUri.LocalPath); } else { // there should be a relationship for each URL Assert.AreEqual(urls[i], rel.TargetUri.ToString()); } } // Bugzilla 53041: Hyperlink relations are duplicated when saving XSSF file workbook = XSSFTestDataSamples.WriteOutAndReadBack(workbook) as XSSFWorkbook; sheet = workbook.GetSheetAt(0) as XSSFSheet; rels = sheet.GetPackagePart().Relationships; Assert.AreEqual(urls.Length, rels.Size); for (int i = 0; i < rels.Size; i++) { PackageRelationship rel = rels.GetRelationship(i); if (rel.TargetUri.IsAbsoluteUri && rel.TargetUri.IsFile) { Assert.AreEqual(urls[i].Replace("file:///", "").Replace("/", "\\"), rel.TargetUri.LocalPath); } else { // there should be a relationship for each URL Assert.AreEqual(urls[i], rel.TargetUri.ToString()); } } }