Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 312118 - JBook function getText returns #N/A if there is a wildcard character in formula
Summary: JBook function getText returns #N/A if there is a wildcard character in formula
Status: RESOLVED INVALID
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Birt-ReportEngine-inbox@eclipse.org CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-05-07 15:30 EDT by stewani CLA
Modified: 2010-05-10 03:18 EDT (History)
1 user (show)

See Also:

Attachments
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 stewani CLA 2010-05-07 15:30:23 EDT 
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.
Comment 1 Wei Yan CLA 2010-05-10 03:18:14 EDT 
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.