Bugzilla – Full Text Bug Listing
| Summary: | JBook function getText returns #N/A if there is a wildcard character in formula | ||
|---|---|---|---|
| Product: | z_Archived | Reporter: | stewani |
| Component: | BIRT | Assignee: | Birt-ReportEngine-inbox <Birt-ReportEngine-inbox> |
| Status: | RESOLVED INVALID | QA Contact: | |
| Severity: | normal | ||
| Priority: | P3 | CC: | wyan |
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
| Whiteboard: | |||
It seems to be the issue of Actuate commerical product. Please report the issue to http://www.birt-exchange.org/bug-reporting/ or contact the Actuate support. |
Build Identifier: 3.2.0 I am using e.spreadsheet java swing API to read excel spreadsheet content. JBook.getText(row, col) reads correct values from excel sheet except when there is a formula with wildcard. I have fx=VLOOKUP("*"&A26&"*",'Sheet 3'!$A$2:$B$100,2,FALSE) to look up anything with *&A26&* in sheet 3 in the specified range. Excel evaluates it to the correct value, but when using getText function I get #N/A. Is there a bug in getText function or does API does not support wildcards? Reproducible: Always Steps to Reproduce: 1.Create a spreasheet with multiple spreadsheet. 2.Add formula fx=VLOOKUP("*"&A2&"*",'Sheet 3'!$A$2:$B$100,2,FALSE) to a cell B2 in sheet 1 3.enter some value eg. none in cell A2 of sheet 1 4. Create a table in Sheet 3. Insert some text in column A with "none" in it eg. MG1none356 in cell A2, FGRnone 456 in cell A3 5. Insert some numbers in column B eg 3 in B2 and 5 in B3. 6. Use e.spreadsheet API to get the JBook. Call function getText(B, 2)in Sheet 7. This should return 3.