Re: Automatic text generation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Paul Smith wrote:
On 3/17/07, Peter Larsen <plarsen@xxxxxxxxxxxxxxxxxxxxxxx> 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??

Regards
  Peter Larsen

[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux