1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
4 <meta http-equiv="content-type" content="text/html; charset=utf-8">
5 <link rel="shortcut icon" type="image/ico" href="http://www.sprymedia.co.uk/media/images/favicon.ico">
7 <title>FixedColumns example</title>
8 <style type="text/css" title="currentStyle">
9 @import "../../media/css/demo_page.css";
10 @import "../../media/css/demo_table.css";
11 td.indexLeft { background-color: white; border-right: 1px solid black; }
12 td.indexRight { background-color: white; border-left: 1px solid black; }
13 div.DTFC_LeftHeadWrapper th,
14 div.DTFC_RightHeadWrapper th {
15 border-bottom: 1px solid white !important;
17 div.DTFC_LeftFootWrapper th,
18 div.DTFC_RightFootWrapper th {
19 border-top: 1px solid white !important;
22 <script type="text/javascript" charset="utf-8" src="../../media/js/jquery.js"></script>
23 <script type="text/javascript" charset="utf-8" src="../../media/js/jquery.dataTables.js"></script>
24 <script type="text/javascript" charset="utf-8" src="media/js/FixedColumns.js"></script>
25 <script type="text/javascript" charset="utf-8">
26 $(document).ready( function () {
27 var oTable = $('#example').dataTable( {
29 "sScrollXInner": "150%",
30 "bScrollCollapse": true,
31 "fnDrawCallback": function ( oSettings ) {
32 /* Need to redo the counters if filtered or sorted */
33 if ( oSettings.bSorted || oSettings.bFiltered ) {
34 for ( var i=0, iLen=oSettings.aiDisplay.length ; i<iLen ; i++ ) {
35 this.fnUpdate( i+1, oSettings.aiDisplay[i], 0, false, false );
36 this.fnUpdate( i+1, oSettings.aiDisplay[i], 6, false, false );
41 { "bSortable": false, "sClass": "indexLeft", "aTargets": [ 0 ] },
42 { "bSortable": false, "sClass": "indexRight", "aTargets": [ -1 ] }
44 "aaSorting": [[ 1, 'asc' ]]
47 new FixedColumns( oTable, {
54 <body id="dt_example">
56 <div class="full_width big">
57 FixedColumns example - left and right columns fixed
61 <p>FixedColumns allows columns to be fixed from both the left and right hand sides of the table. Fixing right hand-side columns is done by using the <i>iRightColumns</i> initialisation parameter, which works just the same as <i>iLeftColumns</i> does for the left side of the table. This example shows both the left and right columns being fixed in place, and a bit of initialisation of DataTables to provide index columns.</p>
65 <table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
68 <th width="3%"> </th>
69 <th>Rendering engine</th>
72 <th>Engine version</th>
74 <th width="3%"> </th>
79 <th width="3%"> </th>
80 <th>Rendering engine</th>
83 <th>Engine version</th>
85 <th width="3%"> </th>
90 <td class="center">1</td>
95 <td class="center">4</td>
96 <td class="center">X</td>
97 <td class="center">1</td>
100 <td class="center">2</td>
105 <td class="center">5</td>
106 <td class="center">C</td>
107 <td class="center">2</td>
110 <td class="center">3</td>
115 <td class="center">5.5</td>
116 <td class="center">A</td>
117 <td class="center">3</td>
120 <td class="center">4</td>
125 <td class="center">6</td>
126 <td class="center">A</td>
127 <td class="center">4</td>
130 <td class="center">5</td>
132 <td>Internet Explorer 7</td>
134 <td class="center">7</td>
135 <td class="center">A</td>
136 <td class="center">5</td>
139 <td class="center">6</td>
141 <td>AOL browser (AOL desktop)</td>
143 <td class="center">6</td>
144 <td class="center">A</td>
145 <td class="center">6</td>
148 <td class="center">7</td>
151 <td>Win 98+ / OSX.2+</td>
152 <td class="center">1.7</td>
153 <td class="center">A</td>
154 <td class="center">7</td>
157 <td class="center">8</td>
160 <td>Win 98+ / OSX.2+</td>
161 <td class="center">1.8</td>
162 <td class="center">A</td>
163 <td class="center">8</td>
166 <td class="center">9</td>
169 <td>Win 98+ / OSX.2+</td>
170 <td class="center">1.8</td>
171 <td class="center">A</td>
172 <td class="center">9</td>
175 <td class="center">10</td>
178 <td>Win 2k+ / OSX.3+</td>
179 <td class="center">1.9</td>
180 <td class="center">A</td>
181 <td class="center">10</td>
184 <td class="center">11</td>
188 <td class="center">1.8</td>
189 <td class="center">A</td>
190 <td class="center">11</td>
193 <td class="center">12</td>
197 <td class="center">1.8</td>
198 <td class="center">A</td>
199 <td class="center">12</td>
202 <td class="center">13</td>
204 <td>Netscape 7.2</td>
205 <td>Win 95+ / Mac OS 8.6-9.2</td>
206 <td class="center">1.7</td>
207 <td class="center">A</td>
208 <td class="center">13</td>
211 <td class="center">14</td>
213 <td>Netscape Browser 8</td>
215 <td class="center">1.7</td>
216 <td class="center">A</td>
217 <td class="center">14</td>
220 <td class="center">15</td>
222 <td>Netscape Navigator 9</td>
223 <td>Win 98+ / OSX.2+</td>
224 <td class="center">1.8</td>
225 <td class="center">A</td>
226 <td class="center">15</td>
229 <td class="center">16</td>
232 <td>Win 95+ / OSX.1+</td>
233 <td class="center">1</td>
234 <td class="center">A</td>
235 <td class="center">16</td>
238 <td class="center">17</td>
241 <td>Win 95+ / OSX.1+</td>
242 <td class="center">1.1</td>
243 <td class="center">A</td>
244 <td class="center">17</td>
247 <td class="center">18</td>
250 <td>Win 95+ / OSX.1+</td>
251 <td class="center">1.2</td>
252 <td class="center">A</td>
253 <td class="center">18</td>
256 <td class="center">19</td>
259 <td>Win 95+ / OSX.1+</td>
260 <td class="center">1.3</td>
261 <td class="center">A</td>
262 <td class="center">19</td>
265 <td class="center">20</td>
268 <td>Win 95+ / OSX.1+</td>
269 <td class="center">1.4</td>
270 <td class="center">A</td>
271 <td class="center">20</td>
274 <td class="center">21</td>
277 <td>Win 95+ / OSX.1+</td>
278 <td class="center">1.5</td>
279 <td class="center">A</td>
280 <td class="center">21</td>
283 <td class="center">22</td>
286 <td>Win 95+ / OSX.1+</td>
287 <td class="center">1.6</td>
288 <td class="center">A</td>
289 <td class="center">22</td>
292 <td class="center">23</td>
295 <td>Win 98+ / OSX.1+</td>
296 <td class="center">1.7</td>
297 <td class="center">A</td>
298 <td class="center">23</td>
301 <td class="center">24</td>
304 <td>Win 98+ / OSX.1+</td>
305 <td class="center">1.8</td>
306 <td class="center">A</td>
307 <td class="center">24</td>
310 <td class="center">25</td>
312 <td>Seamonkey 1.1</td>
313 <td>Win 98+ / OSX.2+</td>
314 <td class="center">1.8</td>
315 <td class="center">A</td>
316 <td class="center">25</td>
319 <td class="center">26</td>
321 <td>Epiphany 2.20</td>
323 <td class="center">1.8</td>
324 <td class="center">A</td>
325 <td class="center">26</td>
328 <td class="center">27</td>
332 <td class="center">125.5</td>
333 <td class="center">A</td>
334 <td class="center">27</td>
337 <td class="center">28</td>
341 <td class="center">312.8</td>
342 <td class="center">A</td>
343 <td class="center">28</td>
346 <td class="center">29</td>
350 <td class="center">419.3</td>
351 <td class="center">A</td>
352 <td class="center">29</td>
355 <td class="center">30</td>
359 <td class="center">522.1</td>
360 <td class="center">A</td>
361 <td class="center">30</td>
364 <td class="center">31</td>
368 <td class="center">420</td>
369 <td class="center">A</td>
370 <td class="center">31</td>
373 <td class="center">32</td>
375 <td>iPod Touch / iPhone</td>
377 <td class="center">420.1</td>
378 <td class="center">A</td>
379 <td class="center">32</td>
382 <td class="center">33</td>
386 <td class="center">413</td>
387 <td class="center">A</td>
388 <td class="center">33</td>
391 <td class="center">34</td>
394 <td>Win 95+ / OSX.1+</td>
395 <td class="center">-</td>
396 <td class="center">A</td>
397 <td class="center">34</td>
400 <td class="center">35</td>
403 <td>Win 95+ / OSX.2+</td>
404 <td class="center">-</td>
405 <td class="center">A</td>
406 <td class="center">35</td>
409 <td class="center">36</td>
412 <td>Win 95+ / OSX.2+</td>
413 <td class="center">-</td>
414 <td class="center">A</td>
415 <td class="center">36</td>
418 <td class="center">37</td>
421 <td>Win 95+ / OSX.2+</td>
422 <td class="center">-</td>
423 <td class="center">A</td>
424 <td class="center">37</td>
427 <td class="center">38</td>
430 <td>Win 95+ / OSX.3+</td>
431 <td class="center">-</td>
432 <td class="center">A</td>
433 <td class="center">38</td>
436 <td class="center">39</td>
439 <td>Win 88+ / OSX.3+</td>
440 <td class="center">-</td>
441 <td class="center">A</td>
442 <td class="center">39</td>
445 <td class="center">40</td>
448 <td>Win 88+ / OSX.3+</td>
449 <td class="center">-</td>
450 <td class="center">A</td>
451 <td class="center">40</td>
454 <td class="center">41</td>
456 <td>Opera for Wii</td>
458 <td class="center">-</td>
459 <td class="center">A</td>
460 <td class="center">41</td>
463 <td class="center">42</td>
467 <td class="center">-</td>
468 <td class="center">A</td>
469 <td class="center">42</td>
472 <td class="center">43</td>
474 <td>Nintendo DS browser</td>
476 <td class="center">8.5</td>
477 <td class="center">C/A</td>
478 <td class="center">43</td>
481 <td class="center">44</td>
483 <td>Konqureror 3.1</td>
485 <td class="center">3.1</td>
486 <td class="center">C</td>
487 <td class="center">44</td>
490 <td class="center">45</td>
492 <td>Konqureror 3.3</td>
494 <td class="center">3.3</td>
495 <td class="center">A</td>
496 <td class="center">45</td>
499 <td class="center">46</td>
501 <td>Konqureror 3.5</td>
503 <td class="center">3.5</td>
504 <td class="center">A</td>
505 <td class="center">46</td>
508 <td class="center">47</td>
510 <td>Internet Explorer 4.5</td>
512 <td class="center">-</td>
513 <td class="center">X</td>
514 <td class="center">47</td>
517 <td class="center">48</td>
519 <td>Internet Explorer 5.1</td>
520 <td>Mac OS 7.6-9</td>
521 <td class="center">1</td>
522 <td class="center">C</td>
523 <td class="center">48</td>
526 <td class="center">49</td>
528 <td>Internet Explorer 5.2</td>
530 <td class="center">1</td>
531 <td class="center">C</td>
532 <td class="center">49</td>
535 <td class="center">50</td>
537 <td>NetFront 3.1</td>
538 <td>Embedded devices</td>
539 <td class="center">-</td>
540 <td class="center">C</td>
541 <td class="center">50</td>
544 <td class="center">51</td>
546 <td>NetFront 3.4</td>
547 <td>Embedded devices</td>
548 <td class="center">-</td>
549 <td class="center">A</td>
550 <td class="center">51</td>
553 <td class="center">52</td>
556 <td>Embedded devices</td>
557 <td class="center">-</td>
558 <td class="center">X</td>
559 <td class="center">52</td>
562 <td class="center">53</td>
566 <td class="center">-</td>
567 <td class="center">X</td>
568 <td class="center">53</td>
571 <td class="center">54</td>
575 <td class="center">-</td>
576 <td class="center">X</td>
577 <td class="center">54</td>
580 <td class="center">55</td>
583 <td>Windows Mobile 6</td>
584 <td class="center">-</td>
585 <td class="center">C</td>
586 <td class="center">55</td>
589 <td class="center">56</td>
593 <td class="center">-</td>
594 <td class="center">C</td>
595 <td class="center">56</td>
598 <td class="center">57</td>
599 <td>Other browsers</td>
602 <td class="center">-</td>
603 <td class="center">U</td>
604 <td class="center">57</td>
609 <div class="spacer"></div>
612 <h1>Initialisation code</h1>
613 <pre>$(document).ready( function () {
614 var oTable = $('#example').dataTable( {
616 "sScrollXInner": "150%",
617 "bScrollCollapse": true,
618 "fnDrawCallback": function ( oSettings ) {
619 /* Need to redo the counters if filtered or sorted */
620 if ( oSettings.bSorted || oSettings.bFiltered ) {
621 for ( var i=0, iLen=oSettings.aiDisplay.length ; i<iLen ; i++ ) {
622 this.fnUpdate( i+1, oSettings.aiDisplay[i], 0, false, false );
623 this.fnUpdate( i+1, oSettings.aiDisplay[i], 6, false, false );
628 { "bSortable": false, "sClass": "indexLeft", "aTargets": [ 0 ] },
629 { "bSortable": false, "sClass": "indexRight", "aTargets": [ -1 ] }
631 "aaSorting": [[ 1, 'asc' ]]
634 new FixedColumns( oTable, {
641 <h1>Documentation</h1>
643 <li><a href="http://datatables.net/extras/fixedcolumns">Usage</a></li>
644 <li><a href="http://datatables.net/docs/FixedColumns">API / parameters</a></li>
647 <h1>Basic examples</h1>
649 <li><a href="index.html">Basic demo of FixedColumns with zero initialisation</a></li>
650 <li><a href="left_right_columns.html">Fix the left and right columns in place</a></li>
651 <li><a href="index_column.html">Index column attached to side of the table</a></li>
652 <li><a href="x_y_scrolling.html">Index column, but with Y scrolling and no pagination</a></li>
653 <li><a href="two_columns.html">Two columns fixed in place</a></li>
654 <li><a href="right_column.html">Fix the right column in place</a></li>
655 <li><a href="css_size.html">Speeding up row height matching with CSS</a></li>
656 <li><a href="themed.html">jQuery UI themed table with FixedColumns</a></li>
659 <h1>Advanced examples</h1>
661 <li><a href="rowspan.html">Using ROWSPAN with FixedColumns</a></li>
662 <li><a href="server-side-processing.html">Server-side processing with FixedColumns</a></li>
663 <li><a href="col_filter.html">Individual column filtering</a></li>
664 <li><a href="scale_fixed.html">Setting the fixed column width and resizing the table</a></li>
665 <li><a href="scale_relative.html">Setting the fixed column width with relative sizing</a></li>
666 <li><a href="row_grouping_height.html">Row grouping by grouping like rows in the fixed column</a></li>
667 <li><a href="row_grouping.html">Row grouping by inserting a grouping row</a></li>
671 <div id="footer" style="text-align:center;">
672 <span style="font-size:10px;">
673 FixedColumns and DataTables © Allan Jardine 2011.<br>