wpdatatables / lib / phpoffice / phpspreadsheet / src / PhpSpreadsheet / Cell / StringValueBinder.php

StringValueBinder.php in wpDataTables – WordPress Data Table, Dynamic Tables & Table Charts Plugin 6.5.1.7, at lib/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/StringValueBinder.php

125 lines 3.4 KB

Raw Download Zip

1	<?php
2
3	namespace PhpOffice\PhpSpreadsheet\Cell;
4
5	use DateTimeInterface;
6	use PhpOffice\PhpSpreadsheet\RichText\RichText;
7	use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
8
9	class StringValueBinder implements IValueBinder
10	{
11	/**
12	* @var bool
13	*/
14	protected $convertNull = true;
15
16	/**
17	* @var bool
18	*/
19	protected $convertBoolean = true;
20
21	/**
22	* @var bool
23	*/
24	protected $convertNumeric = true;
25
26	/**
27	* @var bool
28	*/
29	protected $convertFormula = true;
30
31	public function setNullConversion(bool $suppressConversion = false): self
32	{
33	$this->convertNull = $suppressConversion;
34
35	return $this;
36	}
37
38	public function setBooleanConversion(bool $suppressConversion = false): self
39	{
40	$this->convertBoolean = $suppressConversion;
41
42	return $this;
43	}
44
45	public function getBooleanConversion(): bool
46	{
47	return $this->convertBoolean;
48	}
49
50	public function setNumericConversion(bool $suppressConversion = false): self
51	{
52	$this->convertNumeric = $suppressConversion;
53
54	return $this;
55	}
56
57	public function setFormulaConversion(bool $suppressConversion = false): self
58	{
59	$this->convertFormula = $suppressConversion;
60
61	return $this;
62	}
63
64	public function setConversionForAllValueTypes(bool $suppressConversion = false): self
65	{
66	$this->convertNull = $suppressConversion;
67	$this->convertBoolean = $suppressConversion;
68	$this->convertNumeric = $suppressConversion;
69	$this->convertFormula = $suppressConversion;
70
71	return $this;
72	}
73
74	/**
75	* Bind value to a cell.
76	*
77	* @param Cell $cell Cell to bind value to
78	* @param mixed $value Value to bind in cell
79	*/
80	public function bindValue(Cell $cell, $value)
81	{
82	if (is_object($value)) {
83	return $this->bindObjectValue($cell, $value);
84	}
85
86	// sanitize UTF-8 strings
87	if (is_string($value)) {
88	$value = StringHelper::sanitizeUTF8($value);
89	}
90
91	if ($value === null && $this->convertNull === false) {
92	$cell->setValueExplicit($value, DataType::TYPE_NULL);
93	} elseif (is_bool($value) && $this->convertBoolean === false) {
94	$cell->setValueExplicit($value, DataType::TYPE_BOOL);
95	} elseif ((is_int($value) \|\| is_float($value)) && $this->convertNumeric === false) {
96	$cell->setValueExplicit($value, DataType::TYPE_NUMERIC);
97	} elseif (is_string($value) && strlen($value) > 1 && $value[0] === '=' && $this->convertFormula === false) {
98	$cell->setValueExplicit($value, DataType::TYPE_FORMULA);
99	} else {
100	if (is_string($value) && strlen($value) > 1 && $value[0] === '=') {
101	$cell->getStyle()->setQuotePrefix(true);
102	}
103	$cell->setValueExplicit((string) $value, DataType::TYPE_STRING);
104	}
105
106	return true;
107	}
108
109	protected function bindObjectValue(Cell $cell, object $value): bool
110	{
111	// Handle any objects that might be injected
112	if ($value instanceof DateTimeInterface) {
113	$value = $value->format('Y-m-d H:i:s');
114	} elseif ($value instanceof RichText) {
115	$cell->setValueExplicit($value, DataType::TYPE_INLINE);
116
117	return true;
118	}
119
120	$cell->setValueExplicit((string) $value, DataType::TYPE_STRING); // @phpstan-ignore-line
121
122	return true;
123	}
124	}
125