incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 102499] Cell formatted as percent: inconsistent input handling
Date Thu, 29 Mar 2012 04:57:28 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=102499

--- Comment #8 from Sushi <ahiroshige@ashisuto.co.jp> 2012-03-29 04:57:28 UTC ---
>Terry
Thank you for testing.

As for the 4th case, I'm not too familiar with Linux but I could still
reproduce the same behavior with LibreOffice 3.5.0 on Ubuntu 11.10 using
iBus IME. So I suppose it should be reproducible with OOo 3.3.0 running
on Linux as well.

What IME have you used?

>If I enter the number 1 before formatting the cell as percent,
 formatting renders the entry as 100%
As for this case, I think it is working as designed since the value "1"
entered before specifying a format is considered a serial value. You
would notice if you enter "0.01" into a cell before specifying a format
and then set "%" format to that cell, the cell returns "1%"

On the other hand, if you set "%" formatting to a cell and enter "1" 
to get a value "1%" showing in that cell, then change the format back
to "Standard", the cell should return "0.01"

If you still want that "1" which you entered before specifying a format
to be "1%" when its formatting is changed, then perhaps defining your
own formatting code would do?

Just type in    #"%"   (be sure to include the " when entering) into
Formatting Code input box in the Cell Formatting Dialog Box.

Sorry if you are already aware of it.

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

Mime
View raw message