[libreoffice-users] how to use coding and labelling in a spreadsheet

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+unsubscribe@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