Automatic text generation

[Paul Smith]

On 3/17/07, Peter Larsen <plarsen at famlarsen.homelinux.com> wrote:
> >> Why not simply use the spreadsheet to do this?
> >> You can calculate a text string as well as a nummeric result.
> >> In open office, use concatenate, and then hlookup for each field.
> >>
> >> Create a list with the text corresponding to your nummeric value. Give
> >> it a heading (very important) for instance "Text". Use hlookup to find
> >> the text based on an index (your value) - and remember to add 1, as the
> >> header is row #1. Then simply concatenate the dlookup results for each
> >> column, add spaces if you need. That'll result in a column with text
> >> that corresponds to your number.
> >>
> >> I have a small example spreadsheet here, I can mail you if you're
> >> interested.
> >
> > Thanks to all. Yes, I thought about using the spreadsheet itself, as
> > you suggest. The problem is that the resulting text for each line may
> > be too long and easily visible. Can this be circumvented?
>
> Too long? How much text can each number represent? From my reading,
> everything was to fit on one line, so the length would be limited??

I was not surely enough clear and I am sorry because of that. Each
number may represent strings with 30 characters, and I may have more X
variables.

Paul