public static function getDistanceY(Worksheet $sheet, $startRow = 1, $startOffsetY = 0, $endRow = 1, $endOffsetY = 0)
    {
        $distanceY = 0;

        // add the widths of the spanning rows
        for ($row = $startRow; $row <= $endRow; ++$row) {
            $distanceY += self::sizeRow($sheet, $row);
        }

        // correct for offsetX in startcell
        $distanceY -= (int) floor(self::sizeRow($sheet, $startRow) * $startOffsetY / 256);

        // correct for offsetX in endcell
        $distanceY -= (int) floor(self::sizeRow($sheet, $endRow) * (1 - $endOffsetY / 256));

        return $distanceY;
    }
public static function getDistanceY(Worksheet $sheet, $startRow = 1, $startOffsetY = 0, $endRow = 1, $endOffsetY = 0)
    {
        $distanceY = 0;

        // add the widths of the spanning rows
        for ($row = $startRow; $row <= $endRow; ++$row) {
            $distanceY += self::sizeRow($sheet, $row);
        }

        // correct for offsetX in startcell
        $distanceY -= (int) floor(self::sizeRow($sheet, $startRow) * $startOffsetY / 256);

        // correct for offsetX in endcell
        $distanceY -= (int) floor(self::sizeRow($sheet, $endRow) * (1 - $endOffsetY / 256));

        return $distanceY;
    }
public static function getDistanceY ( Worksheet $ sheet , $ startRow = 1 , $ startOffsetY = 0 , $ endRow = 1 , $ endOffsetY = 0 ) { $ distanceY = 0 ; // add the widths of the spanning rows for ( $ row = $ startRow ; $ row <= $ endRow ; ++ $ row ) { $ distanceY += self :: sizeRow ( $ sheet , $ row ) ; } // correct for offsetX in startcell $ distanceY -= ( int ) floor ( self :: sizeRow ( $ sheet , $ startRow ) * $ startOffsetY / 256 ) ; // correct for offsetX in endcell $ distanceY -= ( int ) floor ( self :: sizeRow ( $ sheet , $ endRow ) * ( 1 - $ endOffsetY / 256 ) ) ; return $ distanceY ; }
Get the vertical distance in pixels between two anchors
The distanceY is found as sum of all the spanning rows minus two offsets.

@param Worksheet $sheet
@param int $startRow (1-based)
@param int $startOffsetY Offset within start cell measured in 1/256 of the cell height
@param int $endRow (1-based)
@param int $endOffsetY Offset within end cell measured in 1/256 of the cell height

@return int Vertical distance measured in pixels
Get the vertical distance in pixels between two anchors The distanceY is found as sum of all the spanning rows minus two offsets .