Bug 53025 - Suggested update to Data Validation section in Quick Guide.
Summary: Suggested update to Data Validation section in Quick Guide.
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.8-dev
Hardware: PC All
: P2 trivial (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2012-04-02 15:27 UTC by Mark B
Modified: 2012-05-18 09:27 UTC (History)
0 users

Updatad documentation and example. (18.16 KB, application/zip)
2012-04-02 15:27 UTC, Mark B
Quick Guide - Hiding and un-hiding rows. (1.74 KB, text/plain)
2012-04-03 14:07 UTC, Mark B

Note You need to log in before you can comment on or make changes to this bug.
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