UniDBGrid - How start editing by keypress?

[Volk65]

Hi!

 

UniDBGrid:  I Need to start editing the cell by pressing Key>32.

How to do it?

[Sherzod]

Hi,

 

Which build are you using?

[Sherzod]

Have you tried to search on the forum?

[Volk65]

I looked... and not found

For example: "How to activate cell editing in UniDBGrid"  http://forums.unigui.com/index.php?/topic/10306-how-to-activate-cell-editing-in-unidbgrid/

[Sherzod]

Which build are you using?

[Volk65]

1.0.0.1421 (personal edition)

[Sherzod]

Have you tried with this old plugin?:

http://forums.unigui.com/index.php?/topic/3483-a-microsoft-excel-grid-plugin-for-ext-js-4/

[Volk65]

Yes. I saw that too.

But the first link did not open. And I wasn't sure if it was still relevant.

 

If the second link is the actual script, I'll try.

https://gist.githubusercontent.com/lukehorvat/5607821/raw/6fe2113b4946b36e8bcdf10a3904560ef9a00758/excel-grid-plugin.js

[Volk65]

I already tested https://gist.githubusercontent.com/lukehorvat/5607821/raw/6fe2113b4946b36e8bcdf10a3904560ef9a00758/excel-grid-plugin.js

(Not working)

 

test6.rar

[Sherzod]

Ok, we will check

[Volk65]

Hi

Any news?

[Sherzod]

Hi,

 

Hi

Any news?

 

There are some problems in solving this task

[Sherzod]

Hi,

 

Here is an example:

https://fiddle.sencha.com/#view/editor&fiddle/2cfu

 

But, you can see one of the problems, if quickly enter data from the keyboard

[Osama Ghazal]

Hi Sherzod,

 

How can I use this solution to edit cell in dbgrid by pressing anykey?

https://fiddle.sencha.com/#view/editor&fiddle/2cfu

@Sherzod

I am using Latest Trial Version:

uniGUI Web Application Framework - Trial Edition
Copyright FMSoft 2009-2023. All rights reserved.
Version:1.90.0 build 1572
info@fmsoft.net

[Sherzod]

Hello,

Have you tried searching the forum? There are some solutions.

[Osama Ghazal]

6 hours ago, Sherzod said:

Hello,

Have you tried searching the forum? There are some solutions.

I read many solutions, but I didn't know from where can I start, I think it is difficult a little bit.

[Osama Ghazal]

I want if I press any key([A..Z] or [0..9]) upper or lower case (a..z and !@#$%^&*())  the cell edited and when press Enter the cursor move to the next cell in the same row if it is not read only

[Osama Ghazal]

I will try now again

[Osama Ghazal]

@Sherzod

Ok, now it works but not very well

it is like excel in one row only

you should only move the cursor by Tab not by Enter and when the row is finished it stops, not moving to the next row.

I think it is very limited not practical.

I can't depend on them if the customer want to work inside the grid in the invoices and vouchers.

for example:

The customer want to enter the barcode then the qty then the price and want to begin a new line by pressing Enter Key, like TDBGGrid

[Sherzod]

On 9/19/2023 at 2:02 PM, Osama Ghazal said:

I think it is very limited not practical.

Sorry, this is what it is at the moment.

On 9/19/2023 at 2:02 PM, Osama Ghazal said:

The customer want to enter the barcode then the qty then the price and want to begin a new line by pressing Enter Key, like TDBGGrid

Although there was a solution to this on the forum.

[bahry]

@Osama Ghazal

http://forums.unigui.com/index.php?/topic/14592-autoedit-in-unidbgrid/

or you can use

///////////////////////////////////////////////////

UniDBGRID>ExtEvents>reconfigure

function reconfigure(sender, store, columns, oldStore, the, eOpts)
{
  for (var i = 0; i < columns.length; i++) {
  if (columns.getEditor()) {
  columns.getEditor().on('specialkey', function (field, e) {   
   if (e.getKey() == 13) {
     e.keyCode = e.TAB;          
     return e.keyCode;
    }
   })
  }    
 }
}

///////////////////////////////////////////////////

But this will not work if in the main form you enabled keyPreview = True and Navigatekeys