Bug 43410 - Formulas parsing issues...
Summary: Formulas parsing issues...
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: Other other
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2007-09-17 09:23 UTC by Pavel Krupets
Modified: 2007-09-18 04:59 UTC (History)
0 users

patch for FormulaParser.java file (4.88 KB, patch)
2007-09-17 12:19 UTC, Pavel Krupets
Details | Diff
patch for TestFormulaParser.java file (2.01 KB, patch)
2007-09-17 12:20 UTC, Pavel Krupets
Details | Diff
new version of source files (12.46 KB, application/octet-stream)
2007-09-17 12:20 UTC, Pavel Krupets

Note You need to log in before you can comment on or make changes to this bug.
Description Pavel Krupets 2007-09-17 09:23:10 UTC

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
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