You bring up something that I have been wondering about. I use Calc for several reasons
- I know Calc fairly well and know nothing about Base. - I Copy from the Internet and Paste directly into a spreadsheet. Is it possible to Copy from the Internet when the Internet has the data in a spreadsheet and Paste directly into Base? Is it possible to extract data from Base in such a way that the data is processed the same way as if the data was on a Calc spreadsheet? Is it possible to use templates to extract data from Base? Walter Denver Colorado On Sat, Oct 3, 2009 at 1:20 PM, Andreas Saeger <[email protected]>wrote: > Walter Hildebrandt wrote: > >> Another condition is that both columns A and B are "compacted" at the top >> of >> the columns. >> >> If there are 10 words in either column A or B, then these words will >> appear >> in rows 1 through 10. >> >> If there are 10 words in column A and 100 words in column B, then column A >> will have the words in rows 1 through 10 and column B will have the words >> in >> rows 1 through 100 >> >> > Hi, > Calc is named Calc since spreadsheets are calculators in the first > place. > Everything related to row sets belongs to databases. Spreadsheets are quite > insufficient surrogates for databases > SELECT "Words" FROM "List 1" UNION SELECT "Words" FROM "List 2" > gives unique words from both lists. > > SELECT "List 1"."Words" FROM "List 1","List 2" WHERE "List 1"."Words"="List > 2"."Words" > lists all words from first list having an equivalent in the second list. > > SELECT-queries return a list derived from other lists in any order of rows > and columns. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
