Issue 108232

Summary: ODFF: FREQUENCY with no data should return zero for all bins
Product: Calc Reporter: caryr <cygcary>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO310m19   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Example spreadsheet none

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".