Bug 44609

Summary: [patch] Initial space in formula breaks FormulaParser.toFormulaString()
Product: POI Reporter: Josh Micich <josh>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: All   
OS: All   
Attachments: svn diff of 3 changed files

Description Josh Micich 2008-03-14 14:47:20 UTC
HSSFCell.getCellFormula() throws IllegalStateException when invoked on a cell with a formula that has a leading space. (e.g. "= 4")

Note - HSSFCell.setCellFormula(String) strips spaces, so that method will not show this bug.  The bug can easily be observed using spreadsheets created by Excel.
Comment 1 Josh Micich 2008-03-14 14:49:40 UTC
Created attachment 21671 [details]
svn diff of 3 changed files
Comment 2 Nick Burch 2008-03-16 08:46:42 UTC
Thanks for this Josh, applied to svn trunk