forked from handsontable/handsontable
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathfixed.html
148 lines (118 loc) · 4.54 KB
/
fixed.html
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
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
<!doctype html>
<html>
<head>
<meta charset='utf-8'>
<title>Fixed Rows & Columns - Handsontable</title>
<!--
Loading Handsontable (full distribution that includes all dependencies)
-->
<script data-jsfiddle="common" src="../dist/handsontable.full.js"></script>
<link data-jsfiddle="common" rel="stylesheet" media="screen" href="../dist/handsontable.full.css">
<!--
Loading demo dependencies. They are used here only to enhance the examples on this page
-->
<link data-jsfiddle="common" rel="stylesheet" media="screen" href="css/samples.css?20140331">
<script src="js/samples.js"></script>
<script src="js/highlight/highlight.pack.js"></script>
<link rel="stylesheet" media="screen" href="js/highlight/styles/github.css">
<link rel="stylesheet" href="css/font-awesome/css/font-awesome.min.css">
<!--
Facebook open graph. Don't copy this to your project :)
-->
<meta property="og:title" content="Fixed Rows & Columns">
<meta property="og:description"
content="This page shows how to configure Handsontable fixed rows/columns">
<meta property="og:url" content="http://handsontable.com/demo/fixed.html">
<meta property="og:image" content="http://handsontable.com/demo/image/og-image.png">
<meta property="og:image:type" content="image/png">
<meta property="og:image:width" content="409">
<meta property="og:image:height" content="164">
<link rel="canonical" href="http://handsontable.com/demo/fixed.html">
<!--
Google Analytics for GitHub Page. Don't copy this to your project :)
-->
<script src="js/ga.js"></script>
<script data-jsfiddle="common">
function createSpreadsheetData(rowCount, colCount) {
rowCount = typeof rowCount === 'number' ? rowCount : 100;
colCount = typeof colCount === 'number' ? colCount : 4;
var rows = []
, i
, j;
for (i = 0; i < rowCount; i++) {
var row = [];
for (j = 0; j < colCount; j++) {
row.push(Handsontable.helper.spreadsheetColumnLabel(j) + (i + 1));
}
rows.push(row);
}
return rows;
}
</script>
</head>
<body>
<div class="wrapper">
<div class="wrapper-row">
<div id="global-menu-clone">
<h1><a href="../index.html">Handsontable</a></h1>
</div>
<div id="container">
<div class="columnLayout">
<div class="rowLayout">
<div class="descLayout">
<div class="pad" data-jsfiddle="example1">
<h2>Fixed rows and columns</h2>
<p>Specify two fixed rows with <code>fixedRowsTop: 2</code> and two fixed columns with <code>fixedColumnsLeft:
2</code> option.</p>
<p>Note: You'll need horizontal scrollbars, so just set a container <code>width</code> and <code>overflow:
scroll</code> in CSS.</p>
<pre id="positions"></pre>
<div id="example1" style="width: 400px; height: 300px; overflow: scroll"></div>
<p>
<button name="dump" data-instance="ht" data-dump="#example1" title="Prints current data source to Firebug/Chrome Dev Tools">
Dump data to console
</button>
</p>
</div>
</div>
<div class="codeLayout">
<div class="pad">
<div class="jsFiddle">
<button class="jsFiddleLink" data-runfiddle="example1">Edit in jsFiddle</button>
</div>
<script data-jsfiddle="example1">
/*
Container looks like this:
<div id="example1" style="width: 400px; height: 300px; overflow: scroll"></div>
*/
var myData = createSpreadsheetData(1000, 100);
var container = document.getElementById('example1');
var ht = new Handsontable(container, {
data: myData,
colWidths: [65, 47, 47, 47, 47, 47, 47, 47, 47, 47],
rowHeaders: true,
colHeaders: true,
fixedRowsTop: 2,
fixedColumnsLeft: 2,
contextMenu: true
});
var positions = document.getElementById('positions');
setInterval(function () {
var str = '';
str += 'rowOffset: ' + ht.rowOffset();
positions.innerHTML = str;
}, 100);
</script>
</div>
</div>
</div>
<div class="footer-text">Handsontable © 2012-2014 Marcin Warpechowski and contributors.<br> Code and documentation
licensed under the The MIT License.
</div>
</div>
</div>
</div>
</div>
<div id="outside-links-wrapper"></div>
</body>
</html>