Class: Spreadsheet_OpenDocument_Writer

Source Location: /util/Spreadsheet/Writer.php

Class Spreadsheet_OpenDocument_Writer

Class Overview

Spreadsheet_OpenDocument_Writer

Located in /util/Spreadsheet/Writer.php [line 69]

Spreadsheet_OpenDocument_Workbook
   |
   --Spreadsheet_OpenDocument_Writer

Author(s):

Norman Markgraf (nmarkgraf(at)user.sourceforge.net)

Information Tags:

Version:	Release: @package_version@
Copyright:	Copyright in 2006, 2007 by The OpenDocumentPHP Team
Link:	http://pear.php.net/package/Spreadsheet_Excel_Writer
Link:	http://opendocumentphp.org
Since:	0.6.0 - 22. Jul. 2007
License:	GNU General Public License 2.0.

Methods

[ Top ]

Inherited Properties, Constants, and Methods

Inherited Properties

Inherited Methods

Inherited Constants

Inherited From Spreadsheet_OpenDocument_Workbook

Spreadsheet_OpenDocument_Workbook::$mainOpenDocument

Spreadsheet_OpenDocument_Workbook::$_automaticStyles

Spreadsheet_OpenDocument_Workbook::$_worksheets

Inherited From Spreadsheet_OpenDocument_Workbook

Spreadsheet_OpenDocument_Workbook::__construct()

Constructor

Spreadsheet_OpenDocument_Workbook::addFormat()

Spreadsheet_OpenDocument_Workbook::addNewAutomaticStyle()

Spreadsheet_OpenDocument_Workbook::addWorksheet()

Spreadsheet_OpenDocument_Workbook::close()

Spreadsheet_OpenDocument_Workbook::setCustomsColor()

Spreadsheet_OpenDocument_Workbook::setTempDir()

[ Top ]

Method Summary

static The	rowcolToCell()	Utility function for writing formulas Converts a cell's coordinates to the A1 format.
Spreadsheet_OpenDocument_Writer	__construct()	The constructor. It just creates a Workbook
void	send()	Send HTTP headers for the OpenDocument Calc file.

[ Top ]

Properties

Methods

static method rowcolToCell [line 122]

static The rowcolToCell(
integer
$row, integer
$col 
)

Utility function for writing formulas Converts a cell's coordinates to the A1 format.

Make sure that $col is in [0..701] as this is the range [A..ZZ]! Also make sure that $row is in [0..MAXINT]!

Examples:

$cellA1 = Spreadsheet_OpenDocument_Writer::rowcolToCell(0, 0);
$cellB4 = Spreadsheet_OpenDocument_Writer::rowcolToCell(3, 1);
$cellD2 = Spreadsheet_OpenDocument_Writer::rowcolToCell(1, 3);

Parameters:

integer	$row:	Row for the cell to convert (0-indexed).
integer	$col:	Column for the cell to convert (0-indexed).

API Tags:

Return:	cell identifier in A1 format
Access:	public

[ Top ]

Constructor __construct [line 80]

Spreadsheet_OpenDocument_Writer __construct(
[string|OpenDocumentArchive
$filename = null] 
)

The constructor. It just creates a Workbook

Parameters:

string|OpenDocumentArchive

$filename:

Eigther the optional filename for the Workbook or a completly ready OpenDocumentArchive object.

Information Tags:

Since:	0.6.0 - 22. Jul. 2007
Throws:	Exception if no filename or OpenDocumentArchive is given.

Redefinition of:

Spreadsheet_OpenDocument_Workbook::__construct(): Constructor

[ Top ]

send [line 153]

void send(
string
$filename 
)

Send HTTP headers for the OpenDocument Calc file.

*** NOT IMPLEMENTED NOW ***

Parameters:

string

$filename:

The filename to use for HTTP headers

API Tags:

Access:

public

[ Top ]

Documentation generated on Wed, 18 Jun 2008 06:34:43 +0200 by phpDocumentor 1.3.2

	OpenDocumentPHP util_Spreadsheet

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