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

Re: Major data loss: Calc formatting numbers

by Graham P Davis-3 :: Rate this Message:

Reply to Author | View in Thread

Gordon Burgess-Parker wrote:

> Dotan Cohen wrote:
>> A new OOo user is using Calc to store information on volunteers in an
>> organization. Israeli ID numbers are 9 digits in length, such as this:
>> 317907977
>>
>> However, Calc has reformated them to this:
>> 317908000
>>
>> This is a major dataloss for the organization. The person in charge is
>> pissed, and both myself and OOo are to blame. OOo is already coming
>> off their machines (14 desktops, and I think a few laptops as well)
>> and I am tasked with recovering the missing data. Is this possible?
>>
>>  
> Well you certainly seem to have something very ODD going on - Calc 3.01
> here doesn't do that, it just displays the original 9-digit number...

No problem here either (version 3.1.0.98.1 on OpenSUSE 11.2-m2). I tried
formatting as both number and text and there was no difference.

How long after entering the data did reformatting occur?


--
Graham P Davis, Bracknell, Berks., UK.  E-mail: newsman not newsboy
"I wear the cheese. It does not wear me."


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

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