----Original Message---- From: [EMAIL PROTECTED] >Magnus wrote, >>I often use Calc as a simple database program and kepp a lot of lists >>(addresses, member >>lists, to-do's, accounting,...). I haven't looked trough every Calc chapter >>(only the outline), but I try to ask anyway. Is there a chapter/section >>somewhere in the Calc Guide (or elsewhere) describing the database >>possibilites >>in calc? (Filterring, sorting, grouping, subtotalling, data ranges, etc). >> >>If this does not exist (yet), should we have one? > >This is mentioned in the "Data Sources" chapter of the Getting Started >Guide, but not in detail. Otherwise, I don't know if it is planned to be >included somewhere in the Calc Guide. Rick, Peter, can you help here? It >sounds to me like something that should be in one of the guides. Of course >it might be something I don't recognise in the outline. > >Cheers, Jean
Well, Spreadsheets are mentioned in the Data Source chapter, but only that spreadsheets may be used as data source (or tables?) in the new Base application. At least as I have understood. I was talking about using Calc native spreadsheet as lists (a simple database) and the Data menu to manipulate the data in that list. Usually the top row of the spreadsheet is used as header and the remaining rows are used as records (one record - one row). The columns define the fields in each record. I recall a couple of days ago that I haven't seen it described anywhere in the OOoAuthor User Guides. Here at work we use this feature quite heavily (but in MS Excel...) e.g. for Action Lists and other kind of lists. Maybe it is too late to make big changes in the Calc outline, but I suggest to have it described somewhere in the Calc Guide (but of course someone (Jean, Rick, Peter?) have to decide if it is appropriate or not to get it described). And of course I do volonteer to write that chapter/section, if it is not written yet. :-) :-) (And I do not get mad if it is decided not to include this feature in the guides :-) ) Best regards Magnus
