<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - CALC - other cases of incorrect help" href="https://bugs.documentfoundation.org/show_bug.cgi?id=106803#c30">Comment # 30</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - CALC - other cases of incorrect help" href="https://bugs.documentfoundation.org/show_bug.cgi?id=106803">bug 106803</a> from <a class="email" href="mailto:gmmellina@inwind.it" title="gmarco <gmmellina@inwind.it>"> gmarco</a> <pre>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) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132177" name="attach_132177" title="screenshot">attachment 132177</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132177&action=edit" title="screenshot">[details]</a> CALC-arrot about "ARROTONDA.ECCESSO" <a href="https://help.libreoffice.org/Calc/Mathematical_Functions/it#ARROTONDA.ECCESSO">https://help.libreoffice.org/Calc/Mathematical_Functions/it#ARROTONDA.ECCESSO</a> it is still same: some text is still in English 2) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132178" name="attach_132178" title="CALC-cerca">attachment 132178</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132178&action=edit" title="CALC-cerca">[details]</a> CALC-cerca about "CERCA" <a href="https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#CERCA">https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#CERCA</a> it is still same: some text is still in English 3) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132179" name="attach_132179" title="CALC-cercaO">attachment 132179</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132179&action=edit" title="CALC-cercaO">[details]</a> CALC-cercaO about "CERCA.ORIZZ" <a href="https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#CERCA.ORIZZ">https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#CERCA.ORIZZ</a> it is still same: "Sintassi" is still in English 4) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132180" name="attach_132180" title="CALC-cercaV">attachment 132180</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132180&action=edit" title="CALC-cercaV">[details]</a> CALC-cercaV about "CERCA.VERT" <a href="https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#CERCA.VERT">https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#CERCA.VERT</a> it is still same: "Sintassi" is still in English 5) attachments 132181-132182 CALC-gcd-mcd-mcm-lcm <a href="https://help.libreoffice.org/Calc/Mathematical_Functions/it">https://help.libreoffice.org/Calc/Mathematical_Functions/it</a> 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" <a href="https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#INDIRIZZO">https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#INDIRIZZO</a> 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) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132185" name="attach_132185" title="CALC-indir3">attachment 132185</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132185&action=edit" title="CALC-indir3">[details]</a> CALC-indir3 about "INDIRETTO" <a href="https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#INDIRETTO">https://help.libreoffice.org/Calc/Spreadsheet_Functions/it#INDIRETTO</a> 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) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132188" name="attach_132188" title="CALC-nomi1a">attachment 132188</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132188&action=edit" title="CALC-nomi1a">[details]</a> to 132191 CALC-nomi.. all has been changed and appears ok 10) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132192" name="attach_132192" title="CALC-rawsubtract">attachment 132192</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132192&action=edit" title="CALC-rawsubtract">[details]</a> CALC-rawsubtract about "RAWSUBTRACT" <a href="https://help.libreoffice.org/Calc/Mathematical_Functions/it">https://help.libreoffice.org/Calc/Mathematical_Functions/it</a> in the index the item 9 RAWSUBTRACT is unrelated (NOT IT) 11) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132193" name="attach_132193" title="CALC-ricerca">attachment 132193</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132193&action=edit" title="CALC-ricerca">[details]</a> 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) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132194" name="attach_132194" title="CALC-trova">attachment 132194</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132194&action=edit" title="CALC-trova">[details]</a> CALC-trova about "TROVA" same as said about "RICERCA" 13) <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132195" name="attach_132195" title="CALC-vero">attachment 132195</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132195&action=edit" title="CALC-vero">[details]</a> CALC-vero about "VERO" it is still same: we see "Restituisce il valore logico VERO. La funzione TRUE() non richiede ..." shoul be VERO().</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>