I don't seem to be able to duplicate Tibor's search and replace in decimal world. and fixed in LibreOffice in October 2011 and Apache OpenOffice in May 2012. If this in on-going you obviously need a better approach. Oracles lack of activity on or visible commitment to had. If this is a one-off, I think I'd just export the file as a comma-delimited file, open it in a word processor, edit out the decimal point and re-import the file into Calc with the phone number properly defined as text. (Note: My telephone number is 9 digits long, my weight (in kg) is only 2)Įdit: My level of fear just went up viewtopic.php?f=6&t=75507 I tend to live in fear that some one, using a speadsheet, will calculate a medicine dose on my telephone number rather than my weight. LibreOffice is ranked 1st while ONLYOFFICE is ranked 3rd. Such changes are not important for the value of a number but may be critical for data such as phone numbers. Numeric data such as phone numbers should always be stored as text, not as numbers, since Calc will take liberties with numbers such as removing leading/trailing zeroes. Acknak wrote:Removing the decimal point is only treating the symptom, not the problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |