Exactly Tom. With Calc, setup cost and time is next to zero, with data
entry not much more. With Base setup cost and time is non-negligible
and data entry is much more time (and therefore real dollar cost)
consuming as each field needs to be filled in by hand when using a
form. With a spreadsheet I can actually cut & paste the info. from a
website directly into Calc. Can that be done with Base?
Seems to me that the best solution even if using a database is to first
enter into a spreadsheet where it can then be saved as a file of CSV and
then imported into a database should I find the need.
Bottom line is it's already done in Calc - took about a minute - while
doing it in Base requires sitting down and spending time and money on
first creating a schema with forms and further, one needs to be a master
of SQL which most people including myself are not. (Inner joins, outer
joins, left right... haven't a clue. Cut & paste? click, drag,
shift-click, click, done, repeat as needed - no higher brain power
required.)
In theory a database is more elegant and conceptually appealing, but in
practice a spreadsheet IMHO wins the day. YMMV.
On 7/22/2012 7:19 AM, Tom Davies wrote:
Hi :)
That is true. So why not use the fastest route to get the required result and stick with
spreadsheeting for now? Definitely a good idea to start vaguely thinking about moving to a
database program when time&resources permits. Base is not yet ready for masses and does
take some fairly considerable expertise "to get it right". Set-up is not trivial
even if some people find it easy.
Regards from
Tom :)
--- On Sun, 22/7/12, Andreas Säger <ville...@t-online.de> wrote:
<snip />
Please ignore Tom. He is very kind but totally ignorant towards LibreOffice
Base which can read spreadsheet data as if they were database data.
<snip />
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted