This example shows how you can add a single row at the column header row, which is useful for display things like charts that are always on top of data.
By default, Spread.Views shows individual header rows in each column header.
When you set the separateColumn property to false, Spread.Views shows one header row entry instead of individual ones.
In this demo, not having separate columns in the column headers allows the developer to display a chart that is always at the top of the data, even when scrolling.
This can also be extended to other types of data at the top of the grid.
<!DOCTYPE html>
<html lang="en">
<head>
<base href="/dataviewsjs/demos/en/sample/Features/Rows/StockIndex/purejs/" />
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="keywords" content="rows, header row, headerrow" />
<meta
name="description"
content="This example shows how you can add a single row at the column header row, which is useful for display things like charts that are always on top of data."
/>
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Stock Index | Features | MESCIUS DataViewsJS JavaScript Demos</title>
<link href="/dataviewsjs/demos/node_modules/normalize.css/normalize.css" rel="stylesheet" type="text/css" />
<link href="/dataviewsjs/demos/static/css/base.css" rel="stylesheet" type="text/css" />
<link href="/dataviewsjs/demos/static/dataviews/gc.dataviews.core.min.css" rel="stylesheet" type="text/css" />
<link href="/dataviewsjs/demos/static/dataviews/gc.dataviews.grid.min.css" rel="stylesheet" type="text/css" />
<link href="styles.css" rel="stylesheet" type="text/css" />
<script src="/dataviewsjs/demos/static/js/app-polyfills.min.js" type="text/javascript"></script>
<script type="text/javascript">
window.process = {
env: {
NODE_ENV: 'production',
USE_NPM: false,
USE_CDN: false,
SITE_ROOT: '/dataviewsjs/demos',
FRAMEWORK: 'purejs',
DVJS_LICENSE_KEY:
'E348418822993781#B0EWvwY4dNNVQqJHUDpFROVWe5ZWNYFlVQFmRsJWRht4Z6lDO4Vla7YUaXhEWxd7Z5YXMuRnY7tWTQRHSlVnaYlXNhlEOpdkZ0FHWYJ5QKd6VXN5aR3ieGhUav9kZTBXWahkYBhEVutmZ72CbjdlZvV5TVdGdiplQsZXe95kUmNmZVF5cJ3mcypWNyx4UydESE3UblxGZyE7KQ94R4BjbUxUewsiaoREMxRDNllWREV6Voh4Q4dDZPRjWrIzUJl4TERXcQZWMHp4Sp9WaMZzN5o6StJmVDJXcwIVVmR6UMVGOlxUW8RmTxZDZTJWVN5GZqJHZuVDMkVGSW3WdxNzKCdDdSB7TzY7cqlnMU5GVyNzNP9WMyhDRvEEOFdkQORDM4dFVlFFWqFWSyMjNQJiOiMlIsISQyIkQ9YjQxIiOigkIsUTM7YjNxYTM0IicfJye&Qf35VfikFVVljI0IyQiwiIxYHITp4c7VWaWFGdhRkI0IiTis7W0ICZyBlIsIiNxUTN6ADI8EDMxMjMwIjI0ICdyNkIsIyc59yc5l6YzVWbuoCLwpmLzVXajNXZt9iKs2WauMXdpN6cl5mLqwSbvNmLzVXajNXZt9iKsAnau26YuMXdpN6cl5mLqwSbvNmL6VGZ9RXajVGchJ7ZuoCLuNmLt36YukHdpNWZwFmcn9iKs46bj9Se4l6YlBXYydmLqwicr9ybj9Se4l6YlBXYydmLqwCcq9ybj9Se4l6YlBXYydmLqIiOiMXbEJCLiMVVJN4UF5kI0ISYONkIsUWdyRnOiwmdFJCLiEDO7MTO9IjM8gTM4gDNzIiOiQWSisnOiQkIsISP3EkVxBVUHFDMplzLlVUdGd7cI9UeIt4SshESzV7NvY7ZxlDOuNTb5tzLr',
SJS_LICENSE_KEY:
'E518585142165236#B0wm4nx4QzdlTHRTSOFzcvVnaJdjSnNEeXdTMUtSUzk6bU94QuVXNwZVZjd4SzYjcadXRIVEMzEXTThkVyR7R85UayoHZZBTYQ5mZyh4Shd6VxFXazF4cBNGRG5WTvUGTsV4T6knQYRzKxxUdk9EarplU7d6VLF6KIR7bPJ5N6ZUMWZWaURGRKRDbLJDN5YjSN5mUoxmaxonSD56LEh7Y7RXenpmTvomevZlV9dkaysCO7hTRQFHcGRWQyc5LI9kQmB7QwR4Z7ZHOR3CSXp6SiFWYzFXeXZUSp94K8VDTkFjdwl4KptSYlRWcDxmNE5kS6kzdrkVcNJXROVGbLJkcTNGRzIER8tmd4YGNhh7dxAnMvIHRv46VtBXS4U5KvJ6dZJ6M5p4TxIjd9I5QSpXTTV6SDZXb7lzaL56ZiojITJCLikTQxUTQFV4NiojIIJCLyETO7UzM7kTO0IicfJye&Qf35VfikkR9IkI0IyQiwiIyEjL6ByUKBCZhVmcwNlI0IiTis7W0ICZyBlIsISNwkTN6ADI8EDMxMjMwIjI0ICdyNkIsIyc59yc5l6YzVWbuoCLwpmLzVXajNXZt9iKs2WauMXdpN6cl5mLqwSbvNmLzVXajNXZt9iKsAnau26YuMXdpN6cl5mLqwSbvNmL6VGZ9RXajVGchJ7ZuoCLuNmLt36YukHdpNWZwFmcn9iKs46bj9Se4l6YlBXYydmLqwicr9ybj9Se4l6YlBXYydmLqwCcq9ybj9Se4l6YlBXYydmLqIiOiMXbEJCLiMVVJN4UF5kI0ISYONkIsUWdyRnOiwmdFJCLiYzMyUjNxIDNxUDO5gTM5IiOiQWSiwSfdtlOicGbmJCLlNHbhZmOiI7ckJye0ICbuFkI1pjIEJCLi4TPRtGOhtWWEFWd4IDOLRVRvx4SyMGcDhTW6n4ep',
},
};
</script>
<script src="/dataviewsjs/demos/node_modules/lodash/lodash.min.js" type="text/javascript"></script>
<script src="https://cdn.jsdelivr.net/npm/echarts@4.2.1/dist/echarts.min.js" type="text/javascript"></script>
<script src="/dataviewsjs/demos/static/dataviews/gc.dataviews.common.min.js" type="text/javascript"></script>
<script src="/dataviewsjs/demos/static/dataviews/gc.dataviews.core.min.js" type="text/javascript"></script>
<script src="/dataviewsjs/demos/static/dataviews/gc.dataviews.grid.min.js" type="text/javascript"></script>
<script src="/dataviewsjs/demos/static/js/license.js" type="text/javascript"></script>
</head>
<body class="theme-default">
<noscript>You need to enable JavaScript to run this app.</noscript>
<div id="grid" class="grid"></div>
<script src="data.js" type="text/javascript"></script>
<script src="app.js" type="text/javascript"></script>
</body>
</html>
var stockChart;
var cols = [
{
id: 'date',
caption: 'Date',
dataField: 'date',
},
{
id: 'open',
caption: 'Open',
dataField: 'open',
},
{
id: 'close',
caption: 'Close',
dataField: 'close',
},
{
id: 'low',
caption: 'Low',
dataField: 'low',
},
{
id: 'high',
caption: 'High',
dataField: 'high',
},
];
var dataView = new GC.DataViews.DataView(
document.getElementById('grid'),
data,
cols,
new GC.DataViews.GridLayout({
headerRow: {
visible: true,
height: 250,
separateColumn: false,
renderer: '<div id="stockWrapper" style="widht:100%;height:100%;"></div>',
},
})
); // focus data.view by default
document.getElementById('grid').focus();
dataView.columnChanged.addHandler(function (e) {
if (e.type === 'resized') {
stockChart.resize();
}
});
var data0 = splitData(data);
var chartOptions = {
title: {
text: 'STOCK INDEX',
left: 'center',
},
tooltip: {
trigger: 'axis',
axisPointer: {
type: 'line',
},
},
grid: {
left: '5%',
right: '5%',
bottom: '15%',
},
xAxis: {
type: 'category',
data: data0.categoryData,
scale: true,
boundaryGap: false,
axisLine: {
onZero: false,
},
splitLine: {
show: false,
},
splitNumber: 20,
min: 'dataMin',
max: 'dataMax',
},
yAxis: {
scale: true,
splitArea: {
show: true,
},
},
dataZoom: [
{
type: 'inside',
start: 50,
end: 100,
},
{
show: true,
type: 'slider',
y: '90%',
start: 50,
end: 100,
},
],
series: [
{
name: 'STOCK INDEX',
type: 'candlestick',
data: data0.values,
},
],
};
stockChart = echarts.init(document.getElementById('stockWrapper'));
stockChart.setOption(chartOptions);
var data = [
{
date: '2018/1/24',
open: 2320.26,
close: 2320.26,
low: 2287.3,
high: 2362.94,
},
{
date: '2018/1/25',
open: 2300,
close: 2291.3,
low: 2288.26,
high: 2308.38,
},
{
date: '2018/1/28',
open: 2295.35,
close: 2346.5,
low: 2295.35,
high: 2346.92,
},
{
date: '2018/1/29',
open: 2347.22,
close: 2358.98,
low: 2337.35,
high: 2363.8,
},
{
date: '2018/1/30',
open: 2360.75,
close: 2382.48,
low: 2347.89,
high: 2383.76,
},
{
date: '2018/1/31',
open: 2383.43,
close: 2385.42,
low: 2371.23,
high: 2391.82,
},
{
date: '2018/2/1',
open: 2377.41,
close: 2419.02,
low: 2369.57,
high: 2421.15,
},
{
date: '2018/2/4',
open: 2425.92,
close: 2428.15,
low: 2417.58,
high: 2440.38,
},
{
date: '2018/2/5',
open: 2411,
close: 2433.13,
low: 2403.3,
high: 2437.42,
},
{
date: '2018/2/6',
open: 2432.68,
close: 2434.48,
low: 2427.7,
high: 2441.73,
},
{
date: '2018/2/7',
open: 2430.69,
close: 2418.53,
low: 2394.22,
high: 2433.89,
},
{
date: '2018/2/8',
open: 2416.62,
close: 2432.4,
low: 2414.4,
high: 2443.03,
},
{
date: '2018/2/18',
open: 2441.91,
close: 2421.56,
low: 2415.43,
high: 2444.8,
},
{
date: '2018/2/19',
open: 2420.26,
close: 2382.91,
low: 2373.53,
high: 2427.07,
},
{
date: '2018/2/20',
open: 2383.49,
close: 2397.18,
low: 2370.61,
high: 2397.94,
},
{
date: '2018/2/21',
open: 2378.82,
close: 2325.95,
low: 2309.17,
high: 2378.82,
},
{
date: '2018/2/22',
open: 2322.94,
close: 2314.16,
low: 2308.76,
high: 2330.88,
},
{
date: '2018/2/25',
open: 2320.62,
close: 2325.82,
low: 2315.01,
high: 2338.78,
},
{
date: '2018/2/26',
open: 2313.74,
close: 2293.34,
low: 2289.89,
high: 2340.71,
},
{
date: '2018/2/27',
open: 2297.77,
close: 2313.22,
low: 2292.03,
high: 2324.63,
},
{
date: '2018/2/28',
open: 2322.32,
close: 2365.59,
low: 2308.92,
high: 2366.16,
},
{
date: '2018/3/1',
open: 2364.54,
close: 2359.51,
low: 2330.86,
high: 2369.65,
},
{
date: '2018/3/4',
open: 2332.08,
close: 2273.4,
low: 2259.25,
high: 2333.54,
},
{
date: '2018/3/5',
open: 2274.81,
close: 2326.31,
low: 2270.1,
high: 2328.14,
},
{
date: '2018/3/6',
open: 2333.61,
close: 2347.18,
low: 2321.6,
high: 2351.44,
},
{
date: '2018/3/7',
open: 2340.44,
close: 2324.29,
low: 2304.27,
high: 2352.02,
},
{
date: '2018/3/8',
open: 2326.42,
close: 2318.61,
low: 2314.59,
high: 2333.67,
},
{
date: '2018/3/11',
open: 2314.68,
close: 2310.59,
low: 2296.58,
high: 2320.96,
},
{
date: '2018/3/12',
open: 2309.16,
close: 2286.6,
low: 2264.83,
high: 2333.29,
},
{
date: '2018/3/13',
open: 2282.17,
close: 2263.97,
low: 2253.25,
high: 2286.33,
},
{
date: '2018/3/14',
open: 2255.77,
close: 2270.28,
low: 2253.31,
high: 2276.22,
},
{
date: '2018/3/15',
open: 2269.31,
close: 2278.4,
low: 2250,
high: 2312.08,
},
{
date: '2018/3/18',
open: 2267.29,
close: 2240.02,
low: 2239.21,
high: 2276.05,
},
{
date: '2018/3/19',
open: 2244.26,
close: 2257.43,
low: 2232.02,
high: 2261.31,
},
{
date: '2018/3/20',
open: 2257.74,
close: 2317.37,
low: 2257.42,
high: 2317.86,
},
{
date: '2018/3/21',
open: 2318.21,
close: 2324.24,
low: 2311.6,
high: 2330.81,
},
{
date: '2018/3/22',
open: 2321.4,
close: 2328.28,
low: 2314.97,
high: 2332,
},
{
date: '2018/3/25',
open: 2334.74,
close: 2326.72,
low: 2319.91,
high: 2344.89,
},
{
date: '2018/3/26',
open: 2318.58,
close: 2297.67,
low: 2281.12,
high: 2319.99,
},
{
date: '2018/3/27',
open: 2299.38,
close: 2301.26,
low: 2289,
high: 2323.48,
},
{
date: '2018/3/28',
open: 2273.55,
close: 2236.3,
low: 2232.91,
high: 2273.55,
},
{
date: '2018/3/29',
open: 2238.49,
close: 2236.62,
low: 2228.81,
high: 2246.87,
},
{
date: '2018/4/1',
open: 2229.46,
close: 2234.4,
low: 2227.31,
high: 2243.95,
},
{
date: '2018/4/2',
open: 2234.9,
close: 2227.74,
low: 2220.44,
high: 2253.42,
},
{
date: '2018/4/3',
open: 2232.69,
close: 2225.29,
low: 2217.25,
high: 2241.34,
},
{
date: '2018/4/8',
open: 2196.24,
close: 2211.59,
low: 2180.67,
high: 2212.59,
},
{
date: '2018/4/9',
open: 2215.47,
close: 2225.77,
low: 2215.47,
high: 2234.73,
},
{
date: '2018/4/10',
open: 2224.93,
close: 2226.13,
low: 2212.56,
high: 2233.04,
},
{
date: '2018/4/11',
open: 2236.98,
close: 2219.55,
low: 2217.26,
high: 2242.48,
},
{
date: '2018/4/12',
open: 2218.09,
close: 2206.78,
low: 2204.44,
high: 2226.26,
},
{
date: '2018/4/15',
open: 2199.91,
close: 2181.94,
low: 2177.39,
high: 2204.99,
},
{
date: '2018/4/16',
open: 2169.63,
close: 2194.85,
low: 2165.78,
high: 2196.43,
},
{
date: '2018/4/17',
open: 2195.03,
close: 2193.8,
low: 2178.47,
high: 2197.51,
},
{
date: '2018/4/18',
open: 2181.82,
close: 2197.6,
low: 2175.44,
high: 2206.03,
},
{
date: '2018/4/19',
open: 2201.12,
close: 2244.64,
low: 2200.58,
high: 2250.11,
},
{
date: '2018/4/22',
open: 2236.4,
close: 2242.17,
low: 2232.26,
high: 2245.12,
},
{
date: '2018/4/23',
open: 2242.62,
close: 2184.54,
low: 2182.81,
high: 2242.62,
},
{
date: '2018/4/24',
open: 2187.35,
close: 2218.32,
low: 2184.11,
high: 2226.12,
},
{
date: '2018/4/25',
open: 2213.19,
close: 2199.31,
low: 2191.85,
high: 2224.63,
},
{
date: '2018/4/26',
open: 2203.89,
close: 2177.91,
low: 2173.86,
high: 2210.58,
},
{
date: '2018/5/2',
open: 2170.78,
close: 2174.12,
low: 2161.14,
high: 2179.65,
},
{
date: '2018/5/3',
open: 2179.05,
close: 2205.5,
low: 2179.05,
high: 2222.81,
},
{
date: '2018/5/6',
open: 2212.5,
close: 2231.17,
low: 2212.5,
high: 2236.07,
},
{
date: '2018/5/7',
open: 2227.86,
close: 2235.57,
low: 2219.44,
high: 2240.26,
},
{
date: '2018/5/8',
open: 2242.39,
close: 2246.3,
low: 2235.42,
high: 2255.21,
},
{
date: '2018/5/9',
open: 2246.96,
close: 2232.97,
low: 2221.38,
high: 2247.86,
},
{
date: '2018/5/10',
open: 2228.82,
close: 2246.83,
low: 2225.81,
high: 2247.67,
},
{
date: '2018/5/13',
open: 2247.68,
close: 2241.92,
low: 2231.36,
high: 2250.85,
},
{
date: '2018/5/14',
open: 2238.9,
close: 2217.01,
low: 2205.87,
high: 2239.93,
},
{
date: '2018/5/15',
open: 2217.09,
close: 2224.8,
low: 2213.58,
high: 2225.19,
},
{
date: '2018/5/16',
open: 2221.34,
close: 2251.81,
low: 2210.77,
high: 2252.87,
},
{
date: '2018/5/17',
open: 2249.81,
close: 2282.87,
low: 2248.41,
high: 2288.09,
},
{
date: '2018/5/20',
open: 2286.33,
close: 2299.99,
low: 2281.9,
high: 2309.39,
},
{
date: '2018/5/21',
open: 2297.11,
close: 2305.11,
low: 2290.12,
high: 2305.3,
},
{
date: '2018/5/22',
open: 2303.75,
close: 2302.4,
low: 2292.43,
high: 2314.18,
},
{
date: '2018/5/23',
open: 2293.81,
close: 2275.67,
low: 2274.1,
high: 2304.95,
},
{
date: '2018/5/24',
open: 2281.45,
close: 2288.53,
low: 2270.25,
high: 2292.59,
},
{
date: '2018/5/27',
open: 2286.66,
close: 2293.08,
low: 2283.94,
high: 2301.7,
},
{
date: '2018/5/28',
open: 2293.4,
close: 2321.32,
low: 2281.47,
high: 2322.1,
},
{
date: '2018/5/29',
open: 2323.54,
close: 2324.02,
low: 2321.17,
high: 2334.33,
},
{
date: '2018/5/30',
open: 2316.25,
close: 2317.75,
low: 2310.49,
high: 2325.72,
},
{
date: '2018/5/31',
open: 2320.74,
close: 2300.59,
low: 2299.37,
high: 2325.53,
},
{
date: '2018/6/3',
open: 2300.21,
close: 2299.25,
low: 2294.11,
high: 2313.43,
},
{
date: '2018/6/4',
open: 2297.1,
close: 2272.42,
low: 2264.76,
high: 2297.1,
},
{
date: '2018/6/5',
open: 2270.71,
close: 2270.93,
low: 2260.87,
high: 2276.86,
},
{
date: '2018/6/6',
open: 2264.43,
close: 2242.11,
low: 2240.07,
high: 2266.69,
},
{
date: '2018/6/7',
open: 2242.26,
close: 2210.9,
low: 2205.07,
high: 2250.63,
},
{
date: '2018/6/13',
open: 2190.1,
close: 2148.35,
low: 2126.22,
high: 2190.1,
},
];
var splitData = function splitData(data) {
var categoryData = [];
var values = [];
for (var i = 0; i < data.length; i++) {
var tempData = _.map(data[i], _.identity);
categoryData.push(tempData.splice(0, 1)[0]);
values.push(tempData);
}
return {
categoryData: categoryData,
values: values,
};
};
.gc-header-row-cell {
padding: 4px;
}
/*# sourceMappingURL=data:application/json;charset=utf8;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbIkZlYXR1cmVzL1Jvd3MvU3RvY2tJbmRleC9wdXJlanMvc3R5bGVzLnNjc3MiLCJGZWF0dXJlcy9Sb3dzL1N0b2NrSW5kZXgvcHVyZWpzL3N0eWxlcy5jc3MiXSwibmFtZXMiOltdLCJtYXBwaW5ncyI6IkFBQUE7RUFDRSxZQUFBO0FDQ0YiLCJmaWxlIjoiRmVhdHVyZXMvUm93cy9TdG9ja0luZGV4L3B1cmVqcy9zdHlsZXMuY3NzIiwic291cmNlc0NvbnRlbnQiOlsiLmdjLWhlYWRlci1yb3ctY2VsbCB7XG4gIHBhZGRpbmc6IDRweDtcbn1cbiIsIi5nYy1oZWFkZXItcm93LWNlbGwge1xuICBwYWRkaW5nOiA0cHg7XG59Il19 */
