1: <?php
  2: /**
  3:  * LICENSE (BSD)
  4:  *
  5:  * Copyright (c) 2013, Gerd Christian Kunze
  6:  * All rights reserved.
  7:  *
  8:  * Redistribution and use in source and binary forms, with or without
  9:  * modification, are permitted provided that the following conditions are
 10:  * met:
 11:  *
 12:  *  * Redistributions of source code must retain the above copyright
 13:  *    notice, this list of conditions and the following disclaimer.
 14:  *
 15:  *  * Redistributions in binary form must reproduce the above copyright
 16:  *    notice, this list of conditions and the following disclaimer in the
 17:  *    documentation and/or other materials provided with the distribution.
 18:  *
 19:  *  * Neither the name of Gerd Christian Kunze nor the names of the
 20:  *    contributors may be used to endorse or promote products derived from
 21:  *    this software without specific prior written permission.
 22:  *
 23:  * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
 24:  * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
 25:  * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
 26:  * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
 27:  * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
 28:  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
 29:  * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
 30:  * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
 31:  * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 32:  * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 33:  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 34:  *
 35:  * Width
 36:  * 19.06.2013 09:17
 37:  */
 38: namespace MOC\Module\Office\Document\Excel\Cell\Style;
 39: use MOC\Api;
 40: use MOC\Generic\Device\Module;
 41: 
 42: /**
 43:  *
 44:  */
 45: class Width implements Module {
 46:     /**
 47:      * Get Changelog
 48:      *
 49:      * @static
 50:      * @return \MOC\Core\Changelog
 51:      */
 52:     public static function InterfaceChangelog() {
 53:         return Api::Core()->Changelog()->Create( __CLASS__ );
 54:     }
 55: 
 56:     /**
 57:      * Get Dependencies
 58:      *
 59:      * @static
 60:      * @return \MOC\Core\Depending
 61:      */
 62:     public static function InterfaceDepending() {
 63:         return Api::Core()->Depending();
 64:     }
 65: 
 66:     /**
 67:      * Get Singleton/Instance
 68:      *
 69:      * @static
 70:      * @return Width
 71:      */
 72:     public static function InterfaceInstance() {
 73:         return new Width();
 74:     }
 75: 
 76:     /**
 77:      * @return \MOC\Module\Office\Document\Excel
 78:      */
 79:     public function Auto() {
 80:         $this->getWidth()->setWidth()->setAutoSize( true );
 81:         return Api::Module()->Office()->Document()->Excel();
 82:     }
 83: 
 84:     /**
 85:      * @param float $Value in Pixel
 86:      *
 87:      * @return \MOC\Module\Office\Document\Excel
 88:      */
 89:     public function Set( $Value ) {
 90:         // FIX: Pixel to Excel-Non-Pixel-Whatever-Value
 91:         $Value = 100 / 705 * $Value;
 92:         $this->getWidth()->setAutoSize( false )->setWidth( $Value );
 93:         return Api::Module()->Office()->Document()->Excel();
 94:     }
 95: 
 96:     /**
 97:      * @return \PHPExcel_Worksheet_ColumnDimension
 98:      */
 99:     private function getWidth() {
100:         return Api::Extension()->Excel()->Current()
101:             ->getActiveSheet()
102:             ->getColumnDimensionByColumn(
103:                 \PHPExcel_Cell::columnIndexFromString(
104:                     preg_replace( '![0-9]+$!is', '', Api::Module()->Office()->Document()->Excel()
105:                     ->Cell()->Select()->Current() )
106:                 ) -1
107:             );
108:     }
109: }
110: