poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1649777 - in /poi/site/publish: changes.html changes.rss encryption.html skin/mysite.css spreadsheet/limitations.html
Date Tue, 06 Jan 2015 11:04:34 GMT
Author: nick
Date: Tue Jan  6 11:04:34 2015
New Revision: 1649777

URL: http://svn.apache.org/r1649777
Log:
Republish site

Modified:
    poi/site/publish/changes.html
    poi/site/publish/changes.rss
    poi/site/publish/encryption.html
    poi/site/publish/skin/mysite.css
    poi/site/publish/spreadsheet/limitations.html

Modified: poi/site/publish/changes.html
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1649777&r1=1649776&r2=1649777&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Tue Jan  6 11:04:34 2015
@@ -257,6 +257,30 @@ if (VERSION > 3) {
 <ul>
         
 <li>
+<img class="icon" alt="add" src="images/add.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=53453">53453</a>
- Add methods to set margins in sections of HWPF documents</li>
+        
+<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=46898">46898</a>
- XSSF: Return #VALUE! for circular references.</li>
+        
+<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=46192">46192</a>
- Add methods to query outline level for HSSF and XSSF</li>
+        
+<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=56240">56240</a>
- Handle PP97_DUALSTORAGE streams</li>
+        
+<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=47261">47261</a>
- SlideShow.removeSlide makes PPT corrupted</li>
+        
+<li>
+<img class="icon" alt="add" src="images/add.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=49541">49541</a>
- Mapping of symbol characters to unicode equivalent</li> 
+        
+<li>
+<img class="icon" alt="add" src="images/add.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=54541">54541</a>
- Add support for cropped images in Slide.draw()</li>
+		
+<li>
+<img class="icon" alt="add" src="images/add.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=57007">57007</a>
- Add initial implementations of DMIN and DGET functions</li>
+        
+<li>
 <img class="icon" alt="add" src="images/add.jpg"> Support for Office Binary Document
RC4 CryptoAPI Encryption for HSLF</li>
         
 <li>
@@ -338,13 +362,19 @@ if (VERSION > 3) {
 <img class="icon" alt="fix" src="images/fix.jpg"> ClassCastException in validating
xml signatures due to missing xml beans resources</li>
         
 <li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=57171">57171</a>
- Adjust active sheet correctly when sheets are moved.</li>
+        
+<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=57163">57163</a>
- Adjust active sheet correctly when sheets are removed.</li>
+        
+<li>
 <img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=57164">57164</a>
- XSSFDrawing.createCellComment() does not honor dx and dy values passed in</li>
         
 <li>
 <img class="icon" alt="add" src="images/add.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=55967">55967</a>
- Picture method to resize with different scales in width and height</li>
         
 <li>
-<img class="icon" alt="add" src="images/add.jpg"> github-7 - Add Cell.removeHyperlink()
for HSSF and XSSF</li>
+<img class="icon" alt="add" src="images/add.jpg"> github-13 - Add Cell.removeHyperlink()
for HSSF and XSSF</li>
     
 </ul>
 

Modified: poi/site/publish/changes.rss
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.rss?rev=1649777&r1=1649776&r2=1649777&view=diff
==============================================================================
--- poi/site/publish/changes.rss (original)
+++ poi/site/publish/changes.rss Tue Jan  6 11:04:34 2015
@@ -1,3 +1,3 @@
 <?xml version="1.0" encoding="ISO-8859-1"?>
 <!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN" "http://my.netscape.com/publish/formats/rss-0.91.dtd">
-<rss version="0.91"><channel><title>POI Changes</title><link>http://poi.apache.org/changes.html</link><description>POI
Changes</description><language>en-us</language><item><title>
add</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers - Support for Office Binary Document RC4 CryptoAPI Encryption for HSLF</description></item><item><title>
add(bug 57195)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 57195) - Support for Office Binary Document RC4 Encryption</description></item><item><title>
fix(bug 57373)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57373) - Fix get/setFirstVisibleTab() for XSSFWorkbook</description></item><item><title>
fix(bug 57362)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57362) - Properly initialize chart-axis datastructure when loading
a spreadsheet which already contains on
 e.</description></item><item><title> fix(bug 56511)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 56511) - Fix NullPointerException for RichText strings with no
formatting for some runs.</description></item><item><title> add(bug
56550)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 56550) - Avoid IBM JDK fail immediately during loading some POI
classes, note: IBM JDK 1.7 or higher is needed because of XML APIs.</description></item><item><title>
add(bug 56595)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 56595) - Switch the cache in DateUtil.isADateFormat() to ThreadLocals
to not have another syncpoint here.</description></item><item><title>
fix(bug 56644)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 56644) - NullPointerException in XSSFCell Constructor with different
MissingCellPolicy</des
 cription></item><item><title> fix(bug 56888)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 56888) - XSSFDataValidation ignores "allow blank" read from sheet,
assumes true</description></item><item><title> fix(bug 57171)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57171) - Adjust the active sheet in setSheetOrder()</description></item><item><title>
fix(bug 57163)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57163) - Adjust the active sheet in removeSheet()</description></item><item><title>
fix(bug 57231)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57231) - Add missing ArrayRecord.clone()</description></item><item><title>
add</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers - Expose the version information from OldExcelExtractor</description></ite
 m><item><title> fix(bug 57071)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57071) - 3+ XSSF column label names for pivot tables</description></item><item><title>
add(bug 57063)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 57063) - XSSF custom column label names for pivot tables</description></item><item><title>
fix(bug 57254)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57254) - XWPF: Correctly build internal list of styles when styles
are added</description></item><item><title> fix(bug 57312)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57312) - XWPF: Add check for null value of underline w:val</description></item></channel></rss>
\ No newline at end of file
+<rss version="0.91"><channel><title>POI Changes</title><link>http://poi.apache.org/changes.html</link><description>POI
Changes</description><language>en-us</language><item><title>
add(bug 53453)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 53453) - Add methods to set margins in sections of HWPF documents</description></item><item><title>
fix(bug 46898)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 46898) - XSSF: Return #VALUE! for circular references.</description></item><item><title>
fix(bug 46192)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 46192) - Add methods to query outline level for HSSF and XSSF</description></item><item><title>
fix(bug 56240)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 56240) - Handle PP97_DUALSTORAGE streams</description></item><item><title>
fix(bug 47261)</t
 itle><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 47261) - SlideShow.removeSlide makes PPT corrupted</description></item><item><title>
add(bug 49541)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 49541) - Mapping of symbol characters to unicode equivalent</description></item><item><title>
add(bug 54541)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 54541) - Add support for cropped images in Slide.draw()</description></item><item><title>
add(bug 57007)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 57007) - Add initial implementations of DMIN and DGET functions</description></item><item><title>
add</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers - Support for Office Binary Document RC4 CryptoAPI Encryption for HSLF</description></item><item><title>
add(bug 
 57195)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 57195) - Support for Office Binary Document RC4 Encryption</description></item><item><title>
fix(bug 57373)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57373) - Fix get/setFirstVisibleTab() for XSSFWorkbook</description></item><item><title>
fix(bug 57362)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57362) - Properly initialize chart-axis datastructure when loading
a spreadsheet which already contains one.</description></item><item><title>
fix(bug 56511)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 56511) - Fix NullPointerException for RichText strings with no
formatting for some runs.</description></item><item><title> add(bug
56550)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 56550) 
 - Avoid IBM JDK fail immediately during loading some POI classes, note: IBM JDK 1.7 or higher
is needed because of XML APIs.</description></item><item><title> add(bug
56595)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 56595) - Switch the cache in DateUtil.isADateFormat() to ThreadLocals
to not have another syncpoint here.</description></item><item><title>
fix(bug 56644)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 56644) - NullPointerException in XSSFCell Constructor with different
MissingCellPolicy</description></item><item><title> fix(bug 56888)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 56888) - XSSFDataValidation ignores "allow blank" read from sheet,
assumes true</description></item><item><title> fix(bug 57171)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57171) - Adjust the act
 ive sheet in setSheetOrder()</description></item><item><title> fix(bug
57163)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57163) - Adjust the active sheet in removeSheet()</description></item><item><title>
fix(bug 57231)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57231) - Add missing ArrayRecord.clone()</description></item><item><title>
add</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers - Expose the version information from OldExcelExtractor</description></item><item><title>
fix(bug 57071)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57071) - 3+ XSSF column label names for pivot tables</description></item><item><title>
add(bug 57063)</title><link>http://poi.apache.org/changes.html</link><description>
add by POI Developers (bug 57063) - XSSF custom column label names for pivot tables</descri
 ption></item><item><title> fix(bug 57254)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57254) - XWPF: Correctly build internal list of styles when styles
are added</description></item><item><title> fix(bug 57312)</title><link>http://poi.apache.org/changes.html</link><description>
fix by POI Developers (bug 57312) - XWPF: Add check for null value of underline w:val</description></item></channel></rss>
\ No newline at end of file

Modified: poi/site/publish/encryption.html
URL: http://svn.apache.org/viewvc/poi/site/publish/encryption.html?rev=1649777&r1=1649776&r2=1649777&view=diff
==============================================================================
--- poi/site/publish/encryption.html (original)
+++ poi/site/publish/encryption.html Tue Jan  6 11:04:34 2015
@@ -257,26 +257,195 @@ if (VERSION > 3) {
 	
 <ul>
 		
-<li>XLS - RC4 Encryption</li>
+<li>Binary formats (.xls, .ppt, .doc, ...)<br>
+        encryption is format-dependent and needs to be implemented per format differently.<br>
+        Use <a href="http://poi.apache.org/apidocs/org/apache/poi/hssf/record/crypto/Biff8EncryptionKey.html">
+        Biff8EncryptionKey</a>.setCurrentUserPassword(String password)
+        to specify the decryption password before opening the file or (where applicable)
before saving.
+        Setting a null password before saving removes the password protection.<br>
+        The password is set in a thread local variable. Do not forget to reset it to null
after text extraction.
+        </li>
 		
-<li>XML-based formats (XLSX, DOCX and etc) - AES and Agile Encryption</li>
+<li>XML-based formats (.xlsx, .pptx, .docx, ...)<br>
+        use the same encryption logic over all formats. When encrypted, the zipped files
will be
+        stored within an OLE file in the EncryptedPackage stream.<br>
+        If you plan to use POI to actually generate encrypted documents, be aware not to
use anything less than
+        agile encryption, because <a href="http://blogs.msdn.com/b/david_leblanc/archive/2010/04/16/don-t-use-office-rc4-encryption-really-just-don-t-do-it.aspx">RC4
is not really secure</a>.
+        Of course you'll need to make sure, that your clients can read the documents,
+        i.e. the various free Excel, Powerpoint, Word viewers have limitations in the cipher
or hashing parameters.<br>
+        If you want to use high encryption parameters, you need to install the "Java Cryptography
Extension (JCE) Unlimited
+        Strength Jurisdiction Policy Files" for your JRE version
+        (Oracle <a href="http://www.oracle.com/technetwork/java/javase/downloads/jce-6-download-429243.html">JDK6</a>,
+        <a href="http://www.oracle.com/technetwork/java/javase/downloads/jce-7-download-432124.html">JDK7</a>,
+        <a href="http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html">JDK8</a>).
+        </li>
 	
 </ul>
 
 	
-<p>Some "write-protected" files are encrypted with build-in password, POI can read
that files too.</p>
+<p>Some "write-protected" files are encrypted with the built-in password "VelvetSweatshop",
POI can read that files too.</p>
     	
 
     
-<a name="XLS"></a>
+<a name="Supported+feature+matrix"></a>
 <div class="h3">
-<h3>XLS</h3>
+<h3>Supported feature matrix</h3>
+</div>
+    
+    
+<p></p>
+
+    
+<table class="ForrestTable" cellspacing="1" cellpadding="4">
+        
+<tr class="b">
+            
+<td colspan="1" rowspan="1"></td>
+            <td colspan="1" rowspan="1">HSSF</td>
+            <td colspan="1" rowspan="1">HSLF</td>
+            <td colspan="1" rowspan="1">HWPF</td>
+            <td colspan="1" rowspan="1">XSSF</td>
+            <td colspan="1" rowspan="1">XSLF</td>
+            <td colspan="1" rowspan="1">XWPF</td>
+        
+</tr>
+        
+<tr class="a">
+            
+<td colspan="1" rowspan="1"><a href="http://msdn.microsoft.com/en-us/library/dd949802(v=office.12).aspx">XOR
obfuscation</a></td>
+            <td class="feature-partly" colspan="1" rowspan="1">Read</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-no" colspan="1" rowspan="1">No</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+        
+</tr>
+        
+<tr class="b">
+            
+<td colspan="1" rowspan="1"><a href="http://msdn.microsoft.com/en-us/library/dd909583(v=office.12).aspx">40-bit
RC4 encryption</a></td>
+            <td class="feature-partly" colspan="1" rowspan="1">Read</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-no" colspan="1" rowspan="1">No</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+        
+</tr>
+        
+<tr class="a">
+            
+<td colspan="1" rowspan="1"><a href="http://msdn.microsoft.com/en-us/library/dd910113(v=office.12).aspx">Office
Binary Document RC4 CryptoAPI Encryption</a></td>
+            <td class="feature-no" colspan="1" rowspan="1">No</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+            <td class="feature-no" colspan="1" rowspan="1">No</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+        
+</tr>
+        
+<tr class="b">
+            
+<td colspan="1" rowspan="1"><a href="http://msdn.microsoft.com/en-us/library/dd907466(v=office.12).aspx">Office
Binary Document RC4 Encryption *)</a></td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+        
+</tr>
+        
+<tr class="a">
+            
+<td colspan="1" rowspan="1"><a href="http://msdn.microsoft.com/en-us/library/dd906131(v=office.12).aspx">ECMA-376
Standard Encryption</a></td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+        
+</tr>
+        
+<tr class="b">
+            
+<td colspan="1" rowspan="1"><a href="http://msdn.microsoft.com/en-us/library/dd906131(v=office.12).aspx">ECMA-376
Agile Encryption</a></td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+        
+</tr>
+        
+<tr class="a">
+            
+<td colspan="1" rowspan="1"><a href="http://msdn.microsoft.com/en-us/library/ms757845(v=vs.85).aspx">ECMA-376
XML Signature</a></td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-na" colspan="1" rowspan="1">N/A</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+            <td class="feature-yes" colspan="1" rowspan="1">Yes</td>
+        
+</tr>
+    
+</table>
+    
+    
+<p>*) the <a href="http://msdn.microsoft.com/en-us/library/cc313071(v=office.12).aspx">MS-OFFCRYPTO</a>
+    documentation only mentions the RC4 (without CryptoAPI) encryption as a "in place" encryption,
but
+    apparently there's also a container based method with that key generation logic. 
+    </p>
+    
+
+    
+<a name="Binary+formats"></a>
+<div class="h3">
+<h3>Binary formats</h3>
 </div>
     	
-<p>When HSSF receive encrypted file, it tries to decode it with MSOffice build-in password.

-	Use static method setCurrentUserPassword(String password) of org.apache.poi.hssf.record.crypto.Biff8EncryptionKey
to
-	set password. It sets thread local variable. Do not forget to reset it to null after text
extraction.
-	</p>
+<p>As mentioned above, use
+        <a href="http://poi.apache.org/apidocs/org/apache/poi/hssf/record/crypto/Biff8EncryptionKey.html">
+        Biff8EncryptionKey</a>.setCurrentUserPassword(String password)
+        to specify the password.</p>
+        
+        
+<pre class="code">
+// XOR/RC4 decryption for xls
+Biff8EncryptionKey.setCurrentUserPassword("pass");
+NPOIFSFileSystem fs = new NPOIFSFileSystem(new File("file.xls"), true);
+HSSFWorkbook hwb = new HSSFWorkbook(fs.getRoot(), true);
+Biff8EncryptionKey.setCurrentUserPassword(null);
+        </pre>
+        
+        
+<pre class="code">
+// RC4 CryptoApi support ppt - decryption
+Biff8EncryptionKey.setCurrentUserPassword("pass");
+NPOIFSFileSystem fs = new NPOIFSFileSystem(new File("file.ppt"), true);
+HSLFSlideShow hss = new HSLFSlideShow(fs);
+...
+// Option 1: remove password
+Biff8EncryptionKey.setCurrentUserPassword(null);
+OutputStream os = new FileOutputStream("decrypted.ppt");
+hss.write(os);
+os.close();
+...
+// Option 2: change encryption settings (experimental)
+// need to cache data (i.e. read all data) before changing the key size
+PictureData picsExpected[] = hss.getPictures();
+hss.getDocumentSummaryInformation();
+EncryptionInfo ei = hss.getDocumentEncryptionAtom().getEncryptionInfo();
+((CryptoAPIEncryptionHeader)ei.getHeader()).setKeySize(0x78);
+OutputStream os = new FileOutputStream("file_120bit.ppt");
+hss.write(os);
+os.close();
+        </pre>
     
 
     
@@ -318,11 +487,11 @@ try {
 </div>
      
 <p>Encrypting a file is similar to the above decryption process. Basically you'll need
to choose between
-     <a href="http://msdn.microsoft.com/en-us/library/dd952186(v=office.12).aspx">standard
and agile encryption</a>.
+     <a href="http://poi.apache.org/apidocs/org/apache/poi/poifs/crypt/EncryptionMode.html">binaryRC4,
standard and agile encryption</a>,
+     the cryptoAPI mode is used internally and it's direct use would result in an incomplete
file.
      Apart of the CipherMode, the EncryptionInfo class provides further parameters to specify
the cipher and
      hashing algorithm to be used.</p>
      
-     
 <pre class="code">
 POIFSFileSystem fs = new POIFSFileSystem();
 EncryptionInfo info = new EncryptionInfo(fs, EncryptionMode.agile);

Modified: poi/site/publish/skin/mysite.css
URL: http://svn.apache.org/viewvc/poi/site/publish/skin/mysite.css?rev=1649777&r1=1649776&r2=1649777&view=diff
==============================================================================
--- poi/site/publish/skin/mysite.css (original)
+++ poi/site/publish/skin/mysite.css Tue Jan  6 11:04:34 2015
@@ -137,3 +137,19 @@ body, th, td {
   font-family: "Courier New", Courier, monospace;
   font-size: 110%;
 }
+
+td .feature-yes {
+  background: #9f9
+}
+
+td .feature-no {
+  background: #f99 
+}
+
+td .feature-partly {
+  background: #bfd
+}
+
+td .feature-na {
+  background: #ddf
+}

Modified: poi/site/publish/spreadsheet/limitations.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/limitations.html?rev=1649777&r1=1649776&r2=1649777&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/limitations.html (original)
+++ poi/site/publish/spreadsheet/limitations.html Tue Jan  6 11:04:34 2015
@@ -200,14 +200,27 @@ if (VERSION > 3) {
 <li>
                     Charts<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>
+					
+<ul>
+						
+<li>
+							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>
+						
+</li>
+						
+<li>
+							XSSF has only limited chart support including making some simple changes 
+							and adding at least some line and scatter charts, see the examples <em>LineChart</em>

+							and <em>ScatterChart</em>.<br>
 <br>
+						
+</li>
+					
+</ul>
                 
 </li>
                 



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message