|
| WD16: How to make a table behave like a spreadsheet? |
| Iniciado por guest, fev., 10 2014 3:56 PM - 8 respostas |
| |
| | | |
|
| |
| Publicado em fevereiro, 10 2014 - 3:56 PM |
I want to make a table behave like a spreadsheet, something like this:
Each field (or cell) in the table can be selected by Tab or mouse, but not edited. The whole cell is highlighted when selecxted. Then F2 can be pressed and only the selected cell becomes editable. Then after "Enter" is pressed, the cell shows as selected but not editable.
I can't for the life of me get this to work. Does anyone have any links to examples of how to do this?
Thanks,
Michael |
| |
| |
| | | |
|
| | |
| |
| Publicado em fevereiro, 10 2014 - 5:30 PM |
Hi
what do you want it to do other then discribed?
Is there initial data in the table? is it linked to something ( file or query )? or is it in memory ?
maybe look at help : http://doc.windev.com/en-US/…
regards allard |
| |
| |
| | | |
|
| | |
| |
| Publicado em fevereiro, 10 2014 - 5:57 PM |
| |
| |
| | | |
|
| | |
| |
| Publicado em fevereiro, 10 2014 - 6:51 PM |
Hi Michael
First, I am assuming WINDEV.
>>>Each field (or cell) in the table can be selected by Tab or mouse, but not edited. The whole cell is highlighted when selecxted. Then F2 can be pressed and only the selected cell becomes editable. Then after "Enter" is pressed, the cell shows as selected but not editable.
- All cell should be by default in EDIT mode, so that it's possible to enter them
- In the entry code of each cell, I would put some code that change the cell color background, and change the CURRENT cell mode to NON editable
- when F2 is pressed, I would make them editable again and set the cursor in it by code
- if anything else is pressed, I would UNhighlit the cell and make it editable again
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado em fevereiro, 10 2014 - 7:38 PM |
Michael,
LST83 has an example of exactly this and it is even in WD16 already.
Maybe pcsoft is willing to send you the example
Or you could just buy lst83. If you have to do it all by yourself it will cost you more money and sweat.
See screenshot below. Yes it really is a WD table control and not Excel. |
| |
| |
| | | |
|
| | |
| |
| Publicado em fevereiro, 11 2014 - 11:09 AM |
Thanks everyone.
That's given me a way to move past my blockage, I hope!
Michael |
| |
| |
| | | |
|
| | |
| |
| Publicado em fevereiro, 12 2014 - 11:29 AM |
Thanks to the original poster for asking this question and Fabrice and Arie for pointing out two very interesting solutions to an aspect I didn't even know I would be facing in the near future 
Awesome stuff :spos:
If only my French were not this subterraneous... these LST's look like being a treasure chest of neat solutions! :xcool: |
| |
| |
| | | |
|
| | |
| |
| Publicado em fevereiro, 12 2014 - 1:14 PM |
Hi Charles
>>>If only my French were not this subterraneous... these LST's look like being a treasure chest of neat solutions! :xcool:<<<
yes they are, and I had some customers who would scan, OCR and google translate the articles...
For the source code, there is no need, as your windev editor is able to change the code language from french to english in just a few clicks
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado em fevereiro, 12 2014 - 1:30 PM |
| you can use activeX / ole of excel :rp: |
| |
| |
| | | |
|
| | | | |
| | |
|