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

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.


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