« Return to Thread: Major data loss: Calc formatting numbers

Re: Major data loss: Calc formatting numbers

by Alan Lord (News) :: Rate this Message:

Reply to Author | View in Thread

On 01/07/09 17:46, Dotan Cohen wrote:
<snip />
> More likely, the text may have been copy/pasted out of an email. Are
> you suggesting that the data that was pasted was already rounded? I
> will look into that possibility.


Have you checked the "Precision as shown" setting on OOo?

"Precision as shown
Specifies whether to make calculations using the rounded values
displayed in the sheet. Charts will be shown with the displayed values.
If the Precision as shown option is not marked, the displayed numbers
are rounded, but they are calculated internally using the non-rounded
number."

Tools-Options-Open Office.org Calc-Calculate...

Just a thought.

Alan


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

 « Return to Thread: Major data loss: Calc formatting numbers