|Summary:||FormulaParser cannot handle "http://" inside a string literal|
|Product:||POI||Reporter:||Avik Sengupta <avik>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
Description Avik Sengupta 2003-09-11 06:34:49 UTC
Mail from feely dot jp at pg dot com >I think I have run into a bug when using a Hyperlink formula. > > My code is simply trying to insert a hyperlink into a cell, calling the > setCellFormula on a cell I have created: > > cell.setCellFormula( "HYPERLINK( \"http://jakarta.apache.org\", \"Jakarta\" )" > ); > > This always gets a Runtime Exception in the FormulaParser. > > However, if you call > cell.setCellFormula( "HYPERLINK( \"jakarta\", \"Jakarta\" )" ); > then it works (but does not give the desired results). > > It appears to me that the FormulaParser treats BOTH the : and . characters as > meaningful and won't allow an http:// string to be passed through.
Comment 1 Avik Sengupta 2003-09-23 18:44:16 UTC
This works fine on 2.0 BRANCH. I have added two testcases as proof. HEAD is hosed, but for different reasons. TestBugs.test23094() and TestFormulaParser.testEmbeddedSlash()
Comment 2 Avik Sengupta 2003-09-23 18:49:29 UTC
Actually, to clarify, the above testcases run fine on HEAD.. but other testcases are hosed.