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

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

From:                   Art <>
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.



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 on Linux (Fedora) 
not sure which OS you are using or which version.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

 Michael D. Setzer II - Computer Science Instructor (Retired)                    
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer
+------------------------------------------------------------+ (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)


ROSETTA      65783064.026787 | ABC          16613838.513356
SETI        109522885.335812 | EINSTEIN    141379519.999240

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.