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

On 12 Sep 2018 at 0:36, Art wrote:

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

> I have a column of numbers I want to enter into a calc column.
>
> One of the numbers is 127.700 (for instance).
>
> So, I copy the number and paste it into the desired column. But, when I
> go back and check the contents of the column, it reads 127.7 instead!!!
>
> And, if I search the spreadsheet for 127.700, there are no hits!!!!
>
> I tried formatting the column to show 3 significant numbers after the
> decimal point, which looks good....but when I check the actual contents
> of that cell, it is still 127.7!!! And, I still can't search for 127.700
> (no hits)!
>
> I tried turning off the autocomplete, no change.
>
> It seems like calc has some sort of deliberate action to inhibit
> entering of trailing zero's (after the decimal point).
>
> How do I turn off this "feature"???
>
> When I copy and paste 117.000 into a cell, I expect to see 117.000 when
> I examine the contents of the cell. I actually don't have a problem with
> how the number is displayed in the spreadsheet, but when I search for
> the number I entered into the column, I need to get hits on 117.000 when
> I search for 117.000.
>
> TY
>
> Art

I just did the ctrl-F in a spreadsheet I have with floating point number. Have a 
number of 1.08 as the displayed data, but it only finds one of the 5. If I click 
formatted Display option at the bottom, it then finds all of them. 

So, that should be on the bottom. I have version 6.1.0.3 on Linux (Fedora) 
not sure which OS you are using or which version.

> -- 
> 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      65783064.026787 | ABC          16613838.513356
SETI        109522885.335812 | EINSTEIN    141379519.999240


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