incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 119586] New: No error messages when SUM includes text?
Date Wed, 30 May 2012 08:26:26 GMT
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.

Mime
View raw message