You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/05/30 10:26:26 UTC
[Bug 119586] New: No error messages when SUM includes text?
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.
[Bug 119586] No error messages when SUM includes text?
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119586
Li Feng Wang <ph...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |phoenix.wanglf@gmail.com
Ever confirmed|0 |1
--- Comment #1 from Li Feng Wang <ph...@gmail.com> ---
can reproduce with AOO3.4 release version(r1327774).
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119586] No error messages when SUM includes text?
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119586
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rb.henschel@t-online.de
--- Comment #2 from Regina Henschel <rb...@t-online.de> ---
In ODF1.2 says, that when using a range, texts are ignored and no converting is
done. Using a single cell and + operator a converting is done. So the
calculation of AOO is correct in respect to the standard. (ODF1.2 part 2,
sections 6.3.7 and 6.16.61)
The green mark in Excel is a warning. AOO does not has the ability to show a
warning. So I would say, this is a request for enhancement.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119586] No error messages when SUM includes text?
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119586
--- Comment #3 from Regina Henschel <rb...@t-online.de> ---
Please have a look at issue 91546. Would that address your request?
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119586] No error messages when SUM includes text?
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119586
--- Comment #4 from Jonathan <jo...@nottingham.ac.uk> ---
Hi Regina,
Issue 91546 would address my request. I note that the way Excel reports errors
is totally dumb, as they are reported in the input not the output. If I have
several hundred or several thousand inputs for one "SUM" I cannot reasonably
look through them all - if I could I would not be doing a SUM. I would
therefore suggest that AOO displays an error message both in the input cells
AND ALSO in the output cell for a calculation with unusual input.
Jonathan.
--
You are receiving this mail because:
You are the assignee for the bug.