OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Simple precentage calculation wildly incorrect result

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
rylan76
General User
General User


Joined: 19 Jul 2005
Posts: 10

PostPosted: Tue Jul 19, 2005 11:44 pm    Post subject: Simple precentage calculation wildly incorrect result Reply with quote

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
View user's profile Send private message
ms777
Super User
Super User


Joined: 07 Feb 2004
Posts: 1355

PostPosted: Wed Jul 20, 2005 12:04 am    Post subject: Reply with quote

looks like one of your cells is formatted as a date / time ...
Back to top
View user's profile Send private message
rylan76
General User
General User


Joined: 19 Jul 2005
Posts: 10

PostPosted: Wed Jul 20, 2005 12:51 am    Post subject: Reply with quote

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
View user's profile Send private message
ms777
Super User
Super User


Joined: 07 Feb 2004
Posts: 1355

PostPosted: Wed Jul 20, 2005 1:05 am    Post subject: Reply with quote

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
View user's profile Send private message
rylan76
General User
General User


Joined: 19 Jul 2005
Posts: 10

PostPosted: Wed Jul 20, 2005 1:52 am    Post subject: Reply with quote

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
View user's profile Send private message
ms777
Super User
Super User


Joined: 07 Feb 2004
Posts: 1355

PostPosted: Wed Jul 20, 2005 3:07 am    Post subject: Reply with quote

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
View user's profile Send private message
rylan76
General User
General User


Joined: 19 Jul 2005
Posts: 10

PostPosted: Wed Jul 20, 2005 5:52 am    Post subject: Reply with quote

Hmm - it's not my OO that is custom compiled, it is the Linux kernel... totally seperated from Open Office...
Back to top
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Wed Jul 20, 2005 3:04 pm    Post subject: Reply with quote

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
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Wed Jul 20, 2005 11:02 pm    Post subject: Reply with quote

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
View user's profile Send private message
rylan76
General User
General User


Joined: 19 Jul 2005
Posts: 10

PostPosted: Wed Jul 20, 2005 11:38 pm    Post subject: Reply with quote

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. Very Happy

Thank you so much,

Kind regards,
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group