Issue 16272 - Wrong formula generation for SUMIF
Summary: Wrong formula generation for SUMIF
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
: 19376 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-07-01 08:19 UTC by maison.godard
Modified: 2003-09-10 11:04 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 maison.godard 2003-07-01 08:19:30 UTC 
Hi, 

this probleme has been tested on Win2K, OO1.1Beta2, FrenchVersion

When using the SUMIF (Somme.SI in french) throught the formula helper, after 
filling th different fields the formula is generated

If the conditionnal statement contains a string, the formula encloses it in 
simple quotes leading to misinterpretation of the formula (sum is always 0)
=SOMME.SI(A2:A10;'dummy';C2:C10) 

Replacing single quotes by a double quote characters gives the good result, the 
function is evaluated
 =SOMME.SI(A2:A10;"dummy";C2:C10)
Comment 1 frank 2003-09-03 14:12:41 UTC 
could not reproduce on OOo1.1rc3 therefore closed worksforme.

Frank
Comment 2 frank 2003-09-03 14:13:08 UTC 
closed worksforme
Comment 3 frank 2003-09-10 11:04:13 UTC 
*** Issue 19376 has been marked as a duplicate of this issue. ***