Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

On Wed, 12 Sep 2018 02:44:26 -0400
Art <> wrote:
It seems that the software is ignoring zeros to the right of the
decimal point. I'm listing frequencies in Megahertz, so the zeros to
the right of the decimal point are significant. I wish I could post
my spreadsheet somewhere, I do know better than to send it to the
list members::>

As far as I can tell the problem is fairly fundamental. LibreOffice
uses a definition of 'significant figure' that is different to that
usually used in the scientific world. Specifically, they don't regard a
0 after a decimal point as significant :(


I'd suggest you have two easy options:
(1) use a 0.000 format and search using the formatted display option
(2) Display the frequencies in kHz so they are all whole numbers

Note that you could display the numbers twice in two columns. Once in a
column that's easy for you to read, and again in a column that's
formatted to be searched. The search column could be hidden.

PS I was going to suggest:
(3) Use scientific format to specify the significant digits
(e.g. ##0.000E+00)

but apparently you can't search 127.700E+00 for 127.7 :(

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


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.