Bug 140771 - Calc, function Frequency, wizard, range definition doubles first cell number
Summary: Calc, function Frequency, wizard, range definition doubles first cell number
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-03-03 10:31 UTC by Carolus
Modified: 2021-03-05 20:38 UTC (History)
1 user (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 Carolus 2021-03-03 10:31:19 UTC 
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
Comment 1 Julien Nabet 2021-03-03 17:59:06 UTC 
On pc Debian testing x86-64 with LO Debian package 7.0.4.2, I don't reproduce this.

Could you give a try to 7.0.4 or brand new 7.1.0 version?
Indeed 6.4 branch is EOL
Comment 2 Carolus 2021-03-04 09:12:38 UTC 
Dear Julien,

I switched to 7.1.0.3 and the error doesn't appear. So its solved in version 7.

But the result of the computation of the frequencies is apparently  wrong. This is the case in both Java run time on or off. I have the example spreadsheet available. If it is better to do a separate bug notification I will do.

Regards,

Harry Croon
Comment 3 Julien Nabet 2021-03-04 17:23:23 UTC 
We can "recycle" this tracker but could you attach an example file which shows what's wrong?
Comment 4 Carolus 2021-03-04 22:31:01 UTC 
There were blank cells in the result. But after rereading the syntax of the frequency function I saw that I used wrong ranges. Sorry for that. This "bug" can be removed.
Comment 5 QA Administrators 2021-03-05 04:19:45 UTC Comment hidden (obsolete)
Comment 6 Julien Nabet 2021-03-05 20:38:43 UTC 
Ok let's put this as WFM then.