Can not change 100% to 100

Discuss the database features
Post Reply
Maria2018
Posts: 4
Joined: Tue Oct 09, 2018 8:20 pm

Can not change 100% to 100

Post by Maria2018 »

Hi all, new here so please be gentle :)
I was inputting a value of 100% into a couple of different columns (database) but then I found out that the percent sign % shouldn't be there. So I tried to delete it. But when I delete just the % sign or delete the entire value of 100% and then enter the value of 100, for some reason I get 10000.00%.
I've tried different cells and it's always the same! If the value was 50% and I try to change to 50 it makes it 5000.00%
So not only it won't let me delete the % sign and puts it right back but it also adds a couple of 00 to every value I enter
I would appreciate some help!
Office 4.1.5 on Windows 10
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Can not change 100% to 100

Post by UnklDonald418 »

Percent is simply a way of displaying a fraction as a whole number.
1 displays as 100%
.5 displays as 50%
.252 displays as 25.2%
The HSQLDB database engine stores the fraction in the table, it knows nothing about percent.
The Base front end multiplies the fraction stored in the database table by 100, adds the % character and displays that result. That is why you are seeing those large numbers.
If you want to enter something like 50% and have it saved as .50, you need to create a Base form instead of entering data directly into the table.
Actually, you should use use Base forms for entering and editing data in most situations.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Maria2018
Posts: 4
Joined: Tue Oct 09, 2018 8:20 pm

Re: Can not change 100% to 100

Post by Maria2018 »

thanks for replying but this doesn't solve my problem. It's a custom form given to me by a company and I have entered about 5 days worth of data. Then they told me that I shouldn't use the % symbol. But when I go to delete it, it puts it right back plus changes the number by adding 00.00 to it.
There must be a way to go into each cell and change from 100% to 100 or from 50% to 50
It's so basic. There must be some kind of formatting going on that doesn't allow me to make this simple change?
Office 4.1.5 on Windows 10
Maria2018
Posts: 4
Joined: Tue Oct 09, 2018 8:20 pm

Re: Can not change 100% to 100

Post by Maria2018 »

well, easily fixed it in excel by changing formatting. Couldn't figure out how to do it in OO
Office 4.1.5 on Windows 10
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Can not change 100% to 100

Post by UnklDonald418 »

I did some testing, the problem is with
a custom form given to me by a company
It appears the form has a Formatted Field control that has its Formatting set to Percent. To change that behavior would require editing the form which would be best done by the form designer.
We might be able guide you through the form editing process, but if the spreadsheet does what you need that's the way to go.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Maria2018
Posts: 4
Joined: Tue Oct 09, 2018 8:20 pm

Re: Can not change 100% to 100

Post by Maria2018 »

thank you for taking the time to help me!
Office 4.1.5 on Windows 10
Post Reply