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


At 20:32 12/09/2018 -0400, Art Noname wrote:
It's a shame that I can't enter numbers with paste, or paste special.

You can. Use Paste Special... if necessary only if your data source is itself a spreadsheet and the values risk arriving with a numerical format associated.

The raw data is in html format from the web, so importing it as text might be viable.

It is.

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.

And the answer was to format your cell range as text.

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.

Sounds messy and error-prone.

I had never thought of formatting the columns BEFORE I pasted the raw data into the spreadsheet!!!

That should have been on page one of your spreadsheet beginner's manual. Wasn't it?

I have no problem working with text instead of numbers, ...

Good.

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.

You probably don't need to. As suggested earlier, just use VALUE(Xn) where you would otherwise use Xn to extract real numbers from your text values as necessary in formulae.

Brian Barker

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


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.