Home All Groups Group Topic Archive Search About
Author
28 Apr 2005 8:13 PM
Bob Morvay
My users want to be able to use the Web Datagrid like an excel spreadsheet.
This means a fully editible grid with arrow key navigation between cells.
The grid seems to support horizontal tabbing between cells but nothing for
the arrow keys.  I have googled for sample code but the best that I could
find was some half completed javascript that captures the key events but
doesn't quite show me how to use it in the grid.  I was wondering if anyone
has any example code where an editable grid could be navigated from cell to
cell using the arrow keys (Left, Right, Up and Down).

Thanks in advance.

Author
29 Apr 2005 1:32 AM
Alvin Bruney [MVP - ASP.NET]
You'd have to do a lot of javascript for that. I'm curious, why don't you
just use a bonafide excel object - the Microsoft Office Web Components is a
good alternative for just such an application.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
Show quoteHide quote
"Bob Morvay" <r@r.com> wrote in message
news:umv2B7CTFHA.3332@TK2MSFTNGP15.phx.gbl...
> My users want to be able to use the Web Datagrid like an excel
> spreadsheet.
> This means a fully editible grid with arrow key navigation between cells.
> The grid seems to support horizontal tabbing between cells but nothing for
> the arrow keys.  I have googled for sample code but the best that I could
> find was some half completed javascript that captures the key events but
> doesn't quite show me how to use it in the grid.  I was wondering if
> anyone
> has any example code where an editable grid could be navigated from cell
> to
> cell using the arrow keys (Left, Right, Up and Down).
>
> Thanks in advance.
>
>
>
Author
29 Apr 2005 12:28 PM
Bob Morvay
Two reasons... It is an existing ASP.Net application and I have never used
the Microsoft Office Web Component :)  Where can I learn more about the
Excel object as it can be used in a web components?

Show quoteHide quote
"Alvin Bruney [MVP - ASP.NET]" <www.lulu.com/owc> wrote in message
news:eyKCbtFTFHA.2432@TK2MSFTNGP12.phx.gbl...
> You'd have to do a lot of javascript for that. I'm curious, why don't you
> just use a bonafide excel object - the Microsoft Office Web Components is
> a good alternative for just such an application.
>
> --
> Regards,
> Alvin Bruney - ASP.NET MVP
>
> [Shameless Author Plug]
> The Microsoft Office Web Components Black Book with .NET
> Now available @ www.lulu.com/owc, Amazon.com etc
> "Bob Morvay" <r@r.com> wrote in message
> news:umv2B7CTFHA.3332@TK2MSFTNGP15.phx.gbl...
>> My users want to be able to use the Web Datagrid like an excel
>> spreadsheet.
>> This means a fully editible grid with arrow key navigation between cells.
>> The grid seems to support horizontal tabbing between cells but nothing
>> for
>> the arrow keys.  I have googled for sample code but the best that I could
>> find was some half completed javascript that captures the key events but
>> doesn't quite show me how to use it in the grid.  I was wondering if
>> anyone
>> has any example code where an editable grid could be navigated from cell
>> to
>> cell using the arrow keys (Left, Right, Up and Down).
>>
>> Thanks in advance.
>>
>>
>>
>
>
Author
30 Apr 2005 12:26 PM
Alvin Bruney [MVP - ASP.NET]
The Office Web Components are easy to program against. You can find the free
download on the Microsoft office website. The help files are enough to get
you started. The newsgroup is office.developer.web.components and msdn lists
a number of articles. The current book on the components is available at
www.lulu.com/owc or on amazon.

hope this helps

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
Show quoteHide quote
"Bob Morvay" <r@r.com> wrote in message
news:eMot$bLTFHA.2556@TK2MSFTNGP12.phx.gbl...
> Two reasons... It is an existing ASP.Net application and I have never used
> the Microsoft Office Web Component :)  Where can I learn more about the
> Excel object as it can be used in a web components?
>
> "Alvin Bruney [MVP - ASP.NET]" <www.lulu.com/owc> wrote in message
> news:eyKCbtFTFHA.2432@TK2MSFTNGP12.phx.gbl...
>> You'd have to do a lot of javascript for that. I'm curious, why don't you
>> just use a bonafide excel object - the Microsoft Office Web Components is
>> a good alternative for just such an application.
>>
>> --
>> Regards,
>> Alvin Bruney - ASP.NET MVP
>>
>> [Shameless Author Plug]
>> The Microsoft Office Web Components Black Book with .NET
>> Now available @ www.lulu.com/owc, Amazon.com etc
>> "Bob Morvay" <r@r.com> wrote in message
>> news:umv2B7CTFHA.3332@TK2MSFTNGP15.phx.gbl...
>>> My users want to be able to use the Web Datagrid like an excel
>>> spreadsheet.
>>> This means a fully editible grid with arrow key navigation between
>>> cells.
>>> The grid seems to support horizontal tabbing between cells but nothing
>>> for
>>> the arrow keys.  I have googled for sample code but the best that I
>>> could
>>> find was some half completed javascript that captures the key events but
>>> doesn't quite show me how to use it in the grid.  I was wondering if
>>> anyone
>>> has any example code where an editable grid could be navigated from cell
>>> to
>>> cell using the arrow keys (Left, Right, Up and Down).
>>>
>>> Thanks in advance.
>>>
>>>
>>>
>>
>>
>
>