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

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.

If you really want to remember the input format, change the format of the
cells in the input column (or row) to text before you enter the data. The
result will be a textual representation of the number. You can then search
for the "number" in the input format.

 To perform calculations on those numbers, you would then create another
column (or row) containing the formula "=value(input cell)" and do the
calculations on the resulting values.

On Wed, Sep 12, 2018 at 12:36 AM Art <ky1k@myfairpoint.net> wrote:

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

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