gistfile1.xml

<?xml version="1.0" encoding="UTF-8"?>
<office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2" grddl:transformation="http://docs.oasis-open.org/office/1.2/xslt/odf2rdf.xsl">
    <office:scripts/>
    <office:font-face-decls>
        <style:font-face style:name="Liberation Sans" svg:font-family="&apos;Liberation Sans&apos;" style:font-family-generic="swiss" style:font-pitch="variable"/>
        <style:font-face style:name="DejaVu Sans" svg:font-family="&apos;DejaVu Sans&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
        <style:font-face style:name="Lohit Hindi" svg:font-family="&apos;Lohit Hindi&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
    </office:font-face-decls>
    <office:automatic-styles>
        <style:style style:name="co1" style:family="table-column">
            <style:table-column-properties fo:break-before="auto" style:column-width="0.8925in"/>
        </style:style>
        <style:style style:name="ro1" style:family="table-row">
            <style:table-row-properties style:row-height="0.178in" fo:break-before="auto" style:use-optimal-row-height="true"/>
        </style:style>
        <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
            <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
        </style:style>
        <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default">
            <style:table-cell-properties fo:background-color="#0047ff"/>
            <style:text-properties fo:color="#ffffff" fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
        </style:style>
        <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
            <style:table-cell-properties fo:background-color="#000000"/>
            <style:text-properties fo:color="#ffffff" fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
        </style:style>
        <style:style style:name="gr1" style:family="graphic">
            <style:graphic-properties draw:ole-draw-aspect="1"/>
        </style:style>
        <style:style style:name="ta_extref" style:family="table">
            <style:table-properties table:display="false"/>
        </style:style>
    </office:automatic-styles>
    <office:body>
        <office:spreadsheet>
            <table:table table:name="Sheet1" table:style-name="ta1" table:print="false">
                <table:table-column table:style-name="co1" table:number-columns-repeated="6" table:default-cell-style-name="Default"/>
                <table:table-row table:style-name="ro1">
                    <table:table-cell table:number-columns-repeated="6"/>
                </table:table-row>
                <table:table-row table:style-name="ro1">
                    <table:table-cell/>
                    <table:table-cell table:style-name="ce1" office:value-type="string">
                        <text:p>Name</text:p>
                    </table:table-cell>
                    <?php foreach($students as $student):?>
                    <table:table-cell table:style-name="ce1" office:value-type="string">
                        <text:p><?php echo $student->getName()?></text:p>
                    </table:table-cell>
                    <?php endforeach;?>
                </table:table-row>
                <?php foreach($students[0]->getTests() as $test):?>
                <table:table-row table:style-name="ro1">
                    <table:table-cell/>
                    <table:table-cell office:value-type="string">
                        <text:p><?php echo $test['month']?></text:p>
                    </table:table-cell>
                    <?php foreach($students as $student):?>
                    <table:table-cell office:value-type="float" office:value="<?php echo $student->getMark($test['month'])->getMark()?>">
                        <text:p><?php echo $student->getMark($test['month'])->getMark()?></text:p>
                    </table:table-cell>
                    <?php endforeach;?>
                </table:table-row>
                <?php endforeach;?>
                <table:table-row table:style-name="ro1">
                    <table:table-cell/>
                    <table:table-cell table:style-name="ce2" office:value-type="string">
                        <text:p>Average</text:p>
                    </table:table-cell>
                    <table:table-cell table:style-name="ce2" table:formula="of:=AVERAGE([.C3:.C6])" office:value-type="float" office:value="11">
                        <text:p>11</text:p>
                    </table:table-cell>
                    <table:table-cell table:style-name="ce2" table:formula="of:=AVERAGE([.D3:.D6])" office:value-type="float" office:value="9.25">
                        <text:p>9.25</text:p>
                    </table:table-cell>
                    <table:table-cell table:style-name="ce2" table:formula="of:=AVERAGE([.E3:.E6])" office:value-type="float" office:value="10.75">
                        <text:p>10.75</text:p>
                    </table:table-cell>
                    <table:table-cell table:style-name="ce2" table:formula="of:=AVERAGE([.F3:.F6])" office:value-type="float" office:value="7.5">
                        <text:p>7.5</text:p>
                    </table:table-cell>
                </table:table-row>
                <table:table-row table:style-name="ro1" table:number-rows-repeated="2">
                    <table:table-cell table:number-columns-repeated="6"/>
                </table:table-row>
                <table:table-row table:style-name="ro1">
                    <table:table-cell>
                        <draw:frame table:end-cell-address="Sheet1.H25" table:end-x="0.1524in" table:end-y="0.0941in" draw:z-index="0" draw:style-name="gr1" svg:width="6.2559in" svg:height="2.7504in" svg:x="0.1193in" svg:y="0.0004in">
                            <draw:object draw:notify-on-update-of-ranges="Sheet1.B3:Sheet1.B6 Sheet1.C2:Sheet1.C2 Sheet1.C3:Sheet1.C6 Sheet1.D2:Sheet1.D2 Sheet1.D3:Sheet1.D6 Sheet1.E2:Sheet1.E2 Sheet1.E3:Sheet1.E6 Sheet1.F2:Sheet1.F2 Sheet1.F3:Sheet1.F6" xlink:href="./Object 1" xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad"/>
                            <draw:image xlink:href="./ObjectReplacements/Object 1" xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad"/>
                        </draw:frame>
                    </table:table-cell>
                    <table:table-cell table:number-columns-repeated="5"/>
                </table:table-row>
            </table:table>
            <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
                <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
                <table:table-row table:style-name="ro1">
                    <table:table-cell/>
                </table:table-row>
            </table:table>
            <table:table table:name="Sheet3" table:style-name="ta1" table:print="false">
                <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
                <table:table-row table:style-name="ro1">
                    <table:table-cell/>
                </table:table-row>
            </table:table>
        </office:spreadsheet>
    </office:body>
</office:document-content>