Freepages-Help-L Archives

Archiver > Freepages-Help > 2010-09 > 1285455898


From: "Barry Carlson" <>
Subject: Re: [FreeHelp] Scrolling Table
Date: Sun, 26 Sep 2010 12:04:58 +1300
References: <4C975A10.2030307@swbell.net><6F560DF74F0A491AB85E58C614C381AC@BERT><BLU0-SMTP99A9B4FBAF66832E53F19ED37E0@phx.gbl><E7C31E1DAC89421C83D8C56AAFD6ED0A@BERT><BLU0-SMTP8795A6E79F3B8F9503BDDFD3630@phx.gbl>


On Sunday, September 26, 2010 1:14 AM (UTC+12)
Ian Singer wrote:-

> Thanks I see the final result which is correct, except all the *
> designators have been stripped, so I guess they would be better at the end
> of each item in the list.

The spreadsheet data will not sort if the * designators are before a word.
Have since used some formula to place them after the text.

http://countjustonce.com/singer-li.html

> I do not understand though what you are putting in Excel and how you
> manipulate it. I can not see putting three columns in Excel and then
> sorting on a blank one. Does the Excel also contain all the HTML and if so
> how are you sorting on just the name and ignoring the URL unless you are
> also running multiple columns and concatenating them? Reply off list if
> you prefer.

I've created a small table showing the 3 columns as in the spreadsheet.

http://countjustonce.com/singer-layout.html

Column B has all the names in it, and Column A has <li><a href=""> and
Column C just has </a></li> in it. The areas colored red are not sorted,
e.g. to add ABC Tools Inc., just click on any row in the existing A section
and select Insert Row. Copy Down data in Column A and C, then modify the url
in Coumn A. Go to Column B and add ABC Tools Inc.. Now hightlight all the
rows in the A data section, select Data / Sort and nominate to sort the rows
on Column B. Just do the same in any other section, and when completed,
highlight and copy all the data in the 3 columns into your html file.

> Once the list is generated does it still need the javascript and CSS and
> if so why?

The CSS is being used to format the page, and there is no way I would try to
get a list to align and sequence itself as you want without using CSS. The
javascript is required to get CSS to operate correctly in all existing
versions of Internet Explorer. I suspect that from IE9+ it will not be
required. Javascript is not used in the sorting of data, and if it had been
applied in that manner, the unsorted data would still be displayed in the
source code; the onscreen display is transparently modified by the script.

Barry

This thread: