WebSVN – eFlore/Applications.cel – Diff – /trunk/jrest/lib/Spreadsheet/Excel/Writer/Worksheet.php

 *  Module written/ported by Xavier Noguer <xnoguer@rezebra.com>
+*
 *  The majority of this is _NOT_ my code.  I simply ported it from the
 *  PERL Spreadsheet::WriteExcel module.
+*
 *  The author of the Spreadsheet::WriteExcel module is John McNamara
 *  <jmcnamara@cpan.org>
+*
 *  I _DO_ maintain this code, and John McNamara has nothing to do with the
 *  porting of this code to PHP.  Any questions directly related to this
 *  class library should be directed to me.
 *    You should have received a copy of the GNU Lesser General Public
 *    License along with this library; if not, write to the Free Software
 *    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
-require_once('Parser.php');
+require_once 'Spreadsheet/Excel/Writer/Parser.php';
-require_once('BIFFwriter.php');
+require_once 'Spreadsheet/Excel/Writer/BIFFwriter.php';
 /**
 * Class for generating Excel Spreadsheets
     var $_xls_strmax;
     /**
     * First row for the DIMENSIONS record
     * @var integer
-    * @see storeDimensions()
+    * @see _storeDimensions()
     */
     var $_dim_rowmin;
     /**
     * Last row for the DIMENSIONS record
     * @var integer
-    * @see storeDimensions()
+    * @see _storeDimensions()
     */
     var $_dim_rowmax;
     /**
     * First column for the DIMENSIONS record
     * @var integer
-    * @see storeDimensions()
+    * @see _storeDimensions()
     */
     var $_dim_colmin;
     /**
     * Last column for the DIMENSIONS record
     * @var integer
-    * @see storeDimensions()
+    * @see _storeDimensions()
     * @var integer
     */
     var $print_colmax;
+    /**
+    * Whether to display RightToLeft.
+    * @var integer
+    */
+    var $_Arabic;
+    /**
+    * Whether to use outline.
+    * @var integer
+    */
+    var $_outline_on;
+    /**
+    * Auto outline styles.
+    * @var bool
+    */
+    var $_outline_style;
+    /**
+    * Whether to have outline summary below.
+    * @var bool
+    */
+    var $_outline_below;
+    /**
+    * Whether to have outline summary at the right.
+    * @var bool
+    */
+    var $_outline_right;
+    /**
+    * Outline row level.
+    * @var integer
+    */
+    var $_outline_row_level;
+    /**
+    * Whether to fit to page when printing or not.
+    * @var bool
+    */
+    var $_fit_page;
+    /**
+    * Number of pages to fit wide
+    * @var integer
+    */
+    var $_fit_width;
+    /**
+    * Number of pages to fit high
+    * @var integer
+    */
+    var $_fit_height;
+    /**
+    * Reference to the total number of strings in the workbook
+    * @var integer
+    */
+    var $_str_total;
+    /**
+    * Reference to the number of unique strings in the workbook
+    * @var integer
+    */
+    var $_str_unique;
+    /**
+    * Reference to the array containing all the unique strings in the workbook
+    * @var array
+    */
+    var $_str_table;
+    /**
+     * Number of merged cell ranges in actual record
+     * @var int $_merged_cells_counter
+     */
+    var $_merged_cells_counter = 0;
+    /**
+     * Number of actual mergedcells record
+     * @var int $_merged_cells_record
+     */
+    var $_merged_cells_record = 0;
+    /**
+    * Merged cell ranges
+    * @var array
+    */
+    var $_merged_ranges;
+    /**
+    * Charset encoding currently used when calling writeString()
+    * @var string
+    */
+    var $_input_encoding;
     /**
     * Constructor
+    *
     * @param string  $name         The name of the new worksheet
     * @param integer $index        The index of the new worksheet
     * @param mixed   &$activesheet The current activesheet of the workbook we belong to
     * @param mixed   &$firstsheet  The first worksheet in the workbook we belong to
     * @param mixed   &$url_format  The default format for hyperlinks
+    * @param mixed   &$parser      The formula parser created for the Workbook
+    * @param string  $tmp_dir      The path to the directory for temporary files
-    * @param mixed   &$parser      The formula parser created for the Workbook
+    * @access private
     */
+    function Spreadsheet_Excel_Writer_Worksheet($BIFF_version, $name,
-    function Spreadsheet_Excel_Writer_Worksheet($name, $index, &$activesheet,
+                                                $index, &$activesheet,
+                                                &$firstsheet, &$str_total,
+                                                &$str_unique, &$str_table,
-                                                &$firstsheet, &$url_format,
+                                                &$url_format, &$parser,
-                                                &$parser)
+                                                $tmp_dir)
+    {
         // It needs to call its parent's constructor explicitly
+        $this->Spreadsheet_Excel_Writer_BIFFwriter();
-        $this->Spreadsheet_Excel_Writer_BIFFwriter();
+        $this->_BIFF_version   = $BIFF_version;
         $rowmax                = 65536; // 16384 in Excel 5
         $colmax                = 256;
         $this->name            = $name;
         $this->index           = $index;
         $this->activesheet     = &$activesheet;
+        $this->firstsheet      = &$firstsheet;
+        $this->_str_total      = &$str_total;
+        $this->_str_unique     = &$str_unique;
-        $this->firstsheet      = &$firstsheet;
+        $this->_str_table      = &$str_table;
         $this->_url_format     = &$url_format;
         $this->_parser         = &$parser;
         //$this->ext_sheets      = array();
-        $this->_filehandle     = "";
+        $this->_filehandle     = '';
         $this->_using_tmpfile  = true;
         //$this->fileclosed      = 0;
         //$this->offset          = 0;
         $this->_xls_rowmax     = $rowmax;
         $this->_selection      = array(0,0,0,0);
         $this->_panes          = array();
         $this->_active_pane    = 3;
         $this->_frozen         = 0;
         $this->selected        = 0;
         $this->_paper_size      = 0x0;
         $this->_orientation     = 0x1;
         $this->_header          = '';
         $this->_footer          = '';
         $this->_hcenter         = 0;
         $this->_margin_foot     = 0.50;
         $this->_margin_left     = 0.75;
         $this->_margin_right    = 0.75;
         $this->_margin_top      = 1.00;
         $this->_margin_bottom   = 1.00;
-        $this->title_rowmin     = NULL;
+        $this->title_rowmin     = null;
-        $this->title_rowmax     = NULL;
+        $this->title_rowmax     = null;
-        $this->title_colmin     = NULL;
+        $this->title_colmin     = null;
-        $this->title_colmax     = NULL;
+        $this->title_colmax     = null;
-        $this->print_rowmin     = NULL;
+        $this->print_rowmin     = null;
-        $this->print_rowmax     = NULL;
+        $this->print_rowmax     = null;
-        $this->print_colmin     = NULL;
+        $this->print_colmin     = null;
-        $this->print_colmax     = NULL;
+        $this->print_colmax     = null;
-        $this->_print_gridlines = 1;
+        $this->_print_gridlines  = 1;
+        $this->_screen_gridlines = 1;
-        $this->_print_headers   = 0;
+        $this->_print_headers    = 0;
         $this->_fit_page        = 0;
         $this->_fit_width       = 0;
         $this->_fit_height      = 0;
         $this->_hbreaks         = array();
         $this->_vbreaks         = array();
         $this->_protect         = 0;
-        $this->_password        = NULL;
+        $this->_password        = null;
         $this->col_sizes        = array();
-        $this->row_sizes        = array();
+        $this->_row_sizes        = array();
         $this->_zoom            = 100;
         $this->_print_scale     = 100;
+        $this->_outline_row_level = 0;
+        $this->_outline_style     = 0;
+        $this->_outline_below     = 1;
+        $this->_outline_right     = 1;
+        $this->_outline_on        = 1;
+        $this->_Arabic            = 0;
+        $this->_merged_ranges     = array();
+        $this->_input_encoding    = '';
+        $this->_dv                = array();
+        $this->_tmp_dir           = $tmp_dir;
+        $this->_tmp_file          = '';
         $this->_initialize();
+    }
     /**
     * Open a tmp file to store the majority of the Worksheet data. If this fails,
     * for example due to write permissions, store the data in memory. This can be
     * slow for large files.
+    *
     * @access private
     */
     function _initialize()
+    {
+        if ($this->_using_tmpfile == false) {
+            return;
+        }
+        if ($this->_tmp_dir === '' && ini_get('open_basedir') === true) {
+            // open_basedir restriction in effect - store data in memory
+            // ToDo: Let the error actually have an effect somewhere
+            $this->_using_tmpfile = false;
+            return new PEAR_Error('Temp file could not be opened since open_basedir restriction in effect - please use setTmpDir() - using memory storage instead');
+        }
         // Open tmp file for storing Worksheet data
+        if ($this->_tmp_dir === '') {
-        $fh = tmpfile();
+            $fh = tmpfile();
-        if ( $fh) {
+        } else {
-            // Store filehandle
+            // For people with open base dir restriction
+            $this->_tmp_file = tempnam($this->_tmp_dir, "Spreadsheet_Excel_Writer");
-            $this->_filehandle = $fh;
+            $fh = @fopen($this->_tmp_file, "w+b");
+        }
-        else {
+        if ($fh === false) {
             // If tmpfile() fails store data in memory
             $this->_using_tmpfile = false;
+        } else {
+            // Store filehandle
+            $this->_filehandle = $fh;
+        }
+    }
     /**
     * Add data to the beginning of the workbook (note the reverse order)
     * and to the end of the workbook.
+    *
     * @access public
     * @see Spreadsheet_Excel_Writer_Workbook::storeWorkbook()
     * @param array $sheetnames The array of sheetnames from the Workbook this
     *                          worksheet belongs to
     */
     function close($sheetnames)
+    {
         $num_sheets = count($sheetnames);
         /***********************************************
         * Prepend in reverse order!!
         */
         // Prepend the sheet dimensions
-        $this->storeDimensions();
+        $this->_storeDimensions();
         // Prepend the sheet password
         $this->_storePassword();
         // Prepend the sheet protection
         $this->_storeProtect();
         // Prepend the page setup
         $this->_storeSetup();
+        /* FIXME: margins are actually appended */
         // Prepend the bottom margin
         $this->_storeMarginBottom();
         // Prepend the top margin
         $this->_storeMarginTop();
         // Prepend the right margin
         $this->_storeMarginRight();
         // Prepend the left margin
         $this->_storeMarginLeft();
         // Prepend the page vertical centering
         $this->_storeVcenter();
         // Prepend the page horizontal centering
         $this->_storeHcenter();
         // Prepend the page footer
         $this->_storeFooter();
         // Prepend the page header
         $this->_storeHeader();
         // Prepend the vertical page breaks
         $this->_storeVbreak();
         // Prepend the horizontal page breaks
         $this->_storeHbreak();
         // Prepend WSBOOL
         $this->_storeWsbool();
         // Prepend GRIDSET
         $this->_storeGridset();
+         //  Prepend GUTS
+        if ($this->_BIFF_version == 0x0500) {
+            $this->_storeGuts();
+        }
         // Prepend PRINTGRIDLINES
         $this->_storePrintGridlines();
         // Prepend PRINTHEADERS
         $this->_storePrintHeaders();
         // Prepend EXTERNSHEET references
+        if ($this->_BIFF_version == 0x0500) {
-        for ($i = $num_sheets; $i > 0; $i--)
+            for ($i = $num_sheets; $i > 0; $i--) {
-        {
-            $sheetname = $sheetnames[$i-1];
+                $sheetname = $sheetnames[$i-1];
-            $this->_storeExternsheet($sheetname);
+                $this->_storeExternsheet($sheetname);
+            }
+        }
         // Prepend the EXTERNCOUNT of external references.
+        if ($this->_BIFF_version == 0x0500) {
-        $this->_storeExterncount($num_sheets);
+            $this->_storeExterncount($num_sheets);
+        }
         // Prepend the COLINFO records if they exist
-        if (!empty($this->_colinfo))
+        if (!empty($this->_colinfo)) {
-        {
+            $colcount = count($this->_colinfo);
-            for($i=0; $i < count($this->_colinfo); $i++) {
+            for ($i = 0; $i < $colcount; $i++) {
                 $this->_storeColinfo($this->_colinfo[$i]);
+            }
             $this->_storeDefcol();
+        }
         // Prepend the BOF record
         $this->_storeBof(0x0010);
         /*
         * End of prepend. Read upwards from here.
         ***********************************************/
         // Append
         $this->_storeWindow2();
         $this->_storeZoom();
         if (!empty($this->_panes)) {
             $this->_storePanes($this->_panes);
+        }
         $this->_storeSelection($this->_selection);
+        $this->_storeMergedCells();
+        /* TODO: add data validity */
+        /*if ($this->_BIFF_version == 0x0600) {
+            $this->_storeDataValidity();
+        }*/
         $this->_storeEof();
+        if ( $this->_tmp_file != '' ) {
+          if ( $this->_filehandle ) {
+            fclose($this->_filehandle);
+            $this->_filehandle = '';
+          }
+          @unlink($this->_tmp_file);
+          $this->_tmp_file      = '';
+          $this->_using_tmpfile = true;
+        }
+    }
     /**
     * Retrieve the worksheet name.
     * This is usefull when creating worksheets without a name.
+    *
     * @access public
     */
     function getName()
+    {
         return $this->name;
+    }
     /**
     * Retrieves data from memory in one chunk, or from disk in $buffer
     * sized chunks.
+    *
     * @return string The data
     */
     function getData()
+    {
         $buffer = 4096;
         // Return data stored in memory
-        if (isset($this->_data))
+        if (isset($this->_data)) {
-        {
             $tmp   = $this->_data;
             unset($this->_data);
             $fh    = $this->_filehandle;
             if ($this->_using_tmpfile) {
                 fseek($fh, 0);
+            }
-            return($tmp);
+            return $tmp;
+        }
         // Return data stored on disk
-        if ($this->_using_tmpfile)
+        if ($this->_using_tmpfile) {
-        {
             if ($tmp = fread($this->_filehandle, $buffer)) {
-                return($tmp);
+                return $tmp;
+            }
+        }
         // No data to return
-        return('');
+        return '';
+    }
+    /**
+    * Sets a merged cell range
+    *
+    * @access public
+    * @param integer $first_row First row of the area to merge
+    * @param integer $first_col First column of the area to merge
+    * @param integer $last_row  Last row of the area to merge
+    * @param integer $last_col  Last column of the area to merge
+    */
+    function setMerge($first_row, $first_col, $last_row, $last_col)
+    {
+        if (($last_row < $first_row) || ($last_col < $first_col)) {
+            return;
+        }
+        $max_record_ranges = floor(($this->_limit - 6) / 8);
+        if($this->_merged_cells_counter >= $max_record_ranges)
+          {
+            $this->_merged_cells_record++;
+            $this->_merged_cells_counter = 0;
+          }
+        // don't check rowmin, rowmax, etc... because we don't know when this
+        // is going to be called
+        $this->_merged_ranges[$this->_merged_cells_record][] = array($first_row, $first_col, $last_row, $last_col);
+        $this->_merged_cells_counter++;
+    }
     /**
     * Set this worksheet as a selected worksheet,
     * i.e. the worksheet has its tab highlighted.
+    *
     * @access public
     */
     function select()
+    {
         $this->selected = 1;
+    }
     /**
     * Set this worksheet as the active worksheet,
     * i.e. the worksheet that is displayed when the workbook is opened.
     * Also set it as selected.
+    *
     function activate()
+    {
         $this->selected = 1;
         $this->activesheet = $this->index;
+    }
     /**
     * Set this worksheet as the first visible sheet.
     * This is necessary when there are a large number of worksheets and the
     * activated worksheet is not visible on the screen.
+    *
     */
     function setFirstSheet()
+    {
         $this->firstsheet = $this->index;
+    }
     /**
     * Set the worksheet protection flag
     * to prevent accidental modification and to
     * hide formulas if the locked and hidden format properties have been set.
+    *
     function protect($password)
+    {
         $this->_protect   = 1;
         $this->_password  = $this->_encodePassword($password);
+    }
     /**
     * Set the width of a single column or a range of columns.
+    *
     * @access public
     * @param integer $firstcol first column on the range
     * @param integer $lastcol  last column on the range
     * @param integer $width    width to set
     * @param mixed   $format   The optional XF format to apply to the columns
     * @param integer $hidden   The optional hidden atribute
+    * @param integer $level    The optional outline level
     */
-    function setColumn($firstcol, $lastcol, $width, $format = 0, $hidden = 0)
+    function setColumn($firstcol, $lastcol, $width, $format = null, $hidden = 0, $level = 0)
+    { // added by Dan Lynn <dan@spiderweblabs.com) on 2006-12-06
+        // look for any ranges this might overlap and remove, size or split where necessary
+        foreach ($this->_colinfo as $key => $colinfo)
-    {
+        {
+            $existing_start = $colinfo[0]; $existing_end = $colinfo[1];
+            // if the new range starts within another range
+            if ($firstcol > $existing_start && $firstcol < $existing_end)
+            { // trim the existing range to the beginning of the new range
+                $this->_colinfo[$key][1] = $firstcol - 1;
+                // if the new range lies WITHIN the existing range
+                if ($lastcol < $existing_end)
+                { // split the existing range by adding a range after our new range
+                    $this->_colinfo[] = array($lastcol+1, $existing_end, $colinfo[2], &$colinfo[3], $colinfo[4], $colinfo[5]);
+                }
+            } // if the new range ends inside an existing range
+            elseif ($lastcol > $existing_start && $lastcol < $existing_end)
+            { // trim the existing range to the end of the new range
+                $this->_colinfo[$key][0] = $lastcol + 1;
+            } // if the new range completely overlaps the existing range
+            elseif ($firstcol <= $existing_start && $lastcol >= $existing_end)
+            {
+                unset($this->_colinfo[$key]);
+            }
+        } // added by Dan Lynn <dan@spiderweblabs.com) on 2006-12-06
+        // regenerate keys
+        $this->_colinfo = array_values($this->_colinfo);
-        $this->_colinfo[] = array($firstcol, $lastcol, $width, &$format, $hidden);
+        $this->_colinfo[] = array($firstcol, $lastcol, $width, &$format, $hidden, $level);
         // Set width to zero if column is hidden
         $width = ($hidden) ? 0 : $width;
-        for($col = $firstcol; $col <= $lastcol; $col++) {
+        for ($col = $firstcol; $col <= $lastcol; $col++)
+        {
             $this->col_sizes[$col] = $width;
         }
+    }
     /**
     * Set which cell or cells are selected in a worksheet
+    *
     * @access public
     * @param integer $first_row    first row in the selected quadrant
     */
     function setSelection($first_row,$first_column,$last_row,$last_column)
+    {
         $this->_selection = array($first_row,$first_column,$last_row,$last_column);
+    }
     /**
     * Set panes and mark them as frozen.
+    *
     * @access public
     * @param array $panes This is the only parameter received and is composed of the following:
     function freezePanes($panes)
+    {
         $this->_frozen = 1;
         $this->_panes  = $panes;
+    }
     /**
     * Set panes and mark them as unfrozen.
+    *
     * @access public
     * @param array $panes This is the only parameter received and is composed of the following:
     function thawPanes($panes)
+    {
         $this->_frozen = 0;
         $this->_panes  = $panes;
+    }
     /**
     * Set the page orientation as portrait.
+    *
     * @access public
     */
     function setPortrait()
+    {
         $this->_orientation = 1;
+    }
     /**
     * Set the page orientation as landscape.
+    *
     * @access public
     */
     function setLandscape()
+    {
         $this->_orientation = 0;
+    }
     /**
     * Set the paper type. Ex. 1 = US Letter, 9 = A4
+    *
     * @access public
     * @param integer $size The type of paper size to use
     */
     function setPaper($size = 0)
+    {
         $this->_paper_size = $size;
+    }
     /**
     * Set the page header caption and optional margin.
+    *
     * @access public
     * @param string $string The header text
             return;
+        }
         $this->_header      = $string;
         $this->_margin_head = $margin;
+    }
     /**
     * Set the page footer caption and optional margin.
+    *
     * @access public
     * @param string $string The footer text
             return;
+        }
         $this->_footer      = $string;
         $this->_margin_foot = $margin;
+    }
     /**
     * Center the page horinzontally.
+    *
     * @access public
     * @param integer $center the optional value for centering. Defaults to 1 (center).
     */
     function centerHorizontally($center = 1)
+    {
         $this->_hcenter = $center;
+    }
     /**
     * Center the page vertically.
+    *
     * @access public
     * @param integer $center the optional value for centering. Defaults to 1 (center).
     */
     function centerVertically($center = 1)
+    {
         $this->_vcenter = $center;
+    }
     /**
     * Set all the page margins to the same value in inches.
+    *
     * @access public
     * @param float $margin The margin to set in inches
         $this->setMarginLeft($margin);
         $this->setMarginRight($margin);
         $this->setMarginTop($margin);
         $this->setMarginBottom($margin);
+    }
     /**
     * Set the left and right margins to the same value in inches.
+    *
     * @access public
     * @param float $margin The margin to set in inches
     function setMargins_LR($margin)
+    {
         $this->setMarginLeft($margin);
         $this->setMarginRight($margin);
+    }
     /**
     * Set the top and bottom margins to the same value in inches.
+    *
     * @access public
     * @param float $margin The margin to set in inches
     function setMargins_TB($margin)
+    {
         $this->setMarginTop($margin);
         $this->setMarginBottom($margin);
+    }
     /**
     * Set the left margin in inches.
+    *
     * @access public
     * @param float $margin The margin to set in inches
     */
     function setMarginLeft($margin = 0.75)
+    {
         $this->_margin_left = $margin;
+    }
     /**
     * Set the right margin in inches.
+    *
     * @access public
     * @param float $margin The margin to set in inches
     */
     function setMarginRight($margin = 0.75)
+    {
         $this->_margin_right = $margin;
+    }
     /**
     * Set the top margin in inches.
+    *
     * @access public
     * @param float $margin The margin to set in inches
     */
     function setMarginTop($margin = 1.00)
+    {
         $this->_margin_top = $margin;
+    }
     /**
     * Set the bottom margin in inches.
+    *
     * @access public
     * @param float $margin The margin to set in inches
     */
     function setMarginBottom($margin = 1.00)
+    {
         $this->_margin_bottom = $margin;
+    }
     /**
     * Set the rows to repeat at the top of each printed page.
+    *
     * @access public
     * @param integer $first_row First row to repeat
     * @param integer $last_row  Last row to repeat. Optional.
     */
-    function repeatRows($first_row, $last_row = NULL)
+    function repeatRows($first_row, $last_row = null)
+    {
         $this->title_rowmin  = $first_row;
         if (isset($last_row)) { //Second row is optional
             $this->title_rowmax  = $last_row;
-        }
-        else {
+        } else {
             $this->title_rowmax  = $first_row;
+        }
+    }
     /**
     * Set the columns to repeat at the left hand side of each printed page.
+    *
     * @access public
     * @param integer $first_col First column to repeat
     * @param integer $last_col  Last column to repeat. Optional.
     */
-    function repeatColumns($first_col, $last_col = NULL)
+    function repeatColumns($first_col, $last_col = null)
+    {
         $this->title_colmin  = $first_col;
         if (isset($last_col)) { // Second col is optional
             $this->title_colmax  = $last_col;
-        }
-        else {
+        } else {
             $this->title_colmax  = $first_col;
+        }
+    }
     /**
     * Set the area of each worksheet that will be printed.
+    *
     * @access public
     * @param integer $first_row First row of the area to print
         $this->print_rowmin  = $first_row;
         $this->print_colmin  = $first_col;
         $this->print_rowmax  = $last_row;
         $this->print_colmax  = $last_col;
+    }
     /**
     * Set the option to hide gridlines on the printed page.
+    *
     * @access public
     */
     function hideGridlines()
+    {
         $this->_print_gridlines = 0;
+    }
+    /**
+    * Set the option to hide gridlines on the worksheet (as seen on the screen).
+    *
+    * @access public
+    */
+    function hideScreenGridlines()
+    {
+        $this->_screen_gridlines = 0;
+    }
     /**
     * Set the option to print the row and column headers on the printed page.
+    *
     * @access public
     * @param integer $print Whether to print the headers or not. Defaults to 1 (print).
     */
     function printRowColHeaders($print = 1)
+    {
         $this->_print_headers = $print;
+    }
     /**
     * Set the vertical and horizontal number of pages that will define the maximum area printed.
     * It doesn't seem to work with OpenOffice.
+    *
     * @access public
+    {
         $this->_fit_page      = 1;
         $this->_fit_width     = $width;
         $this->_fit_height    = $height;
+    }
     /**
     * Store the horizontal page breaks on a worksheet (for printing).
     * The breaks represent the row after which the break is inserted.
+    *
     * @access public
     * @param array $breaks Array containing the horizontal page breaks
     */
     function setHPagebreaks($breaks)
+    {
-        foreach($breaks as $break) {
+        foreach ($breaks as $break) {
-            array_push($this->_hbreaks,$break);
+            array_push($this->_hbreaks, $break);
+        }
+    }
     /**
     * Store the vertical page breaks on a worksheet (for printing).
     * The breaks represent the column after which the break is inserted.
+    *
     * @access public
     * @param array $breaks Array containing the vertical page breaks
     */
     function setVPagebreaks($breaks)
+    {
-        foreach($breaks as $break) {
+        foreach ($breaks as $break) {
-            array_push($this->_vbreaks,$break);
+            array_push($this->_vbreaks, $break);
+        }
+    }
     /**
     * Set the worksheet zoom factor.
+    *
     * @access public
     * @param integer $scale The zoom factor
     */
     function setZoom($scale = 100)
+    {
         // Confine the scale to Excel's range
-        if ($scale < 10 or $scale > 400)
+        if ($scale < 10 || $scale > 400) {
-        {
             $this->raiseError("Zoom factor $scale outside range: 10 <= zoom <= 400");
             $scale = 100;
+        }
         $this->_zoom = floor($scale);
+    }
     /**
     * Set the scale factor for the printed page.
     * It turns off the "fit to page" option
+    *
     * @access public
     * @param integer $scale The optional scale factor. Defaults to 100
     */
     function setPrintScale($scale = 100)
+    {
         // Confine the scale to Excel's range
-        if ($scale < 10 or $scale > 400)
+        if ($scale < 10 || $scale > 400) {
-        {
             $this->raiseError("Print scale $scale outside range: 10 <= zoom <= 400");
             $scale = 100;
+        }
         // Turn off "fit to page" option
-        $this->_fit_page    = 0;
+        $this->_fit_page = 0;
         $this->_print_scale = floor($scale);
+    }
     /**
     * Map to the appropriate write method acording to the token recieved.
+    *
     * @access public
     * @param integer $row    The row of the cell we are writing to
     * @param integer $col    The column of the cell we are writing to
     * @param mixed   $token  What we are writing
     * @param mixed   $format The optional format to apply to the cell
     */
-    function write($row, $col, $token, $format = 0)
+    function write($row, $col, $token, $format = null)
+    {
         // Check for a cell reference in A1 notation and substitute row and column
         /*if ($_[0] =~ /^\D/) {
             @_ = $this->_substituteCellref(@_);
     }*/
-        // Match number
-        if (preg_match("/^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/",$token)) {
+        if (preg_match("/^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/", $token)) {
+            // Match number
-            return $this->writeNumber($row,$col,$token,$format);
+            return $this->writeNumber($row, $col, $token, $format);
-        }
+        } elseif (preg_match("/^[fh]tt?p:\/\//", $token)) {
-        // Match http or ftp URL
+            // Match http or ftp URL
-        elseif (preg_match("/^[fh]tt?p:\/\//",$token)) {
-            return $this->writeUrl($row, $col, $token, $format);
+            return $this->writeUrl($row, $col, $token, '', $format);
-        }
+        } elseif (preg_match("/^mailto:/", $token)) {
-        // Match mailto:
+            // Match mailto:
-        elseif (preg_match("/^mailto:/",$token)) {
-            return $this->writeUrl($row, $col, $token, $format);
+            return $this->writeUrl($row, $col, $token, '', $format);
-        }
-        // Match internal or external sheet link
+        } elseif (preg_match("/^(?:in|ex)ternal:/", $token)) {
-        elseif (preg_match("/^(?:in|ex)ternal:/",$token)) {
+            // Match internal or external sheet link
-            return $this->writeUrl($row, $col, $token, $format);
+            return $this->writeUrl($row, $col, $token, '', $format);
-        }
-        // Match formula
-        elseif (preg_match("/^=/",$token)) {
+        } elseif (preg_match("/^=/", $token)) {
-            return $this->writeFormula($row, $col, $token, $format);
-        }
-        // Match formula
+            // Match formula
-        elseif (preg_match("/^@/",$token)) {
             return $this->writeFormula($row, $col, $token, $format);
-        }
+        } elseif ($token == '') {
-        // Match blank
+            // Match blank
-        elseif ($token == '') {
-            return $this->writeBlank($row,$col,$format);
+            return $this->writeBlank($row, $col, $format);
-        }
+        } else {
-        // Default: match string
+            // Default: match string
-        else {
-            return $this->writeString($row,$col,$token,$format);
+            return $this->writeString($row, $col, $token, $format);
+        }
+    }
     /**
     * Write an array of values as a row
+    *
     * @access public
-    * @param
+    * @param integer $row    The row we are writing to
+    * @param integer $col    The first col (leftmost col) we are writing to
+    * @param array   $val    The array of values to write
+    * @param mixed   $format The optional format to apply to the cell
-    * @return
+    * @return mixed PEAR_Error on failure
     */
-    function writeRow($row, $col, $val, $format=0)
+    function writeRow($row, $col, $val, $format = null)
+    {
         $retval = '';
         if (is_array($val)) {
-            foreach($val as $v) {
+            foreach ($val as $v) {
                 if (is_array($v)) {
                     $this->writeCol($row, $col, $v, $format);
                 } else {
                     $this->write($row, $col, $v, $format);
         } else {
             $retval = new PEAR_Error('$val needs to be an array');
+        }
         return($retval);
+    }
     /**
     * Write an array of values as a column
+    *
     * @access public
+    * @param integer $row    The first row (uppermost row) we are writing to
-    * @param
+    * @param integer $col    The col we are writing to
+    * @param array   $val    The array of values to write
+    * @param mixed   $format The optional format to apply to the cell
-    * @return
+    * @return mixed PEAR_Error on failure
     */
-    function writeCol($row, $col, $val, $format=0)
+    function writeCol($row, $col, $val, $format = null)
+    {
+        $retval = '';
         if (is_array($val)) {
-            foreach($val as $v) {
+            foreach ($val as $v) {
                 $this->write($row, $col, $v, $format);
                 $row++;
+            }
         } else {
             $retval = new PEAR_Error('$val needs to be an array');
+        }
         return($retval);
+    }
     /**
     * Returns an index to the XF record in the workbook
+    *
     * @access private
     * @param mixed &$format The optional XF format
     * @return integer The XF record index
     */
     function _XF(&$format)
+    {
-        if ($format != 0) {
+        if ($format) {
             return($format->getXfIndex());
-        }
-        else {
+        } else {
             return(0x0F);
+        }
+    }
     /******************************************************************************
     *******************************************************************************
+    *
     * Internal methods
     */
     /**
     * Store Worksheet data in memory using the parent's class append() or to a
     * temporary file, the default.
+    *
     * @access private
     * @param string $data The binary data to append
     */
     function _append($data)
+    {
-        if ($this->_using_tmpfile)
+        if ($this->_using_tmpfile) {
-        {
             // Add CONTINUE records if necessary
             if (strlen($data) > $this->_limit) {
                 $data = $this->_addContinue($data);
+            }
-            fwrite($this->_filehandle,$data);
+            fwrite($this->_filehandle, $data);
             $this->_datasize += strlen($data);
-        }
-        else {
+        } else {
             parent::_append($data);
+        }
+    }
     /**
     * Substitute an Excel cell reference in A1 notation for  zero based row and
     * column values in an argument list.
+    *
     * Ex: ("A4", "Hello") is converted to (3, 0, "Hello").
     * @return array
     */
     function _substituteCellref($cell)
+    {
         $cell = strtoupper($cell);
         // Convert a column range: 'A:A' or 'B:G'
-        if (preg_match("/([A-I]?[A-Z]):([A-I]?[A-Z])/",$cell,$match)) {
+        if (preg_match("/([A-I]?[A-Z]):([A-I]?[A-Z])/", $cell, $match)) {
             list($no_use, $col1) =  $this->_cellToRowcol($match[1] .'1'); // Add a dummy row
             list($no_use, $col2) =  $this->_cellToRowcol($match[2] .'1'); // Add a dummy row
             return(array($col1, $col2));
+        }
         // Convert a cell range: 'A1:B7'
-        if (preg_match("/\$?([A-I]?[A-Z]\$?\d+):\$?([A-I]?[A-Z]\$?\d+)/",$cell,$match)) {
+        if (preg_match("/\$?([A-I]?[A-Z]\$?\d+):\$?([A-I]?[A-Z]\$?\d+)/", $cell, $match)) {
             list($row1, $col1) =  $this->_cellToRowcol($match[1]);
             list($row2, $col2) =  $this->_cellToRowcol($match[2]);
             return(array($row1, $col1, $row2, $col2));
+        }
         // Convert a cell reference: 'A1' or 'AD2000'
-        if (preg_match("/\$?([A-I]?[A-Z]\$?\d+)/",$cell)) {
+        if (preg_match("/\$?([A-I]?[A-Z]\$?\d+)/", $cell)) {
             list($row1, $col1) =  $this->_cellToRowcol($match[1]);
             return(array($row1, $col1));
+        }
         // TODO use real error codes
         $this->raiseError("Unknown cell reference $cell", 0, PEAR_ERROR_DIE);
+    }
     /**
     * Convert an Excel cell reference in A1 notation to a zero based row and column
     * reference; converts C1 to (0, 2).
+    *
     * @access private
     function _cellToRowcol($cell)
+    {
         preg_match("/\$?([A-I]?[A-Z])\$?(\d+)/",$cell,$match);
         $col     = $match[1];
         $row     = $match[2];
         // Convert base26 column string to number
         $chars = explode('', $col);
         $expn  = 0;
         $col   = 0;
         while ($chars) {
             $char = array_pop($chars);        // LS char first
             $col += (ord($char) -ord('A') +1) * pow(26,$expn);
             $expn++;
+        }
         // Convert 1-index to zero-index
         $row--;
         $col--;
         return(array($row, $col));
+    }
     /**
     * Based on the algorithm provided by Daniel Rentz of OpenOffice.
+    *
     * @access private
     * @param string $plaintext The password to be encoded in plaintext.
     */
     function _encodePassword($plaintext)
+    {
         $password = 0x0000;
         $i        = 1;       // char position
         // split the plain text password in its component characters
         $chars = preg_split('//', $plaintext, -1, PREG_SPLIT_NO_EMPTY);
-        foreach($chars as $char)
+        foreach ($chars as $char) {
-        {
             $value        = ord($char) << $i;   // shifted ASCII value
             $rotated_bits = $value >> 15;       // rotated bits beyond bit 15
             $value       &= 0x7fff;             // first 15 bits
             $password    ^= ($value | $rotated_bits);
             $i++;
+        }
         $password ^= strlen($plaintext);
         $password ^= 0xCE4B;
         return($password);
+    }
+    /**
+    * This method sets the properties for outlining and grouping. The defaults
+    * correspond to Excel's defaults.
+    *
+    * @param bool $visible
+    * @param bool $symbols_below
+    * @param bool $symbols_right
+    * @param bool $auto_style
+    */
+    function setOutline($visible = true, $symbols_below = true, $symbols_right = true, $auto_style = false)
+    {
+        $this->_outline_on    = $visible;
+        $this->_outline_below = $symbols_below;
-    }
+        $this->_outline_right = $symbols_right;
+        $this->_outline_style = $auto_style;
+        // Ensure this is a boolean vale for Window2
+        if ($this->_outline_on) {
+            $this->_outline_on = 1;
+        }
+     }
+    /**
+    * This method sets the worksheet direction to right-to-left (RTL)
+    *
+    * @param bool $rtl
+    */
+    function setRTL($rtl = true)
+    {
+        $this->_Arabic = ($rtl ? 1 : 0);
+     }
     /******************************************************************************
     *******************************************************************************
+    *
     * BIFF RECORDS
     */
     /**
     * Write a double to the specified row and column (zero indexed).
     * An integer can be written as a double. Excel will display an
     * @param integer $col    Zero indexed column
     * @param float   $num    The number to write
     * @param mixed   $format The optional XF format
     * @return integer
     */
-    function writeNumber($row, $col, $num, $format = 0)
+    function writeNumber($row, $col, $num, $format = null)
+    {
         $record    = 0x0203;                 // Record identifier
         $length    = 0x000E;                 // Number of bytes to follow
         $xf        = $this->_XF($format);    // The cell format
         // Check that row and col are valid and store max and min values
-        if ($row >= $this->_xls_rowmax)
+        if ($row >= $this->_xls_rowmax) {
-        {
             return(-2);
+        }
-        if ($col >= $this->_xls_colmax)
+        if ($col >= $this->_xls_colmax) {
-        {
             return(-2);
+        }
-        if ($row <  $this->_dim_rowmin)
+        if ($row <  $this->_dim_rowmin)  {
-        {
             $this->_dim_rowmin = $row;
+        }
-        if ($row >  $this->_dim_rowmax)
+        if ($row >  $this->_dim_rowmax)  {
-        {
             $this->_dim_rowmax = $row;
+        }
-        if ($col <  $this->_dim_colmin)
+        if ($col <  $this->_dim_colmin)  {
-        {
             $this->_dim_colmin = $col;
+        }
-        if ($col >  $this->_dim_colmax)
+        if ($col >  $this->_dim_colmax)  {
-        {
             $this->_dim_colmax = $col;
+        }
         $header    = pack("vv",  $record, $length);
         $data      = pack("vvv", $row, $col, $xf);
         $xl_double = pack("d",   $num);
-        if ($this->_byte_order) // if it's Big Endian
+        if ($this->_byte_order) { // if it's Big Endian
-        {
             $xl_double = strrev($xl_double);
+        }
         $this->_append($header.$data.$xl_double);
         return(0);
+    }
     /**
     * Write a string to the specified row and column (zero indexed).
     * NOTE: there is an Excel 5 defined limit of 255 characters.
     * $format is optional.
     * Returns  0 : normal termination
     * @param integer $col    Zero indexed column
     * @param string  $str    The string to write
     * @param mixed   $format The XF format for the cell
     * @return integer
     */
-    function writeString($row, $col, $str, $format = 0)
+    function writeString($row, $col, $str, $format = null)
+    {
+        if ($this->_BIFF_version == 0x0600) {
+            return $this->writeStringBIFF8($row, $col, $str, $format);
+        }
         $strlen    = strlen($str);
         $record    = 0x0204;                   // Record identifier
         $length    = 0x0008 + $strlen;         // Bytes to follow
         $xf        = $this->_XF($format);      // The cell format
         $str_error = 0;
         // Check that row and col are valid and store max and min values
-        if ($row >= $this->_xls_rowmax)
+        if ($row >= $this->_xls_rowmax) {
-        {
             return(-2);
+        }
-        if ($col >= $this->_xls_colmax)
+        if ($col >= $this->_xls_colmax) {
-        {
             return(-2);
+        }
-        if ($row <  $this->_dim_rowmin)
+        if ($row <  $this->_dim_rowmin) {
-        {
             $this->_dim_rowmin = $row;
+        }
-        if ($row >  $this->_dim_rowmax)
+        if ($row >  $this->_dim_rowmax) {
-        {
             $this->_dim_rowmax = $row;
+        }
-        if ($col <  $this->_dim_colmin)
+        if ($col <  $this->_dim_colmin) {
-        {
             $this->_dim_colmin = $col;
+        }
-        if ($col >  $this->_dim_colmax)
+        if ($col >  $this->_dim_colmax) {
-        {
             $this->_dim_colmax = $col;
+        }
-        if ($strlen > $this->_xls_strmax)  // LABEL must be < 255 chars
+        if ($strlen > $this->_xls_strmax) { // LABEL must be < 255 chars
-        {
             $str       = substr($str, 0, $this->_xls_strmax);
             $length    = 0x0008 + $this->_xls_strmax;
             $strlen    = $this->_xls_strmax;
             $str_error = -3;
+        }
         $header    = pack("vv",   $record, $length);
         $data      = pack("vvvv", $row, $col, $xf, $strlen);
-        $this->_append($header.$data.$str);
+        $this->_append($header . $data . $str);
         return($str_error);
+    }
+    /**
+    * Sets Input Encoding for writing strings
+    *
+    * @access public
+    * @param string $encoding The encoding. Ex: 'UTF-16LE', 'utf-8', 'ISO-859-7'
+    */
+    function setInputEncoding($encoding)
+    {
+         if ($encoding != 'UTF-16LE' && !function_exists('iconv')) {
+             $this->raiseError("Using an input encoding other than UTF-16LE requires PHP support for iconv");
+         }
+         $this->_input_encoding = $encoding;
+    }
+    /**
+    * Write a string to the specified row and column (zero indexed).
+    * This is the BIFF8 version (no 255 chars limit).
+    * $format is optional.
+    * Returns  0 : normal termination
+    *         -2 : row or column out of range
+    *         -3 : long string truncated to 255 chars
+    *
+    * @access public
+    * @param integer $row    Zero indexed row
+    * @param integer $col    Zero indexed column
+    * @param string  $str    The string to write
+    * @param mixed   $format The XF format for the cell
+    * @return integer
+    */
+    function writeStringBIFF8($row, $col, $str, $format = null)
+    {
+        if ($this->_input_encoding == 'UTF-16LE')
+        {
+            $strlen = function_exists('mb_strlen') ? mb_strlen($str, 'UTF-16LE') : (strlen($str) / 2);
+            $encoding  = 0x1;
+        }
+        elseif ($this->_input_encoding != '')
+        {
+            $str = iconv($this->_input_encoding, 'UTF-16LE', $str);
+            $strlen = function_exists('mb_strlen') ? mb_strlen($str, 'UTF-16LE') : (strlen($str) / 2);
+            $encoding  = 0x1;
+        }
+        else
+        {
+            $strlen    = strlen($str);
+            $encoding  = 0x0;
+        }
+        $record    = 0x00FD;                   // Record identifier
+        $length    = 0x000A;                   // Bytes to follow
+        $xf        = $this->_XF($format);      // The cell format
+        $str_error = 0;
+        // Check that row and col are valid and store max and min values
+        if ($this->_checkRowCol($row, $col) == false) {
+            return -2;
+        }
+        $str = pack('vC', $strlen, $encoding).$str;
+        /* check if string is already present */
+        if (!isset($this->_str_table[$str])) {
+            $this->_str_table[$str] = $this->_str_unique++;
+        }
+        $this->_str_total++;
+        $header    = pack('vv',   $record, $length);
+        $data      = pack('vvvV', $row, $col, $xf, $this->_str_table[$str]);
+        $this->_append($header.$data);
+        return $str_error;
+    }
+    /**
+    * Check row and col before writing to a cell, and update the sheet's
+    * dimensions accordingly
+    *
+    * @access private
+    * @param integer $row    Zero indexed row
+    * @param integer $col    Zero indexed column
+    * @return boolean true for success, false if row and/or col are grester
+    *                 then maximums allowed.
+    */
+    function _checkRowCol($row, $col)
+    {
+        if ($row >= $this->_xls_rowmax) {
+            return false;
+        }
+        if ($col >= $this->_xls_colmax) {
+            return false;
+        }
+        if ($row <  $this->_dim_rowmin) {
+            $this->_dim_rowmin = $row;
+        }
+        if ($row >  $this->_dim_rowmax) {
+            $this->_dim_rowmax = $row;
+        }
+        if ($col <  $this->_dim_colmin) {
+            $this->_dim_colmin = $col;
+        }
+        if ($col >  $this->_dim_colmax) {
+            $this->_dim_colmax = $col;
+        }
+        return true;
+    }
     /**
     * Writes a note associated with the cell given by the row and column.
     * NOTE records don't have a length limit.
+    *
     * @access public
         $record         = 0x001C;                // Record identifier
         $max_length     = 2048;                  // Maximun length for a NOTE record
         //$length      = 0x0006 + $note_length;    // Bytes to follow
         // Check that row and col are valid and store max and min values
-        if ($row >= $this->_xls_rowmax)
         if ($row >= $this->_xls_rowmax) {
             return(-2);
         }
-        if ($col >= $this->_xls_colmax)
         if ($col >= $this->_xls_colmax) {
             return(-2);
         }
-        if ($row <  $this->_dim_rowmin)
         if ($row <  $this->_dim_rowmin) {
             $this->_dim_rowmin = $row;
         }
-        if ($row >  $this->_dim_rowmax)
         if ($row >  $this->_dim_rowmax) {
             $this->_dim_rowmax = $row;
         }
-        if ($col <  $this->_dim_colmin)
         if ($col <  $this->_dim_colmin) {
             $this->_dim_colmin = $col;
         }
-        if ($col >  $this->_dim_colmax)
         if ($col >  $this->_dim_colmax) {
             $this->_dim_colmax = $col;
         }
         // Length for this record is no more than 2048 + 6
         $length    = 0x0006 + min($note_length, 2048);
         $header    = pack("vv",   $record, $length);
         $data      = pack("vvv", $row, $col, $note_length);
-        $this->_append($header.$data.substr($note, 0, 2048));
+        $this->_append($header . $data . substr($note, 0, 2048));
         for($i = $max_length; $i < $note_length; $i += $max_length)
         for ($i = $max_length; $i < $note_length; $i += $max_length) {
             $chunk  = substr($note, $i, $max_length);
             $length = 0x0006 + strlen($chunk);
             $header = pack("vv",   $record, $length);
     * @param mixed   $format The XF format
     */
     function writeBlank($row, $col, $format)
+    {
         // Don't write a blank cell unless it has a format
-        if ($format == 0)
+        if (!$format) {
-        {
             return(0);
+        }
         $record    = 0x0201;                 // Record identifier
         $length    = 0x0006;                 // Number of bytes to follow
         $xf        = $this->_XF($format);    // The cell format
         // Check that row and col are valid and store max and min values
-        if ($row >= $this->_xls_rowmax)
+        if ($row >= $this->_xls_rowmax) {
-        {
             return(-2);
+        }
-        if ($col >= $this->_xls_colmax)
+        if ($col >= $this->_xls_colmax) {
-        {
             return(-2);
+        }
-        if ($row <  $this->_dim_rowmin)
+        if ($row <  $this->_dim_rowmin) {
-        {
             $this->_dim_rowmin = $row;
+        }
-        if ($row >  $this->_dim_rowmax)
+        if ($row >  $this->_dim_rowmax) {
-        {
             $this->_dim_rowmax = $row;
+        }
-        if ($col <  $this->_dim_colmin)
+        if ($col <  $this->_dim_colmin) {
-        {
             $this->_dim_colmin = $col;
+        }
-        if ($col >  $this->_dim_colmax)
+        if ($col >  $this->_dim_colmax) {
-        {
             $this->_dim_colmax = $col;
+        }
         $header    = pack("vv",  $record, $length);
         $data      = pack("vvv", $row, $col, $xf);
-        $this->_append($header.$data);
+        $this->_append($header . $data);
         return 0;
+    }
     /**
     * @param integer $col     Zero indexed column
     * @param string  $formula The formula text string
     * @param mixed   $format  The optional XF format
     * @return integer
     */
-    function writeFormula($row, $col, $formula, $format = 0)
+    function writeFormula($row, $col, $formula, $format = null)
+    {
         $record    = 0x0006;     // Record identifier
         // Excel normally stores the last calculated value of the formula in $num.
         // Clearly we are not in a position to calculate this a priori. Instead
         // we set $num to zero and set the option flags in $grbit to ensure
         // automatic calculation of the formula when the file is opened.
         //
         $xf        = $this->_XF($format); // The cell format
         $num       = 0x00;                // Current value of formula
         $grbit     = 0x03;                // Option flags
-        $chn       = 0x0000;              // Must be zero
+        $unknown   = 0x0000;              // Must be zero
         // Check that row and col are valid and store max and min values
-        if ($row >= $this->_xls_rowmax)
+        if ($this->_checkRowCol($row, $col) == false) {
-        {
-            return(-2);
+            return -2;
+        }
-        if ($col >= $this->_xls_colmax)
-        {
-            return(-2);
-        }
-        if ($row <  $this->_dim_rowmin)
-        {
-            $this->_dim_rowmin = $row;
-        }
-        if ($row >  $this->_dim_rowmax)
-        {
-            $this->_dim_rowmax = $row;
-        }
-        if ($col <  $this->_dim_colmin)
-        {
-            $this->_dim_colmin = $col;
-        }
-        if ($col >  $this->_dim_colmax)
-        {
-            $this->_dim_colmax = $col;
-        }
         // Strip the '=' or '@' sign at the beginning of the formula string
-        if (preg_match("/^=/",$formula)) {
+        if (preg_match("/^=/", $formula)) {
-            $formula = preg_replace("/(^=)/","",$formula);
+            $formula = preg_replace("/(^=)/", "", $formula);
-        }
-        elseif (preg_match("/^@/",$formula)) {
+        } elseif (preg_match("/^@/", $formula)) {
-            $formula = preg_replace("/(^@)/","",$formula);
+            $formula = preg_replace("/(^@)/", "", $formula);
-        }
-        else
+        } else {
-        {
             // Error handling
             $this->writeString($row, $col, 'Unrecognised character for formula');
             return -1;
+        }
         // Parse the formula using the parser in Parser.php
         $error = $this->_parser->parse($formula);
-        if ($this->isError($error))
+        if ($this->isError($error)) {
-        {
             $this->writeString($row, $col, $error->getMessage());
             return -1;
+        }
         $formula = $this->_parser->toReversePolish();
-        if ($this->isError($formula))
+        if ($this->isError($formula)) {
-        {
             $this->writeString($row, $col, $formula->getMessage());
             return -1;
+        }
         $formlen    = strlen($formula);    // Length of the binary string
         $length     = 0x16 + $formlen;     // Length of the record data
         $header    = pack("vv",      $record, $length);
         $data      = pack("vvvdvVv", $row, $col, $xf, $num,
-                                     $grbit, $chn, $formlen);
+                                     $grbit, $unknown, $formlen);
-        $this->_append($header.$data.$formula);
+        $this->_append($header . $data . $formula);
         return 0;
+    }
     /**
     * Write a hyperlink.
     * This is comprised of two elements: the visible label and
     * the invisible link. The visible label is the same as the link unless an
     * alternative string is specified. The label is written using the
     * @param string  $url    URL string
     * @param string  $string Alternative label
     * @param mixed   $format The cell format
     * @return integer
     */
-    function writeUrl($row, $col, $url, $string = '', $format = 0)
+    function writeUrl($row, $col, $url, $string = '', $format = null)
+    {
         // Add start row and col to arg list
-        return($this->_writeUrl_range($row, $col, $row, $col, $url, $string, $format));
+        return($this->_writeUrlRange($row, $col, $row, $col, $url, $string, $format));
+    }
     /**
     * This is the more general form of writeUrl(). It allows a hyperlink to be
     * written to a range of cells. This function also decides the type of hyperlink
     * to be written. These are either, Web (http, ftp, mailto), Internal
     * (Sheet1!A1) or external ('c:\temp\foo.xls#Sheet1!A1').
     * @param string  $url    URL string
     * @param string  $string Alternative label
     * @param mixed   $format The cell format
     * @return integer
     */
-    function _writeUrl_range($row1, $col1, $row2, $col2, $url, $string = '', $format = 0)
+    function _writeUrlRange($row1, $col1, $row2, $col2, $url, $string = '', $format = null)
+    {
         // Check for internal/external sheet links or default to web link
         if (preg_match('[^internal:]', $url)) {
             return($this->_writeUrlInternal($row1, $col1, $row2, $col2, $url, $string, $format));
+        }
         if (preg_match('[^external:]', $url)) {
             return($this->_writeUrlExternal($row1, $col1, $row2, $col2, $url, $string, $format));
+        }
         return($this->_writeUrlWeb($row1, $col1, $row2, $col2, $url, $string, $format));
+    }
     /**
     * Used to write http, ftp and mailto hyperlinks.
     * The link type ($options) is 0x03 is the same as absolute dir ref without
     * sheet. However it is differentiated by the $unknown2 data stream.
+    *
     * @param string  $url    URL string
     * @param string  $str    Alternative label
     * @param mixed   $format The cell format
     * @return integer
     */
-    function _writeUrlWeb($row1, $col1, $row2, $col2, $url, $str, $format = 0)
+    function _writeUrlWeb($row1, $col1, $row2, $col2, $url, $str, $format = null)
+    {
         $record      = 0x01B8;                       // Record identifier
         $length      = 0x00000;                      // Bytes to follow
-        if ($format == 0) {
+        if (!$format) {
             $format = $this->_url_format;
+        }
         // Write the visible label using the writeString() method.
         if ($str == '') {
             $str = $url;
+        }
-        $str_error = $this->writeString($row1, $col1, $str, $format);
+        $str_error = is_numeric($str) ? $this->writeNumber($row1, $col1, $str, $format) : $this->writeString($row1, $col1, $str, $format);
-        if (($str_error == -2) or ($str_error == -3)) {
+        if (($str_error == -2) || ($str_error == -3)) {
             return $str_error;
+        }
         // Pack the undocumented parts of the hyperlink stream
         $unknown1    = pack("H*", "D0C9EA79F9BACE118C8200AA004BA90B02000000");
         $unknown2    = pack("H*", "E0C9EA79F9BACE118C8200AA004BA90B");
         // Pack the option flags
         $options     = pack("V", 0x03);
         // Convert URL to a null terminated wchar string
         $url         = join("\0", preg_split("''", $url, -1, PREG_SPLIT_NO_EMPTY));
         $url         = $url . "\0\0\0";
         // Pack the length of the URL
         $url_len     = pack("V", strlen($url));
         // Calculate the data length
         $length      = 0x34 + strlen($url);
         // Pack the header data
         $header      = pack("vv",   $record, $length);
         $data        = pack("vvvv", $row1, $row2, $col1, $col2);
         // Write the packed data
-        $this->_append( $header. $data.
+        $this->_append($header . $data .
-                        $unknown1. $options.
+                       $unknown1 . $options .
-                        $unknown2. $url_len. $url);
+                       $unknown2 . $url_len . $url);
         return($str_error);
+    }
     /**
     * Used to write internal reference hyperlinks such as "Sheet1!A1".
+    *
     * @access private
     * @see writeUrl()
     * @param string  $url    URL string
     * @param string  $str    Alternative label
     * @param mixed   $format The cell format
     * @return integer
     */
-    function _writeUrlInternal($row1, $col1, $row2, $col2, $url, $str, $format = 0)
+    function _writeUrlInternal($row1, $col1, $row2, $col2, $url, $str, $format = null)
+    {
         $record      = 0x01B8;                       // Record identifier
         $length      = 0x00000;                      // Bytes to follow
-        if ($format == 0) {
+        if (!$format) {
             $format = $this->_url_format;
+        }
         // Strip URL type
-        $url = preg_replace('s[^internal:]', '', $url);
+        $url = preg_replace('/^internal:/', '', $url);
         // Write the visible label
         if ($str == '') {
             $str = $url;
+        }
-        $str_error = $this->writeString($row1, $col1, $str, $format);
+        $str_error = is_numeric($str) ? $this->writeNumber($row1, $col1, $str, $format) : $this->writeString($row1, $col1, $str, $format);
-        if (($str_error == -2) or ($str_error == -3)) {
+        if (($str_error == -2) || ($str_error == -3)) {
             return $str_error;
+        }
         // Pack the undocumented parts of the hyperlink stream
         $unknown1    = pack("H*", "D0C9EA79F9BACE118C8200AA004BA90B02000000");
         // Pack the option flags
         $options     = pack("V", 0x08);
         // Convert the URL type and to a null terminated wchar string
         $url         = join("\0", preg_split("''", $url, -1, PREG_SPLIT_NO_EMPTY));
         $url         = $url . "\0\0\0";
         // Pack the length of the URL as chars (not wchars)
         $url_len     = pack("V", floor(strlen($url)/2));
         // Calculate the data length
         $length      = 0x24 + strlen($url);
         // Pack the header data
         $header      = pack("vv",   $record, $length);
         $data        = pack("vvvv", $row1, $row2, $col1, $col2);
         // Write the packed data
-        $this->_append($header. $data.
+        $this->_append($header . $data .
-                       $unknown1. $options.
+                       $unknown1 . $options .
-                       $url_len. $url);
+                       $url_len . $url);
         return($str_error);
+    }
     /**
     * Write links to external directory names such as 'c:\foo.xls',
     * c:\foo.xls#Sheet1!A1', '../../foo.xls'. and '../../foo.xls#Sheet1!A1'.
+    *
     * Note: Excel writes some relative links with the $dir_long string. We ignore
     * @param string  $url    URL string
     * @param string  $str    Alternative label
     * @param mixed   $format The cell format
     * @return integer
     */
-    function _writeUrlExternal($row1, $col1, $row2, $col2, $url, $str, $format = 0)
+    function _writeUrlExternal($row1, $col1, $row2, $col2, $url, $str, $format = null)
+    {
         // Network drives are different. We will handle them separately
         // MS/Novell network drives and shares start with \\
         if (preg_match('[^external:\\\\]', $url)) {
             return; //($this->_writeUrlExternal_net($row1, $col1, $row2, $col2, $url, $str, $format));
+        }
         $record      = 0x01B8;                       // Record identifier
         $length      = 0x00000;                      // Bytes to follow
-        if ($format == 0) {
+        if (!$format) {
             $format = $this->_url_format;
+        }
         // Strip URL type and change Unix dir separator to Dos style (if needed)
         //
-        $url = preg_replace('[^external:]', '', $url);
+        $url = preg_replace('/^external:/', '', $url);
-        $url = preg_replace('[/]', "\\", $url);
+        $url = preg_replace('/\//', "\\", $url);
         // Write the visible label
         if ($str == '') {
-            $str = preg_replace('[\#]', ' - ', $url);
+            $str = preg_replace('/\#/', ' - ', $url);
+        }
-        $str_error = $this->writeString($row1, $col1, $str, $format);
+        $str_error = is_numeric($str) ? $this->writeNumber($row1, $col1, $str, $format) : $this->writeString($row1, $col1, $str, $format);
         if (($str_error == -2) or ($str_error == -3)) {
             return $str_error;
+        }
         // Determine if the link is relative or absolute:
         //   relative if link contains no dir separator, "somefile.xls"
         //   relative if link starts with up-dir, "..\..\somefile.xls"
         //   otherwise, absolute
         $absolute    = 0x02; // Bit mask
+        if (!preg_match("/\\\/", $url)) {
-        if (!preg_match('[\\]', $url)) {
+            $absolute    = 0x00;
             $absolute    = 0x00;
         if (preg_match("/^\.\.\\\/", $url)) {
+            $absolute    = 0x00;
-        if (preg_match('[^\.\.\\]', $url)) {
+        }
+        $link_type               = 0x01 | $absolute;
-            $absolute    = 0x00;
+        // Determine if the link contains a sheet reference and change some of the
         // parameters accordingly.
         // Split the dir name and sheet name (if it exists)
-        // Determine if the link contains a sheet reference and change some of the
+        /*if (preg_match("/\#/", $url)) {
-        // parameters accordingly.
+            list($dir_long, $sheet) = split("\#", $url);
-        // Split the dir name and sheet name (if it exists)
+        } else {
-        list($dir_long , $sheet) = explode('/\#/', $url);
-        $link_type               = 0x01 | $absolute;
+            $dir_long = $url;
+        }
         if (isset($sheet)) {
+        if (isset($sheet)) {
+            $link_type |= 0x08;
+            $sheet_len  = pack("V", strlen($sheet) + 0x01);
+            $sheet      = join("\0", split('', $sheet));
-            $link_type |= 0x08;
+            $sheet     .= "\0\0\0";
+        } else {
+            $sheet_len   = '';
-            $sheet_len  = pack("V", strlen($sheet) + 0x01);
+            $sheet       = '';
-            $sheet      = join("\0", explode('', $sheet));
+        }*/
-            $sheet     .= "\0\0\0";
+        $dir_long = $url;
-        }
+        if (preg_match("/\#/", $url)) {
-        else {
+            $link_type |= 0x08;
             $sheet_len   = '';
-            $sheet       = '';
         // Pack the link type
         $link_type   = pack("V", $link_type);
         // Calculate the up-level dir count e.g.. (..\..\..\ == 3)
-        $up_count    = preg_match_all("/\.\.\\/", $dir_long, $useless);
+        $up_count    = preg_match_all("/\.\.\\\/", $dir_long, $useless);
         $up_count    = pack("v", $up_count);
         // Store the short dos dir name (null terminated)
-        $dir_short   = preg_replace('/\.\.\\/', '', $dir_long) . "\0";
+        $dir_short   = preg_replace("/\.\.\\\/", '', $dir_long) . "\0";
                           $unknown2     .
                           $up_count     .
                           $dir_short_len.
                           $dir_short    .
                           $unknown3     .
-                          $stream_len   .
+                          $stream_len   ;/*.
                           $dir_long_len .
                           $unknown4     .
                           $dir_long     .
                           $sheet_len    .
-                          $sheet        ;
+                          $sheet        ;*/
         // Pack the header data
         $length   = strlen($data);
         $header   = pack("vv", $record, $length);
         // Write the packed data
         $this->_append($header. $data);
         return($str_error);
     }
     /**
     * This method is used to set the height and format for a row.
+    *
     * @access public
     * @param integer $row    The row to set
     * @param integer $height Height we are giving to the row.
+    *                        Use null to set XF without setting height
+    * @param mixed   $format XF format we are giving to the row
-    *                        Use NULL to set XF without setting height
+    * @param bool    $hidden The optional hidden attribute
-    * @param mixed   $format XF format we are giving to the row
+    * @param integer $level  The optional outline level for row, in range [0,7]
     */
-    function setRow($row, $height, $format = 0)
+    function setRow($row, $height, $format = null, $hidden = false, $level = 0)
+    {
         $record      = 0x0208;               // Record identifier
         $length      = 0x0010;               // Number of bytes to follow
         $colMic      = 0x0000;               // First defined column
         $colMac      = 0x0000;               // Last defined column
         $irwMac      = 0x0000;               // Used by Excel to optimise loading
         $reserved    = 0x0000;               // Reserved
-        $grbit       = 0x01C0;               // Option flags. (monkey) see $1 do
+        $grbit       = 0x0000;               // Option flags
+        $ixfe        = $this->_XF($format);  // XF index
+        // set _row_sizes so _sizeRow() can use it
-        $ixfe        = $this->_XF($format);  // XF index
+        $this->_row_sizes[$row] = $height;
-        // Use setRow($row, NULL, $XF) to set XF format without setting height
+        // Use setRow($row, null, $XF) to set XF format without setting height
-        if ($height != NULL) {
-            $miyRw = $height * 20;  // row height
+        if ($height != null) {
             $miyRw = $height * 20;  // row height
-        else {
+        } else {
             $miyRw = 0xff;          // default row height is 256
+        }
+        $level = max(0, min($level, 7));  // level should be between 0 and 7
+        $this->_outline_row_level = max($level, $this->_outline_row_level);
+        // Set the options flags. fUnsynced is used to show that the font and row
+        // heights are not compatible. This is usually the case for WriteExcel.
+        // The collapsed flag 0x10 doesn't seem to be used to indicate that a row
+        // is collapsed. Instead it is used to indicate that the previous row is
+        // collapsed. The zero height flag, 0x20, is used to collapse a row.
+        $grbit |= $level;
+        if ($hidden) {
+            $grbit |= 0x0020;
+        }
+        $grbit |= 0x0040; // fUnsynced
+        if ($format) {
+            $grbit |= 0x0080;
+        }
         $grbit |= 0x0100;
         $header   = pack("vv",       $record, $length);
         $data     = pack("vvvvvvvv", $row, $colMic, $colMac, $miyRw,
                                      $irwMac,$reserved, $grbit, $ixfe);
         $this->_append($header.$data);
+    }
     /**
     * Writes Excel DIMENSIONS to define the area in which there is data.
+    *
     * @access private
     */
-    function storeDimensions()
+    function _storeDimensions()
-    {
-        $record    = 0x0000;               // Record identifier
+    {
-        $length    = 0x000A;               // Number of bytes to follow
+        $record    = 0x0200;                 // Record identifier
-        $row_min   = $this->_dim_rowmin;   // First row
+        $row_min   = $this->_dim_rowmin;     // First row
-        $row_max   = $this->_dim_rowmax;   // Last row plus 1
+        $row_max   = $this->_dim_rowmax + 1; // Last row plus 1
-        $col_min   = $this->_dim_colmin;   // First column
+        $col_min   = $this->_dim_colmin;     // First column
-        $col_max   = $this->_dim_colmax;   // Last column plus 1
+        $col_max   = $this->_dim_colmax + 1; // Last column plus 1
+        $reserved  = 0x0000;                 // Reserved by Excel
-        $reserved  = 0x0000;               // Reserved by Excel
+        if ($this->_BIFF_version == 0x0500) {
+            $length    = 0x000A;               // Number of bytes to follow
+            $data      = pack("vvvvv", $row_min, $row_max,
+                                       $col_min, $col_max, $reserved);
+        } elseif ($this->_BIFF_version == 0x0600) {
-        $header    = pack("vv",    $record, $length);
+            $length    = 0x000E;
+            $data      = pack("VVvvv", $row_min, $row_max,
+                                       $col_min, $col_max, $reserved);
         $data      = pack("vvvvv", $row_min, $row_max,
-                                   $col_min, $col_max, $reserved);
+        $header = pack("vv", $record, $length);
         $this->_prepend($header.$data);
+    }
     /**
     * Write BIFF record Window2.
+    *
     * @access private
     */
     function _storeWindow2()
+    {
-    {
+        $record         = 0x023E;     // Record identifier
+        if ($this->_BIFF_version == 0x0500) {
+            $length         = 0x000A;     // Number of bytes to follow
+        } elseif ($this->_BIFF_version == 0x0600) {
-        $record         = 0x023E;     // Record identifier
+            $length         = 0x0012;
         $length         = 0x000A;     // Number of bytes to follow
         $grbit          = 0x00B6;     // Option flags
-        $rwTop          = 0x0000;     // Top row visible in window
-        $colLeft        = 0x0000;     // Leftmost column visible in window
+        $rwTop          = 0x0000;     // Top row visible in window
+        $colLeft        = 0x0000;     // Leftmost column visible in window
         $rgbHdr         = 0x00000000; // Row/column heading and gridline color
         // The options flags that comprise $grbit
         $fDspFmla       = 0;                     // 0 - bit
-        $fDspGrid       = 1;                     // 1
+        $fDspGrid       = $this->_screen_gridlines; // 1
         $fDspRwCol      = 1;                     // 2
         $fFrozen        = $this->_frozen;        // 3
         $fDspZeros      = 1;                     // 4
         $fDefaultHdr    = 1;                     // 5
-        $fArabic        = 0;                     // 6
+        $fArabic        = $this->_Arabic;        // 6
-        $fDspGuts       = 1;                     // 7
+        $fDspGuts       = $this->_outline_on;    // 7
         $fFrozenNoSplit = 0;                     // 0 - bit
         $fSelected      = $this->selected;       // 1
         $fPaged         = 1;                     // 2
         $grbit             = $fDspFmla;
         $grbit            |= $fDspGrid       << 1;
         $grbit            |= $fDspRwCol      << 2;
         $grbit            |= $fArabic        << 6;
         $grbit            |= $fDspGuts       << 7;
         $grbit            |= $fFrozenNoSplit << 8;
         $grbit            |= $fSelected      << 9;
         $grbit            |= $fPaged         << 10;
         $header  = pack("vv",   $record, $length);
-        $data    = pack("vvvV", $grbit, $rwTop, $colLeft, $rgbHdr);
+        $data    = pack("vvv", $grbit, $rwTop, $colLeft);
+        // FIXME !!!
+        if ($this->_BIFF_version == 0x0500) {
+            $rgbHdr         = 0x00000000; // Row/column heading and gridline color
+            $data .= pack("V", $rgbHdr);
+        } elseif ($this->_BIFF_version == 0x0600) {
+            $rgbHdr       = 0x0040; // Row/column heading and gridline color index
+            $zoom_factor_page_break = 0x0000;
+            $zoom_factor_normal     = 0x0000;
+            $data .= pack("vvvvV", $rgbHdr, 0x0000, $zoom_factor_page_break, $zoom_factor_normal, 0x00000000);
+        }
         $this->_append($header.$data);
+    }
     /**
     * Write BIFF record DEFCOLWIDTH if COLINFO records are in use.
+    *
     * @access private
     */
     function _storeDefcol()
+    {
         $record   = 0x0055;      // Record identifier
         $length   = 0x0002;      // Number of bytes to follow
         $colwidth = 0x0008;      // Default column width
         $header   = pack("vv", $record, $length);
         $data     = pack("v",  $colwidth);
-        $this->_prepend($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Write BIFF record COLINFO to define column widths
+    *
     * Note: The SDK says the record length is 0x0B but Excel writes a 0x0C
     * length record.
     *                0 => First formatted column,
     *                1 => Last formatted column,
     *                2 => Col width (8.43 is Excel default),
     *                3 => The optional XF format of the column,
     *                4 => Option flags.
+    *                5 => Optional outline level
     */
     function _storeColinfo($col_array)
+    {
         if (isset($col_array[0])) {
             $colFirst = $col_array[0];
         if (isset($col_array[1])) {
             $colLast = $col_array[1];
+        }
         if (isset($col_array[2])) {
             $coldx = $col_array[2];
-        }
-        else {
+        } else {
             $coldx = 8.43;
+        }
         if (isset($col_array[3])) {
             $format = $col_array[3];
-        }
-        else {
+        } else {
             $format = 0;
+        }
         if (isset($col_array[4])) {
             $grbit = $col_array[4];
-        }
-        else {
+        } else {
             $grbit = 0;
+        }
+        if (isset($col_array[5])) {
+            $level = $col_array[5];
+        } else {
+            $level = 0;
+        }
         $record   = 0x007D;          // Record identifier
         $length   = 0x000B;          // Number of bytes to follow
         $coldx   += 0.72;            // Fudge. Excel subtracts 0.72 !?
         $coldx   *= 256;             // Convert to units of 1/256 of a char
         $ixfe     = $this->_XF($format);
         $reserved = 0x00;            // Reserved
+        $level = max(0, min($level, 7));
+        $grbit |= $level << 8;
         $header   = pack("vv",     $record, $length);
         $data     = pack("vvvvvC", $colFirst, $colLast, $coldx,
                                    $ixfe, $grbit, $reserved);
         $this->_prepend($header.$data);
+    }
     /**
     * Write BIFF record SELECTION.
+    *
     * @access private
     * @param array $array array containing ($rwFirst,$colFirst,$rwLast,$colLast)
     function _storeSelection($array)
+    {
         list($rwFirst,$colFirst,$rwLast,$colLast) = $array;
         $record   = 0x001D;                  // Record identifier
         $length   = 0x000F;                  // Number of bytes to follow
         $pnn      = $this->_active_pane;     // Pane position
         $rwAct    = $rwFirst;                // Active row
         $colAct   = $colFirst;               // Active column
         $irefAct  = 0;                       // Active cell ref
         $cref     = 1;                       // Number of refs
         if (!isset($rwLast)) {
             $rwLast   = $rwFirst;       // Last  row in reference
+        }
         if (!isset($colLast)) {
             $colLast  = $colFirst;      // Last  col in reference
+        }
         // Swap last row/col for first row/col as necessary
-        if ($rwFirst > $rwLast)
+        if ($rwFirst > $rwLast) {
-        {
             list($rwFirst, $rwLast) = array($rwLast, $rwFirst);
+        }
-        if ($colFirst > $colLast)
+        if ($colFirst > $colLast) {
-        {
             list($colFirst, $colLast) = array($colLast, $colFirst);
+        }
         $header   = pack("vv",         $record, $length);
         $data     = pack("CvvvvvvCC",  $pnn, $rwAct, $colAct,
                                        $irefAct, $cref,
                                        $rwFirst, $rwLast,
                                        $colFirst, $colLast);
-        $this->_append($header.$data);
+        $this->_append($header . $data);
+    }
+    /**
+    * Store the MERGEDCELLS record for all ranges of merged cells
+    *
+    * @access private
+    */
+    function _storeMergedCells()
+    {
+        // if there are no merged cell ranges set, return
+        if (count($this->_merged_ranges) == 0) {
+            return;
+        }
+        $record   = 0x00E5;
+        foreach($this->_merged_ranges as $ranges)
+          {
+            $length   = 2 + count($ranges) * 8;
+            $header   = pack('vv', $record, $length);
+            $data     = pack('v',  count($ranges));
+            foreach($ranges as $range)
+              $data .= pack('vvvv', $range[0], $range[2], $range[1], $range[3]);
+            $string=$header.$data;
+            $this->_append(&$string, true);
+          }
+    }
     /**
     * Write BIFF record EXTERNCOUNT to indicate the number of external sheet
     * references in a worksheet.
+    *
     * Excel only stores references to external sheets that are used in formulas.
     * @access private
     * @param integer $count The number of external sheet references in this worksheet
     */
     function _storeExterncount($count)
+    {
-        $record   = 0x0016;          // Record identifier
+        $record = 0x0016;          // Record identifier
-        $length   = 0x0002;          // Number of bytes to follow
+        $length = 0x0002;          // Number of bytes to follow
-        $header   = pack("vv", $record, $length);
+        $header = pack("vv", $record, $length);
-        $data     = pack("v",  $count);
+        $data   = pack("v",  $count);
-        $this->_prepend($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Writes the Excel BIFF EXTERNSHEET record. These references are used by
     * formulas. A formula references a sheet name via an index. Since we store a
     * reference to all of the external worksheets the EXTERNSHEET index is the same
     * as the worksheet index.
     * @param string $sheetname The name of a external worksheet
     */
     function _storeExternsheet($sheetname)
+    {
         $record    = 0x0017;         // Record identifier
         // References to the current sheet are encoded differently to references to
         // external sheets.
         //
         if ($this->name == $sheetname) {
             $sheetname = '';
             $length    = 0x02;  // The following 2 bytes
             $cch       = 1;     // The following byte
             $rgch      = 0x02;  // Self reference
-        }
-        else {
+        } else {
             $length    = 0x02 + strlen($sheetname);
             $cch       = strlen($sheetname);
             $rgch      = 0x03;  // Reference to a sheet in the current workbook
+        }
-        $header     = pack("vv",  $record, $length);
+        $header = pack("vv",  $record, $length);
-        $data       = pack("CC", $cch, $rgch);
+        $data   = pack("CC", $cch, $rgch);
-        $this->_prepend($header.$data.$sheetname);
+        $this->_prepend($header . $data . $sheetname);
+    }
     /**
     * Writes the Excel BIFF PANE record.
     * The panes can either be frozen or thawed (unfrozen).
     * Frozen panes are specified in terms of an integer number of rows and columns.
     * Thawed panes are specified in terms of Excel's units for rows and columns.
         $x       = $panes[1];
         $rwTop   = $panes[2];
         $colLeft = $panes[3];
         if (count($panes) > 4) { // if Active pane was received
             $pnnAct = $panes[4];
-        }
-        else {
+        } else {
-            $pnnAct = NULL;
+            $pnnAct = null;
+        }
         $record  = 0x0041;       // Record identifier
         $length  = 0x000A;       // Number of bytes to follow
         // Code specific to frozen or thawed panes.
-        if ($this->_frozen)
+        if ($this->_frozen) {
-        {
             // Set default values for $rwTop and $colLeft
             if (!isset($rwTop)) {
                 $rwTop   = $y;
+            }
             if (!isset($colLeft)) {
                 $colLeft = $x;
+            }
-        }
-        else
+        } else {
-        {
             // Set default values for $rwTop and $colLeft
             if (!isset($rwTop)) {
                 $rwTop   = 0;
+            }
             if (!isset($colLeft)) {
                 $colLeft = 0;
+            }
             // Convert Excel's row and column units to the internal units.
             // The default row height is 12.75
             // The default column width is 8.43
             // The following slope and intersection values were interpolated.
             //
             $y = 20*$y      + 255;
             $x = 113.879*$x + 390;
+        }
         // Determine which pane should be active. There is also the undocumented
         // option to override this should it be necessary: may be removed later.
         //
-        if (!isset($pnnAct))
+        if (!isset($pnnAct)) {
-        {
-            if ($x != 0 and $y != 0)
+            if ($x != 0 && $y != 0) {
                 $pnnAct = 0; // Bottom right
+            }
-            if ($x != 0 and $y == 0)
+            if ($x != 0 && $y == 0) {
                 $pnnAct = 1; // Top right
+            }
-            if ($x == 0 and $y != 0)
+            if ($x == 0 && $y != 0) {
                 $pnnAct = 2; // Bottom left
+            }
-            if ($x == 0 and $y == 0)
+            if ($x == 0 && $y == 0) {
                 $pnnAct = 3; // Top left
+            }
+        }
         $this->_active_pane = $pnnAct; // Used in _storeSelection
         $header     = pack("vv",    $record, $length);
         $data       = pack("vvvvv", $x, $y, $rwTop, $colLeft, $pnnAct);
-        $this->_append($header.$data);
+        $this->_append($header . $data);
+    }
     /**
     * Store the page setup SETUP BIFF record.
+    *
     * @access private
     */
     function _storeSetup()
+    {
         $record       = 0x00A1;                  // Record identifier
         $length       = 0x0022;                  // Number of bytes to follow
         $iPaperSize   = $this->_paper_size;    // Paper size
         $iScale       = $this->_print_scale;   // Print scaling factor
         $iPageStart   = 0x01;                 // Starting page number
         $iFitWidth    = $this->_fit_width;    // Fit to number of pages wide
         $iFitHeight   = $this->_fit_height;   // Fit to number of pages high
         $iRes         = 0x0258;               // Print resolution
         $iVRes        = 0x0258;               // Vertical print resolution
         $numHdr       = $this->_margin_head;  // Header Margin
         $numFtr       = $this->_margin_foot;   // Footer Margin
         $iCopies      = 0x01;                 // Number of copies
         $fLeftToRight = 0x0;                     // Print over then down
         $fLandscape   = $this->_orientation;     // Page orientation
         $fNoPls       = 0x0;                     // Setup not read from printer
         $fNoColor     = 0x0;                     // Print black and white
         $fDraft       = 0x0;                     // Print draft quality
         $fNotes       = 0x0;                     // Print notes
         $fNoOrient    = 0x0;                     // Orientation not set
         $fUsePage     = 0x0;                     // Use custom starting page
         $grbit           = $fLeftToRight;
         $grbit          |= $fLandscape    << 1;
         $grbit          |= $fNoPls        << 2;
         $grbit          |= $fNoColor      << 3;
         $grbit          |= $fDraft        << 4;
         $grbit          |= $fNotes        << 5;
         $grbit          |= $fNoOrient     << 6;
         $grbit          |= $fUsePage      << 7;
         $numHdr = pack("d", $numHdr);
         $numFtr = pack("d", $numFtr);
-        if ($this->_byte_order) // if it's Big Endian
+        if ($this->_byte_order) { // if it's Big Endian
-        {
             $numHdr = strrev($numHdr);
             $numFtr = strrev($numFtr);
+        }
         $header = pack("vv", $record, $length);
         $data1  = pack("vvvvvvvv", $iPaperSize,
                                    $iScale,
                                    $iPageStart,
                                    $iFitWidth,
                                    $grbit,
                                    $iRes,
                                    $iVRes);
         $data2  = $numHdr.$numFtr;
         $data3  = pack("v", $iCopies);
-        $this->_prepend($header.$data1.$data2.$data3);
+        $this->_prepend($header . $data1 . $data2 . $data3);
+    }
     /**
     * Store the header caption BIFF record.
+    *
     * @access private
     */
     function _storeHeader()
+    {
         $record  = 0x0014;               // Record identifier
-        $str     = $this->_header;       // header string
+        $str      = $this->_header;       // header string
-        $cch     = strlen($str);         // Length of header string
+        $cch      = strlen($str);         // Length of header string
+        if ($this->_BIFF_version == 0x0600) {
+            $encoding = 0x0;                  // TODO: Unicode support
+            $length   = 3 + $cch;             // Bytes to follow
+        } else {
-        $length  = 1 + $cch;             // Bytes to follow
+            $length  = 1 + $cch;             // Bytes to follow
+        }
-        $header    = pack("vv", $record, $length);
+        $header   = pack("vv", $record, $length);
+        if ($this->_BIFF_version == 0x0600) {
+            $data     = pack("vC",  $cch, $encoding);
+        } else {
-        $data      = pack("C",  $cch);
+            $data      = pack("C",  $cch);
+        }
-        $this->_append($header.$data.$str);
+        $this->_prepend($header.$data.$str);
+    }
     /**
     * Store the footer caption BIFF record.
+    *
     * @access private
     */
     function _storeFooter()
+    {
         $record  = 0x0015;               // Record identifier
-        $str     = $this->_footer;       // Footer string
+        $str      = $this->_footer;       // Footer string
-        $cch     = strlen($str);         // Length of footer string
+        $cch      = strlen($str);         // Length of footer string
+        if ($this->_BIFF_version == 0x0600) {
+            $encoding = 0x0;                  // TODO: Unicode support
-        $length  = 1 + $cch;             // Bytes to follow
+            $length   = 3 + $cch;             // Bytes to follow
+        } else {
+            $length  = 1 + $cch;
+        }
         $header    = pack("vv", $record, $length);
+        if ($this->_BIFF_version == 0x0600) {
+            $data      = pack("vC",  $cch, $encoding);
+        } else {
-        $data      = pack("C",  $cch);
+            $data      = pack("C",  $cch);
+        }
-        $this->_append($header.$data.$str);
+        $this->_prepend($header . $data . $str);
+    }
     /**
     * Store the horizontal centering HCENTER BIFF record.
+    *
     * @access private
     */
     function _storeHcenter()
+    {
         $record   = 0x0083;              // Record identifier
         $length   = 0x0002;              // Bytes to follow
         $fHCenter = $this->_hcenter;     // Horizontal centering
         $header    = pack("vv", $record, $length);
         $data      = pack("v",  $fHCenter);
-        $this->_append($header.$data);
+        $this->_prepend($header.$data);
+    }
     /**
     * Store the vertical centering VCENTER BIFF record.
+    *
     * @access private
     */
     function _storeVcenter()
+    {
         $record   = 0x0084;              // Record identifier
         $length   = 0x0002;              // Bytes to follow
         $fVCenter = $this->_vcenter;     // Horizontal centering
         $header    = pack("vv", $record, $length);
         $data      = pack("v",  $fVCenter);
-        $this->_append($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Store the LEFTMARGIN BIFF record.
+    *
     * @access private
     */
     function _storeMarginLeft()
+    {
         $record  = 0x0026;                   // Record identifier
         $length  = 0x0008;                   // Bytes to follow
         $margin  = $this->_margin_left;       // Margin in inches
         $header    = pack("vv",  $record, $length);
         $data      = pack("d",   $margin);
-        if ($this->_byte_order) // if it's Big Endian
+        if ($this->_byte_order) { // if it's Big Endian
-        {
             $data = strrev($data);
+        }
-        $this->_append($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Store the RIGHTMARGIN BIFF record.
+    *
     * @access private
     */
     function _storeMarginRight()
+    {
         $record  = 0x0027;                   // Record identifier
         $length  = 0x0008;                   // Bytes to follow
         $margin  = $this->_margin_right;      // Margin in inches
         $header    = pack("vv",  $record, $length);
         $data      = pack("d",   $margin);
-        if ($this->_byte_order) // if it's Big Endian
+        if ($this->_byte_order) { // if it's Big Endian
-        {
             $data = strrev($data);
+        }
-        $this->_append($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Store the TOPMARGIN BIFF record.
+    *
     * @access private
     */
     function _storeMarginTop()
+    {
         $record  = 0x0028;                   // Record identifier
         $length  = 0x0008;                   // Bytes to follow
         $margin  = $this->_margin_top;        // Margin in inches
         $header    = pack("vv",  $record, $length);
         $data      = pack("d",   $margin);
-        if ($this->_byte_order) // if it's Big Endian
+        if ($this->_byte_order) { // if it's Big Endian
-        {
             $data = strrev($data);
+        }
-        $this->_append($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Store the BOTTOMMARGIN BIFF record.
+    *
     * @access private
     */
     function _storeMarginBottom()
+    {
         $record  = 0x0029;                   // Record identifier
         $length  = 0x0008;                   // Bytes to follow
         $margin  = $this->_margin_bottom;     // Margin in inches
         $header    = pack("vv",  $record, $length);
         $data      = pack("d",   $margin);
-        if ($this->_byte_order) // if it's Big Endian
+        if ($this->_byte_order) { // if it's Big Endian
-        {
             $data = strrev($data);
+        }
-        $this->_append($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Merges the area given by its arguments.
         // Swap last row/col for first row/col as necessary
         if ($first_row > $last_row) {
             list($first_row, $last_row) = array($last_row, $first_row);
         }
         if ($first_col > $last_col) {
             list($first_col, $last_col) = array($last_col, $first_col);
         }
         $header   = pack("vv",    $record, $length);
         $data     = pack("vvvvv", $cref, $first_row, $last_row,
                                   $first_col, $last_col);
         $this->_append($header.$data);
+    }
     */
     function _storePrintHeaders()
+    {
         $record      = 0x002a;                   // Record identifier
         $length      = 0x0002;                   // Bytes to follow
         $fPrintRwCol = $this->_print_headers;     // Boolean flag
         $header      = pack("vv", $record, $length);
         $data        = pack("v", $fPrintRwCol);
-        $this->_prepend($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Write the PRINTGRIDLINES BIFF record. Must be used in conjunction with the
     * GRIDSET record.
+    *
     * @access private
     */
     function _storePrintGridlines()
+    {
         $record      = 0x002b;                    // Record identifier
         $length      = 0x0002;                    // Bytes to follow
         $fPrintGrid  = $this->_print_gridlines;    // Boolean flag
         $header      = pack("vv", $record, $length);
         $data        = pack("v", $fPrintGrid);
-        $this->_prepend($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Write the GRIDSET BIFF record. Must be used in conjunction with the
     * PRINTGRIDLINES record.
+    *
     * @access private
     */
     function _storeGridset()
+    {
         $record      = 0x0082;                        // Record identifier
         $length      = 0x0002;                        // Bytes to follow
         $fGridSet    = !($this->_print_gridlines);     // Boolean flag
         $header      = pack("vv",  $record, $length);
         $data        = pack("v",   $fGridSet);
+        $this->_prepend($header . $data);
+    }
+    /**
+    * Write the GUTS BIFF record. This is used to configure the gutter margins
+    * where Excel outline symbols are displayed. The visibility of the gutters is
+    * controlled by a flag in WSBOOL.
+    *
+    * @see _storeWsbool()
+    * @access private
+    */
+    function _storeGuts()
+    {
+        $record      = 0x0080;   // Record identifier
+        $length      = 0x0008;   // Bytes to follow
+        $dxRwGut     = 0x0000;   // Size of row gutter
+        $dxColGut    = 0x0000;   // Size of col gutter
+        $row_level   = $this->_outline_row_level;
+        $col_level   = 0;
+        // Calculate the maximum column outline level. The equivalent calculation
+        // for the row outline level is carried out in setRow().
+        $colcount = count($this->_colinfo);
+        for ($i = 0; $i < $colcount; $i++) {
+           // Skip cols without outline level info.
+           if (count($this->_colinfo[$i]) >= 6) {
+              $col_level = max($this->_colinfo[$i][5], $col_level);
+           }
+        }
+        // Set the limits for the outline levels (0 <= x <= 7).
+        $col_level = max(0, min($col_level, 7));
+        // The displayed level is one greater than the max outline levels
+        if ($row_level) {
+            $row_level++;
+        }
+        if ($col_level) {
+            $col_level++;
+        }
+        $header = pack("vv",   $record, $length);
+        $data   = pack("vvvv", $dxRwGut, $dxColGut, $row_level, $col_level);
         $this->_prepend($header.$data);
+    }
     /**
     * Write the WSBOOL BIFF record, mainly for fit-to-page. Used in conjunction
     * with the SETUP record.
+    *
     * @access private
     */
     function _storeWsbool()
+    {
         $record      = 0x0081;   // Record identifier
         $length      = 0x0002;   // Bytes to follow
+        $grbit       = 0x0000;
         // The only option that is of interest is the flag for fit to page. So we
         // set all the options in one go.
         //
-        if ($this->_fit_page) {
+        /*if ($this->_fit_page) {
             $grbit = 0x05c1;
-        }
-        else {
+        } else {
             $grbit = 0x04c1;
+        }*/
+        // Set the option flags
+        $grbit |= 0x0001;                           // Auto page breaks visible
+        if ($this->_outline_style) {
+            $grbit |= 0x0020; // Auto outline styles
+        }
+        if ($this->_outline_below) {
+            $grbit |= 0x0040; // Outline summary below
+        }
+        if ($this->_outline_right) {
+            $grbit |= 0x0080; // Outline summary right
+        }
+        if ($this->_fit_page) {
+            $grbit |= 0x0100; // Page setup fit to page
+        }
+        if ($this->_outline_on) {
+            $grbit |= 0x0400; // Outline symbols displayed
+        }
-        $header      = pack("vv", $record, $length);
+        $header = pack("vv", $record, $length);
-        $data        = pack("v",  $grbit);
+        $data   = pack("v",  $grbit);
-        $this->_prepend($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Write the HORIZONTALPAGEBREAKS BIFF record.
+    *
     * @access private
     */
+    {
         // Return if the user hasn't specified pagebreaks
         if (empty($this->_hbreaks)) {
             return;
+        }
         // Sort and filter array of page breaks
         $breaks = $this->_hbreaks;
-        sort($breaks,SORT_NUMERIC);
+        sort($breaks, SORT_NUMERIC);
         if ($breaks[0] == 0) { // don't use first break if it's 0
             array_shift($breaks);
+        }
         $record  = 0x001b;               // Record identifier
         $cbrk    = count($breaks);       // Number of page breaks
+        if ($this->_BIFF_version == 0x0600) {
+            $length  = 2 + 6*$cbrk;      // Bytes to follow
+        } else {
-        $length  = ($cbrk + 1) * 2;      // Bytes to follow
+            $length  = 2 + 2*$cbrk;      // Bytes to follow
+        }
         $header  = pack("vv", $record, $length);
         $data    = pack("v",  $cbrk);
         // Append each page break
-        foreach($breaks as $break) {
+        foreach ($breaks as $break) {
+            if ($this->_BIFF_version == 0x0600) {
+                $data .= pack("vvv", $break, 0x0000, 0x00ff);
+            } else {
-            $data .= pack("v", $break);
+                $data .= pack("v", $break);
+            }
+        }
         $this->_prepend($header.$data);
+    }
     /**
     * Write the VERTICALPAGEBREAKS BIFF record.
+    *
     * @access private
     */
+    {
         // Return if the user hasn't specified pagebreaks
         if (empty($this->_vbreaks)) {
             return;
+        }
         // 1000 vertical pagebreaks appears to be an internal Excel 5 limit.
         // It is slightly higher in Excel 97/200, approx. 1026
         $breaks = array_slice($this->_vbreaks,0,1000);
         // Sort and filter array of page breaks
-        sort($breaks,SORT_NUMERIC);
+        sort($breaks, SORT_NUMERIC);
         if ($breaks[0] == 0) { // don't use first break if it's 0
             array_shift($breaks);
+        }
         $record  = 0x001a;               // Record identifier
         $cbrk    = count($breaks);       // Number of page breaks
+        if ($this->_BIFF_version == 0x0600) {
+            $length  = 2 + 6*$cbrk;      // Bytes to follow
+        } else {
-        $length  = ($cbrk + 1) * 2;      // Bytes to follow
+            $length  = 2 + 2*$cbrk;      // Bytes to follow
+        }
         $header  = pack("vv",  $record, $length);
         $data    = pack("v",   $cbrk);
         // Append each page break
         foreach ($breaks as $break) {
+            if ($this->_BIFF_version == 0x0600) {
+                $data .= pack("vvv", $break, 0x0000, 0xffff);
+            } else {
-            $data .= pack("v", $break);
+                $data .= pack("v", $break);
+            }
+        }
-        $this->_prepend($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Set the Biff PROTECT record to indicate that the worksheet is protected.
+    *
     * @access private
     */
+    {
         // Exit unless sheet protection has been specified
         if ($this->_protect == 0) {
             return;
+        }
         $record      = 0x0012;             // Record identifier
         $length      = 0x0002;             // Bytes to follow
         $fLock       = $this->_protect;    // Worksheet is protected
         $header      = pack("vv", $record, $length);
         $data        = pack("v",  $fLock);
         $this->_prepend($header.$data);
+    }
     /**
     * Write the worksheet PASSWORD record.
+    *
     * @access private
     */
     function _storePassword()
+    {
         // Exit unless sheet protection and password have been specified
-        if (($this->_protect == 0) or (!isset($this->_password))) {
+        if (($this->_protect == 0) || (!isset($this->_password))) {
             return;
+        }
         $record      = 0x0013;               // Record identifier
         $length      = 0x0002;               // Bytes to follow
         $wPassword   = $this->_password;     // Encoded password
         $header      = pack("vv", $record, $length);
         $data        = pack("v",  $wPassword);
-        $this->_prepend($header.$data);
+        $this->_prepend($header . $data);
+    }
     /**
     * Insert a 24bit bitmap image in a worksheet.
+    *
     * @param integer $scale_y The vertical scale
     */
     function insertBitmap($row, $col, $bitmap, $x = 0, $y = 0, $scale_x = 1, $scale_y = 1)
+    {
         $bitmap_array = $this->_processBitmap($bitmap);
-        if ($this->isError($bitmap_array))
+        if ($this->isError($bitmap_array)) {
-        {
             $this->writeString($row, $col, $bitmap_array->getMessage());
             return;
+        }
         list($width, $height, $size, $data) = $bitmap_array; //$this->_processBitmap($bitmap);
         // Scale the frame of the image.
         $width  *= $scale_x;
         $height *= $scale_y;
         // Calculate the vertices of the image and write the OBJ record
         $this->_positionImage($col, $row, $x, $y, $width, $height);
         // Write the IMDATA record to store the bitmap data
         $record      = 0x007f;
         $length      = 8 + $size;
         $cf          = 0x09;
         $env         = 0x01;
         $lcb         = $size;
         $header      = pack("vvvvV", $record, $length, $cf, $env, $lcb);
         $this->_append($header.$data);
+    }
     /**
     * Calculate the vertices that define the position of the image as required by
     * the OBJ record.
+    *
     *         +------------+------------+
     function _positionImage($col_start, $row_start, $x1, $y1, $width, $height)
+    {
         // Initialise end cell to the same as the start cell
         $col_end    = $col_start;  // Col containing lower right corner of object
         $row_end    = $row_start;  // Row containing bottom right corner of object
         // Zero the specified offset if greater than the cell dimensions
-        if ($x1 >= $this->_sizeCol($col_start))
+        if ($x1 >= $this->_sizeCol($col_start)) {
-        {
             $x1 = 0;
+        }
-        if ($y1 >= $this->_sizeRow($row_start))
+        if ($y1 >= $this->_sizeRow($row_start)) {
-        {
             $y1 = 0;
+        }
         $width      = $width  + $x1 -1;
         $height     = $height + $y1 -1;
         // Subtract the underlying cell widths to find the end cell of the image
         while ($width >= $this->_sizeCol($col_end)) {
             $width -= $this->_sizeCol($col_end);
             $col_end++;
+        }
         // Subtract the underlying cell heights to find the end cell of the image
         while ($height >= $this->_sizeRow($row_end)) {
             $height -= $this->_sizeRow($row_end);
             $row_end++;
+        }
         // Bitmap isn't allowed to start or finish in a hidden cell, i.e. a cell
         // with zero eight or width.
         //
-        if ($this->_sizeCol($col_start) == 0)
+        if ($this->_sizeCol($col_start) == 0) {
             return;
+        }
-        if ($this->_sizeCol($col_end)   == 0)
+        if ($this->_sizeCol($col_end)   == 0) {
             return;
+        }
-        if ($this->_sizeRow($row_start) == 0)
+        if ($this->_sizeRow($row_start) == 0) {
             return;
+        }
-        if ($this->_sizeRow($row_end)   == 0)
+        if ($this->_sizeRow($row_end)   == 0) {
             return;
+        }
         // Convert the pixel values to the percentage value expected by Excel
         $x1 = $x1     / $this->_sizeCol($col_start)   * 1024;
         $y1 = $y1     / $this->_sizeRow($row_start)   *  256;
         $x2 = $width  / $this->_sizeCol($col_end)     * 1024; // Distance to right side of object
         $y2 = $height / $this->_sizeRow($row_end)     *  256; // Distance to bottom of object
-        $this->_storeObjPicture( $col_start, $x1,
+        $this->_storeObjPicture($col_start, $x1,
-                                  $row_start, $y1,
+                                 $row_start, $y1,
-                                  $col_end, $x2,
+                                 $col_end, $x2,
-                                  $row_end, $y2
+                                 $row_end, $y2);
-                                );
+    }
     /**
     * Convert the width of a cell from user's units to pixels. By interpolation
     * the relationship is: y = 7x +5. If the width hasn't been set by the user we
     * use the default value. If the col is hidden we use a value of zero.
+    *
     * @access private
     * @param integer $col The column
     * @return integer The width in pixels
     */
     function _sizeCol($col)
+    {
         // Look up the cell value to see if it has been changed
         if (isset($this->col_sizes[$col])) {
             if ($this->col_sizes[$col] == 0) {
                 return(0);
-            }
-            else {
+            } else {
                 return(floor(7 * $this->col_sizes[$col] + 5));
+            }
-        }
-        else {
+        } else {
             return(64);
+        }
+    }
     /**
     * 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. (Not
     * possible to hide row yet).
     * @return integer The width in pixels
     */
     function _sizeRow($row)
+    {
         // Look up the cell value to see if it has been changed
-        if (isset($this->row_sizes[$row])) {
+        if (isset($this->_row_sizes[$row])) {
-            if ($this->row_sizes[$row] == 0) {
+            if ($this->_row_sizes[$row] == 0) {
                 return(0);
+            } else {
+                return(floor(4/3 * $this->_row_sizes[$row]));
+            }
-            else {
-                return(floor(4/3 * $this->row_sizes[$row]));
-            }
-        }
-        else {
+        } else {
             return(17);
+        }
+    }
     /**
     * Store the OBJ record that precedes an IMDATA record. This could be generalise
     * to support other Excel objects.
+    *
     * @access private
     */
     function _storeObjPicture($colL,$dxL,$rwT,$dyT,$colR,$dxR,$rwB,$dyB)
+    {
         $record      = 0x005d;   // Record identifier
         $length      = 0x003c;   // Bytes to follow
         $cObj        = 0x0001;   // Count of objects in file (set to 1)
         $OT          = 0x0008;   // Object type. 8 = Picture
         $id          = 0x0001;   // Object ID
         $grbit       = 0x0614;   // Option flags
         $cbMacro     = 0x0000;   // Length of FMLA structure
         $Reserved1   = 0x0000;   // Reserved
         $Reserved2   = 0x0000;   // Reserved
         $icvBack     = 0x09;     // Background colour
         $icvFore     = 0x09;     // Foreground colour
         $fls         = 0x00;     // Fill pattern
         $fAuto       = 0x00;     // Automatic fill
         $icv         = 0x08;     // Line colour
         $Reserved3   = 0x0000;   // Reserved
         $cbPictFmla  = 0x0000;   // Length of FMLA structure
         $Reserved4   = 0x0000;   // Reserved
         $grbit2      = 0x0001;   // Option flags
         $Reserved5   = 0x0000;   // Reserved
         $header      = pack("vv", $record, $length);
         $data        = pack("V", $cObj);
         $data       .= pack("v", $OT);
         $data       .= pack("v", $id);
         $data       .= pack("v", $grbit);
         $data       .= pack("v", $Reserved3);
         $data       .= pack("v", $cbPictFmla);
         $data       .= pack("v", $Reserved4);
         $data       .= pack("v", $grbit2);
         $data       .= pack("V", $Reserved5);
-        $this->_append($header.$data);
+        $this->_append($header . $data);
+    }
     /**
     * Convert a 24 bit bitmap into the modified internal format used by Windows.
     * This is described in BITMAPCOREHEADER and BITMAPCOREINFO structures in the
     * MSDN library.
+    *
     function _processBitmap($bitmap)
+    {
         // Open file.
         $bmp_fd = @fopen($bitmap,"rb");
         if (!$bmp_fd) {
-            return($this->raiseError("Couldn't import $bitmap"));
+            $this->raiseError("Couldn't import $bitmap");
+        }
         // Slurp the file into a string.
         $data = fread($bmp_fd, filesize($bitmap));
         // Check that the file is big enough to be a bitmap.
         if (strlen($data) <= 0x36) {
-            return($this->raiseError("$bitmap doesn't contain enough data.\n"));
+            $this->raiseError("$bitmap doesn't contain enough data.\n");
+        }
         // The first 2 bytes are used to identify the bitmap.
-        $identity = unpack("A2", $data);
+        $identity = unpack("A2ident", $data);
-        if ($identity[''] != "BM") {
+        if ($identity['ident'] != "BM") {
-            return($this->raiseError("$bitmap doesn't appear to be a valid bitmap image.\n"));
+            $this->raiseError("$bitmap doesn't appear to be a valid bitmap image.\n");
+        }
         // Remove bitmap data: ID.
         $data = substr($data, 2);
         // Read and remove the bitmap size. This is more reliable than reading
         // the data size at offset 0x22.
         //
-        $size_array   = unpack("V", substr($data, 0, 4));
+        $size_array   = unpack("Vsa", substr($data, 0, 4));
-        $size   = $size_array[''];
+        $size   = $size_array['sa'];
         $data   = substr($data, 4);
         $size  -= 0x36; // Subtract size of bitmap header.
         $size  += 0x0C; // Add size of BIFF header.
         // Remove bitmap data: reserved, offset, header length.
         $data = substr($data, 12);
         // Read and remove the bitmap width and height. Verify the sizes.
         $width_and_height = unpack("V2", substr($data, 0, 8));
         $width  = $width_and_height[1];
         $height = $width_and_height[2];
         $data   = substr($data, 8);
         if ($width > 0xFFFF) {
-            return($this->raiseError("$bitmap: largest image width supported is 65k.\n"));
+            $this->raiseError("$bitmap: largest image width supported is 65k.\n");
+        }
         if ($height > 0xFFFF) {
-            return($this->raiseError("$bitmap: largest image height supported is 65k.\n"));
+            $this->raiseError("$bitmap: largest image height supported is 65k.\n");
+        }
         // Read and remove the bitmap planes and bpp data. Verify them.
         $planes_and_bitcount = unpack("v2", substr($data, 0, 4));
         $data = substr($data, 4);
         if ($planes_and_bitcount[2] != 24) { // Bitcount
-            return($this->raiseError("$bitmap isn't a 24bit true color bitmap.\n"));
+            $this->raiseError("$bitmap isn't a 24bit true color bitmap.\n");
+        }
         if ($planes_and_bitcount[1] != 1) {
-            return($this->raiseError("$bitmap: only 1 plane nupported in bitmap image.\n"));
+            $this->raiseError("$bitmap: only 1 plane supported in bitmap image.\n");
+        }
         // Read and remove the bitmap compression. Verify compression.
-        $compression = unpack("V", substr($data, 0, 4));
+        $compression = unpack("Vcomp", substr($data, 0, 4));
         $data = substr($data, 4);
         //$compression = 0;
-        if ($compression[""] != 0) {
+        if ($compression['comp'] != 0) {
-            return($this->raiseError("$bitmap: compression not supported in bitmap image.\n"));
+            $this->raiseError("$bitmap: compression not supported in bitmap image.\n");
+        }
         // Remove bitmap data: data size, hres, vres, colours, imp. colours.
         $data = substr($data, 20);
         // Add the BITMAPCOREHEADER data
         $header  = pack("Vvvvv", 0x000c, $width, $height, 0x01, 0x18);
         $data    = $header . $data;
         return (array($width, $height, $size, $data));
+    }
     /**
     * Store the window zoom factor. This should be a reduced fraction but for
     * simplicity we will store all fractions with a numerator of 100.
+    *
     * @access private
+    {
         // If scale is 100 we don't need to write a record
         if ($this->_zoom == 100) {
             return;
+        }
         $record      = 0x00A0;               // Record identifier
         $length      = 0x0004;               // Bytes to follow
         $header      = pack("vv", $record, $length);
         $data        = pack("vv", $this->_zoom, 100);
+        $this->_append($header . $data);
+    }
+    /**
+    * FIXME: add comments
+    */
+    function setValidation($row1, $col1, $row2, $col2, &$validator)
+    {
+        $this->_dv[] = $validator->_getData() .
+                       pack("vvvvv", 1, $row1, $row2, $col1, $col2);
+    }
+    /**
+    * Store the DVAL and DV records.
+    *
+    * @access private
+    */
+    function _storeDataValidity()
+    {
+        $record      = 0x01b2;      // Record identifier
+        $length      = 0x0012;      // Bytes to follow
+        $grbit       = 0x0002;      // Prompt box at cell, no cached validity data at DV records
+        $horPos      = 0x00000000;  // Horizontal position of prompt box, if fixed position
+        $verPos      = 0x00000000;  // Vertical position of prompt box, if fixed position
+        $objId       = 0xffffffff;  // Object identifier of drop down arrow object, or -1 if not visible
+        $header      = pack('vv', $record, $length);
+        $data        = pack('vVVVV', $grbit, $horPos, $verPos, $objId,
+                                     count($this->_dv));
         $this->_append($header.$data);
+        $record = 0x01be;              // Record identifier
+        foreach ($this->_dv as $dv) {
+            $length = strlen($dv);      // Bytes to follow
+            $header = pack("vv", $record, $length);
+            $this->_append($header . $dv);
+        }
+    }
+}
 ?>

Subversion Repositories eFlore/Applications.cel

(root)/trunk/jrest/lib/Spreadsheet/Excel/Writer/Worksheet.php @ 996 – Rev 996 → 1604