@@ 1889-1900 (lines=12) @@ | ||
1886 | * |
|
1887 | * @access private |
|
1888 | */ |
|
1889 | private function _writeHcenter() |
|
1890 | { |
|
1891 | $record = 0x0083; // Record identifier |
|
1892 | $length = 0x0002; // Bytes to follow |
|
1893 | ||
1894 | $fHCenter = $this->_phpSheet->getPageSetup()->getHorizontalCentered() ? 1 : 0; // Horizontal centering |
|
1895 | ||
1896 | $header = pack("vv", $record, $length); |
|
1897 | $data = pack("v", $fHCenter); |
|
1898 | ||
1899 | $this->_append($header.$data); |
|
1900 | } |
|
1901 | ||
1902 | /** |
|
1903 | * Store the vertical centering VCENTER BIFF record. |
|
@@ 1905-1915 (lines=11) @@ | ||
1902 | /** |
|
1903 | * Store the vertical centering VCENTER BIFF record. |
|
1904 | */ |
|
1905 | private function _writeVcenter() |
|
1906 | { |
|
1907 | $record = 0x0084; // Record identifier |
|
1908 | $length = 0x0002; // Bytes to follow |
|
1909 | ||
1910 | $fVCenter = $this->_phpSheet->getPageSetup()->getVerticalCentered() ? 1 : 0; // Horizontal centering |
|
1911 | ||
1912 | $header = pack("vv", $record, $length); |
|
1913 | $data = pack("v", $fVCenter); |
|
1914 | $this->_append($header . $data); |
|
1915 | } |
|
1916 | ||
1917 | /** |
|
1918 | * Store the LEFTMARGIN BIFF record. |
|
@@ 2012-2022 (lines=11) @@ | ||
2009 | * Write the PRINTGRIDLINES BIFF record. Must be used in conjunction with the |
|
2010 | * GRIDSET record. |
|
2011 | */ |
|
2012 | private function _writePrintGridlines() |
|
2013 | { |
|
2014 | $record = 0x002b; // Record identifier |
|
2015 | $length = 0x0002; // Bytes to follow |
|
2016 | ||
2017 | $fPrintGrid = $this->_phpSheet->getPrintGridlines() ? 1 : 0; // Boolean flag |
|
2018 | ||
2019 | $header = pack("vv", $record, $length); |
|
2020 | $data = pack("v", $fPrintGrid); |
|
2021 | $this->_append($header . $data); |
|
2022 | } |
|
2023 | ||
2024 | /** |
|
2025 | * Write the GRIDSET BIFF record. Must be used in conjunction with the |
|
@@ 2211-2227 (lines=17) @@ | ||
2208 | /** |
|
2209 | * Set the Biff PROTECT record to indicate that the worksheet is protected. |
|
2210 | */ |
|
2211 | private function _writeProtect() |
|
2212 | { |
|
2213 | // Exit unless sheet protection has been specified |
|
2214 | if (!$this->_phpSheet->getProtection()->getSheet()) { |
|
2215 | return; |
|
2216 | } |
|
2217 | ||
2218 | $record = 0x0012; // Record identifier |
|
2219 | $length = 0x0002; // Bytes to follow |
|
2220 | ||
2221 | $fLock = 1; // Worksheet is protected |
|
2222 | ||
2223 | $header = pack("vv", $record, $length); |
|
2224 | $data = pack("v", $fLock); |
|
2225 | ||
2226 | $this->_append($header.$data); |
|
2227 | } |
|
2228 | ||
2229 | /** |
|
2230 | * Write SCENPROTECT |