Bug 151998

Description:
Describe:
I used "Calc" to design a form for purchase, and I wanted to directly intercept the corresponding cell data in the form from the database in another worksheet through a function, but unexpected problems occurred; In the purchase form, each column always only displays the first column of data in the database, and some purchase form columns cannot even capture any data.
In other columns in the purchase form, the intercepted data are almost all repeated, and the content is incorrect.

Steps to Reproduce:
1.
I first designed a "form for purchase" (Worksheet 1), which contains: product name, barcode data, price, manufacturer name...

2.
Add one more "New Worksheet" (Worksheet 2). And began to make all the relevant information of manufacturers, products, product barcodes, prices, telephone numbers, etc. in the "New Worksheet" (Worksheet 2), through the design of the form, into a data form related to the product.

3.
I convert the pre-designed product code numbers in the "New Worksheet" (Worksheet 2) into a barcode through a legally downloaded barcode font (Libre Barcode 128 Text), and in the other fields that follow, Enter information on other types of related products in order.

4.
Then go back to the "form for purchase" (Worksheet 1), and in the specified cell, want to use the function:
=IF($E12="","",VLOOKUP($E12,$Vendor FDatabase.$D$11:$BA$1200,3,FALSE()))
I want to retrieve the product name through the barcode data in the "New Worksheet" (Worksheet 2), and transfer the data back to the "form for purchase" (Worksheet 1).

Actual Results:
5.
It is found that no matter in the "form for purchase"(Worksheet 1), entering the barcode of any other product in a specific cell, or trying to retrieve the correct product name from other product information, the correct product name cannot be correctly retrieved.
In the specified search cell, "Form for Receipt" can always display only the first column of product name data in "New Worksheet" (Worksheet 2).

6.
Attempt to capture and display the product name from other columns in the "Form for Purchase" (Worksheet 1), but almost all of the data returned from the other columns below only display "New" The first column of product name data in the "New Worksheet" (Worksheet 2), the second column and other subsequent horizontal column data cannot be displayed for unknown reasons.

Expected Results:
According to the original design, it should be from the specified cell in the "form for purchase" (Worksheet 1), after inputting the barcode number, the "New Worksheet" (Worksheet 2) can be smoothly entered.  In each product-related data field, return other cell data associated with the specified product to the "form for purchase" (Worksheet 1).
Can achieve product data query, and can automatically return relevant data to other fields on the surface.


Reproducible: Couldn't Reproduce


User Profile Reset: Yes

Additional Info:
I've also tried using another related function, but it's also weird, the cells are not fetching any data at all.
Here is another function I use =IFERROR(VLOOKUP($E15,$Vendor FDatabase.$D$11:$BA$1200,3,FALSE()),"")