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

On Tue, 2012-02-07 at 22:59 +0100, Andreas Säger wrote:
Am 07.02.2012 21:58, Paul D. Mirowsky wrote:
I hope to to condense and reply to all.

A person has spent arduous hours of entering/linking/formula-ing etc...
on spreadsheets.
It is not the optimum of data entry, as would be a database form. But it
does do every thing they want it to.

The majority of today's computer/tablet/phone users will never be able 
to manage data properly in this way.

Now, if a translation Calc (spreadsheet) to Base (database SQL)
generated the the database, they would only have to make the data entry

There is no "translation" from spreadsheet to SQL. It is an import 
process of the raw data into your own data structures which are analog 
to a user defined file format. I have done this dozends of times. It has 
nothing to do with plain copy&paste or save as <other file type>. A 
database knows a dozend of data types. Calc knows only two types of data.
Input forms are the second step.

Yes, this is an overly simplistic view, but it is what is being asked
for by most.

Yes, they only describe of what they want to have. They do not waste any 
thought on what they already have and what it takes to make something 
useful with what they have.
All these questions are about software features that exist in that 
software but not in this one.
They can not work with software tools. Instead they expect that the 
tools do their work automagically.
They never show their actual data material (lengthy complaints about 
Calc's csv import options without pasting a single line of the text data 
to import).

     A spreadsheet (Calc or Excel ) cab be used as a back end data
source and Base as the front end. How does this fit into this
     Remember that Base will only create queries and reports from the
spreadsheet. Neither fields, views, nor tables can be created, modified,
or deleted. All of these types of changes must be done in the
     Also, what about saving each sheet of the spreadsheet as a dBase


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.