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: [email protected] 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
