usky-oa
/
jnpf-web-datareport


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
							<!doctype html>
<html>
<head>
  <meta charset='utf-8'>
  <title>Date cell type - Handsontable</title>

  <!--
  Loading Handsontable
  -->
  <link data-jsfiddle="common" rel="stylesheet" media="screen" href="../dist/handsontable.css">
  <link data-jsfiddle="common" rel="stylesheet" media="screen" href="../dist/pikaday/pikaday.css">
  <script data-jsfiddle="common" src="../dist/pikaday/pikaday.js"></script>
  <script data-jsfiddle="common" src="../dist/moment/moment.js"></script>
  <script data-jsfiddle="common" src="../dist/zeroclipboard/ZeroClipboard.js"></script>
  <script data-jsfiddle="common" src="../dist/numbro/numbro.js"></script>
  <script data-jsfiddle="common" src="../dist/numbro/languages.js"></script>
  <script data-jsfiddle="common" src="../dist/handsontable.js"></script>

  <!--
  Loading demo dependencies. They are used here only to enhance the examples on this page
  -->
  <link data-jsfiddle="common" rel="stylesheet" media="screen" href="css/samples.css?20140331">
  <script src="js/samples.js"></script>
  <script src="js/highlight/highlight.pack.js"></script>
  <link rel="stylesheet" media="screen" href="js/highlight/styles/github.css">
  <link rel="stylesheet" href="css/font-awesome/css/font-awesome.min.css">

  <!--
  Facebook open graph. Don't copy this to your project :)
  -->
  <meta property="og:title" content="Date cell type">
  <meta property="og:description"
        content="Date cell type uses the Pikaday Datepicker with Moment.js">
  <meta property="og:url" content="http://handsontable.com/demo/numeric.html">
  <meta property="og:image" content="http://handsontable.com/demo/image/og-image.png">
  <meta property="og:image:type" content="image/png">
  <meta property="og:image:width" content="409">
  <meta property="og:image:height" content="164">
  <link rel="canonical" href="http://handsontable.com/demo/numeric.html">

  <!--
  Google Analytics for GitHub Page. Don't copy this to your project :)
  -->
  <script src="js/ga.js"></script>

  <script data-jsfiddle="common">
    function getCarData() {
      return [
        ["Mercedes", "A 160", "01/14/2006", 6999.9999],
        ["Citroen", "C4 Coupe", "12/01/2008", 8330],
        ["Audi", "A4 Avant", "11/19/2011", 33900],
        ["Opel", "Astra", "02/02/2004", 7000],
        ["BMW", "320i Coupe", "07/24/2011", 30500]
      ];
    }
  </script>
</head>

<body>


<div class="wrapper">
  <div class="wrapper-row">
    <div id="global-menu-clone">
      <h1><a href="../index.html">Handsontable</a></h1>

    </div>

    <div id="container">
      <div class="columnLayout">

        <div class="rowLayout">
          <div class="descLayout">
            <div class="pad" data-jsfiddle="example1">
              <h2>Date cell type</h2>

              <p>To trigger the Date cell type, use the option <code>type: 'date'</code> in <code>columns</code> array
                or <code>cells</code> function.</p>

              <p>The Date cell uses <a href="https://github.com/dbushell/Pikaday">Pikaday datepicker</a> as
                the UI control. Pikaday uses <a href="https://github.com/moment/moment">Moment.js</a> as a date formatter.

              <p>Note that Date cell requires additional files in your <code>&lt;head&gt;</code>:

              <ul>
                <li><code>demo/js/moment/moment.js</code></li>
                <li><code>demo/js/pikaday/pikaday.js</code></li>
              <li><code>demo/js/pikaday/css/pikaday.css</code></li>
              </ul>

              <p>All data entered to the data-typed cells are validated agains the default date format (<code><a
                href="http://momentjs.com/docs/#/parsing/" target="_blank"
                title="Click here to find how to use different date format">DD/MM/YYYY</a></code>), unless another
                format is provided.</p>

              <p>If you enable the <code>correctFormat</code> config item, the dates will be automatically formatted to
                match the desired format.</p>

              <div id="example1"></div>

              <p>
                <button name="dump" data-instance="hot" data-dump="#example1"
                        title="Prints current data source to Firebug/Chrome Dev Tools">
                  Dump
                  data to console
                </button>
              </p>
            </div>
          </div>

          <div class="codeLayout">
            <div class="pad">
              <div class="jsFiddle">
                <button class="jsFiddleLink" data-runfiddle="example1">Edit in jsFiddle</button>
              </div>

              <script data-jsfiddle="example1">
                var container = document.getElementById('example1'),
                  hot;

                hot = new Handsontable(container, {
                  data: getCarData(),
                  startRows: 7,
                  startCols: 4,
                  colHeaders: ['Car', 'Model', 'Registration date', 'Price'],
                  columnSorting: true,
                  contextMenu: true,
                  minSpareRows: 1,
                  columns: [
                    {
                      type: 'autocomplete',
                      source: ['Audi', 'BMW', 'Chrysler', 'Citroen', 'Mercedes', 'Nissan', 'Opel', 'Suzuki', 'Toyota', 'Volvo'],
                      strict: false
                    },
                    {
                      // 2nd cell is simple text, no special options here
                    },
                    {
                      type: 'date',
                      dateFormat: 'MM/DD/YYYY',
                      correctFormat: true,
                      defaultDate: '01/01/1900'
                    },
                    {
                      type: 'numeric',
                      format: '$ 0,0.00'
                    }
                  ]
                });

              </script>
            </div>
          </div>
        </div>

        <div class="footer-text">
        </div>
      </div>

    </div>

  </div>
</div>

<div id="outside-links-wrapper"></div>

</body>
</html>