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


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: 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.