Author: nick
Date: Fri Aug 1 12:51:45 2014
New Revision: 1615086
URL: http://svn.apache.org/r1615086
Log:
Update the limitations document
Modified:
poi/site/publish/changes.html
poi/site/publish/spreadsheet/limitations.html
poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml
poi/site/src/documentation/content/xdocs/trans/es/hssf/limitations.xml
Modified: poi/site/publish/changes.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1615086&r1=1615085&r2=1615086&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Fri Aug 1 12:51:45 2014
@@ -249,10 +249,13 @@ if (VERSION > 3) {
</p>
+
+
+
<a name="3.11-beta1"></a>
<div class="h3">
-<h3>Version 3.11-beta1 (2014-??-??)</h3>
+<h3>Version 3.11-beta1 (2014-08-04)</h3>
</div>
<ul>
Modified: poi/site/publish/spreadsheet/limitations.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/limitations.html?rev=1615086&r1=1615085&r2=1615086&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/limitations.html (original)
+++ poi/site/publish/spreadsheet/limitations.html Fri Aug 1 12:51:45 2014
@@ -7,7 +7,7 @@
<link rel="stylesheet" href="../skin/mysite.css" type="text/css">
<link rel="stylesheet" href="../skin/site.css" type="text/css">
<link media="print" rel="stylesheet" href="../skin/print.css" type="text/css">
-<title>Limitations</title>
+<title>Apache POI - HSSF and XSSF Limitations</title>
</head>
<body bgcolor="white" class="composite">
<!--================= start Banner ==================-->
@@ -177,22 +177,22 @@ if (VERSION > 3) {
<div id="bodycol">
<div class="app">
<div align="center">
-<h1>Limitations</h1>
+<h1>Apache POI - HSSF and XSSF Limitations</h1>
</div>
<div class="h3">
-<a name="Version+3.7+limitations"></a>
+<a name="Current+HSSF+%2F+XSSF+main+limitations"></a>
<div class="h3">
-<h3>Version 3.7 limitations</h3>
+<h3>Current HSSF / XSSF main limitations</h3>
</div>
<p>
The intent of this document is to outline some of the known
limitations of the
- POI HSSF API's. It is not intended to be complete list of
every bug or missing
- feature of HSSF, rather it's purpose is to provide a broad
feel for some of the
- functionality that is missing or broken.
+ POI HSSF and XSSF API's. It is not intended to be complete
list of every bug
+ or missing feature of HSSF or XSSF, rather it's purpose is to
provide a broad
+ feel for some of the functionality that is missing or broken.
</p>
<ul>
@@ -200,10 +200,13 @@ if (VERSION > 3) {
<li>
Charts<br>
<br>
- You can not currently create charts. You can
- however create a chart in Excel, modify the chart data
values using HSSF and write
- a new spreadsheet out. This is possible because POI
attempts to keep existing records
- intact as far as possible.<br>
+ HSSF has some limited support for creating a handful of
very simple Chart types,
+ but largely this isn't supported. HSSF (largely) doesn't
support changing Charts.
+ You can however create a chart in Excel using Named
ranges, modify the chart data
+ values using HSSF and write a new spreadsheet out. This
is possible because POI
+ attempts to keep existing records intact as far as
possible.<br>
+ XSSF has only limited chart support, largely only
supporting making some
+ very simple changes.<br>
<br>
</li>
@@ -211,8 +214,9 @@ if (VERSION > 3) {
<li>
Macros<br>
<br>
- Macros can not be created. However, reading and
re-writing files containing macros will
- safely preserve the macros.<br>
+ Macros can not be created. The are currently no plans to
support macros.
+ However, reading and re-writing files containing macros
will safely preserve
+ the macros.<br>
<br>
</li>
@@ -220,8 +224,8 @@ if (VERSION > 3) {
<li>
Pivot Tables<br>
<br>
- Generating pivot tables is not supported. It has been
reported that files containing pivot
- tables can be read and re-written
safely.
+ HSSF doesn't have support for reading or creating Pivot
tables. XSSF has limited
+ support for creating Pivot Tables, and very limited
read/change support.
</li>
</ul>
Modified: poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml
URL:
http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml?rev=1615086&r1=1615085&r2=1615086&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml
(original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/limitations.xml Fri
Aug 1 12:51:45 2014
@@ -21,36 +21,40 @@
<document>
<header>
- <title>Limitations</title>
+ <title>Apache POI - HSSF and XSSF Limitations</title>
<authors>
<person email="[email protected]" name="Glen Stampoultzis"
id="GJS"/>
</authors>
</header>
<body>
- <section><title>Version 3.7 limitations</title>
+ <section><title>Current HSSF / XSSF main limitations</title>
<p>
The intent of this document is to outline some of the known
limitations of the
- POI HSSF API's. It is not intended to be complete list of
every bug or missing
- feature of HSSF, rather it's purpose is to provide a broad
feel for some of the
- functionality that is missing or broken.
+ POI HSSF and XSSF API's. It is not intended to be complete
list of every bug
+ or missing feature of HSSF or XSSF, rather it's purpose is to
provide a broad
+ feel for some of the functionality that is missing or broken.
</p>
<ul>
<li>
Charts<br/><br/>
- You can not currently create charts. You can
- however create a chart in Excel, modify the chart data
values using HSSF and write
- a new spreadsheet out. This is possible because POI
attempts to keep existing records
- intact as far as possible.<br/><br/>
+ HSSF has some limited support for creating a handful of
very simple Chart types,
+ but largely this isn't supported. HSSF (largely) doesn't
support changing Charts.
+ You can however create a chart in Excel using Named
ranges, modify the chart data
+ values using HSSF and write a new spreadsheet out. This
is possible because POI
+ attempts to keep existing records intact as far as
possible.<br/>
+ XSSF has only limited chart support, largely only
supporting making some
+ very simple changes.<br/><br/>
</li>
<li>
Macros<br/><br/>
- Macros can not be created. However, reading and
re-writing files containing macros will
- safely preserve the macros.<br/><br/>
+ Macros can not be created. The are currently no plans to
support macros.
+ However, reading and re-writing files containing macros
will safely preserve
+ the macros.<br/><br/>
</li>
<li>
Pivot Tables<br/><br/>
- Generating pivot tables is not supported. It has been
reported that files containing pivot
- tables can be read and re-written
safely.
+ HSSF doesn't have support for reading or creating Pivot
tables. XSSF has limited
+ support for creating Pivot Tables, and very limited
read/change support.
</li>
</ul>
</section>
Modified: poi/site/src/documentation/content/xdocs/trans/es/hssf/limitations.xml
URL:
http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/trans/es/hssf/limitations.xml?rev=1615086&r1=1615085&r2=1615086&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/trans/es/hssf/limitations.xml
(original)
+++ poi/site/src/documentation/content/xdocs/trans/es/hssf/limitations.xml Fri
Aug 1 12:51:45 2014
@@ -21,33 +21,29 @@
<document>
<header>
- <title>Jakarta POI - Limitations</title>
+ <title>Apache POI - HSSF and XSSF Limitations</title>
<authors>
- <person email="[email protected]" name="Glen
Stampoultzis" id="GJS"/>
+ <person email="[email protected]" name="Glen Stampoultzis"
id="GJS"/>
</authors>
</header>
<body>
- <section><title>Version 1.5 limitations</title>
+ <section><title>Current HSSF / XSSF main limitations</title>
<p>
The intent of this document is to outline some of the known
limitations of the
- POI HSSF API's. It is not intended to be complete list of
every bug or missing
- feature of HSSF, rather it's purpose is to provide a broad
feel for some of the
- functionality that is missing or broken.
+ POI HSSF and XSSF API's. It is not intended to be complete
list of every bug
+ or missing feature of HSSF or XSSF, rather it's purpose is to
provide a broad
+ feel for some of the functionality that is missing or broken.
</p>
<ul>
<li>
Charts<br/><br/>
- You can not currently create charts. This is planned for
the 2.0 release. You can
- however create a chart in Excel, modify the chart data
values using HSSF and write
- a new spreadsheet out. This is possible because POI
attempts to keep existing records
- intact as far as possible.<br/><br/>
- </li>
- <li>
- Rich Text<br/><br/>
- HSSF does not support rich text cells. Rich text cells are
- cells that have multiple fonts and styles in the once
cell. Any attempt to read
- a spreadsheet that has rich text cells will throw an
exception. This feature may
- be supported in the future but it is not currently
planned. Patches are welcome.<br/><br/>
+ HSSF has some limited support for creating a handful of
very simple Chart types,
+ but largely this isn't supported. HSSF (largely) doesn't
support changing Charts.
+ You can however create a chart in Excel using Named
ranges, modify the chart data
+ values using HSSF and write a new spreadsheet out. This
is possible because POI
+ attempts to keep existing records intact as far as
possible.<br/>
+ XSSF has only limited chart support, largely only
supporting making some
+ very simple changes.<br/><br/>
</li>
<li>
Outlines<br/><br/>
@@ -64,8 +60,8 @@
</li>
<li>
Pivot Tables<br/><br/>
- Generating pivot tables is not supported. Reading
spreadsheets containing pivot tables
- has not been tested.
+ HSSF doesn't have support for reading or creating Pivot
tables. XSSF has limited
+ support for creating Pivot Tables, and very limited
read/change support.
</li>
</ul>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]