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

     * temporary file, the default.
+    *
     * @access private
     * @param string $data The binary data to append
     */
-    function _append($data)
+    function _append(&$data)
+    {
         if ($this->_using_tmpfile) {
             // Add CONTINUE records if necessary
             if (strlen($data) > $this->_limit) {
                 $data = $this->_addContinue($data);
         $xl_double = pack("d",   $num);
         if ($this->_byte_order) { // if it's Big Endian
             $xl_double = strrev($xl_double);
+        }
+		$data = $header . $data . $xl_double;
-        $this->_append($header.$data.$xl_double);
+        $this->_append($data);
         return(0);
+    }
             $str_error = -3;
+        }
         $header    = pack("vv",   $record, $length);
+        $data      = pack("vvvv", $row, $col, $xf, $strlen);
-        $data      = pack("vvvv", $row, $col, $xf, $strlen);
+		$data = $header . $data . $str;
-        $this->_append($header . $data . $str);
+        $this->_append($data);
         return($str_error);
+    }
+        }
         $this->_str_total++;
         $header    = pack('vv',   $record, $length);
+        $data      = pack('vvvV', $row, $col, $xf, $this->_str_table[$str]);
+		$data = $header . $data;
-        $data      = pack('vvvV', $row, $col, $xf, $this->_str_table[$str]);
-        $this->_append($header.$data);
+		$this->_append($data);
         return $str_error;
+    }
+        }
         // 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) . substr($note, 0, 2048);
+		$data = $header . $data;
-        $data      = pack("vvv", $row, $col, $note_length);
-        $this->_append($header . $data . substr($note, 0, 2048));
+        $this->_append($data);
         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);
+            $data   = pack("vvv", -1, 0, strlen($chunk)) . $chunk;
-            $header = pack("vv",   $record, $length);
+			$data = $header . $data;
             $data   = pack("vvv", -1, 0, strlen($chunk));
-            $this->_append($header.$data.$chunk);
+            $this->_append($data);
+        }
         return(0);
             $this->_dim_colmax = $col;
+        }
         $header    = pack("vv",  $record, $length);
+        $data      = pack("vvv", $row, $col, $xf);
+		$data = $header . $data;
-        $data      = pack("vvv", $row, $col, $xf);
-        $this->_append($header . $data);
+        $this->_append($data);
         return 0;
+    }
         $length     = 0x16 + $formlen;     // Length of the record data
         $header    = pack("vv",      $record, $length);
         $data      = pack("vvvdvVv", $row, $col, $xf, $num,
+                                     $grbit, $unknown, $formlen);
-                                     $grbit, $unknown, $formlen);
+		$data = $header . $data . $formula;
-        $this->_append($header . $data . $formula);
+        $this->_append($data);
         return 0;
+    }
         // Pack the header data
         $header      = pack("vv",   $record, $length);
+        $data        = pack("vvvv", $row1, $row2, $col1, $col2);
-        $data        = pack("vvvv", $row1, $row2, $col1, $col2);
+		$data = $header . $data . $unknown1 . $options . $unknown2 . $url_len . $url;
-        // Write the packed data
-        $this->_append($header . $data .
-                       $unknown1 . $options .
+        // Write the packed data
-                       $unknown2 . $url_len . $url);
+        $this->_append($data);
         return($str_error);
+    }
         // Pack the header data
         $header      = pack("vv",   $record, $length);
+        $data        = pack("vvvv", $row1, $row2, $col1, $col2);
-        $data        = pack("vvvv", $row1, $row2, $col1, $col2);
+		$data = $header . $data . $unknown1 . $options . $url_len . $url;
-        // Write the packed data
-        $this->_append($header . $data .
-                       $unknown1 . $options .
+        // Write the packed data
-                       $url_len . $url);
+        $this->_append($data);
         return($str_error);
+    }
                           $sheet        ;*/
         // Pack the header data
         $length   = strlen($data);
+        $header   = pack("vv", $record, $length);
-        $header   = pack("vv", $record, $length);
+		$data = $header. $data;
         // Write the packed data
-        $this->_append($header. $data);
+        $this->_append($data);
         return($str_error);
+    }
         $grbit |= 0x0100;
         $header   = pack("vv",       $record, $length);
         $data     = pack("vvvvvvvv", $row, $colMic, $colMac, $miyRw,
+                                     $irwMac,$reserved, $grbit, $ixfe);
-                                     $irwMac,$reserved, $grbit, $ixfe);
+		$data = $header . $data;
-        $this->_append($header.$data);
+        $this->_append($data);
+    }
     /**
             $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);
+        }
+		$data = $header.$data;
-        $this->_append($header.$data);
+        $this->_append($data);
+    }
     /**
     * Write BIFF record DEFCOLWIDTH if COLINFO records are in use.
         $header   = pack("vv",         $record, $length);
         $data     = pack("CvvvvvvCC",  $pnn, $rwAct, $colAct,
                                        $irefAct, $cref,
                                        $rwFirst, $rwLast,
                                        $colFirst, $colLast);
+		$data = $header . $data;
-        $this->_append($header . $data);
+        $this->_append($data);
+    }
     /**
     * Store the MERGEDCELLS record for all ranges of merged cells
             $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;
+            $string = $header . $data;
-            $this->_append(&$string, true);
+            $this->_append($string);
+          }
+    }
     /**
         $this->_active_pane = $pnnAct; // Used in _storeSelection
+        $header     = pack("vv",    $record, $length);
-        $header     = pack("vv",    $record, $length);
+        $data       = pack("vvvvv", $x, $y, $rwTop, $colLeft, $pnnAct);
-        $data       = pack("vvvvv", $x, $y, $rwTop, $colLeft, $pnnAct);
+		$data = $header . $data;
-        $this->_append($header . $data);
+        $this->_append($data);
+    }
+        }
         $header   = pack("vv",    $record, $length);
         $data     = pack("vvvvv", $cref, $first_row, $last_row,
-                                  $first_col, $last_col);
+                                  $first_col, $last_col);
+		$data = $header . $data;
-        $this->_append($header.$data);
+		$this->_append($data);
+    }
     /**
         $cf          = 0x09;
         $env         = 0x01;
         $lcb         = $size;
+        $header      = pack("vvvvV", $record, $length, $cf, $env, $lcb);
-        $header      = pack("vvvvV", $record, $length, $cf, $env, $lcb);
+		$data = $header . $data;
-        $this->_append($header.$data);
+		$this->_append($data);
+    }
     /**
         $data       .= pack("v", $cbPictFmla);
         $data       .= pack("v", $Reserved4);
         $data       .= pack("v", $grbit2);
         $data       .= pack("V", $Reserved5);
+		$data = $header . $data;
-        $this->_append($header . $data);
+		$this->_append($data);
+    }
     /**
         $record      = 0x00A0;               // Record identifier
         $length      = 0x0004;               // Bytes to follow
         $header      = pack("vv", $record, $length);
+        $data        = pack("vv", $this->_zoom, 100);
-        $data        = pack("vv", $this->_zoom, 100);
+		$data = $header . $data;
-        $this->_append($header . $data);
+		$this->_append($data);
+    }
     /**
         $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));
-                                     count($this->_dv));
+		$data = $header . $data;
-        $this->_append($header.$data);
+		$this->_append($data);
         $record = 0x01be;              // Record identifier
         foreach ($this->_dv as $dv) {
+            $length = strlen($dv);      // Bytes to follow
-            $length = strlen($dv);      // Bytes to follow
+            $header = pack("vv", $record, $length);
-            $header = pack("vv", $record, $length);
+			$header .= $dv;
-            $this->_append($header . $dv);
+            $this->_append($header);
+        }
+    }

Subversion Repositories eFlore/Applications.cel

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