Re: [libreoffice-users] Re: database or spreadsheet

On 2/7/2012 5:08 PM, Dan Lewis wrote:
> spreadsheet. Also, what about saving each sheet of the spreadsheet as 
> a dBase file? --Dan 

Yes, in Calc row 1 is usually a set of fields defined (headers) by there 
type within a sheet (single tab). This is the table.

The essence already exists.  When copying/importing data to Base from 
Calc, it request whether or not the first line
is a definition. In a "save as Base" scenario, it is assumed, but is 
checked for:
Field Undefined - Row 1 column X is blank - cannot save as Base
Field Undefined - Row 1 column X is formatted as (Date,Number,Text, 
Etc..) Are you sure you wish to continue?
If it passes the test, the table is defined.

The crux of the problem is an engine that redefines references, formulas 
and query ranges in Calc to SQL as they become the Base Queries.






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