Apache OpenOffice Community Forum

I am make a table with one column being percentage.
I first made the field type numeric and then format example set it to percent -13%
then tried integer with the same format example
Both when I enter my value of 85% change to zero when I go to the next line.
it did however take 8500%..

any ideas?
thank you

Usually a "formatting as %" multiplies the value by 100 and appends the character '%'. So your field must accept digits after the . or the value will be rounded/truncated.

If you wish to store % as integer, you can do this, but have to create your own formatted field with '%' like you would do for cm, °F etc.

J.