Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
From: "Karl-Heinz Zengerle" <karl-heinz.zengerle@sawag.com>
To: "'POI Users List'" <poi-user@jakarta.apache.org>
Subject: AW: Combo Box
Date: Mon, 9 Feb 2004 19:25:46 +0100
Organization: SAW AG
Message-ID: <005201c3ef3a$22e12d30$3900000a@karlheinzMOBIL>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
In-Reply-To: <4027CE66.7070203@muibros.com>
Importance: Normal

Hi Ruben.

That's exactly why we mix the usage of POI and Excel macros. You might
use an invisible sheet where you write that data and possibly some
indicator which tells you that you've to fill the combo box when opening
Excel (if you don't always like to do it).

Then it's POI without any "exotic" elements.

In that case you shouldn't use the Excel combo boxes because they can't
be filled as comfortable as the "normal" ones in VB.

Regards,	Karl-Heinz.


-----Urspr=FCngliche Nachricht-----
Von: Danny Mui [mailto:danny@muibros.com]=20
Gesendet: Montag, 9. Februar 2004 19:16
An: POI Users List
Betreff: Re: Combo Box

I don't think we have any support for Data Validation at this moment.=20
There have been some talk about implementing it on the list but I do not

think it is available.  A possible workaround with any unsupported=20
feature in HSSF is to use a template that has that feature in it and=20
fill in your data as you go.


Ruben Saavedra wrote:
> What I have to do is to generate a report in excel with the content of
a jsp.
> This jsp has a combo box(drop down list) that it needed to draw in
excel.
> Thank you for your help,Karl-Heinz.
>=20
> Atte.
> Rub=E9n E. Saavedra
> 380-2941
>=20
>=20
> -----Mensaje original-----
> De: Karl-Heinz Zengerle [mailto:karl-heinz.zengerle@sawag.com]
> Enviado el: Lunes, 09 de Febrero de 2004 11:10
> Para: 'POI Users List'
> Asunto: AW: Combo Box
>=20
>=20
> Hi Ruben.
> =20
> We also program with Java & POI but we also do things in Excel
directly.
> There we've also the problem with combo boxes and have seen that there
> are different types (Excel combo boxes - with direct connection to
some
> data source  - and other combo boxes - I hope those from the forms
> library). The different types are different to handle.
> =20
> So most likely you've to tell more precisely what you want to do.
> =20
> Regards,           Karl-Heinz.
> =20
> -----Urspr=FCngliche Nachricht-----
> Von: Ruben Saavedra [mailto:rsaavedra@Falabella.cl]=20
> Gesendet: Montag, 9. Februar 2004 17:02
> An: Poi-Jakarta (E-mail)
> Betreff: RV: Combo Box
> =20
> =20
> I am starting working with POI. Please, I need to know if there is
some
> method that a combobox draws in a sheet excel.=20
> Thank you.=20
>  =20
> =20
> Atte.
> Rub=E9n E. Saavedra
> 380-2941
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>=20

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


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