Issue 108232 - ODFF: FREQUENCY with no data should return zero for all bins
Summary: ODFF: FREQUENCY with no data should return zero for all bins
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO310m19
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-01-11 23:31 UTC by caryr
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Example spreadsheet (12.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-01-11 23:33 UTC, caryr
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description caryr 2010-01-11 23:31:46 UTC
When using frequency() if all the data fields are blank this results in a value 
error for all the bins instead of returning zero for all the bins. This is a 
bit of a corner case, but can occur. I will try to add a spreadsheet that 
demonstrate the problem.
Comment 1 caryr 2010-01-11 23:33:32 UTC
Created attachment 67135 [details]
Example spreadsheet
Comment 2 ooo 2010-01-12 13:53:40 UTC
Indeed, also Excel does it. Will be part of OpenFormula as well.
Comment 3 Marcus 2017-05-20 11:11:36 UTC
Reset assigne to the default "".