Zend_OfficeOpen 2.0 - Martin Keckeis

{zone-template-instance:ZFPROP:Proposal Zone Template}
{zone-data:component-name}
Zend\OfficeOpen
{zone-data}

{zone-data:proposer-list}
[Martin Keckeis|mailto:martin.keckeis@gmail.com]
{zone-data}

{zone-data:liaison}
TBD
{zone-data}

{zone-data:revision}
1.0 - 1 February 2011: Initial Draft.
{zone-data}

{zone-data:overview}
Zend\OfficeOpen is a simple component that can read and write *ISO/IEC 29500 Office Open XML File Formats*.
This include: spreadsheets, wordprocessing and presentation documents.

Supporting of this standard (ISO/IEC 29500)
* Microsoft Office, since version 2007/2010 (only old standard which was not accepted: ECMA-376)
* SoftMaker Office 2010
* Corel WordPerfect, since version X4 (only import)
* ThinkFree Office, since version 3.5
* NeoOffice MAC
* OpenOffice, since version 3.0 (only import)
* Gnumeric and AbiWord (import and export)
* iPhone eMail file support
* iWork, since version '08
* TextEdit, since version Mac OS X 10.5
{zone-data}

* [Microsoft Office XML formats |http://en.wikipedia.org/wiki/Microsoft_Office_XML_formats]

The standard ISO/IEC 29500:2008:
* [Download page (4 ISO documents + 2 with changes) |http://standards.iso.org/ittf/PubliclyAvailableStandards/index.html]
Note: (ISO/IEC 29500-1) beginning at page 5553, are 8 pages where the differences between ISO/IEC 29500:2008 and ECMA-376:2006 are written

Attachments:
* [Spreadsheet parts|http://framework.zend.com/wiki/download/attachments/31982098/spreadsheetParts.jpg]
* [Spreadsheet example structure|http://framework.zend.com/wiki/download/attachments/31982098/spreadsheetExampleStructure.jpg]
* [Wordprocessing parts|http://framework.zend.com/wiki/download/attachments/31982098/wordprocessingParts.jpg]
* [Wordprocessing example structure|http://framework.zend.com/wiki/download/attachments/31982098/wordprocessingExampleStructure.jpg]
* [Shared parts (used by spreadsheet, wordprocessing, presentation|http://framework.zend.com/wiki/download/attachments/31982098/sharedParts.jpg]
{zone-data}

{zone-data:requirements}
* This component *will not* read/write/convert old formats like .xls, .doc, .ppt, ...
* This component *will* read/write ISO/IEC 29500 Office Open XML File Formats
* This component *will* use Zend\Cache for caching readed files
* This component *will* use Zend\Translate and/or Zend\Locale for translation
* This component *maybe* will support both "ISO/IEC 29500" and "ECMA-376"
{zone-data}

{zone-data:dependencies}
* Zend\Exception
* Zend\Cache
* Zend\Translate
* Zend\Locale
* Zend\Config (maybe)
{zone-data}

{zone-data:operation}
General for using this component, the ZipArchive and XML Manipulating from PHP is needed.

||UC-01 write||
1. User defines what shall be written to the output (texts, images, meta-data, formatting, ...)
2. Forwarding the provided data to the generation classes
3. Generate and write each single XML document
4. Putting it in the ZIP together

||UC-01 open/read||
1. Unzip the XMLs
2. open [Content_Types].xml and _rels/.rels (these two files are required minimal)
3. Looping through the needed files (from user)
4. Return output

{zone-data}

{zone-data:milestones}
* Milestone 1: Reading/Understanding the whole XML parts which are possible in the ZIP of word, excel, powerpoint
* Milestone 2: Concept
* Milestone 3: Class/Folder structure
* Milestone 4: Working prototype
* Milestone 5: Feedback
* Milestone 6: Writing Tests
* Milestone 7: Final coding
* Milestone 8: Documentation / Review

{zone-data}

{zone-data:class-list}
* Zend\OfficeOpen\Exception
* ....
{zone-data}

{zone-data:use-cases}
||UC-01 write||
use Zend\Excel;
$excel = new Excel(...);
$excel->setMetadata(...);

$worksheet = $excel->getWorksheet(...);
$worksheet->setHead(...);
$worksheet->setFooter(...);

$style1 = new Excel\Style();
$style1->setBorder(...);
$style1->setBackgroundColor(...);
$style1->setColor(...);

$cell = new Excel\Cell();
$cell->setText('cellText');
$cell->setStyle($style1);

$worksheet->setCell('A', '1', $cell);

$excel->render('test.xlxs');
{zone-data}

{zone-data:skeletons}
{code}
class Zend_Magic_Exception extends Zend_Exception {}

class Zend_Magic {
...
{code}
{zone-data}

{zone-template-instance}