[libreoffice-users] Re: How to.. sort a table in 3 columns

On 10/18/2015 8:02 AM, Andreas Säger wrote:
> Am 18.10.2015 um 12:36 schrieb william drescher:
>
> > > Operating system?
> >
> > Windows 7
> > > Office version?
> > > Office component? Writer? Calc? Base?
> > I'll use whatever I need
> > > File format? doc, docx, odt, ods, xls, odb?
> > odt or ods
> > > I don't understand how you want to dump 2 fields into 3 columns?
> >
> > Location    item      location    item      location  item
> >     1     widget         9     vebelfetzer   13    nails, 10p
> >     1     screws, 8x1     10    L. widget     24 nailsm 16p
> >
> > > The term "pick list" is unclear. Listbox? Writer field of type "input
> > > list"?
> >
> > a pick list is a lit of items to be picked and packed for an order
> > >
> > bill
>
> 1) Store your list data in some kind of simple database:
> Having the 2-column list in a text file (*.csv or *.txt), open the file
> with Calc.
> Having the 2-column list in a spreadsheet, make sure that the A1 and B1
> contain the words "Location" and "Item" as column labels and that all
> locations are numbers (Ctrl+F8 highlights numbers in blue).
> Save the spreadsheet in a separate directory as a dBase file:
> menu:File>SaveAs...
> Navigate to your preferred directory, add a new directory, visit the new
> directory
> menu:File Type:dBase(*.dbf)
> This file format gives various advantages for every day use.
> --------------------------------------
> 2) Connect your database to the office suite:
> File>New>Database...
> [x] Connect to existing database
> Type: dBase
> Point to the directory
> [X] Yes, register the database
> Save the database document (*.odb) in that directory or elsewhere.
> ---------------------------------------
> 3) Generate a dynamic report in columnar layout:
> Click the tables container.
> Right-click the table therein, call the report wizard and create a
> tabular report with a 3-column layout and the right sort order.
> --------------------------------------
> What is this "database document"?
> Your database table is a _link_ to your dBase file. The database
> document (*.odb) does not store any data. It represents the contents of
> the dBase files in the given directory as a collection of database
> tables. Your data are in the dBase file or any additional dBase files
> stored in that directory.
> Since you registered this data source you have quick access to your list
> without opening anything. Just hit F4 in Writer or Calc.
> The report is a Writer document embedded in that database file. It is
> filled with table data every time you open the report. You can store
> snapshots of this report at any time simply saving the embedded Writer
> document as a stand-alone document or as PDF.

Thank you.
bill
>



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