[Libreoffice-bugs] [Bug 121848] New: Assistant cannot select the whole column on other sheet using NB.SI (countif) and somme.si (sumif)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Dec 1 20:15:03 UTC 2018


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

            Bug ID: 121848
           Summary: Assistant cannot select the whole column on other
                    sheet using NB.SI (countif) and somme.si (sumif)
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hug.charlotte at gmail.com

Description:
When using assistant for NB.SI (count if) function on one sheet, if I want to
select a whole column in another sheet, it doesn't work.

Same problem with SOMME.SI (sum if)

Steps to Reproduce:
1.open assistant
2.select NB.SI or SOMME.SI function
3.try to select a whole column in another sheet
4.assistant can not display "sheet2.A:A" for instance

Actual Results:
assistant does not display the selected column in the selected sheet

Expected Results:
nothing is displayed


Reproducible: Always


User Profile Reset: No



Additional Info:
assistant displays the name of the selected column and sheet

-- 
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/20181201/5b5d70dd/attachment.html>


More information about the Libreoffice-bugs mailing list