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
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Example spreadsheet (12.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-01-11 23:33 UTC, caryr 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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 "issues@openoffice.apache.org".