https://bugs.documentfoundation.org/show_bug.cgi?id=151999
Bug ID: 151999
Summary: Unable to use the function to intercept correct
related data from another worksheet.
Product: LibreOffice
Version: 7.4.1.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: 1q842662...@gmail.com
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()),"")
--
You are receiving this mail because:
You are the assignee for the bug.
