[Libreoffice-bugs] [Bug 140771] New: Calc, function Frequency, wizard, range definition doubles first cell number

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140771
           Summary: Calc, function Frequency, wizard, range definition
                    doubles first cell number
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: h.c.croon at hccnet.nl

Description:
entering function frequency(range;critera) and using the wizard to specify the
ranges of both range and criteria, after selecting the ranges, enters the first
cell number twice. After using it name error is generated but you before you
see what causes this error it costs a lot of time.

Steps to Reproduce:
1. Choose destination range and place cursor in first cell
2. enter = and choose "frequency" out of list of functions
3. in wizard window click next, click icon to go to spreadsheet for selecting
first rage
4. Select first range and return to wizard window.
5. Now I see the error: first cell number 2 times present
6. With criteriarange the same occurs

Actual Results:
without corrected it, #name error

Expected Results:
obvious


Reproducible: Always


User Profile Reset: No



Additional Info:
example spreadsheet is available

-- 
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/20210303/5ad6b26f/attachment.htm>