Article View: adobe.framemaker.sgml
Article #1510Re: Table Sorting
From: PamelaOwens
Date: Thu, 29 Jun 2006 13:44
Date: Thu, 29 Jun 2006 13:44
31 lines
3156 bytes
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!webcrossingReferences:
<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