Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 76327 invoked from network); 5 Nov 2003 14:47:53 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 5 Nov 2003 14:47:53 -0000 Received: (qmail 847 invoked by uid 500); 5 Nov 2003 14:47:45 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 832 invoked by uid 500); 5 Nov 2003 14:47:45 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 819 invoked from network); 5 Nov 2003 14:47:45 -0000 Received: from unknown (HELO sec.co.ro) (217.10.198.22) by daedalus.apache.org with SMTP; 5 Nov 2003 14:47:45 -0000 Received: from sec.co.ro (mariuso.sec.co.ro [192.168.3.12]) by sec.co.ro (Postfix on SuSE Linux) with ESMTP id 1EC1F12CE4 for ; Wed, 5 Nov 2003 16:41:15 +0200 (EET) Message-ID: <3FA90D91.1080609@sec.co.ro> Disposition-Notification-To: Marius Oancea Date: Wed, 05 Nov 2003 16:47:45 +0200 From: Marius Oancea User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: POI Users List Subject: I create a first support for Data Validation Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I needed a way to create html:select like controls using poi. I decided to implement data-validation to create this control. (in menu Data-> Validation -> type List .... ). I only tested Data validation type list but should work for other types too (ranges with formulas .... ). The code is done with about 3-4 hacks that can be improoved easily. If sombody wants the code or can tall me how to share tis code I'll be happy. Cheers Marius -- "Why program by hand in five days what you can spend five years of your life automating." - Terence Parr --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: poi-user-help@jakarta.apache.org