Issue 96813 - Changing the decimal place lose the defined unit of a number
Summary: Changing the decimal place lose the defined unit of a number
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO300m9
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-12-02 18:55 UTC by el_cameleon
Modified: 2013-01-29 21:53 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description el_cameleon 2008-12-02 18:55:02 UTC
1- open a new Calc document
    2- enter the value 1,234 into a cell and validate
=> you will see something like "1,23" appear in the cell

    3- Change the formatting of the cell to something like: Standard" meters"
=> you will see something like "1,23 meters" appear in the cell

    4- use the "Add Decimal Place" button
=> the unit of the cell is lost and you will see something like "1,2" in the
cell instead of "1,234 meters", which would be the expected result.

Note 1: it works if you use the money formating instead of a unit
Note 2: consequently, it also works if you use a formating similar to the money
formatting, like this one: # ##0,000 [$m3-40C];[RED]-# ##0,000 [$m3-40C]
Note 3: a discussion about this problem is available on the french forum:
Comment 1 Rainer Bielefeld 2008-12-03 08:44:04 UTC
I checked with "Ooo 3.0.0 (DE) Multilingual version German UI WIN XP: [OOO300m9
(Build9358)]" and can confirm the reported effect. Works fine for
standard-Formattings "%" and currency, but not for user-defined.
Also visible in 2.4
May be this is more an ENHANCEMENT then DEFECT, and more an UI than a formatting