Bug 147736 - Mistake in french documentation of SOMME.SI.ENS()
Summary: Mistake in french documentation of SOMME.SI.ENS()
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
7.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-03-02 17:25 UTC by Stephane Fillod
Modified: 2022-07-06 19:36 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Stephane Fillod 2022-03-02 17:25:32 UTC 
At the bottom of the french help for SOMME.SI.ENS(), the example function (here-below) is incomplete :

  =SOMME.SI.ENS(C2:C6;A2:A6;".*";B2:B6;"<"&MAX(B2:B6))

It is missing the «E2&» string before the third argument, like in the SUMIFS() english help page[2] :

  =SUMIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))

[1] https://help.libreoffice.org/7.2/fr/text/scalc/01/func_sumifs.html?DbPAR=CALC
[2] https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_sumifs.html
Comment 1 Julien Nabet 2022-03-02 18:11:28 UTC 
I did the change here:
https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b24ba91863ca4954&q=+note%3AU2wwM+&sort_by=-priority%2Cposition
(I don't know how much time it'll need so it'll appear on websites).

But I gave a try, it doesn't work. It works only if I remove the ".", so rather

=SOMME.SI.ENS(C2:C6;A2:A6;E2&"*";B2:B6;"<"&MAX(B2:B6))
or in English:
=SUMIFS(C2:C6;A2:A6;E2&"*";B2:B6;"<"&MAX(B2:B6))
Comment 2 Julien Nabet 2022-07-06 19:36:47 UTC 
It seems ok now, let's put this one to FIXED.