Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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.