Bug 23094

Summary: FormulaParser cannot handle "http://" inside a string literal
Product: POI Reporter: Avik Sengupta <avik>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: normal    
Priority: P3    
Version: 2.0-pre3   
Target Milestone: ---   
Hardware: Other   
OS: other   

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.