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+h...@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
