Issue 26834 - writer formulas only accept comma as decimal seperator
Summary: writer formulas only accept comma as decimal seperator
Status: ACCEPTED
Alias: None
Product: Writer
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2004-03-22 19:37 UTC by dawerbuch
Modified: 2013-08-07 14:38 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dawerbuch 2004-03-22 19:37:51 UTC 
I have a table.  In one cell I press F2 to enter the formula:  "4+8.5".  This
display as 125, not 12.5 as expected.
Comment 1 dawerbuch 2004-03-22 19:43:35 UTC 
Correction:  the formula displays as "89", not 12.5 as expected.  In order to
get 12.5 I have to enter "4.0+8.5"; for a result like "8.25" I have to enter
"4.00+4.25".

(1) it would appear the decimal points are being ignored, and the digits are all
being right-justified, regardless of magnitude or value
(2) I should not have to enter decimal points to explicit integer values
(3) I shoul dnot have to pad with zeros to make all numerical entries the same
length in characters.
Comment 2 lohmaier 2004-03-22 21:47:43 UTC 
confirming, adjusting prio, setting target-milestone "not determined"

I can reproduce the problem, but I cannot reproduce the workaround mentioned. 
"4.0+8.5" results in 125 (not 12.5)

OOo ignores the "." as decimal seperator, it only accepts ","

OOo should either use seperator taken form the language-environment (like Calc
does).
Make sure that the decimal behaviour of the numpad will work like in Calc (see
issue 1820)
Comment 3 michael.ruess 2004-03-23 07:45:53 UTC 
MRU->TL: it looks a bit inconsistent here. I tested this with an English OO on
German Linux locale and the calculation only accepted 8.5 as decimal fraction,
but the result was displayed as 12,5. In my opinion, this should all work in the
current cell/character language. So I think the formats there should be unified
in a way...
Comment 4 thomas.lange 2004-03-23 10:54:01 UTC 
.
Comment 5 Martin Hollmichel 2004-05-28 14:54:54 UTC 
according to the announcement on releases
(http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7503) this issue
will be re-targeted to OOo Later.