Bug 53025

Summary: Suggested update to Data Validation section in Quick Guide.
Product: POI Reporter: Mark B <markbrdsly>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: trivial    
Priority: P2    
Version: 3.8-dev   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: Updatad documentation and example.
Quick Guide - Hiding and un-hiding rows.

Description Mark B 2012-04-02 15:27:56 UTC
Created attachment 28529 [details]
Updatad documentation and example.

Updated Data validations section to include examples for XSSF.Usermodel and SS.Usermodel packages. Also included brief details of how to implement linked or dependent drop down lists. Attached archive includes the following;

Updated documentation in both raw text and .doc format.
Source code for full example of dependent or linked drop down lists examples.

Also, plan to include an example in the quick guide that demonstrates how to hide rows on a sheet. The method that should be used to accomplish this is called setZeroHeight() and it was mentioned on the user list that this is misleading as the javadoc simply says this about the method "set whether or not to display this row with 0 height". It may also be worthwhile modifying the javadoc to say that this method may be used to hide the row (similar to selecting the row on the sheet, right clicking and then selecting hide from the pop-up menu when using Excel). Have not included that here as I want to wrute test code to check the hypothesis.
Comment 1 Mark B 2012-04-03 14:07:36 UTC
Created attachment 28539 [details]
Quick Guide - Hiding and un-hiding rows.
Comment 2 Yegor Kozlov 2012-05-18 09:27:28 UTC
Applied in r1340042

Thanks, Mark