Author: nickarls
Date: 2008-08-08 05:21:35 -0400 (Fri, 08 Aug 2008)
New Revision: 8632
Modified:
trunk/doc/Seam_Reference_Guide/en-US/Excel.xml
Log:
JBSEAM-3234: Format documentation according to standards
Modified: trunk/doc/Seam_Reference_Guide/en-US/Excel.xml
===================================================================
--- trunk/doc/Seam_Reference_Guide/en-US/Excel.xml 2008-08-08 08:28:15 UTC (rev 8631)
+++ trunk/doc/Seam_Reference_Guide/en-US/Excel.xml 2008-08-08 09:21:35 UTC (rev 8632)
@@ -1,53 +1,50 @@
-<?xml version="1.0" standalone="no"?>
+<?xml version="1.0" standalone="no"?>
<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd" [
<!ENTITY excel 'the <trademark
class="registered">Microsoft</trademark> <trademark
class="registered">Excel</trademark> spreadsheet application'>
<!ENTITY Excel 'The <trademark
class="registered">Microsoft</trademark> <trademark
class="registered">Excel</trademark> spreadsheet application'>
]>
-
-
-<chapter id="excel">
+<chapter id="excel">
<title>&Excel;</title>
<para>
- Seam also supports generation of
- &excel;
- spreadsheets through the excellent
- <ulink
url="http://jexcelapi.sourceforge.net/">JExcelAPI</ulink> library.
- The generated document is compatible with &excel;
- versions 95, 97, 2000, XP and 2003. Currently a limited subset of the
- library functionality is exposed but the ultimate goal is to be able to do
- everything the library allows for. Please refer to the JExcelAPI
- documentation for more information on capabilities and limitations.
+ Seam also supports generation of &excel; spreadsheets through the
+ excellent <ulink
url="http://jexcelapi.sourceforge.net/">JExcelAPI
+ </ulink> library. The generated document is compatible with
+ &excel; versions 95, 97, 2000, XP and 2003. Currently a limited
+ subset of the library functionality is exposed but the ultimate
+ goal is to be able to do everything the library allows for. Please
+ refer to the JExcelAPI documentation for more information on
+ capabilities and limitations.
</para>
<section id="excel.intro">
<title>&Excel; support</title>
<para>
- &Excel; <literal>jboss-seam-excel.jar</literal>. This JAR
contains the
- &excel; JSF controls, which are used to construct views that can render
- the document, and the DocumentStore component, which serves the
- rendered document to the user. To include &excel; support in your
- application, included <literal>jboss-seam-excel.jar</literal> in
your
- <literal>WEB-INF/lib</literal> directory along with the
- <literal>jxl.jar</literal> JAR file. Furthermore, you need to
configure
- the DocumentStore servlet in your web.xml
+ &Excel; <literal>jboss-seam-excel.jar</literal>. This JAR
contains
+ the &excel; JSF controls, which are used to construct views that can
+ render the document, and the DocumentStore component, which serves
+ the rendered document to the user. To include &excel; support in
+ your application, included <literal>jboss-seam-excel.jar</literal>
+ in your <literal>WEB-INF/lib</literal> directory along with the
+ <literal>jxl.jar</literal> JAR file. Furthermore, you need to
+ configure the DocumentStore servlet in your web.xml
</para>
<para>
- &Excel; Seam module requires the use of Facelets as the view
+ &Excel; Seam module requires the use of Facelets as the view
technology. Additionally, it requires the use of the seam-ui package.
</para>
<para>
- The <literal>examples/excel</literal> project contains an example of
- &excel; support in action. It demonstrates proper deployment packaging,
- and it shows the exposed functionality.
+ The <literal>examples/excel</literal> project contains an example
of
+ &excel; support in action. It demonstrates proper deployment
+ packaging, and it shows the exposed functionality.
</para>
<para>
- Customizing the module to support other kinds of &excel; spreadsheet
- API's has been made very easy. Implement the
- <literal>ExcelWorkbook</literal> interface, set the component name
to
- <literal>org.jboss.seam.excel.<myModule></literal> and
set the
- UIWorkbook type to <literal>myModule</literal> and your own exporter
- will be used. Default is "jxl", but support for CSV has also been
+ Customizing the module to support other kinds of &excel; spreadsheet
+ API's has been made very easy. Implement the <literal>ExcelWorkbook
+ </literal> interface, set the component name to
+ <literal>org.jboss.seam.excel.<myModule></literal> and
set the
+ UIWorkbook type to <literal>myModule</literal> and your own
exporter
+ will be used. Default is "jxl", but support for CSV has also been
added, using the type "csv".
</para>
@@ -55,44 +52,55 @@
<section id="excel.usage">
<title>Creating a simple workbook</title>
<para>
- Basic usage of the worksheet support is simple; it is used like a familiar
- <literal><h:dataTable></literal>
- and you can bind to a <literal>List</literal>,
<literal>Set</literal>,
- <literal>Map</literal>, <literal>Array</literal> or
+ Basic usage of the worksheet support is simple; it is used like a
+ familiar <literal><h:dataTable></literal> and you can
bind to a
+ <literal>List</literal>, <literal>Set</literal>,
+ <literal>Map</literal>, <literal>Array</literal> or
<literal>DataModel</literal>.
</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook
xmlns:e="http://jboss.com/products/seam/excel">
- <e:worksheet>
- <e:cell column="0" row="0" value="Hello
world!"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook
xmlns:e="http://jboss.com/products/seam/excel">
+ <e:worksheet>
+ <e:cell column="0" row="0" value="Hello
world!"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
- <para>That's not terribly useful, so lets have a look at a more common
case:</para>
+ <para>
+ That's not terribly useful, so lets have a look at a more common case:
+ </para>
<programlisting role="XML">
<![CDATA[
-<e:workbook
xmlns:e="http://jboss.com/products/seam/excel">
- <e:worksheet value="#{data}" var="item">
- <e:column>
- <e:cell value="#{item.value}"/>
- </e:worksheet>
-</e:workbook>
-]]>
+ <e:workbook
xmlns:e="http://jboss.com/products/seam/excel">
+ <e:worksheet value="#{data}" var="item">
+ <e:column>
+ <e:cell value="#{item.value}"/>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
<para>
- First we have the top-level workbook element which serves as the container and
it doesn't have any attributes.
- The child-element worksheet has two attributes;
value="#{data}" is the EL-binding to the data and
- var="item" is the name of the current item. Nested inside the
worksheet is a single column and within
- it you see the cell which is the final bind to the data within the currently
iterated item
+ First we have the top-level workbook element which serves as the
+ container and it doesn't have any attributes. The child-element
+ worksheet has two attributes; value="#{data}" is the
+ EL-binding to the data and var="item" is the name of the
+ current item. Nested inside the worksheet is a single column and within
+ it you see the cell which is the final bind to the data within the
+ currently iterated item
</para>
- <para>This is all you know to get started dumping your data to
worksheets!</para>
+ <para>
+ This is all you know to get started dumping your data to worksheets!
+ </para>
</section>
<section id="excel.workbook">
<title>Workbooks</title>
- <para>Workbooks are the top-level parents of worksheets, cell templates and
worksheet templates.</para>
+ <para>
+ Workbooks are the top-level parents of worksheets, cell templates and
+ worksheet templates.
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -112,154 +120,189 @@
<listitem>
<para>
<literal>type</literal>
- —Defines which export module to be used. The
value is a string and can be either
- "jxl" or "csv". The default is
"jxl".
+ —Defines which export module to be used. The
+ value is a string and can be either "jxl" or
+ "csv". The default is "jxl".
</para>
</listitem>
<listitem>
<para>
<literal>templateURI</literal>
- —A template that should be used as a basis for
the workbook. The value is a string
- (URI).
+ —A template that should be used as a basis
+ for the workbook. The value is a string (URI).
</para>
</listitem>
<listitem>
<para>
<literal>arrayGrowSize</literal>
- —The amount of memory by which to increase the
amount of memory allocated to storing
- the workbook data. For processeses reading many small
workbooks inside a WAS it might be
- necessary to reduce the default size Default value is 1
megabyte. The value is a number
- (bytes).
+ —The amount of memory by which to increase
+ the amount of memory allocated to storing the
+ workbook data. For processeses reading many small
+ workbooks inside a WAS it might be necessary to
+ reduce the default size Default value is 1
+ megabyte. The value is a number (bytes).
</para>
</listitem>
<listitem>
<para>
<literal>autoFilterDisabled</literal>
- —Should autofiltering be disabled?. The value is
a boolean.
+ —Should autofiltering be disabled?. The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>cellValidationDisabled</literal>
- —Shoule cell validation be ignored? The value is
a boolean.
+ —Shoule cell validation be ignored? The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>characterSet</literal>
- —The character set. This is only used when the
spreadsheet is read, and has no
- effect when the spreadsheet is written. The value is a
string (character set encoding).
+ —The character set. This is only used when
+ the spreadsheet is read, and has no effect when
+ the spreadsheet is written. The value is a string
+ (character set encoding).
</para>
</listitem>
<listitem>
<para>
<literal>drawingsDisabled</literal>
- —Should drawings be disabled? The value is a
boolean.
+ —Should drawings be disabled? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>excelDisplayLanguage</literal>
- —The language in which the generated file will
display. The value is a string (two
- character ISO 3166 country code).
+ —The language in which the generated file
+ will display. The value is a string (two character
+ ISO 3166 country code).
</para>
</listitem>
<listitem>
<para>
<literal>excelRegionalSettings</literal>
- —The regional settings for the generated excel
file. The value is a string (two
- character ISO 3166 country code).
+ —The regional settings for the generated
+ excel file. The value is a string (two character
+ ISO 3166 country code).
</para>
</listitem>
<listitem>
<para>
<literal>formulaAdjust</literal>
- —Should formulas be adjusted? The value is a
boolean.
+ —Should formulas be adjusted? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>gcDisabled</literal>
- —Should garbage collection be disabled? The value
is a boolean.
+ —Should garbage collection be disabled? The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>ignoreBlanks</literal>
- —Should blanks be ignored? The value is a
boolean.
+ —Should blanks be ignored? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>initialFileSize</literal>
- —The initial amount of memory allocated to store
the workbook data when reading a
- worksheet. For processeses reading many small workbooks
inside a WAS it might be necessary
- to reduce the default size Default value is 5 megabytes.
The value is a number (bytes).
+ —The initial amount of memory allocated to
+ store the workbook data when reading a worksheet.
+ For processeses reading many small workbooks
+ inside a WAS it might be necessary to reduce the
+ default size Default value is 5 megabytes. The
+ value is a number (bytes).
</para>
</listitem>
<listitem>
<para>
<literal>locale</literal>
- —The locale used by JExcelApi to generate the
spreadsheet. Setting this value has no
- effect on the language or region of the generated excel
file. The value is a string.
+ —The locale used by JExcelApi to generate
+ the spreadsheet. Setting this value has no effect
+ on the language or region of the generated excel
+ file. The value is a string.
</para>
</listitem>
<listitem>
<para>
<literal>mergedCellCheckingDisabled</literal>
- —Should merged cell checking be disabled? The
value is a boolean.
+ —Should merged cell checking be disabled?
+ The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>namesDisabled</literal>
- —Should handling of names be disabled? The value
is a boolean.
+ —Should handling of names be disabled? The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>propertySets</literal>
- —Should any property sets be enabled (such as
macros) to be copied along with the
- workbook? Leaving this feature enabled will result in the
JXL process using more memory.
- The value is a boolean.
+ —Should any property sets be enabled (such
+ as macros) to be copied along with the workbook?
+ Leaving this feature enabled will result in the
+ JXL process using more memory. The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>rationalization</literal>
- —Should the cell formats be rationalized before
writing out the sheet? The value is
- a boolean. Default is true.
+ —Should the cell formats be rationalized
+ before writing out the sheet? The value is a
+ boolean. Default is true.
</para>
</listitem>
<listitem>
<para>
<literal>supressWarnings</literal>
- —Should warnings be suppressed?. Due to the
change in logging in version 2.4, this
- will now set the warning behaviour across the JVM
(depending on the type of logger used).
- The value is a boolean.
+ —Should warnings be suppressed?. Due to the
+ change in logging in version 2.4, this will now
+ set the warning behaviour across the JVM
+ (depending on the type of logger used). The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
-
<literal>temporaryFileDuringWriteDirectory</literal>
- —Used in conjunction with the
<literal>useTemporaryFileDuringWrite</literal> setting to set the target
- directory for the temporary files. This value can be NULL,
in which case the normal system
- default temporary directory is used instead. The value is a
string (the directory to which
- temporary files should be written).
+ <literal>
+ temporaryFileDuringWriteDirectory
+ </literal>
+ —Used in conjunction with the
+ <literal>useTemporaryFileDuringWrite</literal>
+ setting to set the target directory for the
+ temporary files. This value can be NULL, in which
+ case the normal system default temporary directory
+ is used instead. The value is a string (the
+ directory to which temporary files should be
+ written).
</para>
</listitem>
<listitem>
<para>
<literal>useTemporaryFileDuringWrite</literal>
- —Should a temporary file is used during the
generation of the workbook. If not set,
- the workbook will take place entirely in memory. Setting
this flag involves an assessment
- of the trade-offs between memory usage and performance. The
value is a boolean.
+ —Should a temporary file is used during the
+ generation of the workbook. If not set, the
+ workbook will take place entirely in memory.
+ Setting this flag involves an assessment of the
+ trade-offs between memory usage and performance.
+ The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>workbookProtected</literal>
- —Should the workbook be protected? The value is a
boolean.
+ —Should the workbook be protected? The value
+ is a boolean.
</para>
</listitem>
</itemizedlist>
@@ -270,19 +313,25 @@
<listitem>
<para>
<literal><e:cellTemplate/></literal>
- —Zero or more cell templates (see <xref
linkend="excel.templates.cell"/>).
+ —Zero or more cell templates (see
+ <xref linkend="excel.templates.cell" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:worksheetTemplate/></literal>
- —Zero or more worksheet templates (see <xref
linkend="excel.templates.worksheetsettings"/>).
+ —Zero or more worksheet templates (see
+ <xref
linkend="excel.templates.worksheetsettings" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:worksheet/></literal>
- —Zero or more worksheets (see <xref
linkend="excel.worksheet"/>).
+ —Zero or more worksheets (see
+ <xref linkend="excel.worksheet" />
+ ).
</para>
</listitem>
</itemizedlist>
@@ -303,11 +352,11 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:cell value="Hello World" row="0"
column="0"/>
- </e:worksheet>
-<e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:cell value="Hello World" row="0"
column="0"/>
+ </e:worksheet>
+ <e:workbook>
]]>
</programlisting>
<para>defines a workbook with a worksheet and a greeting at A1</para>
@@ -316,9 +365,10 @@
<section id="excel.worksheet">
<title>Worksheets</title>
<para>
- Worksheets are the children of workbooks and the parent of columns and worksheet
commands
- They can also contain explicitly placed cells, formulas, images and hyperlinks.
They are the
- pages that make up the workbook.
+ Worksheets are the children of workbooks and the parent of columns and
+ worksheet commands They can also contain explicitly placed cells,
+ formulas, images and hyperlinks. They are the pages that make up the
+ workbook.
</para>
<informaltable>
<tgroup cols="2">
@@ -336,252 +386,303 @@
<listitem>
<para>
<literal>value</literal>
- —An EL-expression to the backing data. The value
is a string.
+ —An EL-expression to the backing data. The
+ value is a string.
</para>
</listitem>
<listitem>
<para>
<literal>var</literal>
- —The current row iterator variable name that can
later be referenced in cell value
- attributes. The value is a string
+ —The current row iterator variable name that
+ can later be referenced in cell value attributes.
+ The value is a string
</para>
</listitem>
<listitem>
<para>
<literal>name</literal>
- —The name of the worksheet. The valus is a
string. Defaults to Sheet# where # is the
- worksheet index. If the given worksheet name exists, that
sheet is selected. This can be
- used for merging several data sets into a single worksheet,
just define the same name for
- them (using <literal>startRow</literal> and
<literal>startCol</literal> to make sure that they don't occupy the same
space).
+ —The name of the worksheet. The valus is a
+ string. Defaults to Sheet# where # is the
+ worksheet index. If the given worksheet name
+ exists, that sheet is selected. This can be used
+ for merging several data sets into a single
+ worksheet, just define the same name for them
+ (using
+ <literal>startRow</literal>
+ and
+ <literal>startCol</literal>
+ to make sure that they don't occupy the same
+ space).
</para>
</listitem>
<listitem>
<para>
<literal>startRow</literal>
- —Defines the starting row for the data. The value
is a number. Used for placing the
- data in other places than the upper-left corner (especially
useful if having multiple data
- sets for a single worksheet). The defaults is 0.
+ —Defines the starting row for the data. The
+ value is a number. Used for placing the data in
+ other places than the upper-left corner
+ (especially useful if having multiple data sets
+ for a single worksheet). The defaults is 0.
</para>
</listitem>
<listitem>
<para>
<literal>startColumn</literal>
- —Defines the starting column for the data. The
value is a number. Used for placing
- the data in other places than the upper-left corner
(especially useful if having multiple
- data sets for a single worksheet). The default is 0.
+ —Defines the starting column for the data.
+ The value is a number. Used for placing the data
+ in other places than the upper-left corner
+ (especially useful if having multiple data sets
+ for a single worksheet). The default is 0.
</para>
</listitem>
<listitem>
<para>
<literal>templates</literal>
- —The comma-separated list of
<literal>worksheetTemplates</literal> to cascade on. The value is a
- string (see <xref
linkend="excel.templates.cell"/>).
+ —The comma-separated list of
+ <literal>worksheetTemplates</literal>
+ to cascade on. The value is a string (see
+ <xref linkend="excel.templates.cell" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>automaticFormulaCalculation</literal>
- —Should formulas be automatically calculated? The
value is a boolean.
+ —Should formulas be automatically
+ calculated? The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>bottomMargin</literal>
- —The bottom margin. The value is a number
(inches)
+ —The bottom margin. The value is a number
+ (inches)
</para>
</listitem>
<listitem>
<para>
<literal>copies</literal>
- —The number of copies. The value is a number.
+ —The number of copies. The value is a
+ number.
</para>
</listitem>
<listitem>
<para>
<literal>defaultColumnWidth</literal>
- —The default column width. The value is a number
(characters * 256).
+ —The default column width. The value is a
+ number (characters * 256).
</para>
</listitem>
<listitem>
<para>
<literal>defaultRowHeight</literal>
- —The default row height. The value is a number
(1/20ths of a point).
+ —The default row height. The value is a
+ number (1/20ths of a point).
</para>
</listitem>
<listitem>
<para>
<literal>displayZeroValues</literal>
- —Should zero-values be displayed? The value is a
boolean.
+ —Should zero-values be displayed? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>fitHeight</literal>
- —The number of pages vertically that this sheet
will be printed into. The value is a
- number.
+ —The number of pages vertically that this
+ sheet will be printed into. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>fitToPages</literal>
- —Should printing be fit to pages? The value is a
boolean.
+ —Should printing be fit to pages? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>fitWidth</literal>
- —The number of pages widthwise which this sheet
should be printed into. The value is
- a number.
+ —The number of pages widthwise which this
+ sheet should be printed into. The value is a
+ number.
</para>
</listitem>
<listitem>
<para>
<literal>footerMargin</literal>
- —The margin for any page footer. The value is a
number (inches).
+ —The margin for any page footer. The value
+ is a number (inches).
</para>
</listitem>
<listitem>
<para>
<literal>headerMargin</literal>
- —The margin for any page headers. The value is a
number (inches).
+ —The margin for any page headers. The value
+ is a number (inches).
</para>
</listitem>
<listitem>
<para>
<literal>hidden</literal>
- —Should the worksheet be hidden? The value is a
boolean.
+ —Should the worksheet be hidden? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>horizontalCentre</literal>
- —Should the worksheet be centered horizontally?
The value is a boolean.
+ —Should the worksheet be centered
+ horizontally? The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>horizontalFreeze</literal>
- —The row at which the pane is frozen vertically.
The value is a number.
+ —The row at which the pane is frozen
+ vertically. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>horizontalPrintResolution</literal>
- —The horizontal print resolution. The value is a
number.
+ —The horizontal print resolution. The value
+ is a number.
</para>
</listitem>
<listitem>
<para>
<literal>leftMargin</literal>
- —The left margin. The value is a number
(inches).
+ —The left margin. The value is a number
+ (inches).
</para>
</listitem>
<listitem>
<para>
<literal>normalMagnification</literal>
- —The normal magnificaton factor (not zoom or
scale factor). The value is a number
- (percentage).
+ —The normal magnificaton factor (not zoom or
+ scale factor). The value is a number (percentage).
</para>
</listitem>
<listitem>
<para>
<literal>orientation</literal>
- —The paper orientation for printing this sheet.
The value is a string that can be
- either "landscape" or "portrait".
+ —The paper orientation for printing this
+ sheet. The value is a string that can be either
+ "landscape" or "portrait".
</para>
</listitem>
<listitem>
<para>
<literal>pageBreakPreviewMagnification</literal>
- —The page break preview magnificaton factor (not
zoom or scale factors). the value
- is a number (percentage).
+ —The page break preview magnificaton factor
+ (not zoom or scale factors). the value is a number
+ (percentage).
</para>
</listitem>
<listitem>
<para>
<literal>pageBreakPreviewMode</literal>
- —Show page in preview mode? The value is a
boolean.
+ —Show page in preview mode? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>pageStart</literal>
- —The page number at which to commence printing.
The value is a number.
+ —The page number at which to commence
+ printing. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>paperSize</literal>
- —The paper size to be used when printing this
sheet. The value is a string that can
- be one of "a4", "a3",
"letter", "legal" etc (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
+ —The paper size to be used when printing
+ this sheet. The value is a string that can be one
+ of "a4", "a3", "letter",
"legal" etc (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.PaperSize
+ </ulink>
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>password</literal>
- —The password for this sheet. The value is a
string.
+ —The password for this sheet. The value is a
+ string.
</para>
</listitem>
<listitem>
<para>
<literal>passwordHash</literal>
- —The password hash - used only when copying
sheets. The value is a string.
+ —The password hash - used only when copying
+ sheets. The value is a string.
</para>
</listitem>
<listitem>
<para>
<literal>printGridLines</literal>
- —Should grid lines be printed? The value is a
boolean.
+ —Should grid lines be printed? The value is
+ a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>printHeaders</literal>
- —Should headers be printed? The value is a
boolean.
+ —Should headers be printed? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>sheetProtected</literal>
- —Should the sheet be protected (read-only)? The
value is a boolean.
+ —Should the sheet be protected (read-only)?
+ The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>recalculateFormulasBeforeSave</literal>
- —Should the formulas be re-calculated when the
sheet is saved? The value is a
- boolean. false
+ —Should the formulas be re-calculated when
+ the sheet is saved? The value is a boolean. false
</para>
</listitem>
<listitem>
<para>
<literal>rightMargin</literal>
- —The right margin. The value is a number
(inches).
+ —The right margin. The value is a number
+ (inches).
</para>
</listitem>
<listitem>
<para>
<literal>scaleFactor</literal>
- —The scale factor for this sheet to be used when
printing. The value is a number
- (percent).
+ —The scale factor for this sheet to be used
+ when printing. The value is a number (percent).
</para>
</listitem>
<listitem>
<para>
<literal>selected</literal>
- —Should the sheet be selected when the workbook
opens? The value is a boolean.
+ —Should the sheet be selected when the
+ workbook opens? The value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>showGridLines</literal>
- —Should gridlines be shown? The value is a
boolean.
+ —Should gridlines be shown? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>topMargin</literal>
- —The top margin. The value is a number (inches).
+ —The top margin. The value is a number
+ (inches).
</para>
</listitem>
<listitem>
@@ -593,21 +694,24 @@
<listitem>
<para>
<literal>verticalFreeze</literal>
- —The row at which the pane is frozen vertically.
The value is a number.
+ —The row at which the pane is frozen
+ vertically. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>verticalPrintResolution</literal>
- —The vertical print resolution. The value is a
number.
+ —The vertical print resolution. The value is
+ a number.
</para>
</listitem>
<listitem>
<para>
<literal>zoomFactor</literal>
- —T zoom factor. Do not confuse zoom factor (which
relates to the on screen view)
- with scale factor (which refers to the scale factor when
printing). The value is a number
- (percentage.
+ —T zoom factor. Do not confuse zoom factor
+ (which relates to the on screen view) with scale
+ factor (which refers to the scale factor when
+ printing). The value is a number (percentage.
</para>
</listitem>
</itemizedlist>
@@ -618,24 +722,33 @@
<listitem>
<para>
<literal><e:printArea/></literal>
- —Zero or more print area definitions (see
<xref linkend="excel.printareatitles"/>).
+ —Zero or more print area definitions (see
+ <xref linkend="excel.printareatitles" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:printTitle/></literal>
- —Zero or more print title definitions (see
<xref linkend="excel.printareatitles"/>).
+ —Zero or more print title definitions (see
+ <xref linkend="excel.printareatitles" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:headerFooter/></literal>
- —Zero or more header/footer definitions ((see
<xref linkend="excel.headersfooters"/>)).
+ —Zero or more header/footer definitions
+ ((see
+ <xref linkend="excel.headersfooters" />
+ )).
</para>
</listitem>
<listitem>
<para>
- Zero or more worksheet commands (see <xref
linkend="excel.worksheetcommands"/> ).
+ Zero or more worksheet commands (see
+ <xref linkend="excel.worksheetcommands" />
+ ).
</para>
</listitem>
</itemizedlist>
@@ -656,16 +769,16 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet name="foo" startColumn="1"
startRow="1">
- <e:column value="#{personList}" var="person">
- <f:facet name="header">
- <e:cell value="Last name"/>
- </f:facet>
- <e:cell value="#{person.lastName}"/>
- </e:column>
- </e:worksheet>
-<e:workbook>
+ <e:workbook>
+ <e:worksheet name="foo" startColumn="1"
startRow="1">
+ <e:column value="#{personList}" var="person">
+ <f:facet name="header">
+ <e:cell value="Last name"/>
+ </f:facet>
+ <e:cell value="#{person.lastName}"/>
+ </e:column>
+ </e:worksheet>
+ <e:workbook>
]]>
</programlisting>
<para>defines a worksheet with the name "foo", starting at
B2.</para>
@@ -673,8 +786,9 @@
<section id="excel.columns">
<title>Columns</title>
<para>
- Columns are the children of worksheets and the parents of cells, images,
formulas and hyperlinks.
- They are the structure that control the iteration of the worksheet data.
+ Columns are the children of worksheets and the parents of cells,
+ images, formulas and hyperlinks. They are the structure that control
+ the iteration of the worksheet data.
</para>
<informaltable>
<tgroup cols="2">
@@ -695,19 +809,22 @@
<listitem>
<para>
<literal>autoSize</literal>
- —Should the column be autosized? The value is a
boolean.
+ —Should the column be autosized? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>hidden</literal>
- —Should the column be hidden? The value is a
boolean.
+ —Should the column be hidden? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>width</literal>
- —The width of the column. The valus ia number
(characters multiplied by 256)
+ —The width of the column. The valus ia
+ number (characters multiplied by 256)
</para>
</listitem>
</itemizedlist>
@@ -718,25 +835,33 @@
<listitem>
<para>
<literal><e:cell/></literal>
- —Zero or more cells (see <xref
linkend="excel.cells"/>).
+ —Zero or more cells (see
+ <xref linkend="excel.cells" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:formula/></literal>
- —Zero or more formulas (see <xref
linkend="excel.formulas"/>).
+ —Zero or more formulas (see
+ <xref linkend="excel.formulas" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:image/></literal>
- —Zero or more images (see <xref
linkend="excel.images"/>).
+ —Zero or more images (see
+ <xref linkend="excel.images" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:hyperLink/></literal>
- —Zero or more hyperlinks (see <xref
linkend="excel.hyperlinks"/>).
+ —Zero or more hyperlinks (see
+ <xref linkend="excel.hyperlinks" />
+ ).
</para>
</listitem>
</itemizedlist>
@@ -766,16 +891,16 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <f:facet name="header">
- <e:cell value="Last name"/>
- </f:facet>
- <e:cell value="#{person.lastName}"/>
- </e:column>
- </e:worksheet>
-<e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <f:facet name="header">
+ <e:cell value="Last name"/>
+ </f:facet>
+ <e:cell value="#{person.lastName}"/>
+ </e:column>
+ </e:worksheet>
+ <e:workbook>
]]>
</programlisting>
<para>defines a column with a header and an iterated output</para>
@@ -784,10 +909,12 @@
<section id="excel.cells">
<title>Cells</title>
<para>
- Cells are nested within columns (for iteration) or inside worksheets (for direct
placement using the <literal>column</literal> and
- <literal>row</literal> attributes) and are responsible for
outputting the value (usually though en EL-expression involving the
- <literal>var</literal>-attribute of the datatable. They can contains
fonts and other formattings and can also use pre-defined
- templates.
+ Cells are nested within columns (for iteration) or inside worksheets
+ (for direct placement using the <literal>column</literal> and
+ <literal>row</literal> attributes) and are responsible for
outputting
+ the value (usually though en EL-expression involving the
+ <literal>var</literal>-attribute of the datatable. They can contain
+ fonts and other formattings and can also use pre-defined templates.
</para>
<informaltable>
<tgroup cols="2">
@@ -808,108 +935,130 @@
<listitem>
<para>
<literal>column</literal>
- —The column where to place the cell. The default
is the internal counter. The value
- is a number. Note that the value is 0-based.
+ —The column where to place the cell. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>row</literal>
- —The row where to place the cell. The default is
the internal counter. The value is
+ —The row where to place the cell. The
+ default is the internal counter. The value is
number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>value</literal>
- —The value to display. Usually an EL-expression
referencing the var-attribute of the
+ —The value to display. Usually an
+ EL-expression referencing the var-attribute of the
containing datatable. The value is a string.
</para>
</listitem>
<listitem>
<para>
<literal>templates</literal>
- —A comma-separated list of cascading, predefined
templates to apply before the own
- formattings (see <xref
linkend="excel.templates.cell"/>).
+ —A comma-separated list of cascading,
+ predefined templates to apply before the own
+ formattings (see
+ <xref linkend="excel.templates.cell" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>forceType</literal>
- —The forced type of the cell data. The value is a
string that can be one of
- "general", "number", "text",
"date", "formula" or "bool". The type is automatically
- detected so there is rarely any use for this attribute.
+ —The forced type of the cell data. The value
+ is a string that can be one of "general",
+ "number", "text", "date",
"formula" or "bool". The
+ type is automatically detected so there is rarely
+ any use for this attribute.
</para>
</listitem>
<listitem>
<para>
<literal>alignment</literal>
- —The alignment of the cell data. The value is a
string that can be one of "centre",
- "fill", "general", "justify",
"left" or "right".
+ —The alignment of the cell data. The value
+ is a string that can be one of "centre",
"fill",
+ "general", "justify", "left"
or "right".
</para>
</listitem>
<listitem>
<para>
<literal>comment</literal>
- —A comment to add to the cell. The value is a
string.
+ —A comment to add to the cell. The value is
+ a string.
</para>
</listitem>
<listitem>
<para>
<literal>commentHeight</literal>
- —The height of the comment. The value is a number
(in pixels).
+ —The height of the comment. The value is a
+ number (in pixels).
</para>
</listitem>
<listitem>
<para>
<literal>commentWidth</literal>
- —A width of the comment. The value is a number
(in pixels).
+ —A width of the comment. The value is a
+ number (in pixels).
</para>
</listitem>
<listitem>
<para>
<literal>indentation</literal>
- —The indentation of the cell. The value is a
number (in pixels)
+ —The indentation of the cell. The value is a
+ number (in pixels)
</para>
</listitem>
<listitem>
<para>
<literal>locked</literal>
- —Should the cell be locked? For this to have any
effect, the sheet containing cells
- with this format must also be locked. The value is a
boolean.
+ —Should the cell be locked? For this to have
+ any effect, the sheet containing cells with this
+ format must also be locked. The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>mask</literal>
- —A format mask (see <xref
linkend="excel.cells.formatmasks"/>).
+ —A format mask (see
+ <xref linkend="excel.cells.formatmasks" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>orientation</literal>
- —The orientation of the cell data. The value is a
string that can be one of
- "horizontal", "minus_45",
"minus_90", "plus_45", "plus_90", "stacked" or
"vertical".
+ —The orientation of the cell data. The value
+ is a string that can be one of "horizontal",
+ "minus_45", "minus_90",
"plus_45", "plus_90",
+ "stacked" or "vertical".
</para>
</listitem>
<listitem>
<para>
<literal>shrinkToFit</literal>
- —Should the cell data be shrunk to fit? The value
is a boolean.
+ —Should the cell data be shrunk to fit? The
+ value is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>verticalAlignment</literal>
- —The vertical aligment of the cell data. The
value is a string that can be one of
- "bottom", "centre", "justify"
or "top").
+ —The vertical aligment of the cell data. The
+ value is a string that can be one of "bottom",
+ "centre", "justify" or
"top").
</para>
</listitem>
<listitem>
<para>
<literal>wrap</literal>
- —Should the data be wrapped so that it fits
within the cell boundaries? The value is
- a boolean.
+ —Should the data be wrapped so that it fits
+ within the cell boundaries? The value is a
+ boolean.
</para>
</listitem>
</itemizedlist>
@@ -921,24 +1070,32 @@
<listitem>
<para>
<literal><e:font/></literal>
- —Zero or more font definitions (see <xref
linkend="excel.cells.fonts"/>).
+ —Zero or more font definitions (see
+ <xref linkend="excel.cells.fonts" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:border/></literal>
- —Zero or more border definitions (see <xref
linkend="excel.cells.borders"/>).
+ —Zero or more border definitions (see
+ <xref linkend="excel.cells.borders" />
+ ).
</para>
</listitem>
<listitem>
<para>
<literal><e:background/></literal>
- —Zero or more background definitions (see
<xref linkend="excel.cells.backgrounds"/>).
+ —Zero or more background definitions (see
+ <xref linkend="excel.cells.backgrounds" />
+ ).
</para>
</listitem>
<listitem>
<para>
- Zero or more validation conditions (see <xref
linkend="excel.cells.validation"/>).
+ Zero or more validation conditions (see
+ <xref linkend="excel.cells.validation" />
+ ).
</para>
</listitem>
@@ -960,23 +1117,24 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <f:facet name="header">
- <e:cell value="Last name"/>
- </f:facet>
- <e:cell value="#{person.lastName}"/>
- </e:column>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}"
var="person">
+ <f:facet name="header">
+ <e:cell value="Last name"/>
+ </f:facet>
+ <e:cell value="#{person.lastName}"/>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>defines a column with a header and an iterated output</para>
<section id="excel.cells.fonts">
<title>Fonts</title>
<para>
- Fonts are nested inside cells, formulas, hyperlinks or cell templates. They
determine the typeface of the cell data
+ Fonts are nested inside cells, formulas, hyperlinks or cell
+ templates. They determine the typeface of the cell data
</para>
<informaltable>
<tgroup cols="2">
@@ -997,54 +1155,72 @@
<listitem>
<para>
<literal>fontName</literal>
- —The font name. The value is a string. Should
be used with care, since the used
- font must be recognized by the <trademark
class="registered">Microsoft</trademark>
- <trademark
class="registered">Excel</trademark> spreadsheet application
+ —The font name. The value is a string.
+ Should be used with care, since the used font
+ must be recognized by the
+ <trademark class="registered">
+ Microsoft
+ </trademark>
+ <trademark
class="registered">Excel</trademark>
+ spreadsheet application
</para>
</listitem>
<listitem>
<para>
<literal>color</literal>
- —The color of the background. The value is a
string that can be one of "blue",
- "red" etc (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
+ —The color of the background. The value
+ is a string that can be one of "blue",
"red"
+ etc (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>pointSize</literal>
- —The point size of the font. The value is a
number.
+ —The point size of the font. The value is
+ a number.
</para>
</listitem>
<listitem>
<para>
<literal>bold</literal>
- —Should the font be bold? The value is a
boolean.
+ —Should the font be bold? The value is a
+ boolean.
</para>
</listitem>
<listitem>
<para>
<literal>italic</literal>
- —Should the font be italic? The value is a
boolean.
+ —Should the font be italic? The value is
+ a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>struckOut</literal>
- —Should the font be struck out? The value is a
boolean.
+ —Should the font be struck out? The value
+ is a boolean.
</para>
</listitem>
<listitem>
<para>
<literal>scriptStyle</literal>
- —The script style of the font. The value is a
string that can be one of
- "normal_script", "subscript" or
"superscript".
+ —The script style of the font. The value
+ is a string that can be one of
"normal_script",
+ "subscript" or "superscript".
</para>
</listitem>
<listitem>
<para>
<literal>underlineStyle</literal>
- —The underline style of the font. The value is
a string that can be one of
- "double", "double_accounting",
"no_underline", "single" or "single_accounting".
+ —The underline style of the font. The
+ value is a string that can be one of
"double",
+ "double_accounting", "no_underline",
"single"
+ or "single_accounting".
</para>
</listitem>
</itemizedlist>
@@ -1075,15 +1251,15 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.age">
- <e:font fontName="Times New Roman" color="red"
bold="true"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}" var="person">
+ <e:cell value="#{person.age">
+ <e:font fontName="Times New Roman"
color="red" bold="true"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>defines a cell with a red, bold, Times New Roman font.</para>
@@ -1091,8 +1267,8 @@
<section id="excel.cells.backgrounds">
<title>Backgrounds</title>
<para>
- Backgrounds are nested inside cells, formulas, hyperlinks or cell templates.
They determine
- the color and pattern of the cell.
+ Backgrounds are nested inside cells, formulas, hyperlinks or cell
+ templates. They determine the color and pattern of the cell.
</para>
<informaltable>
<tgroup cols="2">
@@ -1113,16 +1289,22 @@
<listitem>
<para>
<literal>pattern</literal>
- —The pattern of the background. The value is a
string that can be one of "solid",
- "grey_25" etc (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
The
- default is "solid".
+ —The pattern of the background. The value
+ is a string that can be one of "solid",
+ "grey_25" etc (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Pattern
+ </ulink>
+ ). The default is "solid".
</para>
</listitem>
<listitem>
<para>
<literal>color</literal>
- —The color of the background. The value is a
string that can be one of "blue",
- "red" etc
+ —The color of the background. The value
+ is a string that can be one of "blue",
"red"
+ etc
</para>
</listitem>
</itemizedlist>
@@ -1153,15 +1335,15 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.age">
- <e:background color="green" pattern="grey_25"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}"
var="person">
+ <e:cell value="#{person.age">
+ <e:background color="green"
pattern="grey_25"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>defined a green cell background with a 25% grey mask.</para>
@@ -1169,8 +1351,9 @@
<section id="excel.cells.borders">
<title>Borders</title>
<para>
- Borders are nested inside cells, formulas, hyperlinks and cell templates.
- They determine the color and line style of the cell borders.
+ Borders are nested inside cells, formulas, hyperlinks and cell
+ templates. They determine the color and line style of the cell
+ borders.
</para>
<informaltable>
<tgroup cols="2">
@@ -1191,22 +1374,36 @@
<listitem>
<para>
<literal>border</literal>
- —The border to apply the settings to. The
value is a string that can be one of
- "all", "bottom", "left",
"none", "right" or "top". The default is "all".
+ —The border to apply the settings to. The
+ value is a string that can be one of "all",
+ "bottom", "left", "none",
"right" or "top". The
+ default is "all".
</para>
</listitem>
<listitem>
<para>
<literal>lineStyle</literal>
- —The border line style. The value is a string
that can be one of "medium", "thin"
- etc (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
+ —The border line style. The value is a
+ string that can be one of "medium",
"thin" etc
+ (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.BorderLineStyle
+ </ulink>
+ ).
</para>
</listitem>
<listitem>
<para>
<literal>color</literal>
- —The color of the border. The value is a
string that can be one of "blue", "red"
- etc (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
+ —The color of the border. The value is a
+ string that can be one of "blue",
"red" etc
+ (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
</para>
</listitem>
</itemizedlist>
@@ -1237,23 +1434,23 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.age">
- <e:border border="left" color="green"
lineStyle="thin"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}"
var="person">
+ <e:cell value="#{person.age">
+ <e:border border="left" color="green"
lineStyle="thin"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
<para>defined a thin green border on the left edge of the
cell.</para>
</section>
<section id="excel.cells.validation">
<title>Validation</title>
<para>
- Validations are nested inside cells, formulas or cell templates.
+ Validations are nested inside cells, formulas or cell templates.
They add constrains for the cell data.
</para>
<informaltable>
@@ -1275,46 +1472,57 @@
<listitem>
<para>
<literal>value</literal>
- —The limit (or lower limit where applicable)
of the validation. The value is a
+ —The limit (or lower limit where
+ applicable) of the validation. The value is a
number.
</para>
</listitem>
<listitem>
<para>
<literal>value2</literal>
- —The upper limit (where applicable) of the
validation. The value is a number.
+ —The upper limit (where applicable) of
+ the validation. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>condition</literal>
- —The validation condition. The value is a
string.
+ —The validation condition. The value is a
+ string.
<itemizedlist>
<listitem>
- "equal" - requires the cell value to
match the one defined in the value-attribute
+ "equal" - requires the cell value to
+ match the one defined in the
+ value-attribute
</listitem>
<listitem>
- "greater_equal" - requires the cell
value to be greater than or equal to the
- value defined in the value-attribute
+ "greater_equal" - requires the cell
value
+ to be greater than or equal to the value
+ defined in the value-attribute
</listitem>
<listitem>
- "less_equal" - requires the cell value
to be less than or equal to the value
+ "less_equal" - requires the cell value
to
+ be less than or equal to the value
defined in the value-attribute
</listitem>
<listitem>
- "less_than" - requires the cell value to
be less than the value defined in the
+ "less_than" - requires the cell value
to
+ be less than the value defined in the
value-attribute
</listitem>
<listitem>
- "not_equal" - requires the cell value to
not match the one defined in the
+ "not_equal" - requires the cell value
to
+ not match the one defined in the
value-attribute
</listitem>
<listitem>
- "between" - requires the cell value to
be between the values defined in the
- value- and value2 attributes
+ "between" - requires the cell value to
be
+ between the values defined in the value-
+ and value2 attributes
</listitem>
<listitem>
- "not_between" - requires the cell value
not to be between the values defined in
+ "not_between" - requires the cell value
+ not to be between the values defined in
the value- and value2 attributes
</listitem>
</itemizedlist>
@@ -1348,18 +1556,22 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.age">
- <e:numericValidation condition="between" value="4"
value2="18"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}"
var="person">
+ <e:cell value="#{person.age">
+ <e:numericValidation condition="between"
value="4"
+ value2="18"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>adds numeric validation to a cell specifying that the value must be
between 4 and 18.</para>
+ <para>
+ adds numeric validation to a cell specifying that the value must be
+ between 4 and 18.
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1379,29 +1591,30 @@
<listitem>
<para>
<literal>startColumn</literal>
- —The starting column of the range of values to
validate against. The value is a
+ —The starting column of the range of
+ values to validate against. The value is a
number.
</para>
</listitem>
<listitem>
<para>
<literal>startRow</literal>
- —The starting row of the range of values to
validate against. The value is a
- number.
+ —The starting row of the range of values
+ to validate against. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>endColumn</literal>
- —The ending column of the range of values to
validate against. The value is a
- number.
+ —The ending column of the range of values
+ to validate against. The value is a number.
</para>
</listitem>
<listitem>
<para>
<literal>endRow</literal>
- —The ending row of the range of values to
validate against. The value is a
- number.
+ —The ending row of the range of values to
+ validate against. The value is a number.
</para>
</listitem>
</itemizedlist>
@@ -1432,19 +1645,21 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.position">
- <e:rangeValidation startColumn="0" startRow="0"
endColumn="0" endRow="10"/>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}"
var="person">
+ <e:cell value="#{person.position">
+ <e:rangeValidation startColumn="0"
startRow="0"
+ endColumn="0" endRow="10"/>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
<para>
- adds validation to a cell specifying that the value must be in the values
specified in range A1:A10.
+ adds validation to a cell specifying that the value must be in the
+ values specified in range A1:A10.
</para>
<informaltable>
<tgroup cols="2">
@@ -1474,7 +1689,9 @@
<itemizedlist>
<listitem>
<para>
- <literal>Zero or more list validation
items.</literal>
+ <literal>
+ Zero or more list validation items.
+ </literal>
</para>
</listitem>
</itemizedlist>
@@ -1493,7 +1710,10 @@
</tbody>
</tgroup>
</informaltable>
- <para>e:listValidation is a just a container for holding multiple
e:listValidationItem tags.</para>
+ <para>
+ e:listValidation is a just a container for holding multiple
+ e:listValidationItem tags.
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1544,50 +1764,77 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:column value="#{personList}" var="person">
- <e:cell value="#{person.position">
- <e:listValidation>
- <e:listValidationItem value="manager"/>
- <e:listValidationItem value="employee"/>
- </e:listValidation>
- </e:cell>
- </e:column>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:column value="#{personList}"
var="person">
+ <e:cell value="#{person.position">
+ <e:listValidation>
+ <e:listValidationItem value="manager"/>
+ <e:listValidationItem value="employee"/>
+ </e:listValidation>
+ </e:cell>
+ </e:column>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>adds validation to a cell specifying that the value must be
"manager" or "employee".</para>
+ <para>
+ adds validation to a cell specifying that the value must be
+ "manager" or "employee".
+ </para>
</section>
<section id="excel.cells.formatmasks">
<title>Format masks</title>
<para>
- Format masks are defined in the mask attribute in cell templates, cells or
formulas.
- <emphasis>Note that when using templates, the format mask must be
placed in the first template</emphasis>
- to be cascaded since the constructor hierarchy in
<literal>JExcelAPI</literal> used for copying cell formats makes it hard to
- change the format mask at a later stage. There are two types of format masks,
one for numbers and one for
- dates
+ Format masks are defined in the mask attribute in cell templates,
+ cells or formulas. <emphasis>Note that when using templates, the
+ format mask must be placed in the first template</emphasis>
+ to be cascaded since the constructor hierarchy in
+ <literal>JExcelAPI</literal> used for copying cell formats makes
+ it hard to change the format mask at a later stage. There are two
+ types of format masks, one for numbers and one for dates
</para>
<section id="excel.formatmasks.numbers">
<title>Number masks</title>
<para>
- When encountering a format mask, first it is checked if it is in internal
form, e.g "format1",
- "accounting_float" and so on (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
+ When encountering a format mask, first it is checked if it is in
+ internal form, e.g "format1", "accounting_float" and
so on (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.write.NumberFormats
+ </ulink>
+ ).
</para>
<para>
- if the mask is not in the list, it is treated as a custom mask (see
<ulink
url="http://java.sun.com/javase/6/docs/api/java/text/DecimalFormat.h...>).
- e.g "0.00" and automatically converted to the closest match.
+ if the mask is not in the list, it is treated as a custom mask
+ (see
+ <ulink
+
url="http://java.sun.com/javase/6/docs/api/java/text/DecimalFormat.h...
+ java.text.DecimalFormat
+ </ulink>
+ ). e.g "0.00" and automatically converted to the closest match.
</para>
</section>
<section id="excel.formatmasks.dates">
<title>Date masks</title>
<para>
- When encountering a format mask, first it is checked if it is in internal
form, e.g "format1", "format2"
- and so on (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
+ When encountering a format mask, first it is checked if it is in
+ internal form, e.g "format1", "format2" and so on
(see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.write.DecimalFormats
+ </ulink>
+ ).
</para>
<para>
- if the mask is not in the list, it is treated as a custom mask (see
<ulink
url="http://java.sun.com/javase/6/docs/api/java/text/DateFormat.html...,
e.g "dd.MM.yyyy" and automatically converted to the closest match.
+ if the mask is not in the list, it is treated as a custom mask
+ (see
+ <ulink
+
url="http://java.sun.com/javase/6/docs/api/java/text/DateFormat.html...
+ java.text.DateFormat
+ </ulink>
+ )., e.g "dd.MM.yyyy" and automatically converted to the closest
+ match.
</para>
</section>
</section>
@@ -1595,43 +1842,53 @@
<section id="excel.formulas">
<title>Formulas</title>
<para>
- Formulas are nested within columns (for iteration) or inside worksheets (for
direct placement using the <literal>column</literal> and
- <literal>row</literal> attributes) and add calculations or functions
to ranges of cells. They are essentially cells, see <xref
linkend="excel.cells"/>
- for available attributes. Note that they can apply templates and have own font
definitions
- etc just as normal cells.
+ Formulas are nested within columns (for iteration) or inside worksheets
+ (for direct placement using the <literal>column</literal> and
+ <literal>row</literal> attributes) and add calculations or functions
to
+ ranges of cells. They are essentially cells, see
+ <xref linkend="excel.cells" /> for available attributes. Note
that they
+ can apply templates and have own font definitions etc just as normal
+ cells.
</para>
<para>
- The formula of the cell in placed in the
<literal>value</literal>-attribute as a normal <trademark
class="registered">Microsoft</trademark>
- <trademark class="registered">Excel</trademark>
spreadsheet application notation. Note that when doing
- cross-sheet formulas, the worksheets must exist before referencing a formula
against them. The value is a
- string.
+ The formula of the cell in placed in the <literal>value</literal>
+ -attribute as a normal &excel; notation. Note that when doing
+ cross-sheet formulas, the worksheets must exist before referencing
+ a formula against them. The value is a string.
</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:cellTemplate name="fooTemplate">
- <e:font color="red"/>
- </e:cellTemplate>
- <e:worksheet name="fooSheet">
- <e:cell column="0" row="0" value="1"/>
- </e:worksheet>
- <e:worksheet name="barSheet">
- <e:cell column="0" row="0" value="2"/>
- <e:formula column="0" row="1"
- value="fooSheet!A1+barSheet1!A1"
- templates="fooTemplate">
- <e:font fontSize="12"/>
- </e:formula>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:cellTemplate name="fooTemplate">
+ <e:font color="red"/>
+ </e:cellTemplate>
+ <e:worksheet name="fooSheet">
+ <e:cell column="0" row="0"
value="1"/>
+ </e:worksheet>
+ <e:worksheet name="barSheet">
+ <e:cell column="0" row="0"
value="2"/>
+ <e:formula column="0" row="1"
+ value="fooSheet!A1+barSheet1!A1"
+ templates="fooTemplate">
+ <e:font fontSize="12"/>
+ </e:formula>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>defines an formula in B2 summing cells A1 in worksheets FooSheet and
BarSheet</para>
+ <para>
+ defines an formula in B2 summing cells A1 in worksheets FooSheet and
+ BarSheet
+ </para>
</section>
<section id="excel.images">
<title>Images</title>
- <para>Images are nested within columns (for iteration) or inside worksheets
(for direct placement using the
- <literal>startColumn/startRow</literal> and
<literal>endColumn/endRow</literal> attributes)</para>
+ <para>
+ Images are nested within columns (for iteration) or inside worksheets
+ (for direct placement using the
<literal>startColumn/startRow</literal>
+ and <literal>endColumn/endRow</literal>
+ attributes)
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1651,35 +1908,42 @@
<listitem>
<para>
<literal>startColumn</literal>
- —The starting column of the image. The default is
the internal counter. The value is
- a number. Note that the value is 0-based.
+ —The starting column of the image. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>startRow</literal>
- —The starting row of the image. The default is
the internal counter. The value is a
- number. Note that the value is 0-based.
+ —The starting row of the image. The default
+ is the internal counter. The value is a number.
+ Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>columnSpan</literal>
- —The column span of the image. The default is one
resulting in the default width of
- the image. The value is a number. Note that the value is
0-based.
+ —The column span of the image. The default
+ is one resulting in the default width of the
+ image. The value is a number. Note that the value
+ is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>rowSpan</literal>
- —The row span of the image. The default is the
one resulting in the default height
- of the image. The value is a number. Note that the value is
0-based.
+ —The row span of the image. The default is
+ the one resulting in the default height of the
+ image. The value is a number. Note that the value
+ is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>URI</literal>
- —The URI to the image. The value is a string.
+ —The URI to the image. The value is a
+ string.
</para>
</listitem>
</itemizedlist>
@@ -1710,20 +1974,26 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:image startRow="0" startColumn="0" rowSpan="4"
columnSpan="4"
URI="http://foo.org/logo.jpg"/>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:image startRow="0" startColumn="0"
rowSpan="4"
+ columnSpan="4"
URI="http://foo.org/logo.jpg"/>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
<para>defines an image in A1:E5 based on the given data</para>
</section>
<section id="excel.hyperlinks">
<title>Hyperlinks</title>
- <para>Hyperlinks are nested within columns (for iteration) or inside
worksheets (for direct placement using the
- <literal>startColumn/startRow</literal> and
<literal>endColumn/endRow</literal> attributes). They add link navigation to
URIs</para>
+ <para>
+ Hyperlinks are nested within columns (for iteration) or inside
+ worksheets (for direct placement using the
+ <literal>startColumn/startRow</literal> and
+ <literal>endColumn/endRow</literal> attributes). They add link
+ navigation to URIs
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1743,29 +2013,33 @@
<listitem>
<para>
<literal>startColumn</literal>
- —The starting column of the hyperlink. The
default is the internal counter. The
- value is a number. Note that the value is 0-based.
+ —The starting column of the hyperlink. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>startRow</literal>
- —The starting row of the hyperlink. The default
is the internal counter. The value
- is a number. Note that the value is 0-based.
+ —The starting row of the hyperlink. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endColumn</literal>
- —The ending column of the hyperlink. The default
is the internal counter. The value
- is a number. Note that the value is 0-based.
+ —The ending column of the hyperlink. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endRow</literal>
- —The ending row of the hyperlink. The default is
the internal counter. The value is
- a number. Note that the value is 0-based.
+ —The ending row of the hyperlink. The
+ default is the internal counter. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
@@ -1777,7 +2051,8 @@
<listitem>
<para>
<literal>description</literal>
- —The description of the link. The value is a
string.
+ —The description of the link. The value is a
+ string.
</para>
</listitem>
</itemizedlist>
@@ -1808,21 +2083,25 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:hyperLink startRow="0" startColumn="0"
endRow="4" endColumn="4"
- URL="http://seamframework.org" description="The Seam
Framework"/>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:hyperLink startRow="0" startColumn="0"
endRow="4"
+ endColumn="4" URL="http://seamframework.org"
+ description="The Seam Framework"/>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>defines a described hyperlink pointing to SFWK in the area
A1:E5</para>
+ <para>
+ defines a described hyperlink pointing to SFWK in the area A1:E5
+ </para>
</section>
<section id="excel.headersfooters">
<title>Headers and footers</title>
<para>
- Headers and footers are childrens of worksheets and worksheet templates and
parents of header and footer commands
- They add headers and footers to printed worksheets.
+ Headers and footers are childrens of worksheets and worksheet templates
+ and parents of header and footer commands They add headers and footers
+ to printed worksheets.
</para>
<informaltable>
<tgroup cols="2">
@@ -1843,8 +2122,8 @@
<listitem>
<para>
<literal>type</literal>
- —The type of the header or footer. The value is
string that can be either "header"
- or "footer".
+ —The type of the header or footer. The value
+ is string that can be either "header" or
"footer".
</para>
</listitem>
</itemizedlist>
@@ -1865,19 +2144,22 @@
<listitem>
<para>
<literal>left</literal>
- —The contents of the left header/footer part.
+ —The contents of the left header/footer
+ part.
</para>
</listitem>
<listitem>
<para>
<literal>center</literal>
- —The contents of the center header/footer part.
+ —The contents of the center header/footer
+ part.
</para>
</listitem>
<listitem>
<para>
<literal>right</literal>
- —The contents of the right header/footer part.
+ —The contents of the right header/footer
+ part.
</para>
</listitem>
</itemizedlist>
@@ -1887,7 +2169,9 @@
</tgroup>
</informaltable>
<para>
- The <literal><e:headerFooterCommands></literal> is
just a nesting container in order to support multiple header/footer commands.
+ The <literal><e:headerFooterCommands></literal>
+ is just a nesting container in order to support multiple header/footer
+ commands.
</para>
<informaltable>
<tgroup cols="2">
@@ -1916,9 +2200,7 @@
</para>
<itemizedlist>
<listitem>
- <para>
- Zero or more header/footer commands.
- </para>
+ <para>Zero or more header/footer commands.</para>
</listitem>
</itemizedlist>
<para>
@@ -1936,8 +2218,10 @@
</tbody>
</tgroup>
</informaltable>
- <para>Header/footer commands adds actual commands to the header or footer in
the location where the
- containing facet points.</para>
+ <para>
+ Header/footer commands adds actual commands to the header or footer in
+ the location where the containing facet points.
+ </para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -1957,33 +2241,67 @@
<listitem>
<para>
<literal>command</literal>
- —The command to execute. The value is a string
+ —The command to execute. The value is a
+ string
<itemizedlist>
<listitem>
"append" - appends the text in the
<literal>parameter</literal>
</listitem>
- <listitem>"date" - appends the current
date</listitem>
- <listitem>"page_number" - appends the
page number</listitem>
+ <listitem>
+ "date" - appends the current date
+ </listitem>
+ <listitem>
+ "page_number" - appends the page number
+ </listitem>
<listitem>"time" - appends the
time</listitem>
- <listitem>"total_pages" - appends the
total page count</listitem>
- <listitem>"workbook_name" - appends the
workbook name</listitem>
- <listitem>"worksheet_name" - appends the
worksheet name</listitem>
- <listitem>"toggle_bold" - toggles bold
font</listitem>
- <listitem>"toggle_italics" - toggles
italics</listitem>
- <listitem>"toggle_double_underline" -
toggles double underlining</listitem>
- <listitem>"toggle_outline" - toggles
outline</listitem>
- <listitem>"toggle_shadow" - toggles
shadow</listitem>
- <listitem>"toggle_strikethrough" -
toggles strikethrough</listitem>
- <listitem>"toggle_subscript" - toggles
subscript</listitem>
- <listitem>"toggle_superscript" - toggles
superscript</listitem>
- <listitem>"toggle_underline" - toggles
underline</listitem>
<listitem>
- "font_name" - sets the font name given in
the
+ "total_pages" - appends the total page
count
+ </listitem>
+ <listitem>
+ "workbook_name" - appends the workbook
name
+ </listitem>
+ <listitem>
+ "worksheet_name" - appends the worksheet
+ name
+ </listitem>
+ <listitem>
+ "toggle_bold" - toggles bold font
+ </listitem>
+ <listitem>
+ "toggle_italics" - toggles italics
+ </listitem>
+ <listitem>
+ "toggle_double_underline" - toggles double
+ underlining
+ </listitem>
+ <listitem>
+ "toggle_outline" - toggles outline
+ </listitem>
+ <listitem>
+ "toggle_shadow" - toggles shadow
+ </listitem>
+ <listitem>
+ "toggle_strikethrough" - toggles
+ strikethrough
+ </listitem>
+ <listitem>
+ "toggle_subscript" - toggles subscript
+ </listitem>
+ <listitem>
+ "toggle_superscript" - toggles superscript
+ </listitem>
+ <listitem>
+ "toggle_underline" - toggles underline
+ </listitem>
+ <listitem>
+ "font_name" - sets the font name given in
+ the
<literal>parameter</literal>
</listitem>
<listitem>
- "font_size" - sets the font size given in
the
+ "font_size" - sets the font size given in
+ the
<literal>parameter</literal>
</listitem>
</itemizedlist>
@@ -1992,10 +2310,13 @@
<listitem>
<para>
<literal>parameter</literal>
- —The parameter for some commands. Used by the
font_name, font_size and append
- commands. The font_name parameter is a string that
represents the requested font name, the
- font_size parameter is a number that represents the
requested font size and the append
- parameter is a string of text to be appended to the
header/footer.
+ —The parameter for some commands. Used by
+ the font_name, font_size and append commands. The
+ font_name parameter is a string that represents
+ the requested font name, the font_size parameter
+ is a number that represents the requested font
+ size and the append parameter is a string of text
+ to be appended to the header/footer.
</para>
</listitem>
</itemizedlist>
@@ -2026,17 +2347,17 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:headerFooter type="header">
- <f:facet name="left">
- <e:headerFooterCommands>
- <e:headerFooterCommand command="page_number"/>
- </e:headerFooterCommands>
- </f:facet>
- </e:headerFooter>
- <e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:headerFooter type="header">
+ <f:facet name="left">
+ <e:headerFooterCommands>
+ <e:headerFooterCommand
command="page_number"/>
+ </e:headerFooterCommands>
+ </f:facet>
+ </e:headerFooter>
+ <e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>Defines a header with the page number in the left corner.</para>
@@ -2044,7 +2365,8 @@
<section id="excel.printareatitles">
<title>Print areas and titles</title>
<para>
- Print areas and titles childrens of worksheets and worksheet templates and
provide... print areas and titles.
+ Print areas and titles childrens of worksheets and worksheet templates
+ and provide... print areas and titles.
</para>
<informaltable>
<tgroup cols="2">
@@ -2065,25 +2387,33 @@
<listitem>
<para>
<literal>firstColumn</literal>
- —The column of the top-left corner of the area.
The parameter is a number. Note that the value is 0-based.
+ —The column of the top-left corner of the
+ area. The parameter is a number. Note that the
+ value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>firstRow</literal>
- —The row of the top-left corner of the area. The
parameter is a number. Note that the value is 0-based.
+ —The row of the top-left corner of the area.
+ The parameter is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>lastColumn</literal>
- —The column of the bottom-right corner of the
area. The parameter is a number. Note that the value is 0-based.
+ —The column of the bottom-right corner of
+ the area. The parameter is a number. Note that the
+ value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>lastRow</literal>
- —The row of the bottom-right corner of the area.
The parameter is a number. Note that the value is 0-based.
+ —The row of the bottom-right corner of the
+ area. The parameter is a number. Note that the
+ value is 0-based.
</para>
</listitem>
</itemizedlist>
@@ -2114,24 +2444,29 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:printTitles firstRow="0" firstColumn="0"
lastRow="0" lastColumn="9"/>
- <e:printArea firstRow="1" firstColumn="0"
lastRow="9" lastColumn="9"/>
- </e:worksheet>
-</e:workbook>
- ]]>
+ <e:workbook>
+ <e:worksheet>
+ <e:printTitles firstRow="0" firstColumn="0"
+ lastRow="0" lastColumn="9"/>
+ <e:printArea firstRow="1" firstColumn="0"
+ lastRow="9" lastColumn="9"/>
+ </e:worksheet>
+ </e:workbook>
+ ]]>
</programlisting>
- <para>defines a print title between A1:A10 and a print area between
B2:J10.</para>
+ <para>
+ defines a print title between A1:A10 and a print area between B2:J10.
+ </para>
</section>
<section id="excel.worksheetcommands">
<title>Worksheet Commands</title>
- <para>Worksheet commands are children of workbooks and are usually executed
only once.</para>
+ <para>
+ Worksheet commands are children of workbooks and are usually executed
+ only once.
+ </para>
<section id="excel.worksheetcommands.grouping">
<title>Grouping</title>
- <para>
- Provides grouping of columns and rows.
- </para>
+ <para>Provides grouping of columns and rows.</para>
<informaltable>
<tgroup cols="2">
<colspec colnum="1" colwidth="1*" />
@@ -2151,19 +2486,24 @@
<listitem>
<para>
<literal>startRow</literal>
- —The row to start the grouping at. The value
is a number. Note that the value is 0-based.
+ —The row to start the grouping at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endRow</literal>
- —The row to end the grouping at. The value is
a number. Note that the value is 0-based.
+ —The row to end the grouping at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>collapse</literal>
- —Should the grouping be collapsed initially?
The value is a boolean.
+ —Should the grouping be collapsed
+ initially? The value is a boolean.
</para>
</listitem>
</itemizedlist>
@@ -2211,19 +2551,24 @@
<listitem>
<para>
<literal>startColumn</literal>
- —The column to start the grouping at. The
value is a number. Note that the value is 0-based.
+ —The column to start the grouping at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endColumn</literal>
- —The column to end the grouping at. The value
is a number. Note that the value is 0-based.
+ —The column to end the grouping at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>collapse</literal>
- —Should the grouping be collapsed initially?
The value is a boolean.
+ —Should the grouping be collapsed
+ initially? The value is a boolean.
</para>
</listitem>
</itemizedlist>
@@ -2255,17 +2600,17 @@
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:groupRows startRow="4" endRow="9"
collapse="true"/>
- <e:groupColumns startColumn="0" endColumn="9"
collapse="false"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:groupRows startRow="4" endRow="9"
collapse="true"/>
+ <e:groupColumns startColumn="0" endColumn="9"
collapse="false"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>
- groups rows 5 trough 10 and columns 5 through 10 so that the rows are
initially collapsed (but not the
- columns).
+ groups rows 5 trough 10 and columns 5 through 10 so that the rows
+ are initially collapsed (but not the columns).
</para>
</section>
@@ -2291,7 +2636,8 @@
<listitem>
<para>
<literal>row</literal>
- —The row to break at. The value is a number.
Note that the value is 0-based.
+ —The row to break at. The value is a
+ number. Note that the value is 0-based.
</para>
</listitem>
</itemizedlist>
@@ -2322,11 +2668,11 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:rowPageBreak row="4"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:rowPageBreak row="4"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>breaks page at row 5.</para>
@@ -2353,25 +2699,32 @@
<listitem>
<para>
<literal>startRow</literal>
- —The row to start the merging from. The value
is a number. Note that the value is 0-based.
+ —The row to start the merging from. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>startColumn</literal>
- —The column to start the merging from. The
value is a number. Note that the value is 0-based.
+ —The column to start the merging from.
+ The value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endRow</literal>
- —The row to end the merging at. The value is a
number. Note that the value is 0-based.
+ —The row to end the merging at. The value
+ is a number. Note that the value is 0-based.
</para>
</listitem>
<listitem>
<para>
<literal>endColumn</literal>
- —The column to end the merging at. The value
is a number. Note that the value is 0-based.
+ —The column to end the merging at. The
+ value is a number. Note that the value is
+ 0-based.
</para>
</listitem>
</itemizedlist>
@@ -2402,11 +2755,11 @@
</informaltable>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:mergeCells startRow="0" startColumn="0"
endRow="9" endColumn="9"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:mergeCells startRow="0" startColumn="0"
endRow="9" endColumn="9"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>merges the cells in the range A1:J10</para>
@@ -2415,95 +2768,106 @@
<section id="excel.templates">
<title>Templates</title>
<para>
- Templates are a way of grouping common formatting under a name to be used later.
They come in two flavors, cell
- level and worksheet settings level and they can be cascaded so that the end
result is a union of the applied
- templates (overriden where applicable)
+ Templates are a way of grouping common formatting under a name to be
+ used later. They come in two flavors, cell level and worksheet settings
+ level and they can be cascaded so that the end result is a union of the
+ applied templates (overriden where applicable)
</para>
<section id="excel.templates.cell">
<title>Cell templates</title>
- <para>Cell templates are defined on workbook level using the following
notation</para>
+ <para>
+ Cell templates are defined on workbook level using the following
+ notation
+ </para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:cellTemplate name="foo">
- <font color="red"/>
- </e:cellTemplate>
-</e:workbook>
+ <e:workbook>
+ <e:cellTemplate name="foo">
+ <font color="red"/>
+ </e:cellTemplate>
+ </e:workbook>
]]>
</programlisting>
- <para>and are later used by referencing them in the templates attribute of
a cell</para>
+ <para>
+ and are later used by referencing them in the templates attribute of
+ a cell
+ </para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:cell templates="foo" column="0" row="0"
value="ping"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:cell templates="foo" column="0"
row="0" value="ping"/>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>
- Cell templates have the same attributes as cells (see <xref
linkend="excel.cells"/>). Note
- that the cellTemplate can also contain tags for font, border and background
definitions and they are merged
- with the definitions of the cell using the templates so a more complex
definition could look like
+ Cell templates have the same attributes as cells (see
+ <xref linkend="excel.cells" />
+ ). Note that the cellTemplate can also contain tags for font, border
+ and background definitions and they are merged with the definitions
+ of the cell using the templates so a more complex definition could
+ look like
</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:cellTemplate name="foo" alignment="right">
- <e:font name="Times New Roman"/>
- <e:background color="blue"/>
- </e:cellTemplate>
+ <e:workbook>
+ <e:cellTemplate name="foo"
alignment="right">
+ <e:font name="Times New Roman"/>
+ <e:background color="blue"/>
+ </e:cellTemplate>
- <e:cellTemplate name="bar" wrap="true">
- <e:font color="red"/>
- <e:border color="yellow" lineStyle="thick"/>
- </e:cellTemplate>
-</e:workbook>
+ <e:cellTemplate name="bar" wrap="true">
+ <e:font color="red"/>
+ <e:border color="yellow"
lineStyle="thick"/>
+ </e:cellTemplate>
+ </e:workbook>
]]>
</programlisting>
<para>so that a cell that later on applies the templates</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:cell templates="foo,bar" column="0" row="0"
value="ping">
- <e:border border="left" color="green"
lineStyle="thin"/>
- </e:cell>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet>
+ <e:cell templates="foo,bar" column="0"
row="0" value="ping">
+ <e:border border="left" color="green"
lineStyle="thin"/>
+ </e:cell>
+ </e:worksheet>
+ </e:workbook>
]]>
</programlisting>
<para>
- end up with a red Times New Roman font in a right-aligned, wrapping cell that
has a solid blue background
- and thick yellow borders, with exception of the left border, which is thin
and green.
+ end up with a red Times New Roman font in a right-aligned, wrapping
+ cell that has a solid blue background and thick yellow borders, with
+ exception of the left border, which is thin and green.
</para>
</section>
<section id="excel.templates.worksheetsettings">
<title>Worksheet setting templates</title>
<para>
- Worksheet settings are defined and used in the same way as cell templates. On
workbook level, you can place
- a
+ Worksheet settings are defined and used in the same way as cell
+ templates. On workbook level, you can place a
</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet>
- <e:worksheetTemplate name="foo" horizontalFreeze="5"/>
- </e:worksheet>
-</e:workbook>
+ <e:workbook>
+ <e:worksheetTemplate name="foo"
horizontalFreeze="5"/>
+ </e:workbook>
]]>
</programlisting>
<para>and when you later use it like</para>
<programlisting role="XML">
<![CDATA[
-<e:workbook>
- <e:worksheet templates="foo" verticalFreeze="5"/>
-</e:workbook>
+ <e:workbook>
+ <e:worksheet templates="foo"
verticalFreeze="5"/>
+ </e:workbook>
]]>
</programlisting>
<para>
- you end up with a worksheet that is frozen at column 5 and row 5. Note that a
worksheetTemplate is
- essentially a named worksheet (see <xref
linkend="excel.worksheet"/>).
+ you end up with a worksheet that is frozen at column 5 and row 5.
+ Note that a worksheetTemplate is essentially a named worksheet (see
+ <xref linkend="excel.worksheet" />
+ ).
</para>
</section>
@@ -2511,61 +2875,68 @@
<section id="excel.datatableexporter">
<title>Datatable exporter</title>
<para>
- If you prefer to export an existing JSF datatable instead of writing a dedicated
XHTML document, this can also
- be achieved easily by executing the
- <literal>org.jboss.seam.excel.excelExporter.export</literal>
- component, passing in the id of the datatable as an Seam EL parameter. Consider
you have a data table
+ If you prefer to export an existing JSF datatable instead of writing a
+ dedicated XHTML document, this can also be achieved easily by executing
+ the <literal>org.jboss.seam.excel.excelExporter.export</literal>
+ component, passing in the id of the datatable as an Seam EL parameter.
+ Consider you have a data table
</para>
<programlisting role="XML">
<![CDATA[
-<h:form id="theForm">
- <h:dataTable id="theDataTable" value="#{personList.personList}"
var="person">
- ...
- </h:dataTable>
-</h:form>
+ <h:form id="theForm">
+ <h:dataTable id="theDataTable"
value="#{personList.personList}"
+ var="person">
+ ...
+ </h:dataTable>
+ </h:form>
]]>
</programlisting>
- <para>that you want to view as an <trademark
class="registered">Microsoft</trademark> <trademark
class="registered">Excel</trademark>
- spreadsheet. Place a</para>
+ <para>
+ that you want to view as an
+ <trademark class="registered">Microsoft</trademark>
+ <trademark class="registered">Excel</trademark>
+ spreadsheet. Place a
+ </para>
<programlisting role="XML">
<![CDATA[
-<h:commandLink
- value="Export"
-
action="#{org.jboss.seam.excel.excelExporter.export('theForm:theDataTable')}"
-/>
- ]]>
+ <h:commandLink
+ value="Export"
+
action="#{org.jboss.seam.excel.excelExporter.export('theForm:theDataTable')}"
+ />
+ ]]>
</programlisting>
<para>
- in the form and you're done. You can of course execute the exporter with a
button, s:link or other preferred
- method. There are also plans for a dedicated export tag that can be placed
inside the datatable tag so you
- won't have to refer to the datatable by ID.
+ in the form and you're done. You can of course execute the exporter
+ with a button, s:link or other preferred method. There are also plans
+ for a dedicated export tag that can be placed inside the datatable tag
+ so you won't have to refer to the datatable by ID.
</para>
<section id="excel.datatableexporter.css">
<title>CSS</title>
<para>
- In order to provide formatting for the spreadsheet, you can utilize a number
of xls-prefixed CSS:ish
- attributes that are placed in the style-attribute of the datatable to be
exported:
+ In order to provide formatting for the spreadsheet, you can utilize
+ a number of xls-prefixed CSS:ish attributes that are placed in the
+ style-attribute of the datatable to be exported:
</para>
<programlisting role="XML">
<![CDATA[
-<h:form id="theForm">
- <h:dataTable
- id="theDataTable"
- value="#{personList.personList}"
- var="person"
- style="xlsFontName : Times New Roman; xlsBackgroundColor : red">
- ...
- </h:dataTable>
-</h:form>
+ <h:form id="theForm">
+ <h:dataTable
+ id="theDataTable"
+ value="#{personList.personList}"
+ var="person"
+ style="xlsFontName : Times New Roman; xlsBackgroundColor :
red">
+ ...
+ </h:dataTable>
+ </h:form>
]]>
</programlisting>
<para>
- which sets Times New Roman as the font and red as the cell background. Just
as in CSS, separate name and
- value with a
- <literal>:</literal>
- and multiple attributes with a
- <literal>;</literal>
- . Below is a list of the supported style-attributes:
+ which sets Times New Roman as the font and red as the cell
+ background. Just as in CSS, separate name and value with a
+ <literal>:</literal> and multiple attributes with a
+ <literal>;</literal>. Below is a list of the supported
+ style-attributes:
</para>
<informaltable>
<tgroup cols="2">
@@ -2593,7 +2964,14 @@
<para>xlsFontColor</para>
</entry>
<entry valign="top">
- <para>The color of the font (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The color of the font (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2601,7 +2979,10 @@
<para>xlsFontBold</para>
</entry>
<entry valign="top">
- <para>Should the font be bold? Valid values are
"true" and "false"</para>
+ <para>
+ Should the font be bold? Valid values are "true"
and
+ "false"
+ </para>
</entry>
</row>
<row>
@@ -2609,7 +2990,10 @@
<para>xlsFontItalic</para>
</entry>
<entry valign="top">
- <para>Should the font be italic? Valid values are
"true" and "false"</para>
+ <para>
+ Should the font be italic? Valid values are "true"
+ and "false"
+ </para>
</entry>
</row>
<row>
@@ -2617,7 +3001,14 @@
<para>xlsFontScriptStyle</para>
</entry>
<entry valign="top">
- <para>The script style of the font (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The script style of the font (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.ScriptStyle
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2625,7 +3016,10 @@
<para>xlsFontStruckOut</para>
</entry>
<entry valign="top">
- <para>Should the font be struck out? Valid values are
"true" and "false"</para>
+ <para>
+ Should the font be struck out? Valid values are
+ "true" and "false"
+ </para>
</entry>
</row>
<row>
@@ -2633,7 +3027,14 @@
<para>xlsFontUnderlineStyle</para>
</entry>
<entry valign="top">
- <para>The underline style of the font (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The underline style of the font (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.UnderlineStyle
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2641,7 +3042,14 @@
<para>xlsBackgroundColor</para>
</entry>
<entry valign="top">
- <para>The background color of the cell (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The background color of the cell (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2649,7 +3057,14 @@
<para>xlsBackgroundPattern</para>
</entry>
<entry valign="top">
- <para>The background pattern of the cell (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The background pattern of the cell (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Pattern
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2657,7 +3072,14 @@
<para>xlsAlignment</para>
</entry>
<entry valign="top">
- <para>The alignment of the cell value (see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The alignment of the cell value (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Alignment
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2666,24 +3088,22 @@
</entry>
<entry valign="top">
<para>
- The column widths. Note that the unit is internal to the
<trademark class="registered">Microsoft</trademark>
- <trademark
class="registered">Excel</trademark> spreadsheet file format, be
prepared to use largeish numbers.
- Separate columns with a
- <literal>,</literal>
- and use
- <literal>*</literal>
- for not setting a value.
+ The column widths. Note that the unit is internal to
+ &excel;, be prepared to use largeish numbers.
+ Separate columns with a <literal>,</literal>
+ and use <literal>*</literal> for not setting a
value.
</para>
<programlisting role="XML">
<![CDATA[
-<h:dataTable style="xlsColumnWidths : *,800">
- ...
-</h:dataTable>
-]]>
+ <h:dataTable style="xlsColumnWidths :
*,800">
+ ...
+ </h:dataTable>
+ ]]>
</programlisting>
<para>
- leaves the width on column 1 as default, sets the width of
column 2 to 800 and leaves the
- rest of the columns (if any) as default.
+ leaves the width on column 1 as default, sets the
+ width of column 2 to 800 and leaves the rest of the
+ columns (if any) as default.
</para>
</entry>
</row>
@@ -2692,7 +3112,14 @@
<para>xlsBorderColor</para>
</entry>
<entry valign="top">
- <para>The the border color of the entire cell (see
<ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The the border color of the entire cell (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2700,7 +3127,15 @@
<para>xlsBorderColorLeft</para>
</entry>
<entry valign="top">
- <para>The the border color of the left edge of the cell
(see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The the border color of the left edge of the cell
+ (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2708,7 +3143,14 @@
<para>xlsBorderColorTop</para>
</entry>
<entry valign="top">
- <para>The the border color of the top edge of the cell (see
<ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The the border color of the top edge of the cell (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2716,7 +3158,15 @@
<para>xlsBorderColorRight</para>
</entry>
<entry valign="top">
- <para>The the border color of the right edge of the cell
(see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The the border color of the right edge of the cell
+ (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2724,7 +3174,15 @@
<para>xlsBorderColorBottom</para>
</entry>
<entry valign="top">
- <para>The the border color of the bottom edge of the cell
(see <ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The the border color of the bottom edge of the cell
+ (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2732,7 +3190,14 @@
<para>xlsBorderLineStyle</para>
</entry>
<entry valign="top">
- <para>The the border line style of the entire cell (see
<ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ <para>
+ The the border line style of the entire cell (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
+ </para>
</entry>
</row>
<row>
@@ -2741,7 +3206,13 @@
</entry>
<entry valign="top">
<para>
- The the border line style of the left edge of the cell (see
<ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
+ The the border line style of the left edge of the
+ cell (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
</para>
</entry>
</row>
@@ -2751,7 +3222,13 @@
</entry>
<entry valign="top">
<para>
- The the border line style of the top edge of the cell (see
<ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
+ The the border line style of the top edge of the cell
+ (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ).
</para>
</entry>
</row>
@@ -2761,8 +3238,13 @@
</entry>
<entry valign="top">
<para>
- The the border line style of the right edge of the cell (see
<ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
- styles
+ The the border line style of the right edge of the
+ cell (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ). styles
</para>
</entry>
</row>
@@ -2772,8 +3254,13 @@
</entry>
<entry valign="top">
<para>
- The the border line style of the bottom edge of the cell (see
<ulink
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...>).
- styles
+ The the border line style of the bottom edge of the
+ cell (see
+ <ulink
+
url="http://jexcelapi.sourceforge.net/resources/javadocs/current/doc...
+ jxl.format.Colour
+ </ulink>
+ ). styles
</para>
</entry>
</row>
@@ -2784,46 +3271,50 @@
<section id="excel.datatableexporter.templates">
<title>Templates</title>
<para>
- In order to provide different formatting for different kind of cells you can
use templates. Templates are
- defined in the datatable style attribute as seen in the examples in the
previous section by using a
- dot-notation on the xls-attribute names. Attributes without template names
are considered global and are
- applied to all cells.
+ In order to provide different formatting for different kind of cells
+ you can use templates. Templates are defined in the datatable style
+ attribute as seen in the examples in the previous section by using a
+ dot-notation on the xls-attribute names. Attributes without template
+ names are considered global and are applied to all cells.
</para>
<para>
- Templates are used by referring to them in the style attribute of the
UIOutput using the xlsTemplates
- attribute. If you wish to cascade several templates, separate them with a
+ Templates are used by referring to them in the style attribute of
+ the UIOutput using the xlsTemplates attribute. If you wish to
+ cascade several templates, separate them with a
<literal>,</literal>
.
</para>
<programlisting role="XML">
<![CDATA[
-<h:dataTable style="xlsFontName : Times New Roman; xlsFontColor.foo : blue;
- xlsFontColor.bar : red; xlsFontBold.tar : true">
- <h:column>
- <h:outputText style="xlsTemplates : foo"/>
- </h:column>
- <h:column>
- <h:outputText style="xlsTemplates : bar,tar"/>
- </h:column>
-</h:dataTable>
-]]>
+ <h:dataTable style="xlsFontName : Times New Roman;
xlsFontColor.foo : blue;
+ xlsFontColor.bar : red; xlsFontBold.tar : true">
+ <h:column>
+ <h:outputText style="xlsTemplates : foo"/>
+ </h:column>
+ <h:column>
+ <h:outputText style="xlsTemplates : bar,tar"/>
+ </h:column>
+ </h:dataTable>
+ ]]>
</programlisting>
<para>
- results in the first column being Times New Roman, blue and the second column
being Times New Roman red
- bold.
+ results in the first column being Times New Roman, blue and the
+ second column being Times New Roman red bold.
</para>
</section>
</section>
<section id="excel.links">
<title>Links and further documentation</title>
<para>
- The core of the <trademark
class="registered">Microsoft</trademark> <trademark
class="registered">Excel</trademark> spreadsheet
- functionality is based on the excellent JExcelAPI library which can be found on
-
http://jexcelapi.sourceforge.net/ and most features and possible limitations are
inherited from here.
+ The core of the &excel; functionality is based on the excellent
+ JExcelAPI library which can be found on
+
http://jexcelapi.sourceforge.net/ and most features and possible
+ limitations are inherited from here.
</para>
<para>
- If you use the forum or mailing list, please remember that they don't know
anything about Seam and the usage of
- their library, any issues are best reported in the JBoss Seam JIRA under the
"excel" module.
+ If you use the forum or mailing list, please remember that they don't
+ know anything about Seam and the usage of their library, any issues are
+ best reported in the JBoss Seam JIRA under the "excel" module.
</para>
</section>
</chapter>