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
12,929
1,241.63
4,774.11
2,678.68
3,159.62
1,260.28
1,885.02
461.61
4,509.25
698.31
1
Germany
4,642
8,992.34
31.46
2,203.14
3,088.64
1,554.50
1,804.37
1,662.71
441.83
4,825.78
2
UK
4,838
8,377.48
698.23
4,112.57
3,757.15
4,291.01
1,049.87
4,836.53
4,335.43
3,592.17
3
Japan
4,340
214.08
906.89
1,811.17
360.68
1,132.86
2,972.16
1,964.45
673.17
2,948.11
4
Italy
3,393
7,930.58
4,076.53
2,081.80
1,126.83
4,809.57
2,216.60
2,726.96
778.02
3,917.22
5
Greece
12,640
2,964.32
2,735.37
4,286.47
729.12
4,889.59
3,762.49
1,102.02
4,662.34
2,208.89
6
Austria
14,462
5,172.82
4,602.30
4,649.08
233.95
1,009.93
4,682.13
4,320.68
1,146.03
4,080.72
7
Belgium
16,482
1,153.00
2,066.40
2,922.75
3,905.34
2,996.02
1,803.43
665.23
1,837.83
3,023.41
8
China
4,334
3,867.81
228.37
2,872.83
380.68
3,031.19
3,079.52
4,756.76
879.15
1,599.40
9
Korea
15,954
9,397.88
4,559.09
3,186.49
1,350.38
628.98
2,562.07
2,381.73
2,471.76
871.00
10
US
11,235
2,566.47
4,119.18
4,542.77
4,057.91
3,448.15
1,035.73
2,076.25
495.44
4,419.21
11
Germany
18,072
6,767.28
2,107.92
3,756.09
90.76
4,921.97
1,444.78
3,109.48
198.72
4,831.14
12
UK
10,862
2,911.45
1,763.51
4,936.97
4,336.55
2,038.18
4,353.44
493.21
1,380.39
1,064.24
13
Japan
13,326
5,346.22
379.09
3,973.10
1,519.35
2,261.69
2,626.33
1,844.38
1,665.80
2,938.71
14
Italy
8,549
9,468.02
4,829.17
3,527.19
3,881.73
3,687.82
2,713.97
2,651.15
2,428.15
2,898.29
15
Greece
3,809
3,093.25
2,258.12
354.94
2,708.17
4,276.61
2,758.39
582.32
2,179.33
701.20
16
Austria
9,133
8,802.94
1,263.37
49.84
2,637.73
3,627.76
2,144.61
2,554.82
2,456.22
1,672.49
17
Belgium
9,108
2,777.69
189.12
1,751.78
4,161.85
812.58
988.94
2,804.43
3,421.97
3,991.76
18
China
15,541
6,510.99
3,823.91
970.48
4,601.63
3,954.79
4,475.52
2,196.42
1,706.32
3,995.80
19
Korea
3,764
4,720.38
2,375.32
2,236.68
1,056.19
3,939.96
4,977.84
2,385.81
1,269.75
2,086.22
20
US
1,927
7,900.61
4,331.33
931.25
4,977.02
2,916.13
2,680.85
795.01
245.73
2,365.27
21
Germany
6,853
2,353.71
1,356.09
2,868.80
1,500.76
2,198.27
4,755.83
4,721.36
2,422.26
1,124.99
22
UK
2,771
3,675.19
4,526.38
3,199.19
653.55
983.47
3,548.44
4,657.26
2,228.25
3,931.57
23
Japan
1,548
998.49
3,187.70
958.62
4,622.51
3,044.14
3,737.20
1,076.63
621.86
3,585.49
24
Italy
15,256
7,835.36
4,462.23
2,638.78
533.32
175.69
2,098.09
1,414.53
3,245.40
1,303.33
25
Greece
3,015
7,644.63
75.71
638.48
2,755.06
4,869.48
2,330.60
2,768.00
4,628.20
2,227.19
26
Austria
790
7,146.49
1,900.01
1,695.31
115.63
4,426.43
4,411.94
4,344.94
4,483.65
2,590.99
27
Belgium
16,729
6,368.17
2,981.78
2,509.88
3,846.63
1,500.48
1,279.80
3,327.61
3,610.22
1,178.54
28
China
5,763
2,954.51
3,872.98
170.94
3,017.33
420.32
2,663.08
3,709.12
2,447.06
1,784.38
29
Korea
11,172
7,185.88
4,191.02
2,913.17
1,085.28
3,551.95
1,852.79
416.86
2,416.24
2,623.24
30
US
18,657
4,877.13
1,190.68
1,526.54
1,046.34
530.08
3,961.56
2,430.04
3,381.74
366.75
31
Germany
17,947
1,216.55
3,631.67
3,955.66
1,056.83
1,651.86
1,579.13
4,798.80
452.00
2,180.69
32
UK
16,879
5,727.72
3,136.91
2,896.60
3,871.14
4,962.10
1,098.10
2,165.77
4,727.78
29.45
33
Japan
13,022
7,697.61
2,177.26
3,430.30
3,478.13
4,795.71
2,292.21
4,405.61
4,557.44
2,077.64
34
Italy
18,634
5,237.40
4,445.31
1,679.59
2,069.07
980.75
2,075.23
3,893.98
2,083.46
4,025.13
35
Greece
18,369
3,292.53
4,636.43
4,908.75
4,424.54
2,274.10
3,511.06
3,792.21
3,830.22
4,022.99
36
Austria
9,147
703.08
3,674.85
2,812.96
594.75
851.51
1,155.84
651.47
2,458.57
3,639.48
37
Belgium
8,705
512.81
2,355.73
3,509.23
2,788.82
3,936.05
775.36
3,824.44
1,524.79
3,125.45
38
China
17,377
5,458.36
4,852.01
3,552.00
3,642.17
4,636.41
2,063.72
1,045.26
726.19
4,554.27
39
Korea
9,885
440.11
1,309.12
1,879.49
2,979.54
106.93
3,439.49
4,926.76
3,659.81
1,030.85
40
US
18,824
5,555.68
137.48
2,485.29
1,825.38
3,586.80
3,692.72
2,314.98
779.02
2,208.33
41
Germany
18,897
7,218.01
275.67
1,713.07
308.20
4,646.17
2,616.06
4,525.18
4,240.23
4,130.94
42
UK
13,888
271.22
2,256.36
819.44
2,889.04
2,890.95
1,775.37
3,355.26
3,727.93
3,830.32
43
Japan
6,018
9,282.27
1,730.09
3,133.19
3,723.08
3,575.61
1,180.57
4,742.50
4,377.24
3,646.00
44
Italy
18,378
3,271.84
1,819.61
3,134.96
4,618.70
4,972.90
1,809.44
2,354.13
2,273.72
1,380.62
45
Greece
3,468
3,925.53
2,239.87
1,774.88
4,580.78
1,025.40
4,216.81
4,267.43
1,202.99
2,116.34
46
Austria
18,722
3,552.36
1,504.17
2,297.44
2,989.92
1,013.93
17.36
2,657.60
3,632.46
4,793.48
47
Belgium
14,212
8,872.43
251.43
848.73
2,515.53
4,933.98
4,834.37
4,950.76
1,086.43
1,143.56
48
China
15,597
5,205.32
3,399.11
2,530.96
42.74
4,503.31
3,939.86
4,068.93
4,852.26
2,747.41
49
Korea
16,400
4,006.15
4,403.90
3,371.40
560.62
1,234.58
1,306.38
3,123.23
431.91
288.40
50
US
16,403
8,049.92
36.61
1,280.91
2,911.62
3,680.93
1,741.63
3,618.15
3,284.20
3,497.66
51
Germany
3,525
1,499.00
3,332.44
1,858.07
2,535.07
2,180.43
286.67
4,184.78
1,359.64
3,244.13
52
UK
7,210
6,842.43
1,436.78
4,938.54
3,746.07
2,363.84
3,666.94
1,756.94
1.11
4,267.00
53
Japan
17,029
2,940.53
4,759.74
4,164.51
283.20
31.84
3,768.12
3,525.34
2,215.65
4,958.79
54
Italy
6,365
5,600.44
2,544.12
3,628.85
553.61
2,964.65
4,576.59
897.20
328.84
2,018.99
55
Greece
8,312
7,412.01
2,492.33
509.31
375.62
4,938.49
477.22
1,223.07
2,116.76
1,895.67
56
Austria
18,297
9,072.26
4,108.65
2,279.71
2,573.00
1,808.90
4,926.10
2,772.25
825.95
3,399.84
57
Belgium
1,958
850.80
4,982.54
388.25
2,478.22
2,338.28
2,933.86
3,039.49
1,319.93
1,867.13
58
China
671
4,942.01
2,510.69
1,328.81
3,363.30
4,121.10
3,376.72
301.11
3,716.25
1,105.98
59
Korea
3,963
8,198.34
1,110.68
1,140.92
3,413.31
173.65
1,808.24
4,001.94
4,811.62
3,762.12
60
US
18,493
8,718.23
4,370.03
3,968.16
3,035.38
4,926.89
3,997.66
268.99
4,789.84
3,977.08
61
Germany
15,715
7,434.01
2,003.00
4,379.48
910.36
983.04
4,317.59
1,817.10
3,813.25
4,634.02
62
UK
14,727
5,058.09
2,312.30
3,899.27
4,665.97
4,648.59
2,363.26
4,973.76
889.78
1,874.95
63
Japan
18,372
8,449.54
3,930.84
340.72
4,437.97
2,265.90
1,852.13
3,827.79
356.38
1,116.50
64
Italy
19,232
2,056.31
4,105.08
4,326.30
1,921.25
4,012.32
1,135.16
1,272.40
4,333.17
3,460.88
65
Greece
11,904
891.03
3,700.42
2,258.58
1,843.05
2,044.72
838.57
4,838.91
1,052.63
3,195.66
66
Austria
12,126
8,608.92
648.46
3,191.77
2,789.92
1,723.92
3,165.13
1,200.68
2,215.60
2,700.36
67
Belgium
5,125
7,008.25
1,385.99
601.09
3,403.97
3,388.76
1,647.93
1,883.24
871.81
1,889.31
68
China
17,687
9,880.56
51.09
1,056.40
1,659.81
986.02
55.56
1,314.38
2,573.42
669.97
69
Korea
13,602
4,739.23
3,410.03
2,575.67
2,632.42
2,325.68
1,537.83
3,303.42
1,259.34
3,867.82
70
US
9,407
6,372.82
2,479.41
1,836.38
3,914.14
1,248.74
4,686.38
3,430.61
3,153.41
4,670.62
71
Germany
16,914
1,574.53
2,398.33
63.12
1,803.33
12.70
2,375.67
545.05
3,037.78
2,780.96
72
UK
15,853
7,486.81
4,682.14
4,634.05
3,139.63
2,874.30
2,818.71
1,448.01
4,655.62
2,199.11
73
Japan
18,889
4,887.98
1,497.86
4,097.48
3,108.84
2,344.91
2,912.14
3,755.56
2,103.45
3,798.05
74
Italy
7,575
1,945.58
978.97
3,654.76
4,967.88
1,877.30
2,551.49
643.51
2,173.16
1,149.27
75
Greece
14,900
2,174.77
2,224.97
248.78
4,545.94
382.83
274.05
2,951.78
753.47
4,444.34
76
Austria
894
1,560.13
273.82
3,003.54
22.34
2,433.65
2,634.43
3,633.99
4,218.21
2,141.90
77
Belgium
10,342
8,545.31
3,974.18
2,574.64
2,538.32
3,314.71
4,142.71
2,417.34
3,064.83
1,053.32
78
China
1,562
3,527.19
2,217.54
627.54
1,114.85
426.92
3,761.93
2,788.68
3,269.43
2,072.23
79
Korea
13,531
7,073.11
1,834.05
3,207.23
3,949.92
1,506.68
4,354.98
380.56
3,816.27
126.37
80
US
12,413
9,416.37
3,448.81
1,174.48
4,474.01
4,085.64
2,569.78
3,853.07
1,058.45
3,752.70
81
Germany
1,787
1,884.71
1,977.96
1,986.53
4,356.84
2,838.73
3,351.87
2,345.32
3,049.72
1,641.28
82
UK
6,852
1,634.55
3,608.66
4,689.58
3,509.74
3,870.56
1,708.25
2,170.54
2,605.55
2,187.97
83
Japan
17,914
9,551.27
3,800.91
1,261.07
3,028.60
2,525.98
424.03
3,331.01
4,520.98
101.27
84
Italy
10,613
5,196.14
4,161.25
2,686.15
3,204.29
116.89
967.27
2,092.42
2,197.25
3,293.00
85
Greece
4,083
5,864.74
3,301.97
129.90
1,736.94
4,686.90
1,085.99
1,537.24
3,499.10
3,124.19
86
Austria
4,049
463.93
4,331.98
3,410.92
3,999.54
1,538.67
3,044.33
187.34
2,787.72
240.05
87
Belgium
14,798
6,663.06
1,452.03
4,993.27
4,124.40
4,827.44
1,564.10
2,283.09
4,043.04
2,127.99
88
China
19,814
3,037.09
1,764.17
600.55
160.59
3,550.53
3,256.66
4,043.58
1,844.97
622.13
89
Korea
6,728
3,787.58
1,675.40
4,169.96
2,659.66
4,168.27
2,839.59
1,587.26
3,465.44
3,012.95
90
US
18,054
4,197.36
4,849.70
1,556.73
1,574.68
4,453.38
3,412.66
806.36
1,935.44
1,162.28
91
Germany
17,731
1,205.72
969.26
1,837.80
4,770.07
2,484.87
3,742.97
1,120.05
2,207.25
2,048.22
92
UK
1,465
4,333.28
3,023.46
2,988.13
556.44
383.22
2,215.09
1,960.28
326.82
637.76
93
Japan
7,722
4,034.86
2,505.62
3,893.67
4,705.33
3,674.23
3,924.13
2,216.30
1,713.01
1,416.56
94
Italy
8,667
6,508.02
361.30
52.37
868.21
70.40
3,165.54
3,494.88
3,145.72
3,102.37
95
Greece
13,952
6,141.04
2,748.29
4,310.44
2,388.94
3,481.86
2,026.41
2,709.34
4,655.90
623.50
96
Austria
12,478
9,718.74
4,993.19
265.29
2,589.12
2,700.51
2,220.49
1,814.57
3,019.59
4,540.35
97
Belgium
6,207
8,000.48
3,485.15
3,935.57
150.05
4,497.04
225.08
4,708.16
1,484.46
4,698.10
98
China
11,661
7,721.43
4,723.59
4,585.97
3,383.53
1,901.23
1,941.23
2,333.66
2,859.33
3,213.32
99
Korea
10,136
2,522.19
4,157.36
1,904.97
674.48
4,063.03
279.54
1,180.91
591.15
2,519.12
100
US
12,616
4,951.56
673.72
877.73
1,665.85
2,429.14
2,283.42
2,394.42
1,538.05
904.57
101
Germany
18,114
6,294.28
4,551.32
4,186.72
2,686.23
1,642.56
4,273.83
3,141.40
1,874.64
2,973.85
102
UK
7,686
246.97
2,500.73
1,589.55
1,978.42
3,228.61
3,978.38
17.11
1,389.82
1,498.92
103
Japan
8,100
1,972.96
4,805.36
3,722.14
4,356.49
1,379.14
635.68
1,072.32
4,955.20
4,532.98
104
Italy
1,822
6,395.78
3,103.69
4,803.99
2,903.40
3,929.09
1,188.08
1,672.93
2,373.49
1,658.10
105
Greece
5,436
5,904.37
1,007.49
4,871.21
1,107.36
963.73
267.81
1,986.70
1,005.41
3,280.44
106
Austria
8,502
2,032.63
2,070.23
4,450.22
2,458.11
1,953.83
71.91
2,016.16
1,094.93
4,121.12
107
Belgium
18,549
8,557.23
239.33
4,607.54
1,658.74
1,264.95
991.44
420.99
2,170.38
3,112.45
108
China
3,336
7,578.49
9.39
1,465.51
4,987.80
3,981.18
405.34
4,481.67
2,623.29
1,064.97
109
Korea
16,627
5,438.08
2,363.44
1,813.19
3,153.48
4,169.65
822.10
3,748.10
2,827.90
4,033.68
110
US
14,549
3,672.34
4,788.18
1,821.44
3,797.20
4,038.19
3,891.60
4,902.51
42.27
1,543.09
111
Germany
2,341
3,764.97
1,931.89
1,837.28
505.64
322.42
305.01
4,768.89
4,655.33
4,351.35
112
UK
14,589
3,110.63
2,032.53
2,876.58
1,813.55
176.71
900.66
1,031.81
333.78
1,677.87
113
Japan
15,322
1,654.58
1,763.34
1,776.82
4,748.40
4,781.62
1,233.57
2,220.13
1,723.22
2,431.40
114
Italy
5,432
912.78
910.51
1,843.24
4,167.07
4,626.05
3,268.37
812.75
643.95
2,570.37
115
Greece
4,210
5,277.41
2,857.67
4,188.32
2,413.53
1,705.05
727.29
888.90
2,946.06
3,340.66
116
Austria
8,081
8,448.00
2,200.21
4,336.68
306.98
2,210.84
3,508.17
407.37
409.30
2,558.34
117
Belgium
4,527
6,191.64
1,988.39
2,987.08
486.85
873.69
503.72
4,595.30
3,037.85
3,106.62
118
China
11,878
3,382.71
3,341.44
2,684.31
820.42
403.31
687.09
1,616.32
1,144.44
3,673.26
119
Korea
4,426
998.18
272.32
3,500.88
3,881.21
2,516.35
4,044.96
1,942.96
299.55
1,348.42
120
US
11,854
5,734.19
2,536.83
3,161.81
2,394.63
3,637.84
3,015.44
4,933.47
1,858.04
2,651.73
121
Germany
12,030
2,536.58
4,890.00
424.43
2,356.85
4,460.96
3,123.73
4,996.34
3,189.51
1,557.25
122
UK
19,915
8,435.96
2,583.29
2,805.52
4,578.50
3,327.33
3,577.98
555.07
2,350.85
3,366.50
123
Japan
9,479
7,780.86
3,088.35
1,596.29
4,774.75
376.66
2,956.85
827.02
3,742.70
2,165.62
124
Italy
8,392
7,230.61
2,937.54
4,256.87
4,760.41
446.38
3,040.45
2,060.69
3,727.78
198.77
125
Greece
13,601
5,341.55
3,700.43
224.65
1,687.53
4,947.08
1,039.34
362.81
1,074.66
3,365.06
126
Austria
13,868
9,075.23
589.14
2,723.35
1,236.05
4,660.07
1,104.34
4,256.83
2,931.92
253.92
127
Belgium
17,702
4,707.45
2,101.68
4,198.06
2,815.22
3,464.14
2,476.15
3,327.01
1,647.18
3,946.43
128
China
5,750
7,071.36
3,540.37
3,763.85
3,919.94
967.58
1,649.74
909.26
4,841.04
3,288.91
129
Korea
19,189
8,978.03
2,688.48
1,932.22
3,308.17
3,338.06
836.25
1,760.22
3,714.96
1,820.15
130
US
17,382
7,737.94
3,141.17
4,733.13
334.30
2,744.68
4,621.22
1,109.94
960.29
612.07
131
Germany
5,078
9,075.02
3,986.02
4,286.16
4,148.42
3,127.80
4,296.71
4,399.45
2,643.34
1,258.74
132
UK
6,324
6,409.51
4,240.24
3,977.74
1,615.63
1,713.89
3,534.39
1,875.47
1,850.32
1,512.43
133
Japan
2,212
6,093.28
4,318.41
4,110.38
1,139.13
1,455.78
921.22
990.42
3,502.11
2,075.64
134
Italy
8,116
2,414.60
1,103.03
4,879.00
1,563.91
4,007.21
1,870.77
3,379.50
4,932.88
4,141.01
135
Greece
19,350
2,050.53
1,933.60
15.88
361.86
3,535.53
128.45
737.12
4,951.03
614.99
136
Austria
12,673
4,883.76
2,698.99
3,085.68
1,046.16
2,324.29
3,865.46
1,041.03
3,729.47
1,820.57
137
Belgium
19,728
1,135.49
3,024.10
1,117.31
904.02
708.03
4,538.93
3,318.83
4,431.08
318.99
138
China
6,236
511.52
3,966.80
3,553.17
838.11
2,471.58
4,131.94
3,057.09
745.98
2,411.98
139
Korea
11,655
9,325.62
4,091.07
1,223.68
550.96
2,170.16
312.58
3,074.76
2,400.18
4,691.48
140
US
19,286
9,556.67
2,810.51
1,130.24
4,021.73
2,552.41
1,153.33
4,716.47
1,152.21
3,037.57
141
Germany
19,300
6,519.74
1,042.43
142.11
2,555.68
1,764.63
1,626.61
825.89
3,238.69
1,462.84
142
UK
1,089
3,206.15
4,285.22
2,182.30
4,153.55
1,722.30
942.98
1,118.31
4,297.55
1,327.98
143
Japan
8,109
8,985.86
3,865.93
957.93
622.12
3,672.57
2,969.95
4,003.72
64.12
4,812.53
144
Italy
770
678.96
3,789.46
1,305.56
3,142.68
2,895.28
4,469.62
642.45
3,701.84
2,921.67
145
Greece
1,531
6,151.92
29.03
4,601.12
3,177.69
3,149.50
2,495.60
3,675.02
1,402.02
3,514.90
146
Austria
13,237
5,144.63
3,132.34
655.99
1,937.86
431.91
4,410.33
794.10
1,469.41
819.24
147
Belgium
14,421
386.96
4,390.66
2,343.45
3,218.27
4,050.45
2,346.92
3,923.75
3,105.66
559.02
148
China
9,547
5,138.86
4,196.56
2,682.54
4,641.12
249.90
3,286.08
1,704.38
3,581.71
1,222.88
149
Korea
2,473
2,499.42
923.34
2,008.44
161.49
3,435.29
2,047.07
391.42
2,551.43
2,818.33
150
US
2,738
4,440.43
1,558.44
4,406.50
4,024.47
3,418.10
1,473.10
4,341.88
2,313.08
4,874.07
151
Germany
10,158
9,091.26
4,241.56
4,433.04
925.89
2,711.62
1,577.87
4,461.66
1,721.16
80.14
152
UK
5,432
3,841.41
1,337.68
1,834.74
4,285.24
1,899.81
3,123.67
635.32
2,573.67
4,599.62
153
Japan
900
1,756.71
3,390.81
195.38
3,758.55
3,654.53
3,895.74
3,589.27
650.08
2,387.48
154
Italy
17,204
3,254.95
2,147.72
2,319.93
2,019.25
4,397.52
4,661.71
1,009.88
4,875.36
4,427.45
155
Greece
207
5,863.55
2,730.47
1,076.46
2,334.70
1,614.10
450.58
1,228.07
985.33
994.27
156
Austria
5,629
4,028.78
3,097.80
1,952.46
3,092.31
4,420.38
202.63
1,447.41
1,529.53
229.09
157
Belgium
6,848
3,086.38
2,225.32
2,146.95
2,005.36
2,584.18
3,918.91
623.97
4,511.88
4,336.04
158
China
7,066
9,982.65
17.46
4,572.20
4,342.74
2,103.43
2,161.91
4,108.74
875.45
1,832.72
159
Korea
6,181
8,597.95
4,684.87
4,036.10
558.42
4,166.40
1,519.70
4,475.16
1,264.75
3,242.08
160
US
17,854
1,934.55
3,443.88
1,460.61
4,004.74
3,126.49
2,728.09
1,725.86
2,151.65
28.76
161
Germany
14,616
3,480.05
4,515.11
79.90
4,896.00
4,957.47
379.12
4,071.99
601.82
1,376.01
162
UK
8,607
521.78
80.27
828.33
1,159.52
1,298.59
2,928.17
4,033.06
3,967.20
4,812.61
163
Japan
3,411
7,399.14
3,218.58
2,240.49
3,351.16
4,118.60
2,235.76
3,329.51
1,794.93
1,429.02
164
Italy
10,031
7,521.98
2,835.31
3,605.51
4,851.46
81.80
2,044.75
2,919.08
2,275.57
4,580.30
165
Greece
13,955
5,757.97
4,527.03
4,575.06
972.36
4,281.31
3,744.80
4,463.13
3,006.91
3,185.40
166
Austria
5,891
4,649.42
2,856.31
4,713.00
2,606.04
76.52
4,229.36
1,159.67
1,695.52
1,737.62
167
Belgium
4,861
9,320.80
3,849.26
30.98
258.53
2,957.07
4,939.77
4,272.94
1,030.13
3,846.77
168
China
6,827
4,803.20
3,839.11
2,006.46
528.62
3,206.25
2,472.02
839.75
2,218.17
4,650.79
169
Korea
13,550
9,522.50
3,536.33
3,438.30
549.79
1,361.02
3,558.64
4,182.29
3,035.88
1,329.76
170
US
16,365
7,848.57
4,193.55
2,212.94
3,035.57
294.91
3,448.39
4,679.83
41.43
3,300.73
171
Germany
2,994
5,599.44
4,141.60
2,380.11
3,173.95
1,369.27
1,501.30
514.43
4,187.13
4,524.24
172
UK
5,303
7,172.81
512.01
2,666.41
3,622.84
1,586.61
2,315.70
1,589.40
4,832.51
904.81
173
Japan
2,159
3,801.76
4,687.58
2,288.73
4,860.40
4,571.77
7.42
2,180.25
3,185.70
144.45
174
Italy
1,085
8,287.93
311.33
246.65
4,717.62
4,434.27
2,410.78
4,470.65
3,216.53
84.76
175
Greece
9,107
1,687.05
2,420.74
91.81
1,422.10
787.17
465.09
4,553.82
3,987.56
4,713.98
176
Austria
13,128
5,879.92
4,281.40
880.99
1,783.92
4,995.82
4,509.33
3,734.16
62.13
4,625.89
177
Belgium
11,762
1,151.81
976.76
1,728.35
4,546.31
2,880.28
1,444.14
1,469.95
3,382.79
3,596.67
178
China
10,143
9,511.12
505.37
4,466.96
483.62
1,752.58
2,347.52
837.35
521.27
2,987.68
179
Korea
12,033
4,962.33
3,227.97
1,783.66
1,279.38
1,720.78
4,948.90
2,003.60
2,118.96
3,929.56
180
US
4,409
7,275.54
2,121.84
1,050.72
2,471.29
1,186.09
2,814.64
4,872.95
4,346.67
3,464.17
181
Germany
18,025
951.08
3,209.82
1,747.99
2,549.19
3,691.40
4,058.43
4,239.72
1,668.62
3,423.33
182
UK
7,082
5,936.96
2,547.01
4,802.65
804.17
1,015.01
1,498.22
605.88
2,515.07
2,425.25
183
Japan
19,796
9,896.37
495.85
854.80
3,849.39
1,262.42
2,714.75
4,884.66
1,007.30
707.08
184
Italy
5,479
5,922.83
3,149.58
1,992.04
4,776.63
1,736.78
4,607.37
2,685.12
1,394.99
631.05
185
Greece
19,269
5,458.28
141.09
2,686.63
3,354.27
4,426.67
688.69
2,007.57
3,311.33
1,804.35
186
Austria
1,317
7,774.43
4,782.67
1,207.50
390.11
2,431.97
150.11
217.68
3,176.51
4,272.32
187
Belgium
18,617
4,353.08
2,621.63
1,268.96
2,069.06
161.89
4,041.95
4,584.77
3,804.87
591.78
188
China
11,825
2,666.92
1,152.87
487.02
3,166.59
641.74
292.03
4,550.35
2,319.18
3,347.60
189
Korea
5,497
6,748.14
1,345.46
3,177.48
711.52
1,381.64
903.24
2,692.61
3,854.17
4,238.14
190
US
8,670
5,182.40
3,038.06
2,002.36
1,725.96
3,742.84
3,359.55
1,456.16
4,919.36
3,125.69
191
Germany
9,391
5,747.56
3,724.32
3,397.39
4,620.32
2,849.48
3,247.55
3,697.27
1,244.50
1,117.14
192
UK
8,807
4,072.07
4,953.83
1,956.82
498.29
1,517.25
2,562.27
1,193.69
4,256.36
1,865.43
193
Japan
10,385
6,304.04
3,679.85
474.51
3,585.11
4,605.18
4,819.76
3,817.78
3,956.83
3,367.34
194
Italy
16,676
8,237.39
4,391.82
1,787.54
1,779.46
3,327.05
4,283.70
3,639.83
334.43
31.03
195
Greece
4,079
8,248.47
2,517.03
1,889.68
4,727.59
4,820.12
386.89
4,227.80
2,228.21
2,308.07
196
Austria
4,748
2,732.45
26.25
3,235.12
4,020.32
1,205.97
3,589.24
2,585.27
2,712.75
2,203.43
197
Belgium
13,845
1,204.23
949.66
853.56
4,711.09
1,595.49
3,639.61
3,743.32
3,431.51
2,476.20
198
China
3,979
4,329.60
2,807.80
1,034.59
4,457.66
3,375.69
853.55
2,827.86
2,107.91
4,717.25
199
Korea
8,059
5,187.22
3,755.05
3,443.45
1,465.94
1,734.77
2,913.90
4,905.97
3,769.94
4,596.79
Important
Amount8
1,103.41
493.52
672.77
2,713.02
3,406.85
2,260.87
3,357.31
1,825.38
1,497.46
2,154.75
1,482.23
851.79
2,093.78
3,255.44
923.52
4,821.93
3,097.13
4,174.07
3,557.24
2,260.02
549.28
2,449.94
2,012.59
1,224.88
132.90
4,834.77
2,248.18
2,871.74
4,911.03
2,815.53
2,875.24
4,573.06
4,441.59
161.51
300.93
1,321.33
1,180.03
780.48
2,384.54
1,581.06
2,555.70
2,548.85
868.37
1,547.54
1,131.36
4,375.31
1,740.24
4,408.41
2,071.19
4,821.92
1,129.13
2,781.92
4,975.84
552.71
4,042.58
2,990.84
4,744.50
4,186.30
3,524.04
2,168.67
2,785.57
2,027.11
1,327.18
2,615.27
2,032.29
2,672.12
2,862.62
3,489.76
2,574.55
1,238.26
1,904.51
531.94
4,588.96
3,325.35
2,696.33
134.02
4,549.60
1,796.51
3,718.15
3,959.14
4,145.90
3,610.24
3,629.78
1,095.09
3,816.63
4,278.03
1,046.97
2,117.03
2,209.66
1,003.77
1,854.89
3,523.06
2,556.22
4,604.11
1,104.27
4,300.67
800.11
616.30
4,796.42
3,147.13
976.54
2,375.25
781.48
3,151.93
4,461.95
769.26
1,893.87
2,756.98
537.45
859.08
4,899.02
1,617.03
3,521.27
2,806.46
3,945.16
1,598.59
4,917.16
3,487.56
1,607.76
4,024.26
2,874.79
2,314.85
4,738.08
713.96
4,609.70
2,025.88
2,469.41
907.08
1,215.26
2,317.29
3,176.63
3,529.61
4,708.14
4,074.76
3,566.94
2,161.52
3,162.77
2,962.49
4,174.69
3,772.71
4,370.38
357.02
662.54
4,529.39
2,128.29
1,796.51
2,397.41
4,607.48
4,115.93
3,848.50
1,098.36
4,220.42
3,572.33
4,294.07
4,723.96
361.75
556.52
1,964.42
1,253.64
4,299.83
993.44
3,604.27
1.84
3,710.37
1,167.32
281.02
1,265.41
4,444.81
1,282.82
2,615.53
2,283.91
4,298.57
4,730.79
3,292.35
28.90
507.02
1,698.37
3,752.22
1,704.31
1,155.46
4,717.35
4,982.74
1,314.69
1,441.22
2,307.07
2,070.23
1,120.61
3,048.56
1,116.57
2,503.82
4,048.27
3,784.26
4,570.28
4,900.41
4,795.38
1,390.62
658.36
4,017.91
980.61
574.40
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>