Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

On 12 Sep 2018 at 20:32, Art wrote:

Subject:                Re: [libreoffice-users] can't prevent Calc from 
modifying the number
        I type into a column
To:                     users@global.libreoffice.org
From:                   Art <ky1k@myfairpoint.net>
Date sent:              Wed, 12 Sep 2018 20:32:00 -0400

> 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.

Have you selected the column, and set the format for the column (or range) 
to so the 3 decimal positions you want? If it is set to default, then it will show 
the number as not showing the trailing zeros.

Second, I found that the search works in columns with numbers, but doesn't 
work if there are formulas in the cells??  The sheet I was using, I had a 
column where I had copied the values of one column to another column, and 
the find worked just fine with that one, but later, was trying to do the same on 
the column with formulas, and it didn't find the match? I also did a search 
using the formated, and was looking for 4.08, and it found match for 14.08 as 
well as the 4.08, so it appears to be doing a text match with contains rather 
than a numeric match when doing the find as formated??




> Regards,
>
> Art
>
>
>
>
> -- 
> 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


+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor (Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS

ROSETTA      65786414.038490 | ABC          16613838.513356
SETI        109526605.084600 | EINSTEIN    141382979.499240


-- 
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