hello friends, calc is a powerful spreadsheet program and i want to use this for data analysis. let's say, one study has a variable named "malnutrition" measuring the nutritional status of under-five children. this variable has two value levels - "1=malnutrition" and "2=normal" (ods file link=http://s000.tinyupload.com/?file_id=01897194432026825577). present scenario: if data in entered as "1"/"2", spreadsheet will show it as "1"/"2". if it is entered as "malnutrition"/"normal", it will be shown in that manner. what I expect: after doing value labeling (i.e., telling calc that "1=malnutrition" and "2=normal"), data will be entered as "1"/"2" and it'll appear as "malnutrition"/"normal"). possibilities: renaming the cell. as could be seen in this image (http://s000.tinyupload.com/?file_id=03212213468569832926), cell A2 has a code of "1" and is renamed to "malnutrition" (upper left corner). problem: need to select each cell containing "1" and rename it to malnutrition. otherwise cell A4 is not showing malnutrition for code 1 (http://s000.tinyupload.com/?file_id=37582743697322862277).so i guess, my question finally comes to this- is there any way to do this in a spreadsheet program? waiting for your responses. thanks in advance.
regards, som -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted