[Libreoffice-bugs] [Bug 114660] New: COUNTIFS FUNCTION documentation and correction not consistent

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114660
           Summary: COUNTIFS FUNCTION documentation and correction not
                    consistent
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: djonesgm at gmail.com
                CC: olivier.hallot at documentfoundation.org

Description:
When I follow the suggested syntax, I get errors [including Err 507, which is
not even listed in the error messages.] Libre suggests corrections. These
suggested corrections DO NOT follow the suggested syntax, and they also produce
errors. There is a bad disconnect between the documented / suggested syntax and
whatever actual syntax Libre is looking for.

Actual Results:  
When I follow the suggested syntax, I get errors [including Err 507, which is
not even listed in the error messages.] Libre suggests corrections. These
suggested corrections DO NOT follow the suggested syntax, and they also produce
errors. There is a bad disconnect between the documented / suggested syntax and
whatever actual syntax Libre is looking for.

Expected Results:
noted above


Reproducible: Always


User Profile Reset: No



Additional Info:
1. Syntax as per the Help and syntax within Libre should be consistent. 2. When
Libre suggests an amendment to my attempt, that suggestion should be consistent
with the syntax as set out in help. A major discrepancy I note is that the Help
wants a ";" between parameters, whereas the suggested pollution that Libre
produces uses a "," between parameters.


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101
Firefox/57.0

-- 
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/20171223/bd9c9647/attachment.html>