On 10/18/2015 8:02 AM, Andreas Säger wrote:
Am 18.10.2015 um 12:36 schrieb william drescher:
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
a pick list is a lit of items to be picked and packed for an order
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
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:
Navigate to your preferred directory, add a new directory, visit the new
This file format gives various advantages for every day use.
2) Connect your database to the office suite:
[x] Connect to existing database
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: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy