Drew Jensen wrote: > Andreas Saeger wrote: >> Writer Calc Base Impr Draw Math >> DEN 57% 26% 6% 6% 3% 3% >> FRA 37% 32% 21% 7% 3% 1% >> GER 49% 30% 12% 5% 2% 1% >> NOR 68% 17% 6% 6% 3% 0% >> ooof 50% 30% 14% 2% 3% 2% >> >> >> More than all the others, French fellows seem to be interested in tables. >> >> >> > > 3 of the sites pre-date Base from 2-3 years - so if we toss those and > add the User Comm Forum > > Writer Calc Base Impr Draw Math > UCF 47% 26% 17% 8% 2% 1% > FRA 37% 32% 21% 7% 3% 1% > NOR 68% 17% 6% 6% 3% 0%
The French community discusses more Calc and Base topics, less Writer topics. I believe the French community is technically more advanced. Some of them try harder to get more, whereas a group of less savvy users are interested mainly in Writer (everybody knows word processors), use spreadsheets for all kinds of list processing and disregard Base. Base leaves you alone with an empty container after creating a new database. The table wizzard creates unrelated tables. The Bibliography example is limited due to it's dBase nature. Table "biblio" has nothing to offer beyond a spreadsheet's capabilities. Back to Calc where you can type anything into the given grid, just like you would on a sheet of paper. Well, if you do so you almost certainly run into spreadsheet trouble. Extract from the recent top 40 in the Calc forum http://www.oooforum.org/forum/viewforum.phtml?f=3 > http://www.oooforum.org/forum/viewtopic.phtml?t=67638 SOLVED: Multiple Vlookup search ? > http://www.oooforum.org/forum/viewtopic.phtml?t=67663 Data Input Form > http://www.oooforum.org/forum/viewtopic.phtml?t=67607 Using a formula inside > a link > http://www.oooforum.org/forum/viewtopic.phtml?t=67541 MATCH function on > multiple querys ? > http://www.oooforum.org/forum/viewtopic.phtml?t=66406 how to create receipts > / invoices from a spreadsheet? > http://www.oooforum.org/forum/viewtopic.phtml?t=66285 Dates displayed as > numbers in a Drop List There have been times when 20 to 30% of recent Calc-topics deal with - Wrong results due to numeric strings hidden in between numbers. - Wrong range of cells gets sorted (including header, excluding columns) - All kinds of troubles with filters - eliminate duplicates - foreign keys - input forms - csv processing - "lookup-relations" in ../Sales/Europe/December\ 2007.xls - performance, limited count of rows/columns/sheets - macro to unprotect>check input>insert>copy relation>timestamp>protect This is where Base could gain thousands of users within a few months after 3.0 release, if there where some advanced examples of what you can do with Base together with some knowlege on relations and SQL (less efford than mastering any spreadsheet's formula language and macros). I gave up trying. I can do anything in SQL view, I understand the meaning of error messages, but I encountered too many limitations and an unsafe container format. If I had to implement a relational database today, I would start with anything but Base, keeping connectivity in mind. Base feels like a car, built in a shipyard. Takes some time to let the water run off before you can open the door (without keys) just to find out that the rusty steer wheel is on the other side. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
