Summary: | Error in setFormula with VLOOKUP in 3.1-beta1 and 3.1-beta2 | ||
---|---|---|---|
Product: | POI | Reporter: | David <erudil> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | normal | ||
Priority: | P2 | ||
Version: | 3.0-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP |
Description
David
2008-05-17 13:12:17 UTC
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. |