Mailing-List: contact ooo-issues-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-issues@incubator.apache.org
From: bugzilla@apache.org
To: ooo-issues@incubator.apache.org
Subject: [Bug 119586] New: No error messages when SUM includes text?
Date: Wed, 30 May 2012 08:26:26 +0000
Message-ID: <bug-119586-248469@https.issues.apache.org/ooo/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit
Auto-Submitted: auto-generated
MIME-Version: 1.0

https://issues.apache.org/ooo/show_bug.cgi?id=119586

          Priority: P3
            Bug ID: 119586
          Assignee: ooo-issues@incubator.apache.org
           Summary: No error messages when SUM includes text?
          Severity: major
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: jonathan.burley@nottingham.ac.uk
          Hardware: PC
            Status: UNCONFIRMED
           Version: version58
         Component: ui
           Product: spreadsheet

Created attachment 77802
  --> https://issues.apache.org/ooo/attachment.cgi?id=77802&action=edit
Minimal working example, excel file

In Excel, a SUM which includes a (text? character? factor?) which looks like a
number leads to an error state (small green triangle at top LHS of cell).
Openoffice spreadsheet does not report any errors at all in a similar
situation, I fell for this hook line and sinker with a recent set of
calculations involving spreadsheets sent to me by other people (some apparently
numeric data was not numeric). SUM operates differently to "+", I assume this
is an Excel-related "feature"...

I have attached a minimal working example which highlights this issue, in a
real-world application the inclusion of non-numeric numbers is near impossible
to spot. I can't easily spot a bug report but search terms are non-obvious.

I would like to see an obvious error alert/report in the spreadsheet.

-- 
You are receiving this mail because:
You are the assignee for the bug.