Excel Functions
// test function when the user scrolls down 20px from the top of the document, show the button
window.onscroll = function() {scrollFunction()};
function scrollFunction() {
if (document.body.scrollTop > 20 || document.documentElement.scrollTop > 20) {
document.getElementById("myBtn").style.display = "block";
} else {
document.getElementById("myBtn").style.display = "none";
}
}
// test function When the user clicks on the button, scroll to the top of the document
function topFunction() {
document.body.scrollTop = 0; // For Safari
document.documentElement.scrollTop = 0; // For Chrome, Firefox, IE and Opera
}
function clear_search()
{
document.getElementById("find_it").value = "";
}
function find_function()
{
// get the entered function
input_function = document.getElementById("find_it");
// convert input function string to upper case
input_function = input_function.value.toUpperCase();
// get HTML of all rows
function_table = document.getElementById("excel_table");
var function_rows = new Array();
function_rows = function_table.getElementsByTagName("tr");
function_html = function_rows.innerHTML;
// find matching function by row number
var found_function = 0;
var found_rows = new Array();
var j = 0;
for (var i = 0; i < function_rows.length; i++)
{
// look for the search string by searching each row
search_html = function_rows[i].innerHTML.toUpperCase();
if (search_html.search(input_function) >= 0)
{
// save the row numbers of the found function since it can be contained in multiple rows
// found_rows array holds the row numbers of the matching rows
found_rows[j] = i; j++;
}
}
// display first matching row
for (var i = 0; i < found_rows.length; i++)
{
j = found_rows[i];
function_rows[j].scrollIntoView();
break;
}
// no matches found
if (found_rows.length == 0)
{
document.getElementById("find_it").value = "NOT FOUND";
}
}
function print_selected()
{
// load array with the INPUT tag information for each check box
var checkbox_list = new Array();
checkbox_list = document.getElementsByTagName("input");
// check if user selected any function groups to print
var printstuff = false;
for (var i = 0; i < checkbox_list.length; i++)
{
if (checkbox_list[i].type == 'checkbox')
{
if (checkbox_list[i].checked)
{
printstuff = true;
}
}
}
// if user didnt select any function groups to print, print everything
if (printstuff == false)
{
for (var i = 0; i < checkbox_list.length; i++)
{
if (checkbox_list[i].type == 'checkbox')
{
checkbox_list[i].checked = true;
}
}
}
// load array with the TR tag information for each function row
var function_rows = new Array();
function_table = document.getElementById("excel_table");
function_rows = function_table.getElementsByTagName("tr");
for (var i = 0; i < checkbox_list.length; i++)
{
if (checkbox_list[i].type == 'checkbox')
{
// if the button for the group of functions is checked, process only those that are selected
if (checkbox_list[i].checked == true)
{
// process all of the rows in the table
for (var j = 0; j < function_rows.length; j++)
{
// change the print status to on for each of the functions within the checked group
// if the function_rows class matches the checkbox_list id
if (checkbox_list[i].id == function_rows[j].className)
{
function_rows[j].className = "printon";
}
}
}
}
}
// set print status to off for any rows that are not set to on, start at 1 so that the header row is not turned off
for (var j = 1; j < function_rows.length; j++)
{
if (function_rows[j].className != "printon")
{
function_rows[j].className = "printoff";
}
}
window.print();
}
function print_all(status)
{
// status sent from calling function, TRUE to check all boxes, FALSE to uncheck all boxes
var checkboxes = new Array();
checkboxes = document.getElementsByTagName('input');
for (var i = 0; i < checkboxes.length; i++)
{
if (checkboxes[i].type == 'checkbox')
{
checkboxes[i].checked = status;
}
}
}
function change_button(n)
{
// change button text
var buttonnum = n;
if (buttonnum == 0)
{
// change the button text to indicate that sorting is in progress
document.getElementById("type_sort").innerText = "Sorting...";
}
if (buttonnum == 1)
{
// change the button text to indicate that sorting is in progress
document.getElementById("function_sort").innerText = "Sorting...";
}
}
function change_button_back(n)
{
// change button text back after sort
var buttonnum = n;
if (buttonnum == 0)
{
// change the button text to indicate sorting is done
document.getElementById("type_sort").innerText = "Sort by Type";
}
if (buttonnum == 1)
{
// change the button text to indicate sorting status
document.getElementById("function_sort").innerText = "Sort by Function";
}
}
function change_cursor(id, cursor_type)
{
// change cursor
var elem;
if (document.getElementById && (elem=document.getElementById(id)) )
{
if (elem.style) elem.style.cursor=cursor_type;
}
}
function custom_cursor(id, cursor_file)
{
// custom cursor
var elem;
if (document.getElementById && (elem=document.getElementById(id)) )
{
if (elem.style) elem.style.cursor=cursor_file;
}
}
function sort_table(n)
{
// change_button(n);
var table, rows, switching, i, x, y, shouldSwitch, dir, switchcount = 0;
table = document.getElementById("excel_table");
switching = true;
// Set the sorting direction to ascending:
dir = "asc";
/* Make a loop that will continue until no switching has been done: */
while (switching)
{
// Start by saying: no switching is done:
switching = false;
rows = table.getElementsByTagName("TR");
/* Loop through all table rows (except the first, which contains table headers): */
for (i = 1; i < (rows.length - 1); i++)
{
// Start by saying there should be no switching:
shouldSwitch = false;
/* Get the two elements you want to compare, one from current row and one from the next: */
x = rows[i].getElementsByTagName("TD")[n];
y = rows[i + 1].getElementsByTagName("TD")[n];
/* Check if the two rows should switch place, based on the direction, asc or desc: */
if (dir == "asc")
{
if (x.innerHTML.toLowerCase() > y.innerHTML.toLowerCase())
{
// If so, mark as a switch and break the loop:
shouldSwitch= true;
break;
}
}
else if (dir == "desc")
{
if (x.innerHTML.toLowerCase() < y.innerHTML.toLowerCase())
{
// If so, mark as a switch and break the loop:
shouldSwitch= true;
break;
}
}
}
if (shouldSwitch)
{
/* If a switch has been marked, make the switch and mark that a switch has been done: */
rows[i].parentNode.insertBefore(rows[i + 1], rows[i]);
switching = true;
// Each time a switch is done, increase this count by 1:
switchcount ++;
}
else
{
/* If no switching has been done AND the direction is "asc", set the direction to "desc" and run the while loop again. */
if (switchcount == 0 && dir == "asc")
{
dir = "desc";
switching = true;
}
}
}
// change_button_back(n);
}