[Libreoffice-bugs] [Bug 106803] CALC - other cases of incorrect help
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Wed Nov 28 18:57:48 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=106803
--- Comment #30 from gmarco <gmmellina at inwind.it> ---
Preamble: the html guide needs some revisions, as an example initially in Index
appears WRITER, how to look for CALC? actually that is possible only forwarding
page-to-page.
1) attachment 132177 CALC-arrot about "ARROTONDA.ECCESSO"
https://help.libreoffice.org/Calc/Mathematical_Functions/it#ARROTONDA.ECCESSO
it is still same: some text is still in English
2) attachment 132178 CALC-cerca about "CERCA"
https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#CERCA
it is still same: some text is still in English
3) attachment 132179 CALC-cercaO about "CERCA.ORIZZ"
https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#CERCA.ORIZZ
it is still same: "Sintassi" is still in English
4) attachment 132180 CALC-cercaV about "CERCA.VERT"
https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#CERCA.VERT
it is still same: "Sintassi" is still in English
5) attachments 132181-132182 CALC-gcd-mcd-mcm-lcm
https://help.libreoffice.org/Calc/Mathematical_Functions/it
it is still same:
about 35 GCD_EXCEL2003: invalid function
about 38 LCM_EXCEL2003: invalid function
38.1 Sintassi
38.2 Esempio
38.3 Sintassi it refers to COMBINAZIONE(Numero 1; Numero 2)
38.4 Esempio idem
38.5 Sintassi it refers to COMBINAZIONE(Numero 1; Numero 2)
38.6 Esempio idem
6) attachments 132183-132184 CALC-indir1-CALC-indir2 about "INDIRIZZO"
https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#INDIRIZZO
it is still same: the English word "notation" is in excess and the text is
confused:
"In caso di notazione R1C1 notation, la funzione INDIRIZZO restituisce ..."
and "La funzione INDIRETTO viene salvata senza conversione nel formato ODF
1.0/1.1"
and in the example the reference is to another function:
"Se la cella A1 nella tabella 2 contiene il valore -6, con la funzione in B2
potete fare riferimento indirettamente alla relativa cella, digitando in una
formula =ASSOLUTO(INDIRETTO(B2))....
7) attachment 132185 CALC-indir3 about "INDIRETTO"
https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#INDIRETTO
it is still same: the English word "notation" is in excess and the text is
confused:
"In caso di notazione R1C1 notation, la funzione INDIRIZZO restituisce ... e
INDIRETTO attende ..."
and "Quando aprite documenti dal formato ODF 1.0/1.1, le funzioni INDIRIZZO che
..."
and "Nel memorizzare un documento nel formato ODF 1.0/1.1, se le funzioni
INDIRIZZO prevedono ..."
8) attachments 132186-132186 CALC-lcm 1-CALC-lcm 12 ignore them, duplicates
of the att.132182
9) attachment 132188 to 132191 CALC-nomi.. all has been changed and appears
ok
10) attachment 132192 CALC-rawsubtract about "RAWSUBTRACT"
https://help.libreoffice.org/Calc/Mathematical_Functions/it
in the index the item 9 RAWSUBTRACT is unrelated (NOT IT)
11) attachment 132193 CALC-ricerca about "RICERCA"
it is still same, in Sintassi we see:
RICERCA("Testo ricercato"; "Testo"; Posizione)
TrovaTesto è il testo da cercare. (but before it is writed "Testo
ricercato")
Testo è il testo da cui parte la ricerca. (but you should say "è il testo
dove ricercare"
Moreover, the example can be misleading: there is a blank before the number and
it gets ignored, but should it be a string (=RICERCA(54;" 998877665544") the
result would be 11.
All that is identic in the html guide too.
12) attachment 132194 CALC-trova about "TROVA"
same as said about "RICERCA"
13) attachment 132195 CALC-vero about "VERO"
it is still same: we see "Restituisce il valore logico VERO. La funzione TRUE()
non richiede ..." shoul be VERO().
--
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/20181128/f14dd467/attachment.html>
More information about the Libreoffice-bugs
mailing list