cocoon-cvs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jo...@apache.org
Subject cvs commit: cocoon-2.1/src/blocks/poi/samples/content simple-date-test.xml
Date Sat, 17 May 2003 11:57:53 GMT
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>
  
  
  

Mime
View raw message