You are viewing a plain text version of this content. The canonical link for it is here.
Posted to cvs@cocoon.apache.org by jo...@apache.org on 2003/05/17 13:57:53 UTC
cvs commit: cocoon-2.1/src/blocks/poi/samples/content simple-date-test.xml
joerg 2003/05/17 04:57:53
Added: src/blocks/poi/samples/content simple-date-test.xml
Log:
POI samples reactivated - at least 1 at the moment
Revision Changes Path
1.1 cocoon-2.1/src/blocks/poi/samples/content/simple-date-test.xml
Index: simple-date-test.xml
===================================================================
<?xml version="1.0"?>
<gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7">
<gmr:SheetNameIndex>
<gmr:SheetName>Sheet 0</gmr:SheetName>
</gmr:SheetNameIndex>
<gmr:Sheets>
<gmr:Sheet>
<gmr:Name>Sheet 0</gmr:Name>
<gmr:MaxCol>2</gmr:MaxCol>
<gmr:MaxRow>20</gmr:MaxRow>
<gmr:Styles>
<gmr:StyleRegion startCol="1" startRow="5" endCol="2" endRow="5">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="m/d/yy"/>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="6" endCol="2" endRow="6">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="d-mmm-yy"/>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="7" endCol="2" endRow="7">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="d-mmm"/>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="8" endCol="2" endRow="8">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="mmm-yy"/>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="9" endCol="2" endRow="9">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="h:mm AM/PM"/>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="10" endCol="2" endRow="10">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="h:mm:ss AM/PM"/>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="11" endCol="2" endRow="11">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="h:mm"/>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="12" endCol="2" endRow="12">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="h:mm:ss"/>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="13" endCol="2" endRow="13">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="m/d/yy h:mm"/>
</gmr:StyleRegion>
<gmr:StyleRegion startCol="1" startRow="16" endCol="1" endRow="18">
<gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="m/d/yy"/>
</gmr:StyleRegion>
</gmr:Styles>
<gmr:Cols DefaultSizePts="48">
<gmr:ColInfo No="0" Unit="150" MarginA="1" MarginB="2"/>
<gmr:ColInfo No="1" Unit="150" MarginA="1" MarginB="2"/>
<gmr:ColInfo No="2" Unit="150" MarginA="1" MarginB="2"/>
</gmr:Cols>
<gmr:Rows DefaultSizePts="12.8"/>
<gmr:Cells>
<gmr:Cell Col="0" Row="0" ValueType="60">current serial number:</gmr:Cell>
<gmr:Cell Col="1" Row="0" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="1" ValueType="60">today's serial number:</gmr:Cell>
<gmr:Cell Col="1" Row="1" ValueType="40">=today()</gmr:Cell>
<gmr:Cell Col="0" Row="2" ValueType="60">current time serial:</gmr:Cell>
<gmr:Cell Col="1" Row="2" ValueType="40">=now()-today()</gmr:Cell>
<gmr:Cell Col="0" Row="4" ValueType="60">date formats:</gmr:Cell>
<gmr:Cell Col="1" Row="4" ValueType="60">formatted serial number '37777,7':</gmr:Cell>
<gmr:Cell Col="2" Row="4" ValueType="60">formatted current serial number:</gmr:Cell>
<gmr:Cell Col="0" Row="5" ValueType="60">m/d/yy</gmr:Cell>
<gmr:Cell Col="1" Row="5" ValueType="40">37777,7</gmr:Cell>
<gmr:Cell Col="2" Row="5" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="6" ValueType="60">d-mmm-yy</gmr:Cell>
<gmr:Cell Col="1" Row="6" ValueType="40">37777,7</gmr:Cell>
<gmr:Cell Col="2" Row="6" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="7" ValueType="60">d-mmm</gmr:Cell>
<gmr:Cell Col="1" Row="7" ValueType="40">37777,7</gmr:Cell>
<gmr:Cell Col="2" Row="7" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="8" ValueType="60">mmm-yy</gmr:Cell>
<gmr:Cell Col="1" Row="8" ValueType="40">37777,7</gmr:Cell>
<gmr:Cell Col="2" Row="8" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="9" ValueType="60">h:mm AM/PM</gmr:Cell>
<gmr:Cell Col="1" Row="9" ValueType="40">37777,7</gmr:Cell>
<gmr:Cell Col="2" Row="9" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="10" ValueType="60">h:mm:ss AM/PM</gmr:Cell>
<gmr:Cell Col="1" Row="10" ValueType="40">37777,7</gmr:Cell>
<gmr:Cell Col="2" Row="10" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="11" ValueType="60">h:mm</gmr:Cell>
<gmr:Cell Col="1" Row="11" ValueType="40">37777,7</gmr:Cell>
<gmr:Cell Col="2" Row="11" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="12" ValueType="60">h:mm:ss</gmr:Cell>
<gmr:Cell Col="1" Row="12" ValueType="40">37777,7</gmr:Cell>
<gmr:Cell Col="2" Row="12" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="13" ValueType="60">m/d/yy h:mm</gmr:Cell>
<gmr:Cell Col="1" Row="13" ValueType="40">37777,7</gmr:Cell>
<gmr:Cell Col="2" Row="13" ValueType="40">=now()</gmr:Cell>
<gmr:Cell Col="0" Row="15" ValueType="60">We can also calculate with dates:</gmr:Cell>
<gmr:Cell Col="0" Row="16" ValueType="60">today plus one week:</gmr:Cell>
<gmr:Cell Col="1" Row="16" ValueType="40">=date(year(now()), month(now()), day(now()) + 7)</gmr:Cell>
<gmr:Cell Col="0" Row="17" ValueType="60">today plus three months:</gmr:Cell>
<gmr:Cell Col="1" Row="17" ValueType="40">=date(year(now()), month(now()) + 3, day(now()))</gmr:Cell>
<gmr:Cell Col="0" Row="18" ValueType="60">today minus 2 years:</gmr:Cell>
<gmr:Cell Col="1" Row="18" ValueType="40">=date(year(now()) - 2, month(now()), day(now()))</gmr:Cell>
</gmr:Cells>
</gmr:Sheet>
</gmr:Sheets>
</gmr:Workbook>