Multi-Pane Grid

Although FlexGrid does not allow you to freeze columns on the right of the grid, or rows along the bottom. But this example shows how you can implement something similar using two grids bound to the same data source.

Id
Country
Downloads
Sales
Expenses
Amount1
Amount2
Amount3
Amount4
Amount5
Amount6
Amount7
0
US
14,529
5,989.74
55.71
4,831.08
3,157.08
4,673.21
4,618.47
4,006.31
4,170.33
281.26
1
Germany
18,569
8,114.24
626.39
1,978.99
3,011.74
3,179.64
2,025.93
1,535.86
4,781.44
1,076.85
2
UK
15,910
1,035.97
4,864.71
1,994.39
3,083.85
4,424.05
3,254.19
3,536.90
1,112.51
1,708.62
3
Japan
19,360
7,775.96
4,821.39
4,314.32
3,242.51
4,201.35
4,326.16
4,389.62
2,458.94
456.03
4
Italy
7,626
6,930.04
3,882.92
1,579.45
3,157.41
4,806.87
3,784.76
793.17
431.29
2,425.35
5
Greece
15,938
1,768.78
3,055.33
2,136.34
3,681.70
4,429.84
3,741.17
676.33
2,079.81
3,622.49
6
Austria
6,775
912.32
883.61
3,546.59
3,426.47
1,247.70
4,277.60
1,145.44
1,526.21
4,672.47
7
Belgium
12,323
8,702.42
3,066.55
4,180.18
3,108.20
2,706.44
2,768.98
4,266.41
3,601.03
4,430.87
8
China
3,513
3,175.14
707.67
3,755.17
1,135.69
887.08
4,171.72
3,635.62
404.30
3,830.36
9
Korea
13,073
5,607.44
4,987.13
3,949.30
1,436.10
3,279.44
2,141.14
4,260.39
1,283.92
4,159.65
10
US
15,234
3,521.20
637.75
3,936.33
4,482.71
3,290.46
3,940.91
1,034.45
2,453.12
4,414.30
11
Germany
2,834
9,785.26
1,554.65
1,643.75
2,159.10
4,365.64
3,674.95
4,864.48
844.30
4,895.34
12
UK
18,873
1,265.90
1,453.55
742.50
2,922.79
2,389.48
1,085.70
3,269.56
1,989.24
2,879.19
13
Japan
11,214
174.07
3,615.91
139.35
1,826.95
4,068.98
444.25
3,842.21
904.73
3,559.98
14
Italy
10,273
2,339.13
413.33
3,266.27
1,932.26
1,496.17
4,860.16
2,162.32
1,551.80
195.65
15
Greece
12,478
648.31
4,602.71
915.42
2,017.29
286.84
267.63
3,621.27
820.15
4,687.82
16
Austria
17,194
1,878.59
3,818.26
3,280.76
4,077.27
2,840.48
1,314.59
1,811.92
3,565.24
2,654.37
17
Belgium
7,719
1,403.68
3,497.46
71.06
2,964.14
4,225.15
2,345.45
261.26
4,591.50
27.45
18
China
7,524
893.82
3,530.93
1,495.16
216.18
95.58
252.13
698.20
2,373.01
3,547.71
19
Korea
10,739
5,221.25
4,929.59
3,576.86
2,596.15
515.51
2,422.38
1,984.09
249.81
4,340.03
20
US
74
2,764.04
1,171.52
3,251.69
3,014.56
1,627.50
2,321.62
3,278.82
2,768.83
2,820.60
21
Germany
8,363
6,362.08
1,356.98
1,624.91
3,625.55
2,287.53
4,328.28
2,534.27
4,500.97
2,541.69
22
UK
1,475
8,762.86
2,200.45
2,983.82
1,627.98
3,017.95
3,921.30
402.31
4,392.76
1,738.75
23
Japan
15,928
873.83
2,472.58
4,077.04
3,443.88
2,246.45
339.51
4,797.11
4,807.97
882.70
24
Italy
1,846
1,613.38
2,657.55
127.34
2,097.65
1,899.30
4,302.82
1,960.23
1,887.87
4,663.49
25
Greece
8,837
7,613.52
4,329.83
4,050.36
737.98
1,553.14
3,520.00
2,052.99
17.96
669.74
26
Austria
17,065
1,142.30
653.55
999.21
488.00
2,806.93
2,342.03
2,744.31
1,380.50
3,173.17
27
Belgium
6,573
7,970.32
2,591.49
80.49
3,152.84
4,644.99
4,374.05
1,826.92
2,445.80
2,715.31
28
China
19,695
6,667.82
4,610.42
3,066.96
4,492.68
2,065.02
3,234.77
259.97
2,063.99
2,813.40
29
Korea
8,127
1,296.89
1,376.32
1,515.00
4,791.09
4,808.28
4,054.95
3,743.56
3,349.17
1,162.50
30
US
8,711
4,383.55
1,009.55
1,667.67
4,333.47
580.95
2,149.58
3,639.35
4,343.47
3,741.49
31
Germany
18,828
9,240.68
355.28
3,789.16
275.15
3,622.11
2,273.39
3,162.17
1,415.85
4,273.65
32
UK
18,958
5,204.27
2,852.69
1,302.90
2,099.82
1,648.11
2,159.75
1,302.82
1,629.60
1,618.43
33
Japan
16,239
6,257.88
4,239.53
1,941.65
3,804.95
1,552.87
3,215.43
2,913.12
4,114.64
1,153.35
34
Italy
3,663
9,230.60
4,329.36
1,703.18
53.04
2,222.89
4,520.10
2,895.22
4,867.78
1,373.37
35
Greece
1,289
5,080.56
1,636.07
3,119.37
1,333.00
577.76
901.28
4,789.25
667.15
1,208.67
36
Austria
4,507
8,752.96
1,807.46
3,247.31
2,673.64
503.56
1,066.37
3,132.92
4,584.58
4,821.06
37
Belgium
14,031
32.05
4,520.94
4,899.00
24.46
3,852.31
3,654.24
2,395.09
982.49
4,216.05
38
China
15,604
2,977.88
1,915.02
4,467.00
2,056.12
3,178.68
2,979.20
2,742.22
159.70
2,506.73
39
Korea
14,506
3,891.42
869.34
4,979.48
2,572.75
3,558.72
1,700.00
3,952.62
1,891.19
3,455.81
40
US
15,088
7,041.68
4,561.60
2,783.66
4,000.99
368.84
376.30
4,825.81
1,372.40
1,179.70
41
Germany
1,273
144.99
4,336.10
18.03
3,491.20
2,499.26
279.78
1,960.65
1,206.81
3,650.57
42
UK
5,238
9,888.30
4,065.16
2,611.93
650.40
4,725.68
4,589.41
3,504.67
3,401.53
2,429.30
43
Japan
2,088
9,865.26
2,452.79
661.64
563.38
1,789.40
762.81
113.99
793.19
2,481.66
44
Italy
1,678
8,090.83
3,870.30
1,131.59
2,634.69
1,169.94
1,223.60
274.77
247.32
2,626.57
45
Greece
189
4,866.14
2,702.01
781.06
1,112.01
4,415.85
240.16
3,392.73
2,588.71
3,354.83
46
Austria
10,401
1,332.28
4,106.65
194.21
556.58
1,288.85
1,297.10
4,820.34
889.56
2,372.86
47
Belgium
7,235
2,626.37
3,063.27
2,389.40
1,347.44
4,628.82
1,049.82
3,294.46
2,253.25
208.60
48
China
19,284
9,461.29
857.30
1,424.50
3,908.18
1,658.04
4,591.10
3,965.10
1,720.10
487.08
49
Korea
15,512
9,768.03
2,314.63
3,607.93
2,962.73
4,379.34
498.54
638.42
3,479.88
4,254.22
50
US
1,059
1,954.62
1,906.53
3,148.80
2,273.18
3,284.32
3,173.41
1,209.11
464.84
425.17
51
Germany
13,938
5,318.11
1,804.67
2,017.26
1,622.01
1,671.63
63.17
2,653.29
618.27
4,360.31
52
UK
7,339
8,668.89
2,373.81
930.09
3,606.92
1,976.50
455.36
329.84
468.13
4,416.24
53
Japan
8,608
5,227.14
2,090.25
1,004.40
1,163.10
2,155.21
3,855.71
828.67
2,672.70
94.92
54
Italy
7,112
4,683.59
3,140.76
4,269.76
2,483.00
690.52
1,001.47
3,335.19
4,813.58
2,052.92
55
Greece
837
2,288.44
2,114.65
3,482.74
2,263.67
3,119.84
718.92
1,689.45
4,564.81
3,255.95
56
Austria
4,577
5,349.83
4,400.22
1,848.94
4,356.48
4,267.45
1,018.96
2,388.27
3,362.64
3,339.07
57
Belgium
7,279
3,179.50
248.16
1,410.83
2,691.30
2,276.51
914.76
3,649.12
4,273.35
4,507.93
58
China
6,343
3,210.36
3,035.07
422.68
3,860.95
2,041.07
2,817.15
1,119.93
4,634.90
1,162.53
59
Korea
4,983
8,649.25
1,788.87
2,564.64
3,549.65
4,330.11
423.87
4,057.99
1,397.46
4,966.65
60
US
2,534
1,537.40
4,550.60
3,490.59
1,713.95
1,390.58
2,238.00
3,919.66
4,833.93
2,871.86
61
Germany
19,945
3,849.34
1,947.53
4,999.83
3,883.66
1,457.15
1,704.80
2,684.58
1,654.73
1,939.39
62
UK
2,955
3,216.32
838.49
3,915.55
877.13
3,033.65
2,983.82
391.46
325.34
1,914.85
63
Japan
3,526
3,440.68
3,532.56
2,380.39
4,407.65
1,157.33
39.27
3,173.17
1,787.14
4,716.09
64
Italy
18,529
3,622.83
2,973.22
4,246.81
3,770.26
3,714.92
1,579.52
3,275.21
619.87
2,778.34
65
Greece
7,857
6,224.75
3,081.94
1,090.47
520.04
3,323.89
4,969.68
3,479.32
1,409.39
2,796.97
66
Austria
11,228
4,844.80
4,249.36
1,991.00
4,611.23
4,251.42
1,961.21
167.08
1,022.48
3,633.50
67
Belgium
2,237
6,209.90
2,439.89
4,309.43
2,262.02
2,788.66
3,536.28
3,626.38
4,614.79
3,803.81
68
China
15,664
9,589.60
2,097.21
4,966.12
1,886.54
760.31
4,149.75
4,407.87
2,085.96
2,183.00
69
Korea
15,506
5,183.45
2,315.31
2,936.27
950.45
4,837.10
1,272.38
3,591.38
2,035.72
503.82
70
US
719
6,768.62
642.79
1,333.92
3,285.59
651.81
391.23
3,613.97
4,362.88
556.61
71
Germany
17,652
2,742.18
1,734.51
3,880.92
1,748.96
4,593.49
404.57
1,273.13
1,316.01
4,099.13
72
UK
4,554
4,529.06
4,054.38
2,496.63
3,038.80
958.20
2,490.51
2,039.87
2,499.74
571.97
73
Japan
14,971
7,928.55
2,238.73
1,904.23
3,315.65
1,890.27
3,647.45
1,388.32
4,891.76
3,807.58
74
Italy
9,911
1,127.76
4,567.30
1,326.25
1,782.54
1,945.30
193.36
4,895.08
1,478.54
1,058.38
75
Greece
2,334
5,141.30
78.28
1,265.35
4,255.84
4,677.13
1,499.53
265.86
391.84
938.79
76
Austria
9,475
5,492.98
22.03
1,590.49
559.47
4,512.84
1,393.90
14.73
4,394.43
937.54
77
Belgium
7,563
7,515.14
182.18
2,412.39
3,486.13
1,941.57
1,789.53
4,553.95
4,066.64
2,470.70
78
China
6,024
2,716.98
4,145.21
2,879.83
4,736.48
3,722.72
4,158.87
3,233.86
4,687.28
2,357.81
79
Korea
9,280
5,581.54
3,837.52
3,207.84
1,720.15
4,745.70
2,966.04
350.67
2,097.39
989.92
80
US
9,190
5,757.81
1,059.99
1,233.59
3,742.62
1,873.28
2,453.60
3,142.35
4,981.41
164.00
81
Germany
7,716
8,945.27
2,845.90
2,922.46
2,115.91
2,884.93
1,454.86
3,812.52
3,376.81
705.52
82
UK
6,836
8,734.81
4,260.98
3,957.40
1,752.10
1,482.15
2,069.45
1,822.56
896.16
4,712.75
83
Japan
9,443
2,813.77
4,750.54
3,358.10
2,577.41
4,200.26
3,248.59
1,434.27
3,773.32
1,499.38
84
Italy
14,716
71.74
3,769.26
1,020.07
1,116.30
3,515.66
3,305.82
2,239.35
492.02
610.51
85
Greece
2,594
2,579.37
787.95
2,849.34
1,204.21
2,635.67
3,716.08
190.82
1,096.76
281.08
86
Austria
12,116
9,428.88
2,934.48
4,801.16
1,456.57
3,423.69
3,028.35
3,493.91
1,502.24
1,807.14
87
Belgium
14,531
2,672.85
4,227.28
2,093.65
941.05
1,406.69
1,281.11
2,645.08
4,494.69
4,228.43
88
China
4,052
2,872.81
1,882.00
3,871.00
19.17
2,994.02
2,718.86
3,779.42
3,755.76
2,777.07
89
Korea
7,770
3,373.88
4,631.62
1,341.42
3,753.12
4,423.84
164.82
3,445.23
1,493.63
3,165.09
90
US
5,957
6,121.88
3,609.27
3,427.01
1,072.11
4,305.62
1,422.05
3,767.88
1,178.80
3,260.86
91
Germany
18,687
503.23
334.35
2,926.04
813.66
1,411.54
757.29
2,772.41
573.10
1,834.19
92
UK
13,374
5,326.29
2,704.45
4,559.16
2,647.96
682.78
3,018.52
4,983.54
98.32
1,062.58
93
Japan
4,733
8,744.26
1,076.08
357.09
1,496.12
4,364.11
3,013.91
3,854.50
2,860.46
2,902.10
94
Italy
16,581
3,560.38
377.37
791.49
1,523.72
4,556.55
1,925.94
4,825.83
962.67
2,940.12
95
Greece
6,924
2,125.39
490.14
3,215.74
2,239.77
676.62
2,643.97
1,206.60
186.54
224.44
96
Austria
7,262
4,120.92
2,658.60
2,866.45
2,928.26
2,584.68
3,339.24
3,554.76
3,558.19
4,229.79
97
Belgium
5,861
7,048.94
1,964.33
3,505.51
407.98
1,687.63
1,210.73
4.11
3,973.41
3,474.68
98
China
8,410
3,095.65
3,895.44
4,065.07
3,746.64
3,815.84
3,751.67
3,253.23
119.21
1,581.13
99
Korea
10,569
2,156.23
979.73
1,671.22
1,944.27
4,315.76
3,710.65
851.14
257.77
4,478.39
100
US
19,801
8,151.93
4,242.44
2,099.05
2,018.89
2,666.94
1,630.70
1,187.35
4,741.60
28.15
101
Germany
8,867
280.57
1,568.43
3,799.56
450.41
3,919.82
4,879.26
1,870.10
3,468.63
1,522.09
102
UK
13,474
900.24
3,205.80
2,423.68
1,483.80
662.42
1,356.86
4,834.25
3,951.68
833.14
103
Japan
19,286
3,965.64
2,032.63
4,632.97
222.60
1,087.39
3,880.11
4,008.83
845.54
4,146.25
104
Italy
13,463
8,547.13
1,201.74
509.16
322.08
4,948.42
3,885.97
750.73
4,615.28
1,846.36
105
Greece
13,367
713.70
760.65
3,682.11
2,520.90
202.95
84.35
820.02
2,144.80
3,743.90
106
Austria
15,984
7,688.06
3,400.10
4,236.68
2,037.27
2,208.73
101.90
2,962.97
405.67
4,777.35
107
Belgium
12,354
3,389.86
4,601.45
4,741.23
4,184.85
489.38
4,763.72
2,082.88
3,717.71
560.55
108
China
2,355
3,820.84
633.32
4,540.47
1,533.61
1,156.91
4,979.13
1,678.89
4,950.60
3,020.44
109
Korea
4,897
5,473.59
1,068.28
131.29
4,147.57
3,233.14
4,457.53
2,516.71
4,439.52
3,596.20
110
US
19,910
7,546.90
1,518.19
555.26
2,244.60
453.72
3,599.16
3,962.09
1,395.41
889.77
111
Germany
15,612
6,960.10
1,843.47
4,213.31
3,278.27
973.78
1,544.05
2,612.55
1,983.83
734.44
112
UK
15,243
9,246.16
1,117.00
4,521.35
44.26
1,673.32
4,231.05
1,664.03
218.79
1,829.00
113
Japan
1,881
7,410.33
200.85
4,979.43
4,869.18
1,444.36
1,057.19
4,999.94
3,859.49
3,608.02
114
Italy
9,197
140.39
1,257.59
2,823.96
3,770.79
4,495.00
4,787.54
651.36
1,865.81
4,588.45
115
Greece
17,579
6,676.14
4,997.25
552.13
2,744.96
4,607.21
2,910.70
918.75
4,046.70
3,701.58
116
Austria
9,463
284.45
3,148.79
1,619.95
553.94
1,733.16
1,390.67
2,281.68
1,324.42
1,959.80
117
Belgium
1,544
2,572.06
705.20
737.98
113.15
2,290.48
2,619.04
793.46
2,374.50
3,143.60
118
China
19,181
1,790.49
879.67
1,035.09
1,338.14
3,347.19
229.46
3,348.00
2,197.77
4,676.48
119
Korea
16,436
7,091.85
1,166.62
253.55
3,470.23
4,688.32
4,418.07
3,767.20
2,824.63
310.26
120
US
6,384
2,680.70
1,488.83
647.99
1,826.98
3,698.57
1,575.71
845.36
2,319.20
229.03
121
Germany
5,814
1,303.71
544.65
11.07
962.78
4,672.10
2,186.87
134.76
4,881.80
4,380.86
122
UK
59
1,520.98
2,693.69
118.26
3,043.30
3,061.34
1,597.55
4,445.59
200.68
3,813.56
123
Japan
1,216
2,572.30
256.28
251.03
325.31
1,272.43
2,687.27
4,588.39
4,270.06
4,745.83
124
Italy
12,343
805.92
4,462.47
1,428.10
359.55
141.96
3,693.17
210.32
840.62
560.76
125
Greece
4,832
7,962.05
3,875.80
1,002.61
4,247.17
2,579.30
4,727.17
4,954.62
3,382.97
2,979.81
126
Austria
9,564
4,234.82
1,397.97
2,935.19
747.06
434.64
3,540.33
3,231.41
3,741.26
533.60
127
Belgium
6,337
8,485.45
3,706.90
4,772.59
791.98
4,375.74
2,078.56
2,065.48
204.78
3,836.46
128
China
12,116
6,164.55
3,755.63
1,597.34
1,671.79
2,066.39
4,370.96
2,284.67
2,000.86
2,127.83
129
Korea
16,151
9,695.29
792.36
3,899.24
409.01
1,734.76
3,114.38
2,933.11
2,206.39
2,036.56
130
US
6,243
195.78
1,011.89
3,028.32
3,232.08
1,032.69
2,594.88
4,827.21
1,176.23
2,582.79
131
Germany
1,712
4,498.00
4,271.20
4,721.12
2,861.81
4,401.48
3,332.57
577.82
269.43
3,204.62
132
UK
497
1,497.31
666.93
4,023.66
4,021.87
607.20
986.61
3,712.34
4,453.83
3,851.20
133
Japan
17,615
7,896.56
1,236.97
3,741.74
4,738.40
645.21
2,701.00
801.52
4,615.69
893.37
134
Italy
19,528
6,883.25
2,200.91
4,823.97
3,180.46
1,070.96
4,523.34
176.10
2,226.52
2,416.32
135
Greece
11,279
8,855.53
126.09
2,352.52
3,028.17
934.18
4,767.91
2,273.59
2,997.40
1,570.50
136
Austria
6,411
3,841.53
1,497.21
821.91
2,146.56
816.80
2,892.35
1,378.72
3,184.30
2,068.30
137
Belgium
9,591
8,009.42
408.26
3,051.54
359.75
653.32
2,014.21
4,004.40
4,514.17
329.06
138
China
1,424
8,744.56
4,327.72
2,292.37
767.92
2,926.14
3,799.58
3,024.55
2,363.86
1,428.50
139
Korea
17,805
1,701.71
3,406.61
1,211.83
450.32
2,115.22
4,674.98
1,585.41
3,609.91
4,907.09
140
US
16,546
966.39
3,501.12
2,336.24
579.72
4,833.57
4,809.93
1,585.19
989.01
3,708.95
141
Germany
4,857
5,558.86
2,892.31
2,755.85
3,424.54
3,854.55
4,209.53
796.83
3,846.25
175.16
142
UK
12,044
6,045.47
2,541.70
1,652.54
4,440.15
4,155.02
4,689.76
3,595.24
1,682.89
2,826.16
143
Japan
12,385
4,223.86
4,808.80
3,484.99
846.06
4,375.62
3,454.87
597.24
1,587.49
2,693.42
144
Italy
3,813
7,948.07
3,304.03
1,334.89
479.74
2,268.87
1,911.68
2,205.62
2,390.10
3,518.04
145
Greece
9,147
3,863.88
3,740.83
997.36
3,169.89
1,497.62
2,432.22
1,083.41
4,992.88
3,291.58
146
Austria
12,192
3,122.32
1,693.18
3,779.38
4,290.54
3,003.52
388.60
4,512.24
1,510.88
1,603.17
147
Belgium
17,932
6,551.63
1,043.00
2,510.14
3,522.43
1,738.14
3,292.10
908.39
2,944.23
2,906.87
148
China
15,530
2,390.56
3,233.46
561.22
2,385.21
2,730.75
1,357.72
2,326.37
103.57
3,047.74
149
Korea
1,110
4,284.85
4,573.12
2,339.53
2,654.41
4,734.80
458.57
3,716.26
1,080.85
4,857.52
150
US
8,910
187.60
4,310.62
2,909.90
1,825.21
1,136.01
665.38
2,490.64
4,729.96
2,218.07
151
Germany
8,340
9,802.92
2,259.38
3,652.15
2,005.96
2,670.65
1,313.49
482.75
112.28
1,021.84
152
UK
19,937
1,627.90
1,053.44
2,596.39
4,867.62
1,486.42
501.56
4,996.43
1,556.17
2,334.61
153
Japan
9,976
9,816.55
3,528.52
1,244.54
4,034.40
2,346.90
4,553.04
4,552.67
3,762.37
2,285.58
154
Italy
19,897
6,818.40
4,059.11
2,826.16
760.24
1,850.37
365.66
1,759.54
3,971.91
3,483.17
155
Greece
13,774
7,677.52
1,270.36
4,367.55
2,354.45
1,491.22
584.83
635.41
119.78
4,774.56
156
Austria
1,746
5,679.75
3,011.26
320.39
1,223.10
4,058.00
2,617.93
264.05
1,013.74
1,910.79
157
Belgium
15,633
6,536.28
472.96
686.72
3,971.98
509.29
273.35
1,512.41
1,811.88
25.37
158
China
13,017
652.62
4,630.31
1,579.14
3,471.37
1,157.64
1,447.90
1,175.88
638.87
393.00
159
Korea
10,592
8,196.40
2,937.80
3,409.89
2,937.76
3,207.32
2,813.64
1,238.69
4,648.87
437.17
160
US
19,882
404.97
227.89
4,371.07
2,351.51
1,305.11
3,759.13
1,896.71
167.31
918.12
161
Germany
11,194
9,248.89
2,488.49
1,508.54
3,809.85
2,485.01
3,492.29
2,041.65
2,533.69
1,459.86
162
UK
14,517
1,991.64
1,523.43
2,661.38
2,653.78
502.00
4,153.56
2,157.39
383.88
3,327.22
163
Japan
19,613
9,035.69
409.33
640.11
4,970.86
102.10
2,279.36
1,820.90
832.19
4,441.15
164
Italy
3,022
5,764.41
4,989.08
3,683.58
1,923.34
327.65
2,130.29
2,561.15
4,288.92
4,320.05
165
Greece
3,514
6,342.15
441.00
3,453.02
1,195.99
472.94
2,670.92
4,563.07
4,648.32
1,870.34
166
Austria
18,236
2,292.15
2,299.05
2,448.09
1,373.45
4,952.19
2,149.38
696.62
631.76
338.21
167
Belgium
11,295
5,636.03
1,236.55
1,224.43
3,043.77
4,094.97
2,757.36
1,868.63
4,517.72
1,848.60
168
China
14,890
7,094.81
1,935.61
4,155.96
756.32
2,381.27
3,084.87
2,150.04
3,886.81
3,814.84
169
Korea
12,698
1,317.22
4,342.61
3,479.09
1,374.87
2,312.43
4,561.51
2,607.96
4,789.24
1,660.82
170
US
4,490
6,767.06
3,624.25
1,127.19
918.65
1,942.85
2,133.66
933.81
237.77
124.43
171
Germany
4,188
7,563.20
70.95
3,009.70
2,089.79
3,864.33
1,182.01
1,611.57
4,516.81
4,617.55
172
UK
634
874.54
2,426.94
258.11
1,893.82
686.36
3,219.21
1,360.72
1,307.48
1,735.72
173
Japan
18,652
2,451.16
91.91
2,567.60
1,154.68
289.08
2,801.82
1,865.16
1,144.91
685.05
174
Italy
13,069
629.12
2,646.06
3,455.77
4,710.44
1,878.62
1,456.47
3,426.70
3,662.35
4,230.34
175
Greece
7,559
3,454.91
2,057.84
791.09
3,233.78
3,646.98
3,606.47
613.98
935.93
3,922.58
176
Austria
6,068
8,653.65
2,472.23
4,758.22
355.52
3,014.27
1,164.67
3,130.44
4,931.39
4,256.64
177
Belgium
7,493
6,090.49
360.49
3,635.47
947.72
329.90
464.03
4,697.68
546.97
3,815.12
178
China
7,203
2,051.53
3,248.65
1,692.70
416.49
3,012.15
1,546.60
644.58
4,105.98
1,233.89
179
Korea
17,725
8,022.31
4,233.55
1,869.21
4,211.57
2,327.13
1,955.25
518.14
4,810.58
258.89
180
US
12,695
6,692.44
3,368.78
2,338.94
518.39
702.89
4,392.44
541.06
264.77
4,831.90
181
Germany
2,428
8,518.02
2,096.31
130.33
4,815.24
2,879.36
183.71
1,778.19
960.24
2,262.25
182
UK
235
1,375.12
3,905.33
1,874.05
1,223.72
4,394.39
3,835.69
2,745.20
4,954.17
618.70
183
Japan
224
9,933.22
2,140.14
2,274.40
3,247.89
3,495.31
1,147.68
1,496.46
788.05
4,808.52
184
Italy
1,090
6,670.09
4.44
111.81
4,565.20
1,864.47
2,873.11
454.47
2,372.55
2,398.93
185
Greece
9,702
8,644.50
2,987.72
643.70
1,862.48
289.73
1,862.40
1,458.35
3,291.90
4,943.26
186
Austria
6,376
4,115.55
4,455.65
2,115.65
3,937.88
2,986.26
1,732.31
3,652.88
4,519.86
2,026.89
187
Belgium
6,890
8,356.09
922.88
161.75
3,428.78
192.24
3,257.28
4,520.77
3,888.17
3,234.15
188
China
7,809
8,244.21
2,495.78
2,432.61
624.97
3,713.59
3,447.73
3,926.01
4,102.28
796.10
189
Korea
748
7,482.77
1,176.15
521.62
2,702.53
2,866.48
3,559.70
8.74
2,164.95
560.77
190
US
11,269
7,475.43
2,327.43
3,833.52
917.88
4,902.81
1,303.00
1,225.76
4,647.57
3,185.88
191
Germany
19,579
7,750.32
439.23
4,660.46
2,333.21
1,391.06
3,070.82
3,861.10
1,132.83
4,801.49
192
UK
6,209
1,798.45
4,615.58
3,660.98
126.96
1,239.97
1,658.61
2,644.09
4,432.17
4,433.93
193
Japan
10,335
4,274.55
3,770.20
597.85
1,772.48
3,045.55
3,666.61
1,032.15
2,331.54
3,030.97
194
Italy
3,420
5,270.00
4,164.74
3,425.24
2,360.12
2,453.06
1,693.40
4,354.21
184.05
3,598.40
195
Greece
17,233
3,572.71
4,341.97
4,170.61
2,707.64
2,654.29
4,780.15
1,868.18
4,456.00
3,005.04
196
Austria
16,411
3,808.25
1,939.20
3,535.30
4,424.30
3,735.07
1,954.60
4,138.40
4,224.60
877.63
197
Belgium
13,498
3,186.63
4,802.65
889.28
2,669.72
587.10
4,013.56
3,949.63
3,878.35
4,664.52
198
China
6,136
752.06
2,669.23
2,618.62
2,358.93
3,132.94
3,484.75
3,553.13
4,226.09
1,532.23
199
Korea
8,214
970.16
2,765.36
1,778.35
697.67
638.78
3,391.43
2,392.04
4,792.37
3,916.83
Important
Amount8
3,849.30
1,934.11
4,596.92
2,332.98
2,329.38
1,154.70
1,628.36
2,676.79
3,303.52
2,423.13
4,479.85
1,347.18
328.62
1,089.86
702.81
503.10
1,645.52
2,185.69
4,443.42
2,787.98
2,583.04
3,325.82
636.87
1,744.46
250.04
47.26
2,249.07
623.12
2,674.92
4,571.46
2,846.41
4,914.60
1,597.49
516.42
677.35
4,932.95
2,335.59
1,945.46
1,698.53
1,011.31
3,919.63
3,490.62
3,905.68
4,177.12
3,526.41
278.56
2,352.68
3,807.89
4,770.32
2,387.12
508.19
3,337.69
276.62
2,523.00
3,040.07
4,703.49
4,119.29
4,016.40
211.03
3,365.54
739.08
1,500.67
4,722.61
2,675.10
1,543.61
1,988.65
3,790.03
2,732.84
3,294.19
3,544.93
3,794.88
2,360.23
3,495.04
1,315.20
1,719.52
524.81
1,896.58
4,577.52
3,248.01
2,546.07
3,444.15
3,191.88
550.85
697.61
2,721.48
1,779.14
719.04
2,644.86
3,280.88
243.34
2,352.86
3,493.39
127.33
2,712.53
4,507.28
2,182.30
3,412.48
3,936.43
3,246.00
765.19
3,787.08
3,129.19
3,463.01
4,182.80
4,732.30
696.21
966.46
3,161.41
2,426.62
4,129.74
3,559.00
2,366.70
3,039.01
2,240.60
2,406.27
4,439.73
3,579.35
4,767.25
3,225.81
288.40
3,801.73
4,460.96
888.19
2,834.30
3,022.27
4,509.72
3,622.16
3,260.60
3,875.81
3,510.49
97.82
1,296.30
366.43
891.44
2,461.61
3,368.94
4,684.49
586.00
4,566.91
1,676.59
3,151.21
2,132.22
3,377.94
498.91
1,514.16
215.99
2,548.84
4,804.74
1,797.08
1,150.42
1,951.65
864.45
2,239.99
1,828.50
1,925.42
797.40
4,768.04
391.78
3,359.75
1,656.14
1,796.90
1,830.35
2,377.83
2,250.84
1,365.93
4,055.39
3,266.85
2,746.22
1,905.17
4,990.99
3,469.85
172.49
167.86
2,070.05
2,148.17
1,182.40
1,843.42
1,956.02
4,362.39
1,772.60
2,593.82
877.83
2,273.37
1,436.84
3,784.60
4,394.45
983.83
1,598.33
4,933.02
3,850.18
774.61
3,011.12
4,797.45
773.57
4,020.47
1,336.20
1,100.80
4,931.63
2,564.74
464.88
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
// This file locates: "Scripts/Lesson/C1FlexGrid/ColumnsMultiPaneGrids.js".
c1.documentReady(function () {
    var theGridLeft = wijmo.Control.getControl('#theGridLeft');
    theGridLeft.itemsSource = getData();
    theGridLeft.scrollPositionChanged.addHandler(function (s, e) {
        syncGrids(s, theGridRight)
    });
 
    var theGridRight = wijmo.Control.getControl('#theGridRight');
    theGridRight.itemsSource = theGridLeft.collectionView;
    theGridRight.scrollPositionChanged.addHandler(function (s, e) {
        syncGrids(s, theGridLeft)
    });
 
    // support wheel scrolling on both grids
    theGridLeft.hostElement.addEventListener('wheel', applyWheel);
    theGridRight.hostElement.addEventListener('wheel', applyWheel);
    function applyWheel(e) {
        var root = wijmo.closest(e.target, '[wj-part="root"]');
        if (root) {
            root.scrollTop += 32 * (e.deltaY < 0 ? -1 : +1);
            e.preventDefault();
        }
    }
 
    // synchronize the vertical scrolling position
    // NOTE: the selection is synchronized automatically since both
    // grids are bound to the same CollectionView
    function syncGrids(main, sub) {
        sub.scrollPosition = new wijmo.Point(sub.scrollPosition.x, main.scrollPosition.y);
    }
 
    // move the last two columns to the grid on the right
    theGridRight.columns.clear();
    for (var i = 0; i < 2; i++) {
        var lastCol = theGridLeft.columns[theGridLeft.columns.length - 1];
        theGridLeft.columns.remove(lastCol);
        theGridRight.columns.push(lastCol);
    }
 
    // get some random data
    function getData() {
        var countries = 'US,Germany,UK,Japan,Italy,Greece,Austria,Belgium,China,Korea'.split(','),
                data = [];
        for (var i = 0; i < 200; i++) {
            data.push({
                id: i,
                country: countries[i % countries.length],
                downloads: Math.round(Math.random() * 20000),
                sales: Math.random() * 10000,
                expenses: Math.random() * 5000,
                amount1: Math.random() * 5000,
                amount2: Math.random() * 5000,
                amount3: Math.random() * 5000,
                amount4: Math.random() * 5000,
                amount5: Math.random() * 5000,
                amount6: Math.random() * 5000,
                amount7: Math.random() * 5000,
                amount8: Math.random() * 5000,
                important: i % 5 == 0
            });
        }
        return data;
    }
});
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
// This file locates: "Content/css/Lesson/C1FlexGrid/ColumnsMultiPaneGrids.css".
/* the container for the grids */
.freeze-right {
  background: rgba(0,0,0,.1);
  border: 1px solid grey;
  height: 350px;
  width: auto;
  display: inline-block;
}
 
/* the grids in the container */
.freeze-right > .wj-flexgrid {
  display: inline-block;
  height: 100%;
  width: auto;
  max-width: 400px;
  border: none;
  border-radius: 0;
}
 
/* remove the vertical scrollbar from the grids grid */
.freeze-right > .wj-flexgrid:first-child div[wj-part=root] {
  overflow-y: hidden !important;
}
 
/* don't show selection on grids that don't have the focus */
.freeze-right .wj-flexgrid:not(.wj-state-focused) .wj-cell.wj-state-selected {
  background-color: inherit;
  color: inherit;
}
1
2
3
4
5
6
7
8
9
10
11
12
13
using System.Web.Mvc;
 
namespace LearnMvcClient.Controllers
{
    public partial class C1FlexGridController : Controller
    {
        // GET: ColumnsMultiPaneGrids
        public ActionResult ColumnsMultiPaneGrids()
        {
            return View();
        }
    }
}
1
2
3
4
5
6
7
8
9
10
11
<h1>
    @Html.Raw(Resources.C1FlexGrid.ColumnsMultiPaneGrids_Title)
</h1>
<p>
    @Html.Raw(Resources.C1FlexGrid.ColumnsMultiPaneGrids_Text1)
</p>
 
<div class="freeze-right">
    @Html.C1().FlexGrid().Id("theGridLeft").ShowAlternatingRows(false)
    @Html.C1().FlexGrid().Id("theGridRight").ShowAlternatingRows(false).HeadersVisibility(C1.Web.Mvc.Grid.HeadersVisibility.Column)
</div>