https://bz.apache.org/ooo/show_bug.cgi?id=127305
Peter <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #11 from Peter <[email protected]> --- I do not see this as a defect. OpenOffice is following exactly the rules to calculate with Units here. Which virtually the complete world uses. If you spend 1000 $ on 100 Boxes, and you want the price of 1 piece you would recieve 10$ a peice. That is the Definition we follow, and it is considered as default assumption. Also If you have a budget of 1000$ and you spend 100$ you can calculate 100$/1000$ and you will recieve 1/10 (note the missing of $) And OO will also comply on this behaviour (with some limitations see below.). I do not know what you are doing, but all Office Product work this way. (just confirmed it on Google docs, and I know the same from Excel.) And someone who does a lot of finacial calculations will expect exact this behaviour. I suggest to put your 100.1 into an own Cell and format that Cell to currency. This way you will have in your formula in D2 your expected result. Maybe we should give a way to indicate that a number in a formula is a currency. I.E. if you type (100.1) then it is automaticly concidered finencial number. Since Open Office does not differ between any currency I think it does not matter much. I mean if you calculate 100$/100€ you will recieve 1, and Office will not ask you on change rate. Jim is there an issue with my argumentation? Why do you want the different behaviour at all? -- You are receiving this mail because: You are the assignee for the issue.
