[libreoffice-users] LibreOffice Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function

Anomaly discovered in *versions 4.2.8 and 4.4.6* -
VLOOKUP function

Good morning,
.

LibreOfficeCalc use on a package of administration that contains many
features that interact with Pivot Tables

A very used is VLOOKUP.
The package works very well and there are no problems on the LO version
4.0.6
both Windows and Linux (Ubuntu 12.04 LTS, 4.14 32bit or 64bit).
In this version of the function's result it is right.

THE versions 4.2.8 and 4.4.6 the VLOOKUP function from incorrect result.

In particular, in the spreadsheet attached "PROVA SU VERS 446 -
CONTABILMENTE":

- In Sheet "Registro Mastri' function is in cell B4:
= VLOOKUP (+ B6; PianocontiCE.$A$3.$B$1060;2)

the function result is # N / A

correct resultate is: "CONTO TRANSITORIO PAGHE LL.DD."

I checked several times.
The function syntax is correct.
The reference of the search range is correct;
The search key is correct;
The index of the data result is correct.

My interpretation is that in later versions to 4.0.6 LO does not recognize
the data contained in a PivotTable
(Ie the value of Cod. C / R in the example = 3359)
This might be so?

I kindly ask the technicians LO to verify that this bug is really very
important because it undermines the proper functioning of the package
(which is distributed free to download).

I look forward to answers.

Best regards.

Michele Ras

-- 

http://contabilmenteag.wix.com/contabilmenteag-net
contabilmenteAG.net@gmail.com
contabilmenteAG@hotmail.it
Ras Michele Perito Agrario
Salita S.Barnaba 24d/18 16136 Genova Ge
Tel./Fax.:  010 213059
Tel.Mobile:3201107102

**** Riservatezza / Confidentiality **** In ottemperanza al D.Lgs. n. 196
del 30/6/2003 in materia di protezione dei dati personali, le informazioni
contenute in questo messaggio sono strettamente riservate ed esclusivamente
indirizzate al destinatario indicato (oppure alla persona responsabile di
rimetterlo al destinatario). Vogliate tener presente che qualsiasi uso,
riproduzione o divulgazione di questo messaggio è vietato. Nel caso in cui
aveste ricevuto questo messaggio per errore, vogliate cortesemente
avvertire il mittente e distruggere il presente messaggio.
According to Italian law D.Lgs. 196/2003 concerning privacy, if you are not
the addressee (or responsible for delivery of the message to such person)
you are hereby notified that any disclosure, reproduction, distribution or
other dissemination or use of this communication is strictly prohibited

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted