Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

At 15:43 26/05/2012 +0200, Miguel Angel wrote:
> El 26/05/12 12:41, Brian Barker escribió:
> > At 17:14 25/05/2012 +0200, Miguel Angel wrote:
> > > Maybe the mistake is in search for 0.000, it 
> > > can't be found, because a 0.000 is always 
> > > saved as 0, nonsignificant zeroes to the 
> > > right/left of decimal point are never saved.
> >
> > Computers store numbers in a fixed-length 
> > format - however-many bytes. So there are 
> > always the same number of binary digits stored 
> > - which equates to a different but similarly 
> > (approximately) fixed number of decimal digits 
> > stored (unless you choose multiple precision, 
> > of course). So surely what you may think of as 
> > nonsignificant zeroes are not "never" but *always* stored?
>
> I think not a fixed format, but a fixed length 
> with eight bytes used to store the number in 
> memory, as result fourteen significant numbers.

There has to be a format in which the numbers are 
stored, of course (however many bytes are used): 
fourteen significant decimal digits maps to about 
47 binary digits - just under six bytes.  The 
rest of the space is used for an exponent and for 
signs for both the exponent and the number 
itself.  There are many possible formats, but 
there has to be a fixed one in each computer or system.

> In content.xml file one of the files in .ods 
> file, we can see the saved values in 
> office:value tag and the representation of the value in text:p tag.

Thanks for this.  I confess I was thinking (as 
you were above) of storage in the sense of 
representation in the program itself - during 
processing.  You are right, of course, that 
storage in document files is in decimal, not 
binary, and apparently omits insignificant trailing zeroes.

Brian Barker


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted