|
@@ 465-467 (lines=3) @@
|
| 462 |
|
$file->write('<c r="' . $cell_name . '" s="' . $cell_style_idx . '" t="n"><v>' . intval(self::convert_date_time($value)) . '</v></c>'); |
| 463 |
|
} elseif ($num_format_type == 'n_datetime') { |
| 464 |
|
$file->write('<c r="' . $cell_name . '" s="' . $cell_style_idx . '" t="n"><v>' . self::convert_date_time($value) . '</v></c>'); |
| 465 |
|
} elseif ($num_format_type == 'n_numeric') { |
| 466 |
|
$file->write('<c r="' . $cell_name . '" s="' . $cell_style_idx . '" t="n"><v>' . self::xmlspecialchars($value) . '</v></c>');//int,float,currency |
| 467 |
|
} elseif ($num_format_type == 'n_string') { |
| 468 |
|
$file->write('<c r="' . $cell_name . '" s="' . $cell_style_idx . '" t="inlineStr"><is><t>' . self::xmlspecialchars($value) . '</t></is></c>'); |
| 469 |
|
} elseif ($num_format_type == 'n_auto' || 1) { //auto-detect unknown column types |
| 470 |
|
if (!is_string($value) || $value == '0' || ($value[0] != '0' && ctype_digit($value)) || preg_match( |
|
@@ 476-478 (lines=3) @@
|
| 473 |
|
) |
| 474 |
|
) { |
| 475 |
|
$file->write('<c r="' . $cell_name . '" s="' . $cell_style_idx . '" t="n"><v>' . self::xmlspecialchars($value) . '</v></c>');//int,float,currency |
| 476 |
|
} else { //implied: ($cell_format=='string') |
| 477 |
|
$file->write('<c r="' . $cell_name . '" s="' . $cell_style_idx . '" t="inlineStr"><is><t>' . self::xmlspecialchars($value) . '</t></is></c>'); |
| 478 |
|
} |
| 479 |
|
} |
| 480 |
|
} |
| 481 |
|
|