Bug 43410 - Formulas parsing issues...
Formulas parsing issues...
Status: RESOLVED FIXED
Product: POI
Classification: Unclassified
Component: HSSF
3.0-dev
Other other
: P2 normal (vote)
: ---
Assigned To: POI Developers List
:
Depends on:
Blocks:
  Show dependency tree
 
Reported: 2007-09-17 09:23 UTC by Pavel Krupets
Modified: 2007-09-18 04:59 UTC (History)
0 users



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

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