Bug 8687

Summary:	Formula Parser Chokes on Spaces
Product:	POI	Reporter:	Andy Oliver <poi-support>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	P3
Version:	2.0-dev
Target Milestone:	---
Hardware:	Other
OS:	other
Attachments:	Working test case

Description Andy Oliver 2002-05-01 01:50:02 UTC

FormulaParser currently throws an "Expected" if a " " is in between ()'s for
instance.

SUM( A1:A2 ) should be acceptable as should SUM(A1:A2) --  currently onlt the
latter is.  Basically any whitespace not in " " or ' ' should be ignored however
SUM(A 1:A2) should be illegal.

Excel can acutally preserve these spaces.  (we should try and do that )
Excel chokes on SUM (A1:A2) as I guess SUM( is the token and ) is the end tag.

Comment 1 Avik Sengupta 2002-05-01 19:35:28 UTC

The attached tests work for me. Please supply me with a failing testcase. 

Testing org.apache.poi.hssf.record.formula.FormulaParser
....
Time: 0.181

OK (4 tests)

Comment 2 Avik Sengupta 2002-05-01 19:36:56 UTC

Created attachment 1753 [details]
Working test case

Comment 3 Andy Oliver 2002-05-02 04:30:20 UTC

do AVERAGE( A1:A2 ) or SUM( A1:A2 ) with no other elements and it chokes.

Comment 4 Avik Sengupta 2002-05-02 12:53:25 UTC

I've commited the test for formula parser with the case you suggest. Can u pls 
run it and tell me the results??

Comment 5 Avik Sengupta 2002-05-13 16:20:00 UTC

No testcases show aberrant behaviour. Setting to fixed, reopen with a failing 
testcase.