Issue 26020 - excel file: STDEV misinterpreted
Summary: excel file: STDEV misinterpreted
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-03-01 20:19 UTC by blommaep
Modified: 2004-03-08 11:44 UTC (History)
1 user (show)

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

Attachments
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 blommaep 2004-03-01 20:19:04 UTC 
When opening an excel file with the formula STDEV() used, the result is 
different then in excel.

According to the excel help:
Logical values such as TRUE and FALSE and text are ignored. If logical values 
and text must not be ignored, use the STDEVA worksheet function.

As it shows in excel: If I calculate an stdev over a range of cells, 
the cells containing text (empty text string) and the empty cells (containing 
really nothing, no text, no number, no formula,...) are ignored for the 
calculation.

As it shows in OOo 1.1: 
these cells simply cause an error (#VALUE) in the result cell

(Whatever the concept of STDEV may be on OO, when opening an excel file/saving 
an excel file, it should behave identical.)
Comment 1 frank 2004-03-02 11:54:49 UTC 
Hi,

I could not reproduce your problem.

Please attach a document showing it.

Frank
Comment 2 blommaep 2004-03-08 08:58:00 UTC 
I'm deeply ashamed, as I can't reproduce myself.
(I have one version of the spreadsheet kept, where I had the problem, and it 
seems most likely that I misintrepreted the problem:
Due to other (nonOO) problems, I ended up with only one value and a lot of empty 
strings. STDEV over one value does not exist obviously. 
I've been playing with the formula as such, but I haven't kept those. I think it 
is a non issue. Next time I'll sleep over it before I submit. Sorry)
Comment 3 frank 2004-03-08 11:43:58 UTC 
Hi,

no problem.

So I close it as wfm.

Frank
Comment 4 frank 2004-03-08 11:44:14 UTC 
closed wfm