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
Context
[libreoffice-users] Re: Calc: Search & Replace Within A Column · Andreas Säger
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.