Bug 50732 - : SUMIF function uses incorrect quotation mark for text values
Summary: : SUMIF function uses incorrect quotation mark for text values
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.5.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-05 07:51 UTC by lorandar
Modified: 2014-09-10 18:16 UTC (History)
0 users

See Also:
i915 platform:
i915 features:


Attachments

Description lorandar 2012-06-05 07:51:53 UTC
Problem description: 
When using the SUMIF function through the function wizard, a Criterion with text value is being marked with a single quotation mark, which results in a 0 value of the sum.
When the single quotation mark is manually being changed to a double quotation mark in the formula, the function works correctly.

Example: =SUMIF(E2:E8;'Paid';C2:C8) is the formula gained through use of the wizard. This will result in an incvorrect sum
When being corrected to =SUMIF(E2:E8;"Paid";C2:C8), the result is correct.

Steps to reproduce:
1. Add the following data to a spreadsheet:
A1 = 1; A2 = 2, A3 = 3, A4 = 4, A5 = 5
B1 = Paid; B2 = Unpaid; B3 = Paid; B4 = Unpaid; B5 = Paid

2. Enter a SUMIF formula through the function wizard in C1 with the following arguments:
Range = B1:B5
Criteria = Unpaid
Sum range = A1:A5

Current behavior: Formula =SUMIF(B1:B5;'Unpaid';A1:A5) is generated, the result gained in C1 is 0

Expected behavior: The result in C1 should be 6

This can be obtained by manually changing 'Unpaid' to "Unpaid" in the formula.

Platform (if different from the browser): Ubuntu 12.04 LTS
              
Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:12.0) Gecko/20100101 Firefox/12.0
Comment 1 Noel Grandin 2012-09-04 09:32:27 UTC
Confirmed in 3.6.1.2 (Windows)


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.