Freepages-Help-L ArchivesArchiver > Freepages-Help > 2010-09 > 1285455898
From: "Barry Carlson" <>
Subject: Re: [FreeHelp] Scrolling Table
Date: Sun, 26 Sep 2010 12:04:58 +1300
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.
> 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.
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.
> 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
versions of Internet Explorer. I suspect that from IE9+ it will not be
applied in that manner, the unsorted data would still be displayed in the
source code; the onscreen display is transparently modified by the script.