\PHPExcel_Shared_Excel5

PHPExcel_Shared_Excel5

Summary

Methods
Properties
Constants
sizeCol()
sizeRow()
getDistanceX()
getDistanceY()
oneAnchor2twoAnchor()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Methods

sizeCol()

sizeCol(\PHPExcel_Worksheet  $sheet, string  $col = 'A') : integer

Get the width of a column in pixels. We use the relationship y = ceil(7x) where x is the width in intrinsic Excel units (measuring width in number of normal characters) This holds for Arial 10

Parameters

\PHPExcel_Worksheet $sheet

The sheet

string $col

The column

Returns

integer —

The width in pixels

sizeRow()

sizeRow(\PHPExcel_Worksheet  $sheet, integer  $row = 1) : integer

Convert the height of a cell from user's units to pixels. By interpolation the relationship is: y = 4/3x. If the height hasn't been set by the user we use the default value. If the row is hidden we use a value of zero.

Parameters

\PHPExcel_Worksheet $sheet

The sheet

integer $row

The row index (1-based)

Returns

integer —

The width in pixels

getDistanceX()

getDistanceX(\PHPExcel_Worksheet  $sheet, string  $startColumn = 'A', integer  $startOffsetX, string  $endColumn = 'A', integer  $endOffsetX) : integer

Get the horizontal distance in pixels between two anchors The distanceX is found as sum of all the spanning columns widths minus correction for the two offsets

Parameters

\PHPExcel_Worksheet $sheet
string $startColumn
integer $startOffsetX

Offset within start cell measured in 1/1024 of the cell width

string $endColumn
integer $endOffsetX

Offset within end cell measured in 1/1024 of the cell width

Returns

integer —

Horizontal measured in pixels

getDistanceY()

getDistanceY(\PHPExcel_Worksheet  $sheet, integer  $startRow = 1, integer  $startOffsetY, integer  $endRow = 1, integer  $endOffsetY) : integer

Get the vertical distance in pixels between two anchors The distanceY is found as sum of all the spanning rows minus two offsets

Parameters

\PHPExcel_Worksheet $sheet
integer $startRow

(1-based)

integer $startOffsetY

Offset within start cell measured in 1/256 of the cell height

integer $endRow

(1-based)

integer $endOffsetY

Offset within end cell measured in 1/256 of the cell height

Returns

integer —

Vertical distance measured in pixels

oneAnchor2twoAnchor()

oneAnchor2twoAnchor(\PHPExcel_Worksheet  $sheet, string  $coordinates, integer  $offsetX, integer  $offsetY, integer  $width, integer  $height) : array

Convert 1-cell anchor coordinates to 2-cell anchor coordinates This function is ported from PEAR Spreadsheet_Writer_Excel with small modifications

Calculate the vertices that define the position of the image as required by the OBJ record.

 +------------+------------+
 |   A    |   B  |
+-----+------------+------------+ (x1,y1) 1 (A1).___ __
+-----+---- BITMAP -----+
2 __.
(B2)
(x2,y2)

+---- +------------+------------+

Example of a bitmap that covers some of the area from cell A1 to cell B2.

Based on the width and height of the bitmap we need to calculate 8 vars: $col_start, $row_start, $col_end, $row_end, $x1, $y1, $x2, $y2. The width and height of the cells are also variable and have to be taken into account. The values of $col_start and $row_start are passed in from the calling function. The values of $col_end and $row_end are calculated by subtracting the width and height of the bitmap from the width and height of the underlying cells. The vertices are expressed as a percentage of the underlying cell width as follows (rhs values are in pixels):

x1 = X / W 1024 y1 = Y / H 256 x2 = (X-1) / W 1024 y2 = (Y-1) / H 256

Where: X is distance from the left side of the underlying cell Y is distance from the top of the underlying cell W is the width of the cell H is the height of the cell

Parameters

\PHPExcel_Worksheet $sheet
string $coordinates

E.g. 'A1'

integer $offsetX

Horizontal offset in pixels

integer $offsetY

Vertical offset in pixels

integer $width

Width in pixels

integer $height

Height in pixels

Returns

array