Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread David Robley
Assuming you have a list of the numbers and associated text in separate adjacent columns, you would use VLOOKUP. There is a VLOOKUP tutorial at https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=46746 On 19/2/20 8:08 pm, Andrea Vt wrote: Thank you David for the question I use calc to

Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread Andrea Vt
Thank you David for the question I use calc to extract numbers which ha a meaning ... My english is not very good - is it clear now? :-) Am 19.02.2020 um 10:32 schrieb David Robley: In which component of OpenOffice are you needing to do this? You seem to be using inadequate, or insufficient,

Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread David Robley
In which component of OpenOffice are you needing to do this? You seem to be using inadequate, or insufficient, words here also. On 19/2/20 7:52 pm, Andrea Vt wrote: Text in the or another field doesn't matter Am 19.02.2020 um 10:19 schrieb Andrea Vt: Hello world :-) I decided to send two mes

Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread Andrea Vt
Sorry for typo: ... in the same or ... Am 19.02.2020 um 10:22 schrieb Andrea Vt: Text in the or another field doesn't matter Am 19.02.2020 um 10:19 schrieb Andrea Vt: Hello world :-) I decided to send two message because .. I hit send to early *rotfl* Question 2: How can I show a text,

Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread Andrea Vt
Text in the or another field doesn't matter Am 19.02.2020 um 10:19 schrieb Andrea Vt: Hello world :-) I decided to send two message because .. I hit send to early *rotfl* Question 2: How can I show a text, depending on a number. E.g. 1 -> "That's one" 2 -> "First digit of e" 3 -> "Less t