I'm not sure if this will be of any help to you but I know you can get
Excel to use a named range to define the values of a drop down.
I have spreadsheets that use a column in another worksheet to store the
drop down values that are available, and as such all the values are
readable in POI.
Tim
Lauren Riley wrote:
Elvis,
I've tried to have an existing spreadsheet that has just my drop downs
so I could copy them into a new sheet. I can only copy the first entry
in the drop down...I can't get to the other values.
This is driving me nuts because I really need this ability! So I'm
trying to figure out a different solution.
Lauren
Inactive hide details for Elvis Willems <[EMAIL PROTECTED]>Elvis
Willems <[EMAIL PROTECTED]>
*Elvis Willems <[EMAIL PROTECTED]>*
12/10/2007 08:52 AM
Please respond to
"POI Users List" <[email protected]>
To
POI Users List <[email protected]>
cc
Subject
Re: Drop Down List Cell
Am I right in thinking that .xls files that already have a selection
list pre-made, can not be read by POI either?
Regards,
Elvis Willems
On Mon, 2007-12-10 at 13:13 +0000, Nick Burch wrote:
> On Thu, 6 Dec 2007, Lauren Riley wrote:
> > Have dropdown lists been added to the POI API?
>
> I don't believe so, no
>
> > If not, when will they?
>
> As soon as someone wants to contribute the code for it!
>
> If you are interested in adding support for it, please join the dev
list
> and we can give you advice on the best way to get started with
writing the
> support for it. Otherwise, a few of the poi developers do offer
> consulting - if you're interested, people can contact you off-list.
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
**** DISCLAIMER ****
http://www.schaubroeck.be/maildisclaimer.htm
__________________________________________
The information contained in this message may be privileged and
confidential and protected from disclosure. If you are not the
intended recipient of this message, you are hereby notified that any
dissemination, distribution, or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message, and please
delete it from your computer.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
