incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Bug 119586] New: No error messages when SUM includes text?
Date Wed, 30 May 2012 08:26:26 GMT

          Priority: P3
            Bug ID: 119586
           Summary: No error messages when SUM includes text?
          Severity: major
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Hardware: PC
            Status: UNCONFIRMED
           Version: version58
         Component: ui
           Product: spreadsheet

Created attachment 77802
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.

View raw message