Re: [libreoffice-users] Help with LO Forms

Sorry, I wasn't being clear.

On the webpage at: 
https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base 
you  will find:

*Importing data to Base*
*You can import* text files, *spreadsheet files*, and your system 
address book in read-only mode only.
*When you import from a* text or*spreadsheet file, the file must have a 
first row of header information. The second row of the file is the first 
valid data row. The format of every field in the second row determines 
the format for the entire column. Any format information from a 
spreadsheet file gets lost when importing to Base.*
     For example, to ensure the first column has a text format, you 
must make sure that the first field of the first valid data row contains 
text. If a field in the first valid data row contains a number, the 
whole column is set to number format, and only numbers, no text, will be 
shown in that column.

*Open a Base file of the database type that you want.*
    Either create a new Base file using the Database Wizard, or open 
any existing Base file that is not read-only.
*Open the Calc file that contains the data to be imported to Base*. You 
can open a *.dbf dBASE file or many other file types.
*Select the data to be copied to Base*.
    You can enter a range reference like A1:X500 in the Name Box if you 
don't want to scroll.
    If you copy a dBASE sheet, include the top row that contains the 
header data.
*Choose Edit - Copy*.
*In the Base window, click Tables to view the tables.**
**    In the Base window, choose Edit - Paste.*
*You see the Copy Table dialog. Most databases need a primary key, so 
you may want to check the Create primary key box.**
*
    On Windows systems, you can also use drag-and-drop instead of Copy 
and Paste. Also, for registered databases, you can open the datasource 
browser (press F4) instead of opening the Base window.



On 2/16/2017 12:00 PM, Paul D. Mirowsky wrote:
> See 
> https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base 
> to do this.
>
>
> On 2/16/2017 11:52 AM, Robert Großkopf wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Hi Ian,
> > > I have a Spreadsheet of Data and I have prepared a Form in Writer
> > > to display and edit this information.
> > This won't work. You can't use a a table in Calc as a database and
> > edit this data in a form of the database or in a form of wirter.
> > Tables of a spreadsheet aren't editable in Base, You could only search
> > througt that data, filter them but can't change them.
> >
> > Regards
> >
> > Robert
> > - -- Homepage: http://robert.familiegrosskopf.de
> > LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v2
> >
> > iQIcBAEBAgAGBQJYpdizAAoJELDKYwaoS9AIRwMP/0OTzyPPWqhhDGIMN14MSDCo
> > XdxFFXAfmA3SN8RjYLSRHKFqs3ldPO/Qv27Ui2B5+87638r7ZpQ93NpysS8u7Kmx
> > vmkAbADxUqJoe+6T1Cx10D20yhp5pVimLTYEJZlqrAEK/KkwIRef8hnalhKNNLOa
> > rrGWuXNaKug5R8EUjChkgdA8lOUNhLiZ59IjSmDsU6mULU6zildQqVxzfd5Am2TO
> > EaNXrIseTe7v3v93oDnQK1GrN9bPldMp112PxYySB0Qgpqh26S7Qus0QLp4K4EED
> > 4soMG1A2L1FQXTpNdHO856WUaN8qnXPxdJ0mNBT9AeiK330XtHuEvczQ7sFwfVv4
> > B4yebHHPWXVuKPQbzCiZ7A1IrJdjmn1UW+ejTemLy4P4j3APEHObGxnC8c8ZfGvv
> > AqK63Ji59lZDQxBJEOnT3Woskk6kNuGOQWIjYwfDn0rtAqvt7Z3rq09VYLAEuO4G
> > Eg69LLYSC/h9aoUPdURC5w+/qXBTbw0jK+GC+NtX8UaGKpxwtj6S1HBRZ2aRioeV
> > oAdNFQEKRumtkoSAzPQbzHoAWd5Z+ZwoYcIo1j23v1p/QP1nEGwPks01LJiK7aO0
> > adAVjtn9k5oH4d4gtiJfAzk0pT2KaV/qlUoIgV0Im4lbAIgQrSUo8jdSDk/obZ0Y
> > spqFaDe4xoQWOv26EuFf
> > =EjGI
> > -----END PGP SIGNATURE-----


--
To unsubscribe e-mail to: users+unsubscribe@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