File Source for OpenDocumentSpreadsheet.php

<?php
/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
/*
* Created on 04. Jan. 2007 by Norman Markgraf (nmarkgraf(at)user.sourceforge.net)
*/
/**
* OpenDocumentSpreadsheet class file
*
* PHP versions 5
*
* LICENSE:
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
* A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
* OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
* DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
* THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
* OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*
* This software consists of voluntary contributions made by many individuals
* and is licensed under the GPL. For more information please see
* <http://opendocumentphp.org>.
*
* $Id: OpenDocumentSpreadsheet.php 263 2007-08-06 08:28:49Z nmarkgraf $
*
* @category File Formats
* @package OpenDocumentPHP
* @author Norman Markgraf (nmarkgraf(at)user.sourceforge.net)
* @copyright Copyright in 2006, 2007 by The OpenDocumentPHP Team
* @license http://www.gnu.org/licenses/gpl.html GNU General Public License 2.0.
* @version SVN: $Id: OpenDocumentSpreadsheet.php 263 2007-08-06 08:28:49Z nmarkgraf $
* @link http://opendocumentphp.org
* @since 0.5.0 - 08. Feb. 2007
*/
/**
*
*/
require_once 'OpenDocumentPHP/OpenDocumentAbstract.php';
/**
* OpenDocumentSpreadsheet class.
*
* You could uses this class as follows:
*
* <code>
* $fullpath = 'YourFavoriteCalcDocument.odc';
* $text = new OpenDocumentSpreadsheet( $fullpath );
* // do something with it
* ...
* // And write it back
* $text->close();
* </code>
*
* If you want to revert all modifications and do not write anything back to the archive you can
* use the first parameter of this function and set it to false.
*
* <code>
* $fullpath = 'YourFavoriteCalcDocument.odc';
* $text = new OpenDocumentSpreadsheet( $fullpath );
* // do something with it or not
* ...
* // But this time, we do not want to write it back to the archive
* $text->close( false );
* </code>
*
* Be aware that even if you do not modifiy the OpenDocument, the library will!
* So do not expect the that the file is absolut the same after you run the close method.
*
* @category File Formats
* @package OpenDocumentPHP
* @author Norman Markgraf (nmarkgraf(at)user.sourceforge.net)
* @copyright Copyright in 2006, 2007 by The OpenDocumentPHP Team
* @license http://www.gnu.org/licenses/gpl.html GNU General Public License 2.0.
* @version Release: @package_version@
* @link http://opendocumentphp.org
* @since 0.5.0 - 08. Feb. 2007
*/
class OpenDocumentSpreadsheet extends OpenDocumentAbstract {
/**
* Namespace CALC
*/
const odmCalcNamespace = 'application/vnd.oasis.opendocument.spreadsheet';
/**
* Constructor method.
*
* Read (and if not exists create) an OpenDocument calc file (aka spreadsheet).
*
*
* @param string $fullpath Full path and name of the document
* @since 0.5.0 - 08. Feb. 2007
*/
function __construct($fullpath=null)
{
// Construct a text document
parent :: __construct(self :: odmCalcNamespace);
// Is the variable $fullpath given?
if (isset($fullpath) && is_string($fullpath)) {
if (file_exists($fullpath)) {
// File does exist, so we can load it via open.
parent :: open($fullpath);
$this->content->getBody()->getSpreadsheetFragment();
} else {
// File does not exist, so we can create it.
parent :: open($fullpath, self :: CREATE, self :: odmCalcNamespace);
// Set everything to a OpenDocument CALC file.
$this->content->setSpreadsheet();
}
} else {
// JUST A CLEAN FILE WITH NO FILE NAME JET!!!! DANGER!!!!
$this->init();
$this->content->setSpreadsheet();
}
}
/**
* Create a new sheet with the name '$sheetname'.
*
* @access public
* @param string $sheetname The name of the new sheet
* @return object
* @since 0.5.0 - 08. Feb. 2007
*/
function addSheet($sheetname)
{
return $this->content->getTable($sheetname);
}
/**
* Setup some default data for the meta.xml.
*
* We will setup some data for the meta.xml document. You can use this method and
* overwrite even the static given data in this method by calling the MetaFragment
* or DublinCoreFragment methods again.
*
* Currently we set the following meta datas:
*
* DublinCore:
* <ul>
* <li>The subject is set to 'A generated subject by OpenDocumentPHP.'.</li>
* <li>The title is set to 'This is a generated title by OpenDocumentPHP.'.</li>
* <li>The description is set to 'This is a short description by OpenDocumentPHP.'.</li>
* <li>The language is set up 'en' for an english text.</li>
* </ul>
*
* (OpenDocument-)Meta:
* currently nothing is set here.
*
* In your own code you can change the value very simple:
* <code>
* $doc = new OpenDocumentText('YourFavoriteText.odt');
* ...
* // Retreive the DublinCoreFragment to change dublin core meta data
* $dc = $doc->getMeta()->getDublinCoreFragment();
* // Change title to new title
* $dc->setTitle( 'This is a new title of the document.' );
* ...
* // Retreive the MetaFragment to change OpenDocument meta data
* $meta = $doc->getMeta()->getMetaFragment();
* // Change the initial creator of the document
* $meta->setInitialCreator( 'Robert Duck' );
* ...
* </code>
*
* @access public
* @since 0.5.3 - 03. Aug. 2007
*/
function setDefaultMeta()
{
// =====================================================================
$dc = $this->getMeta()->getDublinCoreFragment();
// ---------------------------------------------------------------------
$dc->setSubject('A generated subject by OpenDocumentPHP.');
$dc->setTitle('This is a generated title by OpenDocumentPHP.');
$dc->setDescription('This is a short description by OpenDocumentPHP.');
$dc->setLanguage('en');
// =====================================================================
$meta = $this->getMeta()->getMetaFragment();
// ---------------------------------------------------------------------
}
/**
* We set up some default font face declarations here.
*
* We put the same font face declarations in the styles.xml and content.xml
* document.
*
* There are two font faces declared by this method:
* Tahoma1 and Arial Unicode MS.
*
* @access public
* @since 0.5.3 - 04. Aug. 2007
*/
function setDefaultFontFaces()
{
// Get the StylesDocument object
$styles = $this->getStyles();
// Retrieve the FontFaceDeclarations object
$ffd = $styles->getFontFaceDeclarations();
/*
* Create a new font face.
* We will call it 'Tahoma1' which depends on the 'Tahoma' font family.
*/
$fontface_Tahoma = $ffd->nextFontFace();
$fontface_Tahoma->setStyleName('Tahoma1');
$fontface_Tahoma->setSVGFontFamily('Tahoma');
/*
* Create a new font face.
* We will call it 'Arial Unicode MS' which depends on the 'Arial Unicode MS' font family
* and we set the font pitch to 'variable'.
*/
$fontface_Arial = $ffd->nextFontFace();
$fontface_Arial->setStyleName('Arial Unicode MS');
$fontface_Arial->setSVGFontFamily(utf8_encode("'Arial Unicode MS'"));
$fontface_Arial->setFontPitch('variable');
/*
* We need FontFaceDecl in content.xml too.
* So we make a copy of the font face declaration and import this
* to the font face declaration part of the content.xml
*
*/
$content = $this->getContent();
$cffd = $content->getFontFaceDeclarations();
$cffd->importNode($ffd);
}
/**
* Set up some default styles.
*
* We define the 'Standart' and 'Heading_20_1' fonts in this method.
*
* @access public
* @since 0.5.3 - 04. Aug. 2007
*/
function setDefaultStyles()
{
$default_style = $this->getStyles()->getStyles()->getDefaultStyle();
$default_style->setFamily('paragraph');
// Set paragraph properties:
$paragraph_properties = $default_style->getParagraphProperties();
$paragraph_properties->setHyphenationLadderCount('no-limit');
$paragraph_properties->setTextAutospace('ideograph-alpha');
$paragraph_properties->setPunctuationWrap = ('hanging');
$paragraph_properties->setLineBreak('strict');
$paragraph_properties->setTabStopDistance('1.251cm');
$paragraph_properties->setWritingMode('page');
// Set text properties:
$text_properties = $default_style->getTextProperties();
$text_properties->setLanguage('de');
$text_properties->setCountry('DE');
$text_properties->setFontName('Times New Roman');
$text_properties->setFontSize('12pt');
$text_properties->setFontNameAsian('Arial Unicode MS');
$text_properties->setFontSizeAsian('12pt');
$text_properties->setFontNameComplex('Tahoma');
$text_properties->setFontSizeComplex('12pt');
$text_properties->setHyphenate('false');
$text_properties->setHyphenationRemainCharCount('2');
$text_properties->setHyphenationPushCharCount('2');
// ...
/*
<style:text-properties
style:use-window-font-color="true"
style:language-asian="none"
style:country-asian="none"
style:language-complex="none"
style:country-complex="none"
*/
$style_Standard = $this->getStyles()->getStyles()->getStyle();
$style_Standard->setStyleName('Standard');
$style_Standard->setFamily('paragraph');
$style_Standard->setClass('text');
}
}
?>

	OpenDocumentPHP

[ class tree: OpenDocumentPHP ] [ index: OpenDocumentPHP ] [ all elements ]

Source for file OpenDocumentSpreadsheet.php