[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