projects
/
Pman.Core
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Pman.Gnumeric.js
[Pman.Core]
/
SimpleExcel.php
diff --git
a/SimpleExcel.php
b/SimpleExcel.php
index
e07fa12
..
6515710
100644
(file)
--- a/
SimpleExcel.php
+++ b/
SimpleExcel.php
@@
-76,7
+76,7
@@
class Pman_Core_SimpleExcel extends Pman
var $worksheet= false;
var $worksheet= false;
- function
Pman_Core_SimpleExcel
($data,$cfg)
+ function
__construct
($data,$cfg)
{
// print_r($cfg);exit;
require_once 'Spreadsheet/Excel/Writer.php';
{
// print_r($cfg);exit;
require_once 'Spreadsheet/Excel/Writer.php';
@@
-94,7
+94,7
@@
class Pman_Core_SimpleExcel extends Pman
$cfg['formats'] = isset($cfg['formats']) ? $cfg['formats'] : array();
$this->formats['_default_date_format_'] = $workbook->addFormat();;
$cfg['formats'] = isset($cfg['formats']) ? $cfg['formats'] : array();
$this->formats['_default_date_format_'] = $workbook->addFormat();;
-
$this->formats['_default_date_format_']->setNumFormat('YYYY-MM-DD');
+ $this->formats['_default_date_format_']->setNumFormat('YYYY-MM-DD');
foreach($cfg['formats'] as $f=>$fcfg) {
foreach($cfg['formats'] as $f=>$fcfg) {
@@
-384,11
+384,14
@@
class Pman_Core_SimpleExcel extends Pman
if (preg_match('/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/', $v)) {
$dataFormat = 'date';
if (preg_match('/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/', $v)) {
$dataFormat = 'date';
- $format = empty($format) ?
'YYYY-MM-DD'
: $format;
+ $format = empty($format) ?
$this->formats['_default_date_format_']
: $format;
$ut_to_ed_diff = 86400 * 25569;
$ut_to_ed_diff = 86400 * 25569;
+ $gmt = strtotime('1970-01-01');
- $v = (strtotime($v) + $ut_to_ed_diff) / 86400;
- var_Dump(array($format, $v));
+ $v = (strtotime($v) + $ut_to_ed_diff - $gmt) / 86400;
+ // need to +8hrs to get real time..
+
+
}
if ( (is_numeric($v) && strlen($v) > 1 && substr($v,0,1) == '0' && substr($v,1,1) != '.' )
}
if ( (is_numeric($v) && strlen($v) > 1 && substr($v,0,1) == '0' && substr($v,1,1) != '.' )