Am 10.09.2012 18:56, JAMES MAJESKI wrote:
The following is a reply to my query from a private source:
Data bases are for fixed data columns and standardized input methods and
require manipulation by sql type query tools. Unless you are getting
automatic feeds of significant amounts of data from your world wide
operations I don't see what it would do for you. If you are putting together
a business then a data base would be a good thing even if it is simple, but
those are available pre-canned and some are open source. Unless you are
doing something far more complex than I imagine spread sheets should serve
you well and spread sheets have reporting capabilities.
You want a standardized input method to generate text files with ISO
dates. Unlike its users, a spreadsheet does not care about formatting
attributes. The only thing that really counts is the cell value.
Databases are designed to do what most of today's spreadsheet users try
so desparately try to do in spreadsheets. Databases are ubiquitous
online and offline.
Valid CSV files are exported from databases and they are destined to be
imported back into other databases. Each row represents a record, each
record has the same amount of fields, each field has a distinct data type.
A spreadsheet has no records nor fields and the only data types are
text, number and boolean (in Calc even the booleans are numbers).
There are various ways to load csv into a spreadsheet so you can process
the imported data by means of spreadsheet formulas. Simple statistics,
projections, what-if-scenarios are the most typical spreadsheet
applications based on database data. You pull it into a sheet and let
the spreadsheet do what spreadsheets use to do (which is not text editing).
Base is our database component. It is very, very underdeveloped,
nevertheless underestimated. Even the worst database tool does a better
database job than the best spreadsheet can do.
For unsubscribe instructions e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: 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