Diese Seite mit anderen teilen ...

Informationen zum Thema:
WinDev Forum
Beiträge im Thema:
Erster Beitrag:
vor 7 Monaten, 1 Woche
Letzter Beitrag:
vor 7 Monaten, 1 Woche
Beteiligte Autoren:
André Labuschagné, Fabrice Harari, Peter Holemans

Spreadsheet Advice - WebDev

Startbeitrag von André Labuschagné am 13.03.2017 10:22

Hi All

I am looking for some help with a spreadsheet type of control in WebDev.

I need a control or scheme where the user can navigate through a spreadsheet grid type of control using the left arrow, right arrow, up arrow and down arrow and the enter key. The focus must move through the cells and I must be able to control what happens in each cell - there must be hand code points. The control must also have the first row as a header.

Has anyone managed to do this?



Hi Andre,

I guess you'll have to look in separate non WebDev controls. But to my experience (I did (try to) use quite some external elements in WB) it is not so straight forward as with other web development tools because WB is just too d@mn closed and works according to a prehistoric forms development paradigm which just doesn't work with all the open fancy global web stuff and standards

I guess you're looking for something like this (Free for small companies and available for a variety of dev platforms): Syncfusion Spreadsheet control

Have a look around on the net. There's plenty of nice food out there... Just take into account that integrating this stuff in WebDev will be extremely hard to do...

Waiting for a similar control to come from PCSoft is likely to be waiting for Godot (unless they steal it somewhere and make a half baked WB cloned version of it for V23 in about 18 months).

Guess you'll have to look for alternatives.

Just my 2 cents,

Peter Holemans

von Peter Holemans - am 13.03.2017 14:01
Hi Andre

if you just need the navigation (and not the calculation type functions), then you should be able to do that quite easily with a looper (you can give it a table look if you want) and 4 buttons...

Each buttons has one of the arrow keys as shortcut, and does a returntocapture of the control on the left, right or a looperselectplus of the line before or after...

Best regards

von Fabrice Harari - am 13.03.2017 20:22
Hi Peter

I have never done anything with asp.net and WebDev. Is this even possible?


von André Labuschagné - am 14.03.2017 06:42
Hi Fabrice

I have tried that and it could work. Any calculation work I can handle at the hand code level. These are quite simple grids where I am just looking for easy familiar user input and navigation. The only problem I have with it is the header. The columns must have headers. These need to be kept aligned so would have to be part of the looper itself. Maybe the first "row" could be the header. Then I would need to keep tabs on the position of the cursor in the grid. How do you separate the first row cell type from the rest? I do not think that is possible. If the table control allowed navigation in and around cells that would solve this problem. I do not think that is possible.


von André Labuschagné - am 14.03.2017 06:47
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.