🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.framemaker.sgml
Article #1510

Re: Table Sorting

#1510
From: PamelaOwens
Date: Thu, 29 Jun 2006 13:44
31 lines
3156 bytes
This is all I could find and it was no help (except that I was able to figure out that in my table it was treating the hyphen as a minus sign): Adobe\FrameMaker7.2\help\help.html
Sorting columns and rows

You can rearrange the cells of columns or rows into either ascending or descending order. Ascending order sorts from the beginning of the alphabet or the lowest number; descending order sorts from the end of the alphabet or the largest number.

Original table (left) and sorted by first column (right)
When sorting numbers, text is sorted after numbers, but dollar signs and other symbols are ignored, and negative signs are significant. For example, -9 or (9) sorts before 9 in an ascending sort.

You can sort dates or times as long as they are entered as text, use a consistent format, and include leading zeros. For example, if you're using dd/mm/yy and hh:mm:ss formats, enter 04/12/01 or 09:30:25.

To sort a table:

Save your document, so that you can revert to your last saved version if the sort gives unexpected results.
Make sure there are no hidden conditional rows in the table (use Special > Conditional Text).
Do one of the following:
To sort all columns or all rows in a table, click anywhere in the table.
To sort only certain rows, select cells in the rows you want to sort.
Choose Table > Sort.
If you're sorting all rows or all columns, click Select All Body Rows.
Do any of the following:
To sort the rows of the table, click Row Sort. If the rows contain heading or footing cells as well as body cells, only the body cells will be sorted.
To sort the columns of the table, click Column Sort.
To sort uppercase letters apart from lowercase letters, select Consider Case.

Ascending sort with and without Consider Case selected
Choose a primary sort key by selecting from the Sort By text box and clicking Ascending Sort or Descending Sort.
You may sort straddle cells as long as they don't extend past a row or column that you're using as a sort key. (Use Table > Unstraddle and try again.)

Optionally, choose a second and third sort key from the Then By areas.
Click Sort.
Note: FrameMaker will correctly sort numbers preceded by the special symbols ()+-,. and $. However, combining several of these symbols in a cell may adversely affect sorting. For example, a table cell containing -2 will fall correctly between -1 and -3, but a cell containing -2+3 will not (it will be interpreted as -23).
Technical Details
Message-ID: <3bc0c25b.0@webcrossing.la2eafNXanI>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed-east.nntpserver.com!nntpserver.com!statler.nntpserver.com!news.glorb.com!syros.belnet.be!news.belnet.be!news.stben.net!webcrossing
References: <3bc0c25b.-1@webcrossing.la2eafNXanI>

Show Full Headers
Complete Article Headers
X-Google-Thread: fcc08,c52fba7dca235a0f
X-Google-Attributes: gidfcc08,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: PamelaOwens@adobeforums.com
Newsgroups: adobe.framemaker.sgml
Subject: Re: Table Sorting
Message-ID: <3bc0c25b.0@webcrossing.la2eafNXanI>
Date: Thu, 29 Jun 2006 06:44:41 -0700
References: <3bc0c25b.-1@webcrossing.la2eafNXanI>
Lines: 53
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed-east.nntpserver.com!nntpserver.com!statler.nntpserver.com!news.glorb.com!syros.belnet.be!news.belnet.be!news.stben.net!webcrossing