[Libreoffice-bugs] [Bug 106523] CALC discrepancies and gaps

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=106523

--- Comment #12 from gmarco <gmmellina at inwind.it> ---
(In reply to QA Administrators from comment #11)
> ** Please read this message in its entirety before responding **
> 
Update (LO 5.4.5.1)
Regarding the attachments "CALC-inf ..." NOTHING changed
Regarding the attachments "CALC-spreads ..." all text appears now in IT but the
help informations are still inadequate and lacking in examples.
For example: about the formula "= SEARCH (0.8,A2:A4;C2:C4) getting #N/A"
exemplified in the "examples for CERCA (LOOKUP)" attached on 2017-03-13 the
result #N/A is not documented!
Another example (new attachments CERCA (IT).JPG and CERCA (EN).JPG): the
proposition "If LOOKUP can not find the search criterion, it matches the
largest value in the search vector that is less than or equal to the search
criterion" is incorrect and, in the IT version, even incomprehensible because
the subject is missing ("Se CERCA non può trovare il criterio di ricerca,
corrisponde al valore più grande nel vettore di ricerca, il quale è inferiore o
uguale al criterio di ricerca"); the correct diction should be "Se CERCA ....,
il risultato corrisponde al valore inferiore più grande nel vettore di ricerca"
and in EN "... that is less than to the search criterion".

The reason is elementary:
who/what "corrisponde"?  certainly "il risultato"; 
why "inferiore o uguale" (EN "less than or equal to" if the assumption is that
"can not find"?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180315/8c9e7b14/attachment-0001.html>