[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 Dominik Stadler changed: What|Removed |Added CC||diptesh2...@gmail.com --- Comment #12 from Dominik Stadler --- *** Bug 57669 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #11 from Dominik Stadler --- I found a way to support reading this file, see r1896552. -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 --- Comment #11 from canzar...@gmail.com --- I also face similar issue loading a file from https://andwebtraffic.org Not sure what really causes the issue. Thanks -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 --- Comment #10 from Antonio Casueps --- Tested with 4.1.1 just in case, still fails -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 Antonio Casueps changed: What|Removed |Added CC||casu...@hotmail.com -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 ithan changed: What|Removed |Added CC|ithanr...@gmail.com | -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 ithan changed: What|Removed |Added CC||ithanr...@gmail.com -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 ithan changed: What|Removed |Added CC|ithanr...@gmail.com | -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 Dominik Stadler dominik.stad...@gmx.at changed: What|Removed |Added Depends on||50426, 53984 --- Comment #9 from Dominik Stadler dominik.stad...@gmx.at --- Seems to be caused by slightly corrupted Excel files, see bug 50426 and bug 53984 for similar issues where we could work around the problem somehow, although in this case it does not seem to be that easy as a simple fix similar to the previous bugs does not make it work... -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 Dominik Stadler dominik.stad...@gmx.at changed: What|Removed |Added Blocks||57669 --- Comment #8 from Dominik Stadler dominik.stad...@gmx.at --- This is similar to the error reported in bug 57669 -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://bz.apache.org/bugzilla/show_bug.cgi?id=52447 Dominik Stadler dominik.stad...@gmx.at changed: What|Removed |Added OS||All -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447 Deepesh Ramrakhyani deepesh...@gmail.com changed: What|Removed |Added CC||deepesh...@gmail.com OS|Mac System 7|Windows 7 -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447 Deepesh Ramrakhyani deepesh...@gmail.com changed: What|Removed |Added OS||All -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447 Deepesh Ramrakhyani deepesh...@gmail.com changed: What|Removed |Added OS|All |Windows 7 -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447 Deepesh Ramrakhyani deepesh...@gmail.com changed: What|Removed |Added Priority|P2 |P1 Version|3.8 |3.10 OS|All |Mac System 7 Severity|major |critical --- Comment #7 from Deepesh Ramrakhyani deepesh...@gmail.com --- Hi, I am currently facing the similar kind of issue will loading a file from this link: https://www.jse.co.za/_layouts/15/DownloadHandler.ashx?FileName=/Safex/All%20Contract%20Details.xls. If I open the file and enable editing,it size becomes almost double and it loads properly.But due to some restriction i cant done these changes in code. Thanks and Regards, Deepesh Ramrakhyani. -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447 --- Comment #5 from andrey 404er...@gmail.com --- Created attachment 29400 -- https://issues.apache.org/bugzilla/attachment.cgi?id=29400action=edit file with hyperlink that repro's the exception -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447
andrey 404er...@gmail.com changed:
What|Removed |Added
Status|NEEDINFO|NEW
Version|3.8-dev |3.8
OS|Windows Vista |Windows 7
--- Comment #6 from andrey 404er...@gmail.com ---
Hello, I am getting the same exception with Apache POI 3.8 and the file
attached.
Exception:
java.lang.RuntimeException: Unexpected record type
(org.apache.poi.hssf.record.HyperlinkRecord)
at
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.init(RowRecordsAggregate.java:107)
at org.apache.poi.hssf.model.InternalSheet.init(InternalSheet.java:208)
at
org.apache.poi.hssf.model.InternalSheet.createSheet(InternalSheet.java:163)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:296)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:248)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:192)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:327)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:308)
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:70)
at comMiscUnitTests.testExcelReader(MiscUnitTests.java:693)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
at
com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:76)
at
com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:195)
at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:63)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:120)
Unit test:
@Test
public void testExcelReader() throws IOException, InvalidFormatException
{
InputStream stream = null;
try
{
stream =
this.getClass().getResourceAsStream(/sample_with_hyperlinks.xls);
WorkbookFactory.create(stream);
} finally
{
stream.close();
}
}
I have not been able to create a simpler file that produces the exception.
Thanks in advance.
--
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447 --- Comment #4 from Nick Burch nick.bu...@alfresco.com 2012-01-13 11:03:26 UTC --- You could maybe go at it with a Hex Editor - you should be able to search for the hyperlink URL and text (assuming neither use accented or non-English characters they'll show up normally). Then, change those in the hex editor to something dummy but with the same size, and finally check in Excel that it can still open the files and sees the dummy text instead -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447 --- Comment #3 from Dave S. david.st...@windstream.com 2012-01-12 16:16:15 UTC --- I tried manually creating each hyperlink separately in a reduced form of the target spreadsheet, and POI was able to operate on it successfully. I don't know exactly what the process is upstream; the developer generating the Excel file I receive may be doing something when creating her hyperlinks that POI doesn't like. I'd attach the spreadsheet, but it contains business data that probably shouldn't be shared. If there was a quick way to change the URLs in the hyperlinks without messing with whatever structure they're currently in, that would be sufficient to remove sensitive data and share the workbook. Thanks! -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447 Nick Burch nick.bu...@alfresco.com changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #2 from Nick Burch nick.bu...@alfresco.com 2012-01-11 15:07:17 UTC --- Any chance you could supply the problem file? It looks like POI thinks the hyperlink applies to several rows, which isn't currently supported. We'll need the file to investigate why that is (to see the options on the hyperlink records, where they live in your file etc) -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447
--- Comment #1 from Dave S. david.st...@windstream.com 2012-01-10 22:47:42
UTC ---
This is the code I'm using to attempt to open the workbook:
public ExcelFileWrapper(String filename, Timestamp endDate) {
this.filename = filename;
this.endDate = endDate;
final File f = new File(filename);
try {
excelFile = WorkbookFactory.create(f);
} catch (Exception e) {
log.error(Could not open Excel workbook for updating., e);
}
}
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 52447] Unable to Open Excel XLS with hyperlink cells.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52447 Dave S. david.st...@windstream.com changed: What|Removed |Added CC||david.st...@windstream.com -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
