cell.lookup.html 4.16 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="X-UA-Compatible" content="IE=Edge"/>
    <meta http-equiv="Pragma" content="no-cache">
    <meta http-equiv="Expires" content="-1">
    <meta content="text/html;charset=utf-8" http-equiv="Content-Type">
    <meta content="utf-8" http-equiv="encoding">
    <title>jQuery.sheet - The Ajax Spreadsheet</title>
    <script type="text/javascript" src="../jquery-1.10.2.min.js"></script>
    <script type="text/javascript" src="https://rawgithub.com/Spreadsheets/formula/master/formula.js"></script>
    <script type="text/javascript" src="../jquery.sheet.js"></script>
    <script type="text/javascript">
        $.sheet.preLoad('../');
        $(function() {
            var data = tsv.parse("Density	Viscosity	Temperature\n\
0.457	3.55	500\n\
0.525	3.25	400\n\
0.616	2.93	300\n\
0.675	2.75	250\n\
0.746	2.57	200\n\
0.835	2.38	150\n\
0.946	2.17	100\n\
1.09	1.95	50\n\
1.29	1.71	0"),
                    table = document.createElement('table'),
                    tr,
                    td,
                    row,
                    col;

            table.setAttribute('title', 'Lookup Data');

            while(data.length) {
                row = data.shift();
                tr = document.createElement('tr');
                table.appendChild(tr);
                while(row.length) {
                    col = row.shift();
                    td = document.createElement('td');
                    td.innerHTML = col;
                    tr.appendChild(td);
                }
            }
            $('#sheetParent')
                    .append(table)
                    .sheet();
        });
    </script>
</head>
<body>
<div id="sheetParent" title="Cell Lookup">
    <table title="Test">
        <tr>
            <td class="styleBold styleCenter">Function</td>
            <td class="styleBold styleCenter">Execution</td>
            <td class="styleBold styleCenter">Desired Result</td>
            <td class="styleBold styleCenter">Correct?</td>
            <td class="styleBold styleCenter">Notes</td>
        </tr>
        <tr>
            <td>VLOOKUP</td>
            <td data-formula="VLOOKUP(1,SHEET2!A2:C10,2)"></td>
            <td>2.17</td>
            <td data-formula="IF(THISROWCELL('B') = THISROWCELL('C'), TRUE, FALSE)"></td>
            <td></td>
        </tr>
        <tr>
            <td>VLOOKUP</td>
            <td data-formula="=VLOOKUP(1,SHEET2!A2:C10,3,TRUE)"></td>
            <td>100</td>
            <td data-formula="IF(THISROWCELL('B') = THISROWCELL('C'), TRUE, FALSE)"></td>
            <td></td>
        </tr>
        <tr>
            <td>VLOOKUP</td>
            <td data-formula="=VLOOKUP(0.7,SHEET2!A2:C10,3,FALSE)"></td>
            <td></td>
            <td data-formula="IF(THISROWCELL('B') = THISROWCELL('C'), TRUE, FALSE)"></td>
            <td></td>
        </tr>
        <tr>
            <td>VLOOKUP</td>
            <td data-formula="VLOOKUP(0.1,SHEET2!A2:C10,2,TRUE)"></td>
            <td>1.71</td>
            <td data-formula="IF(THISROWCELL('B') = THISROWCELL('C'), TRUE, FALSE)"></td>
            <td></td>
        </tr>
        <tr>
            <td>HLOOKUP</td>
            <td data-formula="HLOOKUP('Density',SHEET2!A1:C10,2,TRUE)"></td>
            <td>0.457</td>
            <td data-formula="IF(THISROWCELL('B') = THISROWCELL('C'), TRUE, FALSE)"></td>
            <td></td>
        </tr>
        <tr>
            <td>HLOOKUP</td>
            <td data-formula="HLOOKUP('Viscosity',SHEET2!A1:C10,1,TRUE)"></td>
            <td>Viscosity</td>
            <td data-formula="IF(THISROWCELL('B') = THISROWCELL('C'), TRUE, FALSE)"></td>
            <td></td>
        </tr>
        <tr>
            <td>HLOOKUP</td>
            <td data-formula="HLOOKUP('Temperature',SHEET2!A1:C10,6,TRUE)"></td>
            <td>200</td>
            <td data-formula="IF(THISROWCELL('B') = THISROWCELL('C'), TRUE, FALSE)"></td>
            <td></td>
        </tr>
        <tr>
            <td>HLOOKUP</td>
            <td data-formula="HLOOKUP('Test',SHEET2!A1:C10,2,TRUE)"></td>
            <td></td>
            <td data-formula="IF(THISROWCELL('B') = THISROWCELL('C'), TRUE, FALSE)"></td>
            <td></td>
        </tr>
    </table>
</div>
</body>
</html>