[Solved] Computation gives unexpected result

[pino]

I've found that OOC 4.1.11 will not compute numbers with more than 4 decimal places.

so eg
4.9999 * 19.33 * 1.59 gives 153.601
but
4.99999etc * 19.33 * 1.59 gives 153.604 which is the same as 5 * 19.33 * 1.59 (BUT result should be 153.674)

Solutions please.

[Hagar Delest]

Hi and welcome to the forum!

There is a problem with your figures indeed. Here is what I get with LibreOffice:

You should have a look at the topic of this post: £3.04 x 365 Does Not Equal £1,110.46.
Note that you talk about 4 decimal places but you only display 3 of them. There may be a rounding in the formulas.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.

[Zizi64]

pino ,

please upload your small, ODF type sample spreadsheet file here.

[pino]

Thanks to both Hagar Delest and Zizi64 for replying.
I made the mistake of not interrogating the output. Apologies for wasting your time.
regards Pino.