skyversation
/
meidu2021


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146
							<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@include file="/context/mytags.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

  <t:base type="jquery,easyui,tools,DatePicker"></t:base>
  
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  
<head>

  <meta name="spreadjs culture" content="zh-cn" />
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
          
    <link rel="stylesheet" type="text/css" href="plug-in/SpreadJS/css/gc.spread.sheets.excel2016colorful.13.1.0.css">
    <script src="plug-in/SpreadJS/scripts/gc.spread.sheets.all.13.1.0.min.js" type="text/javascript"></script>
    <script src="plug-in/SpreadJS/scripts/resources/zh/gc.spread.sheets.resources.zh.13.1.0.min.js" type="text/javascript"></script>
   <script src = "webpage/cn/com/lzt/budget/tempsheet/hrDetail.js" type="text/javascript"></script>
   <script src="plug-in/SpreadJS/license.js" type="text/javascript"></script>
<style>
.sample-tutorial {
    position: relative;
    height: 100%;
    overflow: hidden;
}
.sample-spreadsheets {
    width: calc(100%);
    height: 100%;
    overflow: hidden;
    float: left;
}

.options-container {
    float: right;
    width: 40%;
    /* padding: 12px; */
    padding-left: 12px;
    padding-right: 12px;
    height: 100%;
    box-sizing: border-box;
    background: #fbfbfb;
    overflow: auto;
}

.option-row {
    font-size: 14px;
    margin-top: 10px;
}

label {
    margin-bottom: 6px;
}

input {
    padding: 4px 6px;
}

input[type=button] {
    margin-top: 6px;
}

.buttonStyle{
    width:240px;
    height:30px;
}

.colorPickerContent{
    width: 100%;
    background-color:white;
}

.colorDom{
    width: 14px;
    height: 14px;
    margin:0 0 0 6px;
    display: inline-block;
    border: solid 1px #333333;
    vertical-align: top;
}
body {
    position: absolute;
    top: 0;
    bottom: 0;
    left: 0;
    right: 0;
}
    </style>

  
</head>
  
<body style="background:#FFFFFF">
	 <div class="sample-tutorial" style="top: 20px;height: 500px;">
        <div id="ss" class="sample-spreadsheets" ></div>
	    </div>
    </div>

<script>

var spreadNS = GC.Spread.Sheets;

window.onload = function () {
    var spread =  new GC.Spread.Sheets.Workbook(document.getElementById('ss'), {
		sheetCount: 1
	});
    var sd = detaildataSource;
    var sheet = spread.getActiveSheet();
   /*  if (sd.length > 0) {
    	sheet.setDataSource(sd);
    } */
    var table = sheet.tables.addFromDataSource("Table1", 0, 0, detaildataSource, spreadNS.Tables.TableThemes.medium2);
    table.showFooter(true);
    table.showHeader(true);
    table.highlightFirstColumn(true);
    table.highlightLastColumn(false);
    table.setColumnFormula(4, "=SUBTOTAL(109,[2020年度工时预算])");
    table.setColumnFormula(5, "=SUBTOTAL(109,[年度预留工时])");
    table.setColumnFormula(9, "=SUBTOTAL(109,[月平均成本])");
    table.setColumnValue(1, "合计");
    
    
    sheet.setColumnWidth(0, 80);
    sheet.setColumnWidth(1, 120);
    sheet.setColumnWidth(2, 120);
    sheet.setColumnWidth(3, 120);
    sheet.setColumnWidth(4, 120);
    sheet.setColumnWidth(5, 120);
    sheet.setColumnWidth(6, 120);
    sheet.setColumnWidth(7, 120);
    sheet.setColumnWidth(8, 120);
    sheet.setColumnWidth(9, 120);
    
   /*  var border = new GC.Spread.Sheets.LineBorder();
    var styleInfo = new GC.Spread.Sheets.Tables.TableStyle('red', 'black', '10px arial', border, border, border, border, border, border);
    var tableStyle = new GC.Spread.Sheets.Tables.TableTheme();
    tableStyle.name('tableStyle1');
    tableStyle.headerRowStyle(styleInfo)
    var table = sheet.tables.add('table1', 0, 0, 4, 10, spreadNS.Tables.TableThemes.medium2); */
};

</script>
  
</body>
  
</html>