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

For the formatted display to work, the cells have to be formated to show the 
decimal places to the degree you want. I have the column set to show just 2 
decimal places. So 5 of the cells show 1.08 though the raw numbers are 
actually slightly different. So, if you set the columns to use the format with 3 
decimals, and then click on the as formatted it should work. If not, you might 
try upgrading to the latest version. Sometimes it is something that is fixed in 
the newer versions.


On 12 Sep 2018 at 2:44, Art wrote:

Subject:                Re: [libreoffice-users] can't prevent Calc from 
modifying the number
        I type into a column
To:                     "Michael D. Setzer II" <msetzerii@gmail.com>, 
users@global.libreoffice.org
From:                   Art <ky1k@myfairpoint.net>
Date sent:              Wed, 12 Sep 2018 02:44:26 -0400

> On 09/12/2018 01:09 AM, Michael D. Setzer II wrote:
> > 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.
>
> I'm running Xubuntu 18.04, with Version: 6.0.3.2, Build ID:
> 1:6.0.3-0ubuntu1. It is fully updated.
>
> I'm not quite sure I understand your explanation.
>
> If I open a fresh spreadsheet and enter '117.700' into one cell, then
> search for '117.000', there are no hits. When I look at the contents of
> the cell, it says '117.7', which isn't the number I entered. I can
> search for 117.7 and it will be found, but, 117.76, 117.774 and 117.706
> are also found.....which is wrong.
>
> I did try formatted display checkbox at the bottom of the screen, but
> there is no difference.
>
> 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::>
>
> Any ideas?


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