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

thank you regina. that is exactly what i was trying to achieve. addition of red was a nice touch 
too.
thank you very much for your help.

regards,
som
On Thursday 24 March 2016 01:56 PM, Regina Henschel wrote:
> Hi som,
>
> you can use format codes. Format codes do not change the value of the
> cell, but only how this value is shown. So the content of the cell would
> be still the number 1 or 2, but you would read "malnutrition" and "normal".
>
> Open Style&Formatting dialog, right-click cell style 'default', select
> 'New'. Enter a name for the new style in tab 'Organizer',e.g.
> 'myLabels'. In tab 'Numbers' select 'User-defined'. Then write the
> following into the input field 'Format'
>
> [=1]"malnutrition";[=2]"normal";[RED]Standard
>
> You can click on the "edit comment" icon to define an identifier for
> this format.
> Then click the green check mark to add it. OK.
> Now mark the area where you will enter the data and assign the newly
> created cell style.
>
> When you now enter a 1 into a cell, the input line shows a 1 and you can
> calculate with the content 1, but in the cell itself you will see
> 'malnutrition'.
>
> I have included the part [RED]Standard, so that all other numbers will
> be in red to show, that this entry is not correct.
>
> Find more about Format codes in the help.
>
> Kind regards
> Regina
>
>
> som schrieb:
> > 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