ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
Public Member Functions | Data Fields | Private Member Functions | Static Private Member Functions | Private Attributes | Static Private Attributes
PHPExcel_Writer_Excel5_Xf Class Reference
+ Collaboration diagram for PHPExcel_Writer_Excel5_Xf:

Public Member Functions

 __construct (PHPExcel_Style $style=null)
 Constructor. More...
 
 writeXf ()
 Generate an Excel BIFF XF record (style or cell). More...
 
 setIsStyleXf ($value)
 Is this a style XF ? More...
 
 setBottomColor ($colorIndex)
 Sets the cell's bottom border color. More...
 
 setTopColor ($colorIndex)
 Sets the cell's top border color. More...
 
 setLeftColor ($colorIndex)
 Sets the cell's left border color. More...
 
 setRightColor ($colorIndex)
 Sets the cell's right border color. More...
 
 setDiagColor ($colorIndex)
 Sets the cell's diagonal border color. More...
 
 setFgColor ($colorIndex)
 Sets the cell's foreground color. More...
 
 setBgColor ($colorIndex)
 Sets the cell's background color. More...
 
 setNumberFormatIndex ($numberFormatIndex)
 Sets the index to the number format record It can be date, time, currency, etc... More...
 
 setFontIndex ($value)
 Set the font index. More...
 

Data Fields

 $_numberFormatIndex
 
 $_text_justlast
 
 $_fg_color
 
 $_bg_color
 
 $_bottom_color
 
 $_top_color
 
 $_left_color
 
 $_right_color
 

Private Member Functions

 _mapHAlign ($hAlign)
 Map to BIFF2-BIFF8 codes for horizontal alignment. More...
 

Static Private Member Functions

static _mapBorderStyle ($borderStyle)
 Map border style. More...
 
static _mapFillType ($fillType)
 Map fill type. More...
 
static _mapVAlign ($vAlign)
 Map to BIFF2-BIFF8 codes for vertical alignment. More...
 
static _mapTextRotation ($textRotation)
 Map to BIFF8 codes for text rotation angle. More...
 
static _mapLocked ($locked)
 Map locked. More...
 
static _mapHidden ($hidden)
 Map hidden. More...
 

Private Attributes

 $_isStyleXf
 
 $_fontIndex
 

Static Private Attributes

static $_mapBorderStyle
 Map of BIFF2-BIFF8 codes for border styles array of int. More...
 
static $_mapFillType
 Map of BIFF2-BIFF8 codes for fill types array of int. More...
 
static $_mapHAlign
 Map of BIFF2-BIFF8 codes for horizontal alignment array of int. More...
 
static $_mapVAlign
 Map of BIFF2-BIFF8 codes for vertical alignment array of int. More...
 

Detailed Description

Definition at line 71 of file Xf.php.

Constructor & Destructor Documentation

◆ __construct()

PHPExcel_Writer_Excel5_Xf::__construct ( PHPExcel_Style  $style = null)

Constructor.

@access public

Parameters
PHPExcel_StyleThe XF format

Definition at line 140 of file Xf.php.

141 {
142 $this->_isStyleXf = false;
143 $this->_fontIndex = 0;
144
145 $this->_numberFormatIndex = 0;
146
147 $this->_text_justlast = 0;
148
149 $this->_fg_color = 0x40;
150 $this->_bg_color = 0x41;
151
152 $this->_diag = 0;
153
154 $this->_bottom_color = 0x40;
155 $this->_top_color = 0x40;
156 $this->_left_color = 0x40;
157 $this->_right_color = 0x40;
158 $this->_diag_color = 0x40;
159 $this->_style = $style;
160
161 }
$style
$style
Definition: example_012.php:70

References $style.

Member Function Documentation

◆ _mapBorderStyle()

static PHPExcel_Writer_Excel5_Xf::_mapBorderStyle (   $borderStyle)
staticprivate

Map border style.

Parameters
string$borderStyle
Returns
int

Definition at line 406 of file Xf.php.

406 {
407 if (isset(self::$_mapBorderStyle[$borderStyle]))
408 return self::$_mapBorderStyle[$borderStyle];
409 return 0x00;
410 }

Referenced by writeXf().

+ Here is the caller graph for this function:

◆ _mapFillType()

static PHPExcel_Writer_Excel5_Xf::_mapFillType (   $fillType)
staticprivate

Map fill type.

Parameters
string$fillType
Returns
int

Definition at line 445 of file Xf.php.

445 {
446 if (isset(self::$_mapFillType[$fillType]))
447 return self::$_mapFillType[$fillType];
448 return 0x00;
449 }

Referenced by writeXf().

+ Here is the caller graph for this function:

◆ _mapHAlign()

PHPExcel_Writer_Excel5_Xf::_mapHAlign (   $hAlign)
private

Map to BIFF2-BIFF8 codes for horizontal alignment.

Parameters
string$hAlign
Returns
int

Definition at line 470 of file Xf.php.

471 {
472 if (isset(self::$_mapHAlign[$hAlign]))
473 return self::$_mapHAlign[$hAlign];
474 return 0;
475 }

Referenced by writeXf().

+ Here is the caller graph for this function:

◆ _mapHidden()

static PHPExcel_Writer_Excel5_Xf::_mapHidden (   $hidden)
staticprivate

Map hidden.

Parameters
string
Returns
int

Definition at line 538 of file Xf.php.

538 {
539 switch ($hidden) {
540 case PHPExcel_Style_Protection::PROTECTION_INHERIT: return 0;
541 case PHPExcel_Style_Protection::PROTECTION_PROTECTED: return 1;
542 case PHPExcel_Style_Protection::PROTECTION_UNPROTECTED: return 0;
543 default: return 0;
544 }
545 }
PHPExcel_Style_Protection\PROTECTION_UNPROTECTED
const PROTECTION_UNPROTECTED
Definition: Protection.php:41
PHPExcel_Style_Protection\PROTECTION_INHERIT
const PROTECTION_INHERIT
Protection styles.
Definition: Protection.php:39
PHPExcel_Style_Protection\PROTECTION_PROTECTED
const PROTECTION_PROTECTED
Definition: Protection.php:40

References PHPExcel_Style_Protection\PROTECTION_INHERIT, PHPExcel_Style_Protection\PROTECTION_PROTECTED, and PHPExcel_Style_Protection\PROTECTION_UNPROTECTED.

Referenced by writeXf().

+ Here is the caller graph for this function:

◆ _mapLocked()

static PHPExcel_Writer_Excel5_Xf::_mapLocked (   $locked)
staticprivate

Map locked.

Parameters
string
Returns
int

Definition at line 523 of file Xf.php.

523 {
524 switch ($locked) {
525 case PHPExcel_Style_Protection::PROTECTION_INHERIT: return 1;
526 case PHPExcel_Style_Protection::PROTECTION_PROTECTED: return 1;
527 case PHPExcel_Style_Protection::PROTECTION_UNPROTECTED: return 0;
528 default: return 1;
529 }
530 }

References PHPExcel_Style_Protection\PROTECTION_INHERIT, PHPExcel_Style_Protection\PROTECTION_PROTECTED, and PHPExcel_Style_Protection\PROTECTION_UNPROTECTED.

Referenced by writeXf().

+ Here is the caller graph for this function:

◆ _mapTextRotation()

static PHPExcel_Writer_Excel5_Xf::_mapTextRotation (   $textRotation)
staticprivate

Map to BIFF8 codes for text rotation angle.

Parameters
int$textRotation
Returns
int

Definition at line 505 of file Xf.php.

505 {
506 if ($textRotation >= 0) {
507 return $textRotation;
508 }
509 if ($textRotation == -165) {
510 return 255;
511 }
512 if ($textRotation < 0) {
513 return 90 - $textRotation;
514 }
515 }

◆ _mapVAlign()

static PHPExcel_Writer_Excel5_Xf::_mapVAlign (   $vAlign)
staticprivate

Map to BIFF2-BIFF8 codes for vertical alignment.

Parameters
string$vAlign
Returns
int

Definition at line 493 of file Xf.php.

493 {
494 if (isset(self::$_mapVAlign[$vAlign]))
495 return self::$_mapVAlign[$vAlign];
496 return 2;
497 }

Referenced by writeXf().

+ Here is the caller graph for this function:

◆ setBgColor()

PHPExcel_Writer_Excel5_Xf::setBgColor (   $colorIndex)

Sets the cell's background color.

@access public

Parameters
int$colorIndexColor index

Definition at line 352 of file Xf.php.

353 {
354 $this->_bg_color = $colorIndex;
355 }

◆ setBottomColor()

PHPExcel_Writer_Excel5_Xf::setBottomColor (   $colorIndex)

Sets the cell's bottom border color.

@access public

Parameters
int$colorIndexColor index

Definition at line 285 of file Xf.php.

286 {
287 $this->_bottom_color = $colorIndex;
288 }

◆ setDiagColor()

PHPExcel_Writer_Excel5_Xf::setDiagColor (   $colorIndex)

Sets the cell's diagonal border color.

@access public

Parameters
int$colorIndexColor index

Definition at line 329 of file Xf.php.

330 {
331 $this->_diag_color = $colorIndex;
332 }

◆ setFgColor()

PHPExcel_Writer_Excel5_Xf::setFgColor (   $colorIndex)

Sets the cell's foreground color.

@access public

Parameters
int$colorIndexColor index

Definition at line 341 of file Xf.php.

342 {
343 $this->_fg_color = $colorIndex;
344 }

◆ setFontIndex()

PHPExcel_Writer_Excel5_Xf::setFontIndex (   $value)

Set the font index.

Parameters
int$valueFont index, note that value 4 does not exist

Definition at line 374 of file Xf.php.

375 {
376 $this->_fontIndex = $value;
377 }

◆ setIsStyleXf()

PHPExcel_Writer_Excel5_Xf::setIsStyleXf (   $value)

Is this a style XF ?

Parameters
boolean$value

Definition at line 274 of file Xf.php.

275 {
276 $this->_isStyleXf = $value;
277 }

◆ setLeftColor()

PHPExcel_Writer_Excel5_Xf::setLeftColor (   $colorIndex)

Sets the cell's left border color.

@access public

Parameters
int$colorIndexColor index

Definition at line 307 of file Xf.php.

308 {
309 $this->_left_color = $colorIndex;
310 }

◆ setNumberFormatIndex()

PHPExcel_Writer_Excel5_Xf::setNumberFormatIndex (   $numberFormatIndex)

Sets the index to the number format record It can be date, time, currency, etc...

@access public

Parameters
integer$numberFormatIndexIndex to format record

Definition at line 364 of file Xf.php.

365 {
366 $this->_numberFormatIndex = $numberFormatIndex;
367 }

◆ setRightColor()

PHPExcel_Writer_Excel5_Xf::setRightColor (   $colorIndex)

Sets the cell's right border color.

@access public

Parameters
int$colorIndexColor index

Definition at line 318 of file Xf.php.

319 {
320 $this->_right_color = $colorIndex;
321 }

◆ setTopColor()

PHPExcel_Writer_Excel5_Xf::setTopColor (   $colorIndex)

Sets the cell's top border color.

@access public

Parameters
int$colorIndexColor index

Definition at line 296 of file Xf.php.

297 {
298 $this->_top_color = $colorIndex;
299 }

◆ writeXf()

PHPExcel_Writer_Excel5_Xf::writeXf ( )

Generate an Excel BIFF XF record (style or cell).

Returns
string The XF record

Definition at line 169 of file Xf.php.

170 {
171 // Set the type of the XF record and some of the attributes.
172 if ($this->_isStyleXf) {
173 $style = 0xFFF5;
174 } else {
175 $style = self::_mapLocked($this->_style->getProtection()->getLocked());
176 $style |= self::_mapHidden($this->_style->getProtection()->getHidden()) << 1;
177 }
178
179 // Flags to indicate if attributes have been set.
180 $atr_num = ($this->_numberFormatIndex != 0)?1:0;
181 $atr_fnt = ($this->_fontIndex != 0)?1:0;
182 $atr_alc = ((int) $this->_style->getAlignment()->getWrapText()) ? 1 : 0;
183 $atr_bdr = (self::_mapBorderStyle($this->_style->getBorders()->getBottom()->getBorderStyle()) ||
184 self::_mapBorderStyle($this->_style->getBorders()->getTop()->getBorderStyle()) ||
185 self::_mapBorderStyle($this->_style->getBorders()->getLeft()->getBorderStyle()) ||
186 self::_mapBorderStyle($this->_style->getBorders()->getRight()->getBorderStyle()))?1:0;
187 $atr_pat = (($this->_fg_color != 0x40) ||
188 ($this->_bg_color != 0x41) ||
189 self::_mapFillType($this->_style->getFill()->getFillType()))?1:0;
190 $atr_prot = self::_mapLocked($this->_style->getProtection()->getLocked())
191 | self::_mapHidden($this->_style->getProtection()->getHidden());
192
193 // Zero the default border colour if the border has not been set.
194 if (self::_mapBorderStyle($this->_style->getBorders()->getBottom()->getBorderStyle()) == 0) {
195 $this->_bottom_color = 0;
196 }
197 if (self::_mapBorderStyle($this->_style->getBorders()->getTop()->getBorderStyle()) == 0) {
198 $this->_top_color = 0;
199 }
200 if (self::_mapBorderStyle($this->_style->getBorders()->getRight()->getBorderStyle()) == 0) {
201 $this->_right_color = 0;
202 }
203 if (self::_mapBorderStyle($this->_style->getBorders()->getLeft()->getBorderStyle()) == 0) {
204 $this->_left_color = 0;
205 }
206 if (self::_mapBorderStyle($this->_style->getBorders()->getDiagonal()->getBorderStyle()) == 0) {
207 $this->_diag_color = 0;
208 }
209
210 $record = 0x00E0; // Record identifier
211 $length = 0x0014; // Number of bytes to follow
212
213 $ifnt = $this->_fontIndex; // Index to FONT record
214 $ifmt = $this->_numberFormatIndex; // Index to FORMAT record
215
216 $align = $this->_mapHAlign($this->_style->getAlignment()->getHorizontal()); // Alignment
217 $align |= (int) $this->_style->getAlignment()->getWrapText() << 3;
218 $align |= self::_mapVAlign($this->_style->getAlignment()->getVertical()) << 4;
219 $align |= $this->_text_justlast << 7;
220
221 $used_attrib = $atr_num << 2;
222 $used_attrib |= $atr_fnt << 3;
223 $used_attrib |= $atr_alc << 4;
224 $used_attrib |= $atr_bdr << 5;
225 $used_attrib |= $atr_pat << 6;
226 $used_attrib |= $atr_prot << 7;
227
228 $icv = $this->_fg_color; // fg and bg pattern colors
229 $icv |= $this->_bg_color << 7;
230
231 $border1 = self::_mapBorderStyle($this->_style->getBorders()->getLeft()->getBorderStyle()); // Border line style and color
232 $border1 |= self::_mapBorderStyle($this->_style->getBorders()->getRight()->getBorderStyle()) << 4;
233 $border1 |= self::_mapBorderStyle($this->_style->getBorders()->getTop()->getBorderStyle()) << 8;
234 $border1 |= self::_mapBorderStyle($this->_style->getBorders()->getBottom()->getBorderStyle()) << 12;
235 $border1 |= $this->_left_color << 16;
236 $border1 |= $this->_right_color << 23;
237
238 $diagonalDirection = $this->_style->getBorders()->getDiagonalDirection();
239 $diag_tl_to_rb = $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_BOTH
240 || $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_DOWN;
241 $diag_tr_to_lb = $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_BOTH
242 || $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_UP;
243 $border1 |= $diag_tl_to_rb << 30;
244 $border1 |= $diag_tr_to_lb << 31;
245
246 $border2 = $this->_top_color; // Border color
247 $border2 |= $this->_bottom_color << 7;
248 $border2 |= $this->_diag_color << 14;
249 $border2 |= self::_mapBorderStyle($this->_style->getBorders()->getDiagonal()->getBorderStyle()) << 21;
250 $border2 |= self::_mapFillType($this->_style->getFill()->getFillType()) << 26;
251
252 $header = pack("vv", $record, $length);
253
254 //BIFF8 options: identation, shrinkToFit and text direction
255 $biff8_options = $this->_style->getAlignment()->getIndent();
256 $biff8_options |= (int) $this->_style->getAlignment()->getShrinkToFit() << 4;
257
258 $data = pack("vvvC", $ifnt, $ifmt, $style, $align);
259 $data .= pack("CCC"
260 , self::_mapTextRotation($this->_style->getAlignment()->getTextRotation())
261 , $biff8_options
262 , $used_attrib
263 );
264 $data .= pack("VVv", $border1, $border2, $icv);
265
266 return($header . $data);
267 }
PHPExcel_Style_Borders\DIAGONAL_DOWN
const DIAGONAL_DOWN
Definition: Borders.php:41
PHPExcel_Style_Borders\DIAGONAL_BOTH
const DIAGONAL_BOTH
Definition: Borders.php:42
PHPExcel_Style_Borders\DIAGONAL_UP
const DIAGONAL_UP
Definition: Borders.php:40
PHPExcel_Writer_Excel5_Xf\_mapVAlign
static _mapVAlign($vAlign)
Map to BIFF2-BIFF8 codes for vertical alignment.
Definition: Xf.php:493
PHPExcel_Writer_Excel5_Xf\_mapFillType
static _mapFillType($fillType)
Map fill type.
Definition: Xf.php:445
PHPExcel_Writer_Excel5_Xf\$_fontIndex
$_fontIndex
Definition: Xf.php:84
PHPExcel_Writer_Excel5_Xf\_mapLocked
static _mapLocked($locked)
Map locked.
Definition: Xf.php:523
PHPExcel_Writer_Excel5_Xf\_mapHidden
static _mapHidden($hidden)
Map hidden.
Definition: Xf.php:538
PHPExcel_Writer_Excel5_Xf\$_numberFormatIndex
$_numberFormatIndex
Definition: Xf.php:90
PHPExcel_Writer_Excel5_Xf\_mapBorderStyle
static _mapBorderStyle($borderStyle)
Map border style.
Definition: Xf.php:406
PHPExcel_Writer_Excel5_Xf\_mapHAlign
_mapHAlign($hAlign)
Map to BIFF2-BIFF8 codes for horizontal alignment.
Definition: Xf.php:470
PHPExcel_Writer_Excel5_Xf\$_fg_color
$_fg_color
Definition: Xf.php:102
PHPExcel_Writer_Excel5_Xf\$_top_color
$_top_color
Definition: Xf.php:120
$header
$header
Definition: example_011.php:123

References $_fg_color, $_fontIndex, $_numberFormatIndex, $_top_color, $data, $header, $style, _mapBorderStyle(), _mapFillType(), _mapHAlign(), _mapHidden(), _mapLocked(), _mapVAlign(), PHPExcel_Style_Borders\DIAGONAL_BOTH, PHPExcel_Style_Borders\DIAGONAL_DOWN, and PHPExcel_Style_Borders\DIAGONAL_UP.

+ Here is the call graph for this function:

Field Documentation

◆ $_bg_color

PHPExcel_Writer_Excel5_Xf::$_bg_color

Definition at line 108 of file Xf.php.

◆ $_bottom_color

PHPExcel_Writer_Excel5_Xf::$_bottom_color

Definition at line 114 of file Xf.php.

◆ $_fg_color

PHPExcel_Writer_Excel5_Xf::$_fg_color

Definition at line 102 of file Xf.php.

Referenced by writeXf().

◆ $_fontIndex

PHPExcel_Writer_Excel5_Xf::$_fontIndex
private

Definition at line 84 of file Xf.php.

Referenced by writeXf().

◆ $_isStyleXf

PHPExcel_Writer_Excel5_Xf::$_isStyleXf
private

Definition at line 78 of file Xf.php.

◆ $_left_color

PHPExcel_Writer_Excel5_Xf::$_left_color

Definition at line 126 of file Xf.php.

◆ $_mapBorderStyle

PHPExcel_Writer_Excel5_Xf::$_mapBorderStyle
staticprivate
Initial value:
= array ( PHPExcel_Style_Border::BORDER_NONE => 0x00,
PHPExcel_Style_Border::BORDER_THIN => 0x01,
PHPExcel_Style_Border::BORDER_MEDIUM => 0x02,
PHPExcel_Style_Border::BORDER_DASHED => 0x03,
PHPExcel_Style_Border::BORDER_DOTTED => 0x04,
PHPExcel_Style_Border::BORDER_THICK => 0x05,
PHPExcel_Style_Border::BORDER_DOUBLE => 0x06,
PHPExcel_Style_Border::BORDER_HAIR => 0x07,
PHPExcel_Style_Border::BORDER_MEDIUMDASHED => 0x08,
PHPExcel_Style_Border::BORDER_DASHDOT => 0x09,
PHPExcel_Style_Border::BORDER_MEDIUMDASHDOT => 0x0A,
PHPExcel_Style_Border::BORDER_DASHDOTDOT => 0x0B,
PHPExcel_Style_Border::BORDER_MEDIUMDASHDOTDOT => 0x0C,
PHPExcel_Style_Border::BORDER_SLANTDASHDOT => 0x0D,
)
PHPExcel_Style_Border\BORDER_MEDIUMDASHDOTDOT
const BORDER_MEDIUMDASHDOTDOT
Definition: Border.php:48
PHPExcel_Style_Border\BORDER_THIN
const BORDER_THIN
Definition: Border.php:52
PHPExcel_Style_Border\BORDER_THICK
const BORDER_THICK
Definition: Border.php:51
PHPExcel_Style_Border\BORDER_DOTTED
const BORDER_DOTTED
Definition: Border.php:43
PHPExcel_Style_Border\BORDER_MEDIUMDASHED
const BORDER_MEDIUMDASHED
Definition: Border.php:49
PHPExcel_Style_Border\BORDER_HAIR
const BORDER_HAIR
Definition: Border.php:45
PHPExcel_Style_Border\BORDER_DASHDOT
const BORDER_DASHDOT
Definition: Border.php:40
PHPExcel_Style_Border\BORDER_SLANTDASHDOT
const BORDER_SLANTDASHDOT
Definition: Border.php:50
PHPExcel_Style_Border\BORDER_MEDIUMDASHDOT
const BORDER_MEDIUMDASHDOT
Definition: Border.php:47
PHPExcel_Style_Border\BORDER_MEDIUM
const BORDER_MEDIUM
Definition: Border.php:46
PHPExcel_Style_Border\BORDER_DASHED
const BORDER_DASHED
Definition: Border.php:42
PHPExcel_Style_Border\BORDER_DASHDOTDOT
const BORDER_DASHDOTDOT
Definition: Border.php:41
PHPExcel_Style_Border\BORDER_DOUBLE
const BORDER_DOUBLE
Definition: Border.php:44
PHPExcel_Style_Border\BORDER_NONE
const BORDER_NONE
Definition: Border.php:39

Map of BIFF2-BIFF8 codes for border styles array of int.

Definition at line 384 of file Xf.php.

◆ $_mapFillType

PHPExcel_Writer_Excel5_Xf::$_mapFillType
staticprivate
Initial value:
= array( PHPExcel_Style_Fill::FILL_NONE => 0x00,
PHPExcel_Style_Fill::FILL_SOLID => 0x01,
PHPExcel_Style_Fill::FILL_PATTERN_MEDIUMGRAY => 0x02,
PHPExcel_Style_Fill::FILL_PATTERN_DARKGRAY => 0x03,
PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRAY => 0x04,
PHPExcel_Style_Fill::FILL_PATTERN_DARKHORIZONTAL => 0x05,
PHPExcel_Style_Fill::FILL_PATTERN_DARKVERTICAL => 0x06,
PHPExcel_Style_Fill::FILL_PATTERN_DARKDOWN => 0x07,
PHPExcel_Style_Fill::FILL_PATTERN_DARKUP => 0x08,
PHPExcel_Style_Fill::FILL_PATTERN_DARKGRID => 0x09,
PHPExcel_Style_Fill::FILL_PATTERN_DARKTRELLIS => 0x0A,
PHPExcel_Style_Fill::FILL_PATTERN_LIGHTHORIZONTAL => 0x0B,
PHPExcel_Style_Fill::FILL_PATTERN_LIGHTVERTICAL => 0x0C,
PHPExcel_Style_Fill::FILL_PATTERN_LIGHTDOWN => 0x0D,
PHPExcel_Style_Fill::FILL_PATTERN_LIGHTUP => 0x0E,
PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRID => 0x0F,
PHPExcel_Style_Fill::FILL_PATTERN_LIGHTTRELLIS => 0x10,
PHPExcel_Style_Fill::FILL_PATTERN_GRAY125 => 0x11,
PHPExcel_Style_Fill::FILL_PATTERN_GRAY0625 => 0x12,
PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR => 0x00,
PHPExcel_Style_Fill::FILL_GRADIENT_PATH => 0x00,
)
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTUP
const FILL_PATTERN_LIGHTUP
Definition: Fill.php:57
PHPExcel_Style_Fill\FILL_SOLID
const FILL_SOLID
Definition: Fill.php:40
PHPExcel_Style_Fill\FILL_PATTERN_DARKDOWN
const FILL_PATTERN_DARKDOWN
Definition: Fill.php:43
PHPExcel_Style_Fill\FILL_PATTERN_DARKUP
const FILL_PATTERN_DARKUP
Definition: Fill.php:48
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTVERTICAL
const FILL_PATTERN_LIGHTVERTICAL
Definition: Fill.php:58
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRAY
const FILL_PATTERN_LIGHTGRAY
Definition: Fill.php:53
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTDOWN
const FILL_PATTERN_LIGHTDOWN
Definition: Fill.php:52
PHPExcel_Style_Fill\FILL_PATTERN_DARKGRAY
const FILL_PATTERN_DARKGRAY
Definition: Fill.php:44
PHPExcel_Style_Fill\FILL_PATTERN_GRAY125
const FILL_PATTERN_GRAY125
Definition: Fill.php:51
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTHORIZONTAL
const FILL_PATTERN_LIGHTHORIZONTAL
Definition: Fill.php:55
PHPExcel_Style_Fill\FILL_PATTERN_DARKTRELLIS
const FILL_PATTERN_DARKTRELLIS
Definition: Fill.php:47
PHPExcel_Style_Fill\FILL_PATTERN_GRAY0625
const FILL_PATTERN_GRAY0625
Definition: Fill.php:50
PHPExcel_Style_Fill\FILL_NONE
const FILL_NONE
Definition: Fill.php:39
PHPExcel_Style_Fill\FILL_PATTERN_MEDIUMGRAY
const FILL_PATTERN_MEDIUMGRAY
Definition: Fill.php:59
PHPExcel_Style_Fill\FILL_GRADIENT_PATH
const FILL_GRADIENT_PATH
Definition: Fill.php:42
PHPExcel_Style_Fill\FILL_GRADIENT_LINEAR
const FILL_GRADIENT_LINEAR
Definition: Fill.php:41
PHPExcel_Style_Fill\FILL_PATTERN_DARKVERTICAL
const FILL_PATTERN_DARKVERTICAL
Definition: Fill.php:49
PHPExcel_Style_Fill\FILL_PATTERN_DARKHORIZONTAL
const FILL_PATTERN_DARKHORIZONTAL
Definition: Fill.php:46
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRID
const FILL_PATTERN_LIGHTGRID
Definition: Fill.php:54
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTTRELLIS
const FILL_PATTERN_LIGHTTRELLIS
Definition: Fill.php:56
PHPExcel_Style_Fill\FILL_PATTERN_DARKGRID
const FILL_PATTERN_DARKGRID
Definition: Fill.php:45

Map of BIFF2-BIFF8 codes for fill types array of int.

Definition at line 417 of file Xf.php.

◆ $_mapHAlign

PHPExcel_Writer_Excel5_Xf::$_mapHAlign
staticprivate
Initial value:
= array( PHPExcel_Style_Alignment::HORIZONTAL_GENERAL => 0,
PHPExcel_Style_Alignment::HORIZONTAL_LEFT => 1,
PHPExcel_Style_Alignment::HORIZONTAL_CENTER => 2,
PHPExcel_Style_Alignment::HORIZONTAL_RIGHT => 3,
PHPExcel_Style_Alignment::HORIZONTAL_FILL => 4,
PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY => 5,
PHPExcel_Style_Alignment::HORIZONTAL_CENTER_CONTINUOUS => 6,
)
PHPExcel_Style_Alignment\HORIZONTAL_FILL
const HORIZONTAL_FILL
Definition: Alignment.php:45
PHPExcel_Style_Alignment\HORIZONTAL_GENERAL
const HORIZONTAL_GENERAL
Definition: Alignment.php:39
PHPExcel_Style_Alignment\HORIZONTAL_RIGHT
const HORIZONTAL_RIGHT
Definition: Alignment.php:41
PHPExcel_Style_Alignment\HORIZONTAL_CENTER
const HORIZONTAL_CENTER
Definition: Alignment.php:42
PHPExcel_Style_Alignment\HORIZONTAL_CENTER_CONTINUOUS
const HORIZONTAL_CENTER_CONTINUOUS
Definition: Alignment.php:43
PHPExcel_Style_Alignment\HORIZONTAL_JUSTIFY
const HORIZONTAL_JUSTIFY
Definition: Alignment.php:44
PHPExcel_Style_Alignment\HORIZONTAL_LEFT
const HORIZONTAL_LEFT
Definition: Alignment.php:40

Map of BIFF2-BIFF8 codes for horizontal alignment array of int.

Definition at line 456 of file Xf.php.

◆ $_mapVAlign

PHPExcel_Writer_Excel5_Xf::$_mapVAlign
staticprivate
Initial value:
= array( PHPExcel_Style_Alignment::VERTICAL_TOP => 0,
PHPExcel_Style_Alignment::VERTICAL_CENTER => 1,
PHPExcel_Style_Alignment::VERTICAL_BOTTOM => 2,
PHPExcel_Style_Alignment::VERTICAL_JUSTIFY => 3,
)
PHPExcel_Style_Alignment\VERTICAL_CENTER
const VERTICAL_CENTER
Definition: Alignment.php:51
PHPExcel_Style_Alignment\VERTICAL_JUSTIFY
const VERTICAL_JUSTIFY
Definition: Alignment.php:52
PHPExcel_Style_Alignment\VERTICAL_TOP
const VERTICAL_TOP
Definition: Alignment.php:50
PHPExcel_Style_Alignment\VERTICAL_BOTTOM
const VERTICAL_BOTTOM
Definition: Alignment.php:49

Map of BIFF2-BIFF8 codes for vertical alignment array of int.

Definition at line 482 of file Xf.php.

◆ $_numberFormatIndex

PHPExcel_Writer_Excel5_Xf::$_numberFormatIndex

Definition at line 90 of file Xf.php.

Referenced by writeXf().

◆ $_right_color

PHPExcel_Writer_Excel5_Xf::$_right_color

Definition at line 132 of file Xf.php.

◆ $_text_justlast

PHPExcel_Writer_Excel5_Xf::$_text_justlast

Definition at line 96 of file Xf.php.

◆ $_top_color

PHPExcel_Writer_Excel5_Xf::$_top_color

Definition at line 120 of file Xf.php.

Referenced by writeXf().

The documentation for this class was generated from the following file: