Re: [libreoffice-users] Number comparisons in conditional text

2016-05-08 Thread Gary Dale
The first option is what I have been doing - it uses a calc file to drive a mailing list. The logic is in the document, not in the calc file, so that I can bring in new data without a lot of effort - the raw data can just be a .csv file. The second option, using a "smart" calc file, moves the

Re: [libreoffice-users] Number comparisons in conditional text

2016-05-08 Thread Bruce Hohl
Gary, See attached for a working case when in LO Base. You do have to be very careful when using Base Queries (SQL) that everything is exactly correct like where commas are placed (or not) and how quotes / half quotes are used (or not). So setting this up in Base will likely take more time than

[libreoffice-users] Base-Conect an external spreadsheet data

2016-05-08 Thread jorge
Good night, hi all: I have two options when I conect to a external spreadsheet data with BASE: 1) Conect with the third option when start the wizard selecting: spreadsheet. In this case we can import the structure and data from it. The first options is keep the conections with the

Re: [libreoffice-users] Number comparisons in conditional text

2016-05-08 Thread Gary Dale
Thanks Bruce. I appreciate the help. I was trying values from a table that translates age ranges into text. I hate hard coding numbers, let alone the number of ranges, because I handle events for two different groups who have their own definitions. They used to be encoded in the different