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

On 09/12/2018 12:45 PM, jomali wrote:
You seem to have a fundamental misunderstanding of how spreadsheets work.
When you enter a number into a numeric cell, the software converts it into
an internal format, which it then displays in the format you specify for
the cell. It does not remember the form in which you entered it. Thus,
127.700 and 127.7 are the same number.

TY all,

It's a shame that I can't enter numbers with paste, or paste special.
The raw data is in html format from the web, so importing it as text
might be viable.

Indeed, 127.000 and 127.7 are the same number, however, it seems that
when I enter 127.700, there should be a way to prevent the spreadsheet
from formatting it for its own internal use. I believe this was my
original question::>

Last evening, I figured out that I could add .00001 to each frequency,
which would allow me to search properly, since it's a simple math
function, it can be done automatically. So, I enter 127.700 MHz, then
add 10Hz to each number. The search function does work this way. I'm not
sure how I will proceed, but the input from list members helps a lot!

I had never thought of formatting the columns BEFORE I pasted the raw
data into the spreadsheet!!! I have no problem working with text instead
of numbers, I can do the text part on a separate sheet from the main
data. The main sheet is getting more complicated as I add features, so
the move to a separate 'text only' sheet might be the answer.

Again, thank you all! And thanks to those who write the software and run
the mailing list. I'm sure this is never said as often as it should be.



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.