You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/05/23 09:06:33 UTC
DO NOT REPLY [Bug 45025] Error in setFormula with VLOOKUP in 3.
1-beta1 and 3.1-beta2
https://issues.apache.org/bugzilla/show_bug.cgi?id=45025
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #1 from Josh Micich <jo...@gildedtree.com> 2008-05-23 00:06:33 PST ---
The main problem is use of semicolons (;) for argument separators when POI
expects commas (,). (Similar to first part of bug 45041). I guess if comma is
used as a decimal separator, something else is required to delimit arguments.
For the moment, all POI can do is present a better error message.
Internationalization would require a big effort.
I added a fix for this in svn r659455. Now POI will give a message like:
Parse error near char 13 ';' in specified formula 'VLOOKUP("123";'Tarifas venta
personal'!$D$12:$E$30;2;false)'. Expected ',' or ')'
After changing the semicolons to commas, POI seems to output a spreadsheet with
a well encoded VLOOKUP formula.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org