| View previous topic :: View next topic |
| Author |
Message |
rylan76
General User
Joined: 19 Jul 2005
Posts: 10
|
 Posted: Tue Jul 19, 2005 11:44 pm Post subject: Simple precentage calculation wildly incorrect result |
 |
|
Hi
I have the following calculation I want to execute in a cell
VAT = 0.40 * amount
if amount is 918.55
doing
=(0.40)*(A85) (where A85 is the cell containing 918.55)
results in
33634508.73 which is obviously wildly wrong.
Going back to the cell where I entered
=(0.40)*(A85)
the cell now contains
(36617)*(A85)
How did the explicitly specified decimal fraction 0.40 become 36617?
Or am I doing something obviously wrong? |
|
| Back to top |
|
 |
ms777
Super User
Joined: 07 Feb 2004
Posts: 1355
|
| Posted: Wed Jul 20, 2005 12:04 am Post subject: |
|
|
| looks like one of your cells is formatted as a date / time ... |
|
| Back to top |
|
|
rylan76
General User
Joined: 19 Jul 2005
Posts: 10
|
| Posted: Wed Jul 20, 2005 12:51 am Post subject: |
|
|
Hi thanks for replying!
That's just the thing - I can't get the cells to take on a "normal" mode - i. e. non-date. I've tried right clicking on a cell and making the format to be a number, but OO refuses to allow it - the moment I enter a value into that cell again it is interpreted as a date and there is no way I can switch it to being a number.
How can I make all cells in a sheet be numbers only, not dates?
Thanks again, |
|
| Back to top |
|
|
ms777
Super User
Joined: 07 Feb 2004
Posts: 1355
|
| Posted: Wed Jul 20, 2005 1:05 am Post subject: |
|
|
just saw your other post - you seem to have a real problem there ...
1st: what is your OO version / your system
2nd: Is it a spreadsheet problem or an OO installation problem ? Create a new, empty doc, and have a look if the same problem occurs
3rd: What is the locale you installed the system for ? Can you try a different locale ?
Just some guesses ...
good luck ms777 |
|
| Back to top |
|
|
rylan76
General User
Joined: 19 Jul 2005
Posts: 10
|
| Posted: Wed Jul 20, 2005 1:52 am Post subject: |
|
|
Joined: 07 Feb 2004
Posts: 299
Hi
> 1st: what is your OO version / your system
How can I find out my OO version? I am using it on a Fedora Core 3 install with a custom-compiled 2.6.12 kernel.
> 2nd: Is it a spreadsheet problem or an OO installation >problem ? Create a new, empty doc, and have a look if the >same problem occurs
I have done this, same problem occurs consistently - all cells in all sheets are forced to be dates, no matter what you specify via the "Format Cells (Control+1)" menu option.
> 3rd: What is the locale you installed the system for ? Can >you try a different locale ?
Locale? How can I check that? I noticed that in the non-working "Format Cells" screen there is a language dropdown. It is set at "Default" - I can make it US English, UK English or even my native language all cells still treat any numeric input as a date. No change in the problem.
Just some guesses ...
Thanks a lot for replying! |
|
| Back to top |
|
|
ms777
Super User
Joined: 07 Feb 2004
Posts: 1355
|
| Posted: Wed Jul 20, 2005 3:07 am Post subject: |
|
|
| Quote: | | How can I find out my OO version? I am using it on a Fedora Core 3 install with a custom-compiled 2.6.12 kernel. |
Under the Help/ About menu, you find something like 1.1.4 or 1.9.93 ...
As this failure has to the best of my knowledge never been reported in this forum I belive it may be due to your custom compiled OO version. Can you download and install a standard 1.1.4 (stable) or 1.9.10X OO 2.0 version ? |
|
| Back to top |
|
|
rylan76
General User
Joined: 19 Jul 2005
Posts: 10
|
| Posted: Wed Jul 20, 2005 5:52 am Post subject: |
|
|
| Hmm - it's not my OO that is custom compiled, it is the Linux kernel... totally seperated from Open Office... |
|
| Back to top |
|
|
Dale
Super User
Joined: 21 Feb 2005
Posts: 1440
Location: Australia
|
| Posted: Wed Jul 20, 2005 3:04 pm Post subject: |
|
|
| rylan76 wrote: | > 3rd: What is the locale you installed the system for ? Can >you try a different locale ?
Locale? How can I check that? I noticed that in the non-working "Format Cells" screen there is a language dropdown. It is set at "Default" - I can make it US English, UK English or even my native language all cells still treat any numeric input as a date. No change in the problem.
Just some guesses ...
Thanks a lot for replying! |
Tools > Options
Expand "Language Settings"
Select "Languages"
You may have a locale selected that uses "." as the date separator - hence your problem. You should be able to see the current separator by
Format Cells
Select "Number" tab
Select "Date" in the Category box
- The Format box will show how the current Locale displays dates (ie. the default separator).
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!
OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos |
|
| Back to top |
|
|
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Wed Jul 20, 2005 11:02 pm Post subject: |
|
|
From the thread(s)I am not clear if you have done this already , If so then ignore this.
Tools/options/language settings/languages:
Language - locale setting = English uk
the currency defaults to sterling
All dots will be read as decimal separators and not as dates
.
Dont change "language default for documents"
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
rylan76
General User
Joined: 19 Jul 2005
Posts: 10
|
| Posted: Wed Jul 20, 2005 11:38 pm Post subject: |
|
|
Hi Carl
At last! This seems to have fixed it - I can now enter numbers with the . as decimal indicator, and calculations also seem to work right. Guess I was just poking at the wrong stuff up to now. 
Thank you so much,
Kind regards, |
|
| Back to top |
|
|
|
