public static function PHPExcel_Shared_Font::getDefaultRowHeightByFont in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Shared/Font.php \PHPExcel_Shared_Font::getDefaultRowHeightByFont()

* Get the effective row height for rows without a row dimension or rows with height -1 * For example, for Calibri 11 this is 15 points * *

Parameters

PHPExcel_Style_Font $font The workbooks default font: * @return float Row height in points

2 calls to PHPExcel_Shared_Font::getDefaultRowHeightByFont()

PHPExcel_Shared_Excel5::sizeRow in vendor/phpoffice/phpexcel/Classes/PHPExcel/Shared/Excel5.php

* 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. * *

PHPExcel_Writer_HTML::buildCSS in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/HTML.php

* Build CSS styles * *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Shared/Font.php, line 603

Class

PHPExcel_Shared_Font

PHPExcel_Shared_Font

Code

public static function getDefaultRowHeightByFont(PHPExcel_Style_Font $font) {
  switch ($font
    ->getName()) {
    case 'Arial':
      switch ($font
        ->getSize()) {
        case 10:

          // inspection of Arial 10 workbook says 12.75pt ~17px
          $rowHeight = 12.75;
          break;
        case 9:

          // inspection of Arial 9 workbook says 12.00pt ~16px
          $rowHeight = 12;
          break;
        case 8:

          // inspection of Arial 8 workbook says 11.25pt ~15px
          $rowHeight = 11.25;
          break;
        case 7:

          // inspection of Arial 7 workbook says 9.00pt ~12px
          $rowHeight = 9;
          break;
        case 6:
        case 5:

          // inspection of Arial 5,6 workbook says 8.25pt ~11px
          $rowHeight = 8.25;
          break;
        case 4:

          // inspection of Arial 4 workbook says 6.75pt ~9px
          $rowHeight = 6.75;
          break;
        case 3:

          // inspection of Arial 3 workbook says 6.00pt ~8px
          $rowHeight = 6;
          break;
        case 2:
        case 1:

          // inspection of Arial 1,2 workbook says 5.25pt ~7px
          $rowHeight = 5.25;
          break;
        default:

          // use Arial 10 workbook as an approximation, extrapolation
          $rowHeight = 12.75 * $font
            ->getSize() / 10;
          break;
      }
      break;
    case 'Calibri':
      switch ($font
        ->getSize()) {
        case 11:

          // inspection of Calibri 11 workbook says 15.00pt ~20px
          $rowHeight = 15;
          break;
        case 10:

          // inspection of Calibri 10 workbook says 12.75pt ~17px
          $rowHeight = 12.75;
          break;
        case 9:

          // inspection of Calibri 9 workbook says 12.00pt ~16px
          $rowHeight = 12;
          break;
        case 8:

          // inspection of Calibri 8 workbook says 11.25pt ~15px
          $rowHeight = 11.25;
          break;
        case 7:

          // inspection of Calibri 7 workbook says 9.00pt ~12px
          $rowHeight = 9;
          break;
        case 6:
        case 5:

          // inspection of Calibri 5,6 workbook says 8.25pt ~11px
          $rowHeight = 8.25;
          break;
        case 4:

          // inspection of Calibri 4 workbook says 6.75pt ~9px
          $rowHeight = 6.75;
          break;
        case 3:

          // inspection of Calibri 3 workbook says 6.00pt ~8px
          $rowHeight = 6.0;
          break;
        case 2:
        case 1:

          // inspection of Calibri 1,2 workbook says 5.25pt ~7px
          $rowHeight = 5.25;
          break;
        default:

          // use Calibri 11 workbook as an approximation, extrapolation
          $rowHeight = 15 * $font
            ->getSize() / 11;
          break;
      }
      break;
    case 'Verdana':
      switch ($font
        ->getSize()) {
        case 10:

          // inspection of Verdana 10 workbook says 12.75pt ~17px
          $rowHeight = 12.75;
          break;
        case 9:

          // inspection of Verdana 9 workbook says 11.25pt ~15px
          $rowHeight = 11.25;
          break;
        case 8:

          // inspection of Verdana 8 workbook says 10.50pt ~14px
          $rowHeight = 10.5;
          break;
        case 7:

          // inspection of Verdana 7 workbook says 9.00pt ~12px
          $rowHeight = 9.0;
          break;
        case 6:
        case 5:

          // inspection of Verdana 5,6 workbook says 8.25pt ~11px
          $rowHeight = 8.25;
          break;
        case 4:

          // inspection of Verdana 4 workbook says 6.75pt ~9px
          $rowHeight = 6.75;
          break;
        case 3:

          // inspection of Verdana 3 workbook says 6.00pt ~8px
          $rowHeight = 6;
          break;
        case 2:
        case 1:

          // inspection of Verdana 1,2 workbook says 5.25pt ~7px
          $rowHeight = 5.25;
          break;
        default:

          // use Verdana 10 workbook as an approximation, extrapolation
          $rowHeight = 12.75 * $font
            ->getSize() / 10;
          break;
      }
      break;
    default:

      // just use Calibri as an approximation
      $rowHeight = 15 * $font
        ->getSize() / 11;
      break;
  }
  return $rowHeight;
}