Bug 43410 - Formulas parsing issues...
Summary: Formulas parsing issues...
Status: RESOLVED FIXED
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
URL:
Keywords:
Depends on:
Blocks:
 
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
View All Add an attachment (proposed patch, testcase, etc.)

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