Bug 88047

Summary: Statistical add-in function DEVSQ
Product: LibreOffice Reporter: wnget
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEEDINFO --- QA Contact:
Severity: normal    
Priority: medium CC: sociology4programming
Version: 4.3.4.1 release   
Hardware: x86 (IA32)   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: Libre Calc showing the error in DEVSQ

Description wnget 2015-01-05 11:19:44 UTC 
In the ANOVA single or two factor, the Total returns Error:508.
On following up what could be the problem, the syntax is:-
=DEVSQ($'Inferential Statistics'.$F$2:$F$31,$'Inferential Statistics'.$G$2:$G$31)
instead of:-
DEVSQ(Number1; Number2; ...Number30) as reported in https://help.libreoffice.org/Calc/Statistical_Functions_Part_Five#Syntax_39
Comment 1 Bookman800 2015-01-05 11:28:55 UTC 
How can it be clearly reproduced? Need for the data
Comment 2 wnget 2015-01-05 12:09:07 UTC 
Created attachment 111764 [details]
Libre Calc showing the error in DEVSQ

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.