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 <villeroy@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+help@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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.