Bug 35027

Summary: FormulaParser cannot parse cross sheet references with underscores
Product: POI Reporter: Tobias Haubner <tobias.haubner>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: Other   
OS: other   

Description Tobias Haubner 2005-05-23 19:21:27 UTC
Excel allows cross sheet references with underscores without having to escape
the sheet name: e.g: =Cash_Flow!A1
POI's FormulaParser however cannot handle such references because an underscore
is not a character letter and isAlpha(char c) returns false.

Solution could be to change the method isAlpha(char c) in
org.apache.poi.hssf.model.FormulaParser from

return Character.isLetter(c) || c == '$';


return Character.isLetter(c) || c == '$' || c == '_';
Comment 1 Avik Sengupta 2005-05-31 21:13:15 UTC
Fixed, thanks Tobias. 

Please verify.