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

On 10/17/2015 10:37 AM, Andreas Säger wrote:
> Am 16.10.2015 um 22:02 schrieb william drescher:
> > I have a list that has two fields: aisle and item.  I need to maintain
> > the list sorted by item, but print a pick list by aisle.  This would be
> > simple except, when I print the list for marking I need to print it in
> > item order, in 3 columns.  When I print the pick list I again need to
> > print it in 3 columns, sorted by item,
> >
> > Right now I am sorting the list by aisle and manually cutting and
> > pasting it into 3 columns.  I currently have the data in a spreadsheet.
> >
> > I tried using frames set for 3 columns, but when past the sorted list
> > into the frames it does not spill over onto the 2nd and 3rd columns.
> >
> > I would appreciate suggestions.
> >
> > Thanks,
> >
> > bill
>
> 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



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