Issue 128331 - Error value when entering a fractional percentage.
Summary: Error value when entering a fractional percentage.
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.7
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Keith N. McKenna
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-03-11 14:57 UTC by mintwaxed115
Modified: 2020-03-17 00:27 UTC (History)
2 users (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 mintwaxed115 2020-03-11 14:57:19 UTC 
In cells formatted with the default percentage format, upon entering a fractional value such as nine-tents of a percent, the value displayed is 90 percent rater than .9 percent. It appears that the decimal point is being ignored.
Comment 1 oooforum (fr) 2020-03-11 17:48:40 UTC 
Your bug report is being closed as NOT_AN_ISSUE due to a lack of information which is needed in order to accurately reproduce and confirm the problem. We need the following information:

a) Provide details of your system including which edition is used (pro family...)

b) Provide a step-by-step procedure to reproduce (the simpler will be the better)

c) Provide any test case(s) which will help us confirm the problem (like a sample document)

d) Provide screenshots of the problem if you think it might help



Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue.
Comment 2 Keith N. McKenna 2020-03-14 17:34:38 UTC 
Confirmed with the following configuration:
Apache OpenOffice AOO417m1(Build:9800)  -  Rev. 46059c9192
2019-09-03 12:04
System Microsoft Windows 10 Version 1909 (OS Build 18363.720)

Steps used to reproduce:

Open Apache OpenOffice
Select Spreadsheet from the start center
Format cell A1 as per cent
enter .9
tab to next cell
cell A1 displays as 90.00%
Comment 3 oooforum (fr) 2020-03-16 10:50:41 UTC 
(In reply to Keith N. McKenna from comment #2)
> Format cell A1 as per cent
> enter .9
> tab to next cell
> cell A1 displays as 90.00%

And what did you expect?
0.9 is logically equal to 90%
Comment 4 Keith N. McKenna 2020-03-17 00:27:06 UTC 
Since as OOoforum (fr) correctly points out .9 = logically equivalent to 90% I am closing as Not An AOO Issue.