In xls one field contains more than 20 characters. When I upload that xls,
initially it shows the data only not in red color box. But when I click the
box only it shows red color. How can I show in red color when load the
document.
Ayodeji Aladejebi wrote:
>
> meanwhile for the AjaxExcelGirdPanel, you have to click on the cell labels
> to edit them and you will require
> wicket-extensions along with the wicket jar to make it work
>
> regards
>
> On 7/4/07, Ayodeji Aladejebi <[EMAIL PROTECTED]> wrote:
>>
>> hmm..i have been busy
>>
>> but i worked a quick fix for you
>>
>> it is attached, its a netbeans project folder.
>>
>> I really hope you find it useful
>>
>> There are two panels there that meet your requirements
>> ExcelGridPanel and AjaxExcelGridPanel
>>
>> i does not support paging yet so that gagantic excel data wont scatter
>> the
>> screen
>>
>> I also realized that Loop and ListView have a lot of difference cuz
>> igor's
>> validation error notification code did not work with Loop until i
>> modified
>> it to ListView
>>
>> Either way, you could work your way from what is attached
>>
>> when i have more updates, i will let you know
>>
>> regards
>>
>>
>> On 7/2/07, Edi <[EMAIL PROTECTED]> wrote:
>> >
>> >
>> > Excuse me,
>> >
>> > ANy updates? please
>> >
>> >
>> >
>> > Ayodeji Aladejebi wrote:
>> > >
>> > > alas...igor has rescued us
>> > > pls give me some time to update the code wih this approach and send
>> it
>> > to
>> > > yu
>> > >
>> > > On 6/29/07, Igor Vaynberg <[EMAIL PROTECTED]> wrote:
>> > >>
>> > >> On 6/29/07, Ayodeji Aladejebi <[EMAIL PROTECTED] > wrote:
>> > >> >
>> > >> > that should be simple, although my wicket is bit rusty at the
>> > moment, I
>> > >> > think
>> > >> >
>> > >> > final TextField tx = new TextField("cell", new
>> > >> > PropertyModel(values[row][col],"data"));
>> > >> > tx.add(new IValidator(){
>> > >> > public void validate(FormComponent fc){
>> > >> >
>> > >> > if(fc.getValue () is greater than 20){
>> > >> > fc.add(new AttributeModifier("style",true, new
>> > >> > Model("background-color: #FF0000;")));
>> > >> > fc.error("error.toolongvalue ",null);
>> > >> > }else{
>> > >> > fc.add(new AttributeModifier("style",true, new
>> > >> > Model("background-color: normal-color;")));
>> > >> > }
>> > >> >
>> > >> > }
>> > >> > });
>> > >> > item.add(tx);
>> > >> >
>> > >> >
>> > >> > something like dat...just buzz around
>> > >>
>> > >>
>> > >> ayyayay, i guess no matter how you try to engineer the api people
>> > always
>> > >> find ways to abuse it :)
>> > >>
>> > >> TextField tf=new TextField(....) { oncomponenttag(tag) { if
>> > (!isvalid())
>> > >> {
>> > >> tag.put("class","error"); } }};
>> > >> tf.add(StringValidator.maxLength(20));
>> > >>
>> > >> -igor
>> > >>
>> > >>
>> > >>
>> > >> On 6/29/07, Edi < [EMAIL PROTECTED] > wrote:
>> > >> > >
>> > >> > >
>> > >> > > Or, tell me how to validate, if the text box value exceeds 20
>> > >> > > characters, I
>> > >> > > want to change the color of the text box. HOW?
>> > >> > >
>> > >> > >
>> > >> > >
>> > >> > > Ayodeji Aladejebi wrote:
>> > >> > > >
>> > >> > > > well,
>> > >> > > > yu can use String.length to do dat. but be aware it might
>> > jumble
>> > >> > > your
>> > >> > > > table
>> > >> > > > because some Text will be *This is a very long text that can
>> > expand
>> > >> > > the
>> > >> > > > Textfield too much* and some will be just "Hi".
>> > >> > > >
>> > >> > > > I had to make that trade off as well
>> > >> > > >
>> > >> > > > i am looking for some javascript technique maybe yu can show
>> me
>> > if
>> > >> > > yu
>> > >> > > > find.
>> > >> > > >
>> > >> > > > Look for a javascript library that can allow a user to
>> > dynamically
>> > >> > > expand
>> > >> > > > the textfield lenght with his mouse. so that we can attach
>> that
>> >
>> > >> > > Behavior
>> > >> > > > to
>> > >> > > > each Textfield
>> > >> > > >
>> > >> > > >
>> > >> > > >
>> > >> > > > On 6/29/07, Edi < [EMAIL PROTECTED]> wrote:
>> > >> > > >>
>> > >> > > >>
>> > >> > > >> Hi,
>> > >> > > >>
>> > >> > > >> In your sample code,
>> > >> > > >>
>> > >> > > >> tx.add (new AttributeModifier("size",true, new
>> > >> Model(String.valueOf
>> > >> > > (8))));
>> > >> > > >> It shows all the size of textbox is same.
>> > >> > > >>
>> > >> > > >> I want to change the size of text box value according to text
>> > each
>> > >> > > >> contents
>> > >> > > >>
>> > >> > > >>
>> > >> > > >>
>> > >> > > >> Ayodeji Aladejebi wrote:
>> > >> > > >> >
>> > >> > > >> > meanwhile,
>> > >> > > >> > if yu look at this code in the Wicket - JExcel example
>> > >> > > >> >
>> > >> > > >> > Cell cell = sheet.getCell(col, row);
>> > >> > > >> > values[row][col] = new
>> > >> > > XCell(row,
>> > >> > > >> > col,cell.getContents());
>> > >> > > >> >
>> > >> > > >> > return
>> > >> > > values[row][col].getData();
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >> > The Cell object is from JExcel and its where Datatype
>> should
>> > be
>> > >> > > >> retrieved
>> > >> > > >> > from
>> > >> > > >> >
>> > >> > > >> > 2. To validate,
>> > >> > > >> >
>> > >> > > >> > You can write a default wicket validator (See Validator
>> > >> > > examples),
>> > >> > > >> > The validator can access the Textfield arrays and then
>> check
>> > for
>> > >> > > >> validity
>> > >> > > >> >
>> > >> > > >> > its shouldn't be too difficult anyway
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >> > On 6/28/07, Ayodeji Aladejebi <[EMAIL PROTECTED] > wrote:
>> > >> > > >> >>
>> > >> > > >> >> I think that is within the scope of the JExcel API and not
>> > a
>> > >> > > wicket
>> > >> > > >> >> thing.
>> > >> > > >> >> Refer to the JExcel API doc first
>> > >> > > >> >>
>> > >> > > >> >> On 6/28/07, Edi < [EMAIL PROTECTED] > wrote:
>> > >> > > >> >> >
>> > >> > > >> >> >
>> > >> > > >> >> > Hi,
>> > >> > > >> >> >
>> > >> > > >> >> > I am Newbie of Wicket. I have downloaded sample example
>> > to
>> > >> > > read XLS
>> > >> > > >> >> file
>> > >> > > >> >> >
>> > >> > > >> >> > using Wicket with JExcel.
>> > >> > > >> >> > It's working fine.
>> > >> > > >> >> >
>> > >> > > >> >> > My doubt is 1.How can I retrieve the datatype of each
>> > cell?
>> > >> > > and 2.
>> > >> > > >> How
>> > >> > > >> >> > to
>> > >> > > >> >> > validate the each cell values?
>> > >> > > >> >> >
>> > >> > > >> >> > Please give me some Suggestions.
>> > >> > > >> >> >
>> > >> > > >> >> > Thanking You.
>> > >> > > >> >> > Regards,
>> > >> > > >> >> > Edi
>> > >> > > >> >> > --
>> > >> > > >> >> > View this message in context:
>> > >> > > >> >> >
>> > >> > >
>> http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11342103
>> > >> > > >> >> > Sent from the Wicket - User mailing list archive at
>> > >> Nabble.com
>> > >> > > .
>> > >> > > >> >> >
>> > >> > > >> >> >
>> > >> > > >> >> >
>> > >> > > >> >> >
>> > >> > > >> >>
>> > >> > > >>
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > > >> >> > This SF.net email is sponsored by DB2 Express
>> > >> > > >> >> > Download DB2 Express C - the FREE version of DB2 express
>> > and
>> > >> > > take
>> > >> > > >> >> > control of your XML. No limits. Just data. Click to get
>> > it
>> > >> > > now.
>> > >> > > >> >> > http://sourceforge.net/powerbar/db2/
>> > >> > > >> >> > _______________________________________________
>> > >> > > >> >> > Wicket-user mailing list
>> > >> > > >> >> > Wicket-user@lists.sourceforge.net
>> > >> > > >> >> > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > > >> >> >
>> > >> > > >> >>
>> > >> > > >> >>
>> > >> > > >> >>
>> > >> > > >> >> --
>> > >> > > >> >>
>> > >> > > >> >>
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >>
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > > >> > This SF.net email is sponsored by DB2 Express
>> > >> > > >> > Download DB2 Express C - the FREE version of DB2 express
>> and
>> > >> take
>> > >> > > >> > control of your XML. No limits. Just data. Click to get it
>> > now.
>> > >> > > >> > http://sourceforge.net/powerbar/db2/
>> > >> > > >> > _______________________________________________
>> > >> > > >> > Wicket-user mailing list
>> > >> > > >> > Wicket-user@lists.sourceforge.net
>> > >> > > >> > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >>
>> > >> > > >> --
>> > >> > > >> View this message in context:
>> > >> > > >>
>> > http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11356793
>> > >> > > >> Sent from the Wicket - User mailing list archive at
>> Nabble.com
>> > .
>> > >> > > >>
>> > >> > > >>
>> > >> > > >>
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > > >> This SF.net email is sponsored by DB2 Express
>> > >> > > >> Download DB2 Express C - the FREE version of DB2 express and
>> > take
>> > >> > > >> control of your XML. No limits. Just data. Click to get it
>> > now.
>> > >> > > >> http://sourceforge.net/powerbar/db2/
>> > >> > > >> _______________________________________________
>> > >> > > >> Wicket-user mailing list
>> > >> > > >> Wicket-user@lists.sourceforge.net
>> > >> > > >> https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > > >>
>> > >> > > >
>> > >> > > >
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > > > This SF.net email is sponsored by DB2 Express
>> > >> > > > Download DB2 Express C - the FREE version of DB2 express and
>> > take
>> > >> > > > control of your XML. No limits. Just data. Click to get it
>> now.
>> >
>> > >> > > > http://sourceforge.net/powerbar/db2/
>> > >> > > > _______________________________________________
>> > >> > > > Wicket-user mailing list
>> > >> > > > Wicket-user@lists.sourceforge.net
>> > >> > > > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > > >
>> > >> > > >
>> > >> > >
>> > >> > > --
>> > >> > > View this message in context:
>> > >> > >
>> http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11357007
>> > >> > > Sent from the Wicket - User mailing list archive at Nabble.com.
>> > >> > >
>> > >> > >
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > >
>> > >> > > This SF.net email is sponsored by DB2 Express
>> > >> > > Download DB2 Express C - the FREE version of DB2 express and
>> take
>> >
>> > >> > > control of your XML. No limits. Just data. Click to get it now.
>> > >> > > http://sourceforge.net/powerbar/db2/
>> > >> > > _______________________________________________
>> > >> > > Wicket-user mailing list
>> > >> > > Wicket-user@lists.sourceforge.net
>> > >> > > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > >
>> > >> >
>> > >> >
>> > >> >
>> > >> >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > This SF.net email is sponsored by DB2 Express
>> > >> > Download DB2 Express C - the FREE version of DB2 express and take
>> > >> > control of your XML. No limits. Just data. Click to get it now.
>> > >> > http://sourceforge.net/powerbar/db2/
>> > >> > _______________________________________________
>> > >> > Wicket-user mailing list
>> > >> > Wicket-user@lists.sourceforge.net
>> > >> > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> >
>> > >> >
>> > >>
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> This SF.net email is sponsored by DB2 Express
>> > >> Download DB2 Express C - the FREE version of DB2 express and take
>> > >> control of your XML. No limits. Just data. Click to get it now.
>> > >> http://sourceforge.net/powerbar/db2/
>> > >> _______________________________________________
>> > >> Wicket-user mailing list
>> > >> Wicket-user@lists.sourceforge.net
>> > >> https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >>
>> > >>
>> > >
>> > >
>> >
>> -------------------------------------------------------------------------
>> > > This SF.net email is sponsored by DB2 Express
>> > > Download DB2 Express C - the FREE version of DB2 express and take
>> > > control of your XML. No limits. Just data. Click to get it now.
>> > > http://sourceforge.net/powerbar/db2/
>> > > _______________________________________________
>> > > Wicket-user mailing list
>> > > Wicket-user@lists.sourceforge.net
>> > > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >
>> > >
>> >
>> > --
>> > View this message in context:
>> > http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11394181
>> > Sent from the Wicket - User mailing list archive at Nabble.com.
>> >
>> >
>> >
>> >
>> -------------------------------------------------------------------------
>> > This SF.net email is sponsored by DB2 Express
>> > Download DB2 Express C - the FREE version of DB2 express and take
>> > control of your XML. No limits. Just data. Click to get it now.
>> > http://sourceforge.net/powerbar/db2/
>> > _______________________________________________
>> > Wicket-user mailing list
>> > Wicket-user@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> >
>>
>>
>>
>>
>>
>>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Wicket-user mailing list
> Wicket-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wicket-user
>
>
--
View this message in context:
http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11424912
Sent from the Wicket - User mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Wicket-user mailing list
Wicket-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wicket-user
