Hi
i tried to retrieve a DVRecord from a HSSFDataValidation object by
passing the sheet as a parameter,
dvRecord = dataValidation.createDVRecord(sheet);
boolean isList = validationRecord.getListExplicitFormula();
if (isList) {
System.out.println("List found");
}
but I need to create a DataValidation object for that. DataValidation
class does not expose a constructor, so if i create a DVConstraint
object using the createExplicitListConstraint(String[] list) method i
have to provide the string array.
Is there any solution to get around this and check whether the sheet
contains an ListExplicitFormula?
Thanks in advance for your time!
On Thu, Nov 18, 2010 at 10:59 AM, Sewwandi <[email protected]> wrote:
> Thanks a lot for the reply!
>
> On Wed, Nov 17, 2010 at 9:43 PM, Mark Beardsley
> <[email protected]> wrote:
>>
>> Sorry to say this but as far as I am aware, there is no way to recover the
>> values the user may have specified for the list validation. If you are lucky
>> and the list validation has been constructed from a range of cells that ypou
>> know about in advance of parsing the sheet then you would be able to recover
>> the values from these cells.
>>
>> If you felt like working on a patch for the API that adds this
>> finctionality, then I am sure there will be many appreciative users. The
>> easiest place to start would be with XSSF in my opionion as it is built over
>> another layer called xmlbeans. Those classes are created by parsing the XSD
>> schema for the xlsx file format and so there will almost certainly be
>> methods somewhere that allow you to both get and set the list validations
>> contents. If you need any help getting started, I am confident that someone
>> od the dev list will help with advice.
>>
>> Yours
>>
>> Mark B
>> --
>> View this message in context:
>> http://apache-poi.1045710.n5.nabble.com/Identifying-Combo-boxes-in-excel-sheets-tp3268561p3269309.html
>> Sent from the POI - User mailing list archive at Nabble.com.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
