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
5,787
4,474.97
585.96
4,432.18
996.75
1,699.50
1,404.65
4,612.16
4,159.71
3,170.67
1
Germany
18,690
7,029.38
3,678.45
4,246.86
3,591.22
3,157.99
51.00
4,576.62
1,684.79
1,436.76
2
UK
9,959
4,300.93
1,328.94
1,396.87
2,118.70
270.46
4,266.58
1,413.01
1,995.64
538.33
3
Japan
5,616
8,193.35
1,772.43
453.50
3,211.18
1,804.82
1,271.01
4,731.73
3,026.44
747.41
4
Italy
13,186
3,766.44
213.57
742.08
2,765.07
4,779.37
3,668.39
131.00
2,982.63
1,980.61
5
Greece
7,029
7,060.81
1,935.00
3,837.54
3,369.53
4,876.81
2,633.57
3,778.78
4,309.19
2,413.78
6
Austria
19,347
1,460.11
3,151.11
4,159.20
438.83
1,677.15
2,050.11
4,476.91
4,517.89
4,458.24
7
Belgium
5,898
7,284.38
3,526.97
579.42
3,922.23
3,284.64
447.57
3,757.90
4,196.95
4,067.01
8
China
1,405
9,649.61
1,519.16
2,899.38
154.69
1,717.44
1,499.02
2,007.46
1,946.52
401.01
9
Korea
647
3,510.09
584.84
4,006.82
4,469.89
3,109.70
2,393.96
4,122.62
2,566.60
2,017.24
10
US
8,089
5,150.56
4,987.71
4,397.71
648.84
2,227.50
118.92
1,397.53
4,478.92
1,703.41
11
Germany
8,104
6,919.76
3,756.59
2,590.87
2,808.61
2,330.32
4,360.21
4,140.59
102.27
282.68
12
UK
1,266
4,569.42
3,190.82
235.90
4,530.13
2,640.42
791.45
4,581.43
4,700.55
1,800.16
13
Japan
4,241
8,801.39
4,536.74
4,446.95
3,090.07
2,248.02
158.92
3,087.29
2,371.58
2,338.20
14
Italy
11,759
7,590.00
1,143.71
663.17
3,489.45
738.05
2,694.23
226.29
1,008.40
2.60
15
Greece
2,164
5,135.91
1,004.66
2,099.87
2,801.23
2,558.18
4,587.23
371.85
2,850.09
2,558.33
16
Austria
2,288
5,217.51
575.76
1,278.98
4,081.71
4,886.49
263.46
3,596.95
2,309.95
1,557.93
17
Belgium
6,009
5,604.09
4,336.55
4,741.86
3,851.52
636.72
2,672.51
1,715.16
1,220.62
3,462.32
18
China
1,866
1,158.88
3,294.52
4,421.43
621.40
230.90
2,324.16
1,799.64
3,986.85
3,901.79
19
Korea
4,547
5,139.38
1,248.36
4,602.92
1,342.88
3,376.59
2,219.93
211.83
974.62
4,682.38
20
US
7,402
372.90
1,110.82
491.30
1,388.29
4,857.83
2,341.28
4,607.34
735.74
1,348.62
21
Germany
8,825
9,115.78
1,623.27
703.21
4,793.30
1,377.60
2,679.34
793.64
3,589.45
3,355.26
22
UK
13,080
466.72
3,927.76
2,032.92
4,274.42
2,905.81
1,870.51
1,818.24
1,009.89
265.45
23
Japan
12,212
9,920.27
609.20
481.88
3,924.60
4,327.47
4,051.31
2,617.06
4,437.78
4,661.82
24
Italy
14,831
9,923.04
701.11
817.31
2,277.16
740.72
4,333.67
1,668.05
1,371.91
555.06
25
Greece
19,459
9,382.46
1,004.98
851.06
2,728.26
1,191.48
1,886.41
1,728.35
2,398.60
3,723.89
26
Austria
14,968
1,841.98
949.18
1,962.86
806.75
3,806.49
1,947.37
1,271.86
3,675.94
3,928.31
27
Belgium
2,081
1,351.65
2,172.18
1,464.18
1,852.66
1,034.00
4,321.96
2,550.76
3,721.79
462.62
28
China
16,271
7,471.69
4,211.85
4,679.82
4,571.41
3,503.09
1,080.89
120.42
1,492.65
2,577.98
29
Korea
15,481
221.33
4,350.13
158.96
1,288.48
2,363.55
1,429.23
4,336.14
4,962.73
3,086.75
30
US
19,305
6,100.77
3,802.34
684.67
4,526.60
3,177.40
1,263.36
1,334.56
3,482.25
4,401.02
31
Germany
2,385
3,159.22
2,489.05
3,966.86
4,246.96
445.20
2,080.43
399.79
4,979.99
308.60
32
UK
11,376
7,951.54
2,160.99
218.48
1,007.17
3,186.78
138.22
4,016.15
3,680.52
2,211.27
33
Japan
1,102
4,083.05
2,726.41
4,401.25
2,619.90
768.20
812.72
805.96
1,065.99
1,001.94
34
Italy
7,833
3,177.12
571.08
4,265.24
3,234.06
4,860.66
1,852.43
189.16
1,760.91
4,388.22
35
Greece
13,433
6,568.02
1,682.75
4,718.66
3,589.79
1,627.22
4,226.65
4,476.48
2,744.72
274.74
36
Austria
10,046
1,800.94
4,696.59
3,422.25
4,842.34
375.68
1,046.14
2,169.39
2,113.78
1,598.62
37
Belgium
2,886
5,946.36
2,219.23
2,463.69
3,799.23
4,605.67
2,275.74
10.51
1,060.02
2,168.32
38
China
1,538
8,355.15
2,794.53
559.87
302.03
244.06
969.37
3,052.29
976.25
2,681.17
39
Korea
11,211
7,484.31
1,410.15
3,644.35
2,236.77
134.06
2,324.29
4,154.11
108.80
3,010.55
40
US
11,132
8,095.28
1,169.06
2,336.07
2,047.10
2,583.11
1,660.42
1,944.40
4,944.18
266.60
41
Germany
16,062
3,774.68
2,942.93
1,158.68
2,139.96
2,722.89
4,852.09
3,134.02
3,442.45
2,215.51
42
UK
12,572
3,855.56
787.02
4,054.22
3,750.47
2,339.04
1,891.80
1,500.06
1,900.55
3,483.49
43
Japan
1,133
136.96
1,976.23
3,888.76
1,007.44
1,786.97
771.01
1,049.78
2,011.49
1,046.96
44
Italy
4,533
536.81
4,618.57
1,434.59
2,550.53
2,339.27
629.96
4,529.03
3,485.24
557.02
45
Greece
9,052
1,326.60
4,040.44
4,611.15
2,200.53
2,797.12
1,402.76
4,395.17
625.52
4,774.95
46
Austria
11,517
7,803.65
729.80
4,153.40
1,166.85
1,447.91
1,123.75
916.36
2,951.60
3,273.04
47
Belgium
13,008
7,018.49
1,767.87
1,975.69
2,159.43
2,129.37
2,280.84
694.41
3,222.08
1,930.79
48
China
748
8,423.30
564.94
3,438.01
38.92
3,447.34
4,113.31
635.49
1,394.43
420.18
49
Korea
17,423
1,326.75
1,387.43
3,355.27
560.61
4,780.41
4,447.98
3,467.40
1,622.87
4,081.26
50
US
15,256
1,742.84
451.24
1,170.63
849.82
4,173.29
1,333.92
2,221.24
2,022.82
532.22
51
Germany
3,049
9,375.28
2,740.26
1,152.11
3,668.28
2,111.26
1,965.31
4,210.42
1,331.58
551.69
52
UK
18,609
5,544.42
619.75
1,267.07
4,302.38
4,371.61
52.57
4,831.33
2,689.58
88.31
53
Japan
5,641
687.37
2,585.50
2,015.89
1,958.97
1,928.19
944.88
1,104.05
1,381.62
1,903.48
54
Italy
17,669
176.71
961.15
4,417.45
473.70
454.74
3,172.95
1,778.65
2,294.07
470.10
55
Greece
3,640
7,534.26
2,778.62
203.12
3,271.82
91.80
1,677.80
4,200.48
1,724.85
4,999.10
56
Austria
16,797
4,242.19
773.64
4,131.71
655.26
3,307.89
1,716.55
100.78
903.13
2,116.15
57
Belgium
3,021
3,756.99
1,507.58
605.91
1,952.58
975.88
3,004.79
2,045.37
3,054.66
1,508.54
58
China
18,033
8,094.20
3,288.30
927.85
2,751.99
3,419.98
3,612.39
2,301.57
627.97
3,832.39
59
Korea
697
5,402.47
4,419.87
4,530.42
1,939.05
496.06
4,641.49
698.19
3,737.45
1,336.91
60
US
17,381
8,274.00
569.83
4,948.77
3,456.48
3,784.70
2,441.90
108.72
3,699.85
1,764.67
61
Germany
5,446
65.84
269.83
2,390.71
1,460.04
2,137.47
416.99
2,522.68
3,648.54
4,948.75
62
UK
7,670
1,961.00
3,470.11
979.84
3,895.88
2,829.94
3,745.66
3,062.80
2,244.09
481.90
63
Japan
14,398
3,491.27
1,743.42
2,883.31
391.63
3,950.24
4,200.93
1,675.52
4,393.81
1,239.59
64
Italy
8,030
8,468.94
1,672.32
4,756.20
4,957.14
70.47
2,712.59
519.90
1,262.21
1,335.07
65
Greece
873
5,465.27
2,336.78
3,648.36
3,148.70
2,830.09
2,166.42
4,708.96
4,555.41
2,168.00
66
Austria
2,629
3,655.59
4,625.94
909.40
540.03
4,026.31
2,834.84
4,454.20
775.61
3,006.86
67
Belgium
13,547
9,335.69
1,041.15
135.85
1,629.69
723.68
4,816.16
3,105.43
659.26
2,521.15
68
China
1,870
3,906.20
4,757.03
4,699.26
1,987.83
3,750.74
1,016.91
2,839.85
4,227.11
2,051.71
69
Korea
7,828
5,626.99
85.42
1,836.48
2,342.69
4,703.14
3,502.96
3,828.70
1,570.61
771.11
70
US
1,626
4,589.60
1,502.05
1,054.71
2,552.93
2,386.38
4,622.30
3,285.04
1,987.22
3,789.23
71
Germany
13,386
1,566.79
1,593.31
3,369.43
2,668.71
2,230.87
4,870.43
3,073.43
123.95
727.89
72
UK
16,157
7,644.56
2,187.01
1,071.79
1,709.82
3,986.81
4,419.27
1,082.43
3,228.63
1,657.62
73
Japan
2,604
3,626.28
4,197.61
3,303.92
3,146.49
1,272.00
1,379.59
460.22
3,069.40
1,444.25
74
Italy
14,213
419.24
1,904.58
3,369.80
2,466.11
2,070.77
2,709.33
4,661.66
4,212.96
3,858.84
75
Greece
985
7,773.63
4,050.33
2,378.77
2,467.38
997.35
3,989.97
1,238.76
150.44
4,045.80
76
Austria
13,066
5,037.75
4,779.77
580.14
2,493.24
439.64
2,689.37
4,635.12
2,117.36
4,946.05
77
Belgium
17,614
3,843.14
2,847.43
4,705.60
4,138.72
2,669.88
1,978.68
1,551.85
420.53
716.80
78
China
12,380
2,618.34
1,203.18
1,260.25
3,092.21
3,461.25
4,132.44
985.57
1,275.32
1,759.99
79
Korea
8,071
4,844.19
1,244.38
2,315.09
1,981.53
4,158.95
1,200.15
4,338.36
732.36
2,164.48
80
US
8,790
7,380.40
1,940.25
367.22
1,697.98
4,269.23
2,814.97
3,862.71
1,564.06
3,495.61
81
Germany
18,130
6,698.68
3,990.23
165.87
41.33
3,811.79
2,639.32
1,557.83
3,048.83
3,131.72
82
UK
13,072
5,685.65
3,647.83
2,174.47
3,286.93
4,136.23
2,954.37
1,827.01
4,545.50
4,908.12
83
Japan
17,120
9,138.06
3,089.96
1,822.90
2,095.43
1,302.62
4,842.87
4,625.18
604.25
1,293.71
84
Italy
5,374
9,961.69
3,037.72
2,235.45
469.70
4,408.67
1,596.03
146.43
1,677.20
5.16
85
Greece
1,766
8,360.88
317.03
4,312.39
3,652.91
1,066.32
4,596.74
3,331.01
712.90
904.86
86
Austria
10,595
6,828.29
1,586.48
2,042.87
1,689.15
883.59
1,587.30
1,065.41
3,362.53
2,367.54
87
Belgium
18,554
9,788.02
1,462.30
4,138.53
535.68
249.52
511.07
240.71
3,748.39
4,169.93
88
China
6,640
2,710.27
4,410.09
4,592.29
1,010.44
1,636.28
4,489.16
2,129.77
3,283.76
816.65
89
Korea
17,868
7,967.14
4,200.73
4,395.35
702.39
2,401.43
1,394.83
4,503.66
523.15
4,900.38
90
US
13,917
1,273.43
2,966.06
1,479.35
1,298.55
3,548.09
3,635.81
2,234.34
2,597.48
4,125.62
91
Germany
8,797
7,127.70
3,518.89
4,236.56
3,903.17
2,861.84
219.62
3,479.78
1,573.31
4,989.07
92
UK
17,231
16.69
3,942.56
1,153.38
2,718.63
3,575.90
4,741.29
1,024.34
3,148.99
54.53
93
Japan
8,436
1,726.95
1,139.71
1,196.53
614.47
1,421.92
2,438.16
4,073.13
4,934.72
3,549.29
94
Italy
17,609
1,871.88
4,254.21
3,954.74
1,219.95
123.62
3,579.01
839.02
1,633.05
4,841.70
95
Greece
6,330
4,287.71
4,323.75
4,283.65
434.89
1,308.05
2,426.06
1,120.86
892.68
1,301.19
96
Austria
15,549
3,125.28
1,554.36
368.83
1,016.98
399.72
1,196.89
3,468.33
1,485.61
2,223.83
97
Belgium
2,213
2,470.68
4,867.99
3,464.40
2,714.04
2,682.46
2,479.29
4,735.75
3,953.32
3,535.63
98
China
10,795
8,368.20
3,515.77
1,278.91
2,433.89
4,936.69
2,932.39
3,013.31
3,838.81
580.95
99
Korea
9,761
7,279.48
2,228.21
4,185.98
4,919.69
1,747.55
3,228.61
3,369.20
1,122.99
3,777.48
100
US
1,944
1,588.49
820.11
432.43
1,680.12
1,942.43
4,245.88
123.38
2,599.83
1,441.18
101
Germany
17,474
3,426.71
3,164.08
1,585.73
1,906.27
4,000.75
33.26
3,944.47
3,410.10
2,709.76
102
UK
1,084
626.69
4,284.36
3,759.56
968.86
1,450.83
2,253.56
3,356.73
3,348.90
869.13
103
Japan
8,604
5,784.56
4,719.60
1,370.26
898.56
4,785.16
4,676.76
2,266.87
4,414.31
2,021.71
104
Italy
2,086
1,022.30
3,361.16
1,786.02
3,864.84
3,312.40
3,405.73
4,025.81
2,472.13
2,201.06
105
Greece
2,106
8,601.34
1,496.12
1,817.74
169.46
3,237.67
2,721.53
1,868.13
201.17
3,299.67
106
Austria
917
2,164.04
1,882.13
1,188.41
1,729.83
930.84
162.37
2,112.29
3,050.70
4,786.50
107
Belgium
17,163
9,224.90
4,184.44
4,790.63
720.29
663.76
1,920.49
2,065.95
3,359.38
2,928.96
108
China
18,166
6,480.61
2,599.41
775.83
1,215.67
2,562.80
2,984.01
2,859.91
4,814.19
1,756.94
109
Korea
5,509
9,232.24
2,121.22
1,704.67
154.86
145.16
3,589.98
2,064.92
3,816.37
316.66
110
US
12,435
3,537.50
2,665.47
4,044.52
4,268.58
974.17
3,786.52
3,433.51
271.11
1,849.35
111
Germany
15,029
6,153.08
4,895.13
1,336.35
2,724.05
1,156.42
4,419.21
3,647.64
3,013.10
2,964.62
112
UK
9,327
5,889.85
2,646.97
4,988.91
3,762.79
3,391.56
1,794.56
2,274.44
657.69
4,884.43
113
Japan
7,269
5,945.41
811.90
661.73
937.33
1.39
2,424.78
2,579.19
2,920.64
3,188.97
114
Italy
12,304
2,647.47
1,899.17
1,440.25
4,139.84
1,635.11
1,200.71
2,632.77
4,127.91
1,771.79
115
Greece
18,732
8,879.49
630.12
1,148.72
4,568.65
3,148.10
2,258.39
3,063.30
2,504.43
4,779.29
116
Austria
7,051
1,820.26
1,999.37
4,033.07
4,064.84
614.08
4,755.83
17.31
1,252.17
2,598.10
117
Belgium
3,329
8,677.40
2,281.75
2,783.99
1,430.17
4,894.37
2,471.28
680.76
1,304.19
3,280.81
118
China
2,085
2,584.00
4,221.82
1,907.96
3,140.42
3,984.11
2,622.98
2,410.46
2,159.45
3,073.37
119
Korea
5,557
5,204.98
1,089.59
4,905.76
2,831.68
2,107.26
4,909.10
3,945.71
3,162.39
1,440.20
120
US
9,033
6,642.31
1,135.06
2,257.85
767.95
2,201.26
3,764.19
1,011.86
4,874.22
2,406.92
121
Germany
14,655
9,390.81
1,452.22
2,918.74
2,664.29
1,856.62
1,156.48
3,186.88
4,636.39
960.88
122
UK
757
8,816.77
1,375.07
3,646.02
2,363.39
462.91
3,031.16
2,160.82
4,738.20
443.07
123
Japan
2,935
6,482.91
3,355.76
4,862.08
530.45
2,977.43
4,829.50
2,269.63
32.22
3,578.57
124
Italy
11,046
8,038.67
2,987.18
3,035.80
2,396.03
4,702.77
4,348.15
154.67
1,132.23
4,235.20
125
Greece
16,892
2,616.74
810.84
2,883.56
2,229.95
253.79
3,776.39
2,736.30
4,803.51
3,828.04
126
Austria
609
551.43
1,093.38
3,590.19
3,369.99
3,581.12
112.31
3,676.23
2,489.72
1,727.60
127
Belgium
9,075
2,129.18
2,798.92
1,881.17
3,424.08
3,468.53
3,567.70
4,209.22
2,395.08
2,146.46
128
China
10,117
3,109.35
3,908.05
4,192.78
4,606.10
3,058.14
175.83
1,733.06
919.85
1,013.67
129
Korea
14,515
9,055.45
802.36
3,517.11
1,155.60
2,050.32
2,251.14
3,800.87
2,101.33
4,573.16
130
US
14,422
996.06
432.37
941.03
4,522.12
4,409.27
3,314.12
1,596.04
2,076.32
2,936.70
131
Germany
7,417
2,926.21
4,235.92
513.02
2,652.69
2,716.10
3,405.74
2,253.60
567.12
2,295.30
132
UK
1,487
5,149.63
4,909.72
4,913.82
2,512.14
1,995.21
2,251.33
1,903.37
480.02
3,487.26
133
Japan
15,649
8,226.58
133.44
628.70
379.82
1,184.45
506.00
3,429.08
1,066.31
1,232.69
134
Italy
899
4,960.07
1,964.34
2,679.55
1,562.62
3,629.72
4,007.24
307.41
2,691.00
2,422.47
135
Greece
13,517
4,426.62
3,524.66
3,979.07
2,799.14
962.15
2,326.79
4,625.68
3,151.00
894.50
136
Austria
12,335
519.77
1,762.15
321.55
3,932.87
1,147.00
1,775.50
3,512.35
2,958.02
3,963.80
137
Belgium
15,212
737.73
1,405.58
2,392.09
4,816.82
2,004.97
2,281.34
4,543.90
3,314.36
4,888.70
138
China
13,073
2,529.45
443.51
4,837.44
1,553.38
2,097.40
1,082.72
3,444.49
3,465.08
1,718.75
139
Korea
4,335
6,595.53
2,425.49
1,748.93
4,970.82
4,405.06
559.16
2,759.59
2,775.86
456.32
140
US
10,241
1,736.70
4,627.21
2,193.85
4,189.93
2,697.19
840.86
2,459.33
1,176.02
1,724.57
141
Germany
13,741
1,802.25
2,591.27
490.98
1,416.34
1,542.48
2,497.32
2,323.21
1,091.30
1,634.83
142
UK
13,092
9,144.03
2,915.72
1,024.56
3,525.44
1,810.88
2,904.71
916.48
1,315.06
1,464.63
143
Japan
8,054
7,325.28
653.35
1,688.40
3,944.11
3,889.32
365.54
3,219.52
2,158.92
3,931.41
144
Italy
4,065
1,888.78
1,662.24
3,696.51
4,779.88
1,086.27
4,511.84
278.38
2,217.63
3,483.63
145
Greece
3,755
3,871.59
4,933.69
4,975.84
770.87
4,615.52
2,828.62
2,334.82
2,382.34
2,135.13
146
Austria
13,243
4,328.95
1,071.39
351.05
1,769.06
4,029.32
200.56
3,166.71
1,739.71
2,319.11
147
Belgium
9,046
2,494.35
1,182.62
757.30
4,491.78
1,108.62
4,801.26
1,378.12
342.17
1,625.65
148
China
167
5,436.95
529.90
3,918.49
1,331.94
2,350.10
3,318.49
3,868.22
3,285.32
3,996.73
149
Korea
14,966
2,036.03
3,491.98
275.52
3,947.61
2,975.26
1,468.90
4,306.61
3,519.17
2,639.56
150
US
17,609
9,999.06
4,636.29
4,485.47
1,739.28
1,505.94
2,591.29
1,560.58
434.75
2,892.29
151
Germany
15,451
6,789.83
2,018.97
2,122.96
2,426.94
3,435.92
1,287.48
1,752.25
3,460.40
3,733.99
152
UK
7,863
8,481.92
702.62
416.35
4,736.73
2,140.75
2,733.70
3,599.77
4,989.85
3,965.97
153
Japan
3,947
5,618.17
2,391.11
1,084.41
2,086.65
1,852.28
62.77
4,050.96
4,406.63
2,822.96
154
Italy
17,537
652.99
1,353.59
1,714.47
1,820.82
4,467.93
1,830.15
4,993.49
4,223.97
28.23
155
Greece
15,957
859.98
819.14
138.26
2,109.83
4,921.01
206.05
1,438.86
1,500.63
2,167.72
156
Austria
8,902
6,625.05
384.69
3,208.22
3,466.23
4,503.10
2,926.59
2,926.00
1,353.36
2,728.50
157
Belgium
10,102
6,207.88
136.40
276.64
1,084.05
1,271.37
2,959.35
303.75
1,393.62
1,948.97
158
China
6,561
5,456.64
3,953.51
1,586.20
2,245.94
371.71
1,211.93
389.22
3,509.67
4,048.30
159
Korea
3,792
848.60
2,245.91
734.30
536.25
4,886.72
989.11
1,531.39
1,076.49
1,865.72
160
US
19,980
336.96
1,020.83
3,249.01
3,271.55
3,705.64
759.99
998.44
1,166.04
3,479.84
161
Germany
10,283
2,742.88
1,207.65
1,412.77
2,551.48
4,764.67
3,599.35
650.26
919.08
2,462.00
162
UK
12,616
2,101.47
1,122.21
961.65
49.68
3,079.03
4,780.19
693.77
2,205.40
3,939.62
163
Japan
7,971
7,659.79
4,171.51
496.90
1,683.94
2,678.98
2,437.56
4,336.68
4,630.85
1,143.32
164
Italy
4,192
7,814.59
1,069.54
4,792.31
4,862.52
4,285.08
626.32
3,176.25
1,334.67
2,108.97
165
Greece
3,373
5,035.91
3,959.95
3,484.03
807.40
3,522.62
3,687.90
1,830.62
3,754.07
3,499.38
166
Austria
13,484
9,116.07
3,729.76
2,793.56
2,293.91
369.12
3,875.92
2,955.23
3,900.34
4,674.28
167
Belgium
15,705
4,044.02
4,717.39
4,534.83
2,446.17
2,173.91
4,534.69
3,343.67
2,298.55
4,231.23
168
China
11,141
4,603.58
2,492.71
4,518.74
353.54
2,396.24
1,140.31
2,696.38
89.49
259.26
169
Korea
5,118
453.64
1,077.72
3,555.26
3,944.18
376.73
4,354.67
4,131.24
1,365.56
851.33
170
US
347
8,240.03
1,559.89
1,749.12
1,410.97
1,325.95
3,553.53
580.33
2,603.70
1,042.14
171
Germany
17,941
7,228.73
4,581.72
2,258.66
3,063.00
94.48
4,238.61
1,751.54
1,038.22
4,820.96
172
UK
5,750
3,834.09
2,092.87
317.15
1,272.21
94.41
1,215.11
3,656.41
123.64
4,446.19
173
Japan
19,784
7,637.34
4,100.73
442.61
3,722.55
4,002.22
2,378.98
2,985.43
3,760.51
1,920.20
174
Italy
12,098
7,821.99
1,851.75
2,980.53
3,714.20
415.46
4,487.54
2,320.09
787.79
3,404.84
175
Greece
19,794
8,573.18
819.52
937.69
4,170.60
1,503.26
2,809.75
1,681.25
670.50
4,839.43
176
Austria
13,840
4,232.30
985.18
4,458.12
4,345.46
2,055.87
4,337.09
3,582.40
4,781.12
2,214.73
177
Belgium
16,528
3,670.78
1,733.87
2,639.28
3,987.07
1,446.52
2,466.19
400.81
1,631.01
1,232.49
178
China
5,229
2,091.84
2,345.24
2,431.71
738.89
4,720.08
2,748.64
3,691.11
2,535.51
3,383.09
179
Korea
275
5,573.87
122.33
1,994.21
3,726.51
1,090.52
2,464.02
3,831.87
1,935.89
4,545.18
180
US
1,263
2,472.82
1,140.29
2,877.22
3,500.12
4,249.52
4,435.92
1,101.70
158.19
1,818.16
181
Germany
11,369
1,570.61
3,388.93
1,983.94
260.25
3,915.44
2,637.24
2,489.73
3,601.83
3,636.17
182
UK
1,827
1,452.71
3,704.66
2,459.21
1,443.02
4,580.36
317.54
2,461.74
290.68
3,287.46
183
Japan
12,754
6,493.85
4,954.40
1,618.36
339.71
4,798.49
3,359.55
3,998.66
1,897.64
1,823.57
184
Italy
19,537
5,896.22
1,057.19
4,990.86
4,573.59
4,066.50
1,468.87
2,814.25
824.15
4,009.71
185
Greece
17,365
8,217.63
3,976.06
1,581.70
995.84
1,425.58
4,679.87
452.77
3,365.49
910.54
186
Austria
6,107
2,159.07
2,959.29
3,980.34
1,046.91
491.64
3,074.32
2,568.04
2,419.92
2,984.94
187
Belgium
12,789
5,115.78
745.46
1,574.59
1,778.93
4,113.07
963.76
3,310.27
1,935.01
838.12
188
China
646
3,567.02
4,140.35
4,441.71
3,340.17
2,709.24
1,293.63
693.80
3,764.09
4,890.61
189
Korea
9,146
9,792.78
1,516.88
2,271.69
4,558.99
4,869.49
744.87
1,459.97
2,779.09
3,777.80
190
US
14,592
9,620.50
3,683.32
2,526.88
4,007.62
3,046.85
2,392.03
4,352.88
126.34
3,043.02
191
Germany
1,241
2,137.97
363.80
2,619.13
4,383.58
49.36
3,258.78
3,873.17
884.06
4,828.67
192
UK
7,027
8,581.70
1,904.38
223.10
3,193.12
1,330.22
4,090.35
1,892.71
2,441.20
1,563.48
193
Japan
17,904
138.39
43.72
2,598.60
1,376.49
1,405.94
3,648.35
1,431.52
253.51
2,792.85
194
Italy
1,766
7,984.65
4,501.92
2,411.76
4,831.69
302.57
1,620.66
3,149.22
4,050.90
3,129.61
195
Greece
6,467
5,034.07
2,822.79
4,064.45
2,597.40
3,493.91
1,094.48
109.55
4,941.71
2,492.78
196
Austria
2,398
5,850.32
4,302.93
4,347.18
4,302.01
4,377.10
2,339.24
2,538.15
4,275.96
4,860.87
197
Belgium
19,722
1,093.28
1,090.57
574.42
1,784.55
4,583.93
1,446.03
121.12
2,063.11
3,960.00
198
China
19,159
9,170.30
3,797.75
2,442.02
334.40
16.46
2,049.33
493.64
4,316.10
99.18
199
Korea
2,770
2,132.65
3,192.23
2,424.61
4,512.31
1,761.83
3,456.94
704.83
4,634.97
2,967.53
Important
Amount8
2,251.65
2,702.07
1,112.10
1,825.85
3,990.64
203.73
3,159.27
99.20
3,461.38
4,876.50
345.95
3,780.71
1,611.15
1,997.77
2,728.22
3,917.40
2,124.36
2,948.71
2,778.68
1,615.89
777.49
3,547.23
2,706.87
2,192.44
452.86
1,056.22
279.31
596.12
1,570.20
3,021.55
1,245.24
3,668.51
4,061.26
824.04
68.32
313.14
1,732.51
4,570.37
3,400.52
1,575.12
4,005.76
4,486.84
607.87
52.02
1,786.47
641.14
2,340.30
4,520.57
4,016.93
4,397.36
2,027.99
1,771.99
3,941.70
4,103.72
1,109.98
3,968.40
4,796.94
2,910.26
2,643.12
3,506.39
2,809.52
455.39
2,718.00
3,755.28
2,233.22
1,175.15
2,302.55
3,889.21
218.79
4,051.35
2,081.76
4,558.18
2,332.82
3,153.54
1,722.79
4,032.84
4,096.23
3,099.35
647.16
688.80
1,086.92
2,327.69
3,459.73
4,457.25
995.55
3,035.40
4,076.10
2,155.49
605.94
3,277.20
1,922.28
3,578.58
1,587.12
2,172.46
706.03
950.08
4,676.41
3,801.42
4,377.92
2,234.17
1,334.04
3,795.98
4,622.57
4,735.82
2,347.44
2,567.30
3,705.65
4,085.36
3,696.84
2,686.48
3,778.57
2,039.21
2,802.51
1,293.83
829.14
4,812.15
1,855.11
2,037.60
449.15
2,454.36
3,523.27
3,344.23
1,162.78
4,831.10
3,341.24
3,912.94
4,193.28
2,683.31
4,632.13
987.23
1,884.77
2,428.26
1,779.35
2,128.89
4,872.26
2,428.45
923.32
588.26
1,180.85
411.22
1,125.03
11.02
1,977.02
1,346.54
4,000.33
3,101.33
3,453.45
150.89
3,647.88
1,357.26
2,195.47
1,522.05
342.23
1,052.18
3,365.05
4,887.16
3,775.94
3,043.18
2,368.65
4,787.59
3,253.94
4,568.14
2,113.34
4,492.01
697.04
291.80
2,182.16
3,162.12
2,726.24
4,965.73
804.30
951.42
3,718.72
4,469.67
1,904.38
4,761.70
3,171.29
2,537.11
3,557.69
3,368.53
1,862.38
2,183.34
4,844.32
4,589.26
2,672.13
2,165.84
3,444.27
28.79
4,519.53
417.13
899.71
926.08
1,415.30
2,495.15
695.03
1,843.50
3,045.59
3,689.69
1,952.78
2,285.92
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>