Bug 44609 - [patch] Initial space in formula breaks FormulaParser.toFormulaString()
[patch] Initial space in formula breaks FormulaParser.toFormulaString()
Status: RESOLVED FIXED
Product: POI
Classification: Unclassified
Component: HSSF
unspecified
All All
: P2 normal (vote)
: ---
Assigned To: POI Developers List
:
Depends on:
Blocks:
  Show dependency tree
 
Reported: 2008-03-14 14:47 UTC by Josh Micich
Modified: 2008-03-16 08:46 UTC (History)
0 users



Attachments
svn diff of 3 changed files (11.00 KB, text/plain)
2008-03-14 14:49 UTC, Josh Micich
Details

Note You need to log in before you can comment on or make changes to this bug.
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