Bug 43410

Summary: Formulas parsing issues...
Product: POI Reporter: Pavel Krupets <pkrupets>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: Other   
OS: other   
Attachments: patch for FormulaParser.java file
patch for TestFormulaParser.java file
new version of source files

Description Pavel Krupets 2007-09-17 09:23:10 UTC
Hello,

In Excel one can enter .1 instead of 0.1 and A1.A2 or A1..A2 or A1...A2  instead
of A1:A2.

1st one is easy to fix. 2nd one is more tricky (formula parser should be changed).
Comment 1 Nick Burch 2007-09-17 09:28:31 UTC
Any chance you could do a patch to implement these alternate formula syntax styles?
Comment 2 Pavel Krupets 2007-09-17 09:29:56 UTC
ok.
Comment 3 Pavel Krupets 2007-09-17 12:19:40 UTC
Created attachment 20835 [details]
patch for FormulaParser.java file
Comment 4 Pavel Krupets 2007-09-17 12:20:04 UTC
Created attachment 20836 [details]
patch for TestFormulaParser.java file
Comment 5 Pavel Krupets 2007-09-17 12:20:57 UTC
Created attachment 20837 [details]
new version of source files
Comment 6 Pavel Krupets 2007-09-17 12:22:03 UTC
- Added support for .1 style numbers
- Added support for 1E+1 style numbers
- Added support for . or .. or ... range separators (used instead of semicolon)
Comment 7 Nick Burch 2007-09-18 04:59:21 UTC
Thanks for these patches, I've applied them