Forums Home / Wijmo / General Discussion
Posted by: holly.anderson on 16 October 2017, 9:42 am EST
holly.anderson
Posted 16 October 2017, 9:42 am EST
Hello,
I have a cell in a FlexSheet that contains an auto-complete control. If the user types into the cell and triggers quick-edit mode, then the arrow keys cannot be used to select a result from the auto-complete drop down menu. Is there any way (maybe in the beginningEdit event) to detect if the cell is in quick-edit mode and, if so, put it in full-edit mode?
Thanks,
Holly
abhishek.dutta
Posted 17 October 2017, 7:06 am EST
Hi Holly, I have created a sample for Auto Complete in FlexSheet and I was not able to reproduce the issue that you are facing. Could you please run the attached sample and let me know if you faced the same issue with this sample as well. If yes, then please elaborate the steps or modify the sample so as to reproduce the issue and then send it back to us so that we can investigate this in detail.
Download the sample from here:
https://www.grapecity.com/en/public/uploads/a662a48496218d71c4b14ef80ef4af881508237556593.zip
holly.anderson
Posted 17 October 2017, 8:38 am EST
Please see the attached sample and follow these steps to replicate the issue:
Notice that the arrow keys cannot be used to select options from the menu because the cell is in quick-edit mode. Instead, the focus shifts to the below cell and the first item from the list is selected. If you double-click the cell in step 1, this is not a problem because the cell is in full-edit mode.
Basically, I just want to be able to trigger full-edit mode in a cell when the user begins editing it in quick-edit mode. I may want to do this with other cell types as well, not just those with auto complete editors.
abhishek.dutta
Posted 18 October 2017, 5:08 am EST
Hi Holly,
I have tried using startEditing Method to put the Cell into Full Edit mode but it did not seem to work as expected. I also tried simulating the F2 KeyPress on Focus Event of AutoComplete and that didn’t do the trick as well.
I will keep investigating the issue and also loop in the Dev Team for inputs. It will take me a while to get back to you on this as we have a long weekend here. I will try to update you on Monday if I find something you can work with.
Thanks,
Abhishek
holly.anderson
Posted 24 October 2017, 8:45 am EST
Hi Abhishek,
Any update on this?
Holly
manish.gupta
Posted 25 October 2017, 8:34 am EST
Hi,
We are investigating on this issue. We will update soon.
~Manish
manish.gupta
Posted 26 October 2017, 5:36 am EST
Hi Holly,
You will be able to select an item from drop-down using the arrow key with help of CustomGridEditor class define in the attached sample. Please refer to the attached sample for the same.
~Manish
holly.anderson
Posted 26 October 2017, 7:56 am EST
Hi Manish,
Thanks for the update. Unfortunately, this solution seems a bit complicated. Is there really no other simple way to set the edit mode (quick vs full) on a specific cell? I may also want to do this for other types of cells (not necessarily auto complete) in the future and was hoping for an easier way to do so. If this is not something that is currently possible, could it be entered as an enhancement request?
Holly
manish.gupta
Posted 27 October 2017, 8:20 am EST
Hi Holly,
We require some time for investigating and for finding a simpler solution for this case. We will update you as we get an update.
~Manish
manish.gupta
Posted 28 October 2017, 3:12 am EST
Hi Holly,
This issue requires further investigation. Hence, forwarded to the concerned team for further investigation with id 294156.
We will let you know as we get the update.
~Manish
holly.anderson
Posted 18 December 2017, 2:52 pm EST
Is there any update on this? I’m running into additional scenarios where I’d like to be able to check if a cell is in quick-edit or full-edit mode.
manish.gupta
Posted 19 December 2017, 4:55 am EST
Hi ,
The issue found fixed with latest build 5.20173.380.
Please let us know for further queries.
~Manish
holly.anderson
Posted 19 December 2017, 8:44 am EST
Hi Manish,
I’m glad that the issue with the auto-complete control has been fixed, but as I stated in my prior posts, I’d like to be able to detect and/or trigger a cell’s edit mode for cells with other types of editors.
Is there some way (e.g. in the beginningEdit event handler) to detect whether the cell that is being edited is in full-edit or quick-edit mode? And is there some way to programmatically set the edit mode for a cell? I’d like to use this logic for custom editors.
Thanks,
Holly
manish.gupta
Posted 20 December 2017, 6:14 am EST
Hi Holly,
You may detect if edit mode is quick or full by handling beginningEdit and click and keydown event for sheet hostElement. Please refer to the attached code snippet for the same.
sheet.hostElement.addEventListener("click",function(){
editType="full"
});
sheet.hostElement.addEventListener("keydown",function(){
editType="quick"
});
sheet.beginningEdit.addHandler(function(s,e){
console.log(editType)
})
You may enter in edit mode using startEditing method. This method may be used to enter in both mode.
flex.startEditing(fullEdit?: boolean, r?: number, c?: number, focus?: boolean);
~Manish
holly.anderson
Posted 2 February 2018, 5:08 pm EST
Hello,
I know it’s been a while since the answer was posted, but I’m having an issue with my implementation of automatically entering full-edit mode for certain cells. In the attached sample, two columns are frozen and I have a custom editor in the first column. When a cell in the first column is edited via key press (quick-edit mode), I cancel the edit and start editing the same cell in full-edit mode. Normally, this works fine and the key that the user pressed registers in the cell after full-edit mode is triggered. However, there are certain cases where the first character is not registered in the cell.
Based on my tests, it seems that the issue occurs when moving the selection from a frozen cell to a cell with a custom editor via clicking the mouse. If the selection is changed using keyboard navigation, then the issue doesn’t occur. The issue is occurring in IE (11.0.9600.18860) on Windows 7, but not Chrome. I’ve included some of my tests below.
Results: The cell enters full-edit mode, but the typed number does not appear in the cell.
Results: The cell enters full-edit mode, and the typed number appears in the cell.
Results: The cell enters full-edit mode, and the typed number appears in the cell.
Holly
manish.gupta
Posted 5 February 2018, 6:06 am EST
Hi Holly,
For this, you need to set cloneFrozenCells property to false. Please refer to the attached sample for the same.
~Manish
holly.anderson
Posted 5 February 2018, 8:32 am EST
Hi Manish,
Is there any other way to get around this? If I set cloneFrozenCells to false, performance will be negatively impacted in IE. I ran into another issue with frozen cells in IE, and you were able to provide a workaround for that problem (https://www.grapecity.com/en/forums/wijmo/flexsheet---click-events-d). Is there anything similar that can be done here?
Thanks,
Holly
manish.gupta
Posted 6 February 2018, 1:58 am EST
Hi Holly,
We tried to find a workaround to overcome this issue (finger crossed 
)
Please find the attached sample for the same and let us know if it works or not.
~Manish
manish.gupta
Posted 6 February 2018, 1:59 am EST
holly.anderson
Posted 6 February 2018, 4:29 pm EST
Hi Manish,
Thank you very much for the workaround! I had to tweak it a bit, but so far it seems to be working very well.
Would it make sense to log this issue as a bug? It’s a shame that custom editors don’t work as expected in the specific scenario that I described in my previous post. It would be nice if they behaved as expected without having to set cloneFrozenCells to false.
Holly
manish.gupta
Posted 7 February 2018, 12:11 am EST
Hi Holly,
Yeah, this should be logged as query to the concerned team. We have forwarded to the concerned team with tracking id 307919. ’
We will update you as we get any update on this.
~Manish
holly.anderson
Posted 7 March 2018, 4:39 pm EST
This issue was reported as fixed on a different thread: https://www.grapecity.com/en/forums/wijmo/accessing-flexsheet-filter
However, I’m still able to replicate the issue with build 5.20173.430 in IE 11 on Windows 7.
abhishek.dutta
Posted 8 March 2018, 6:23 am EST
Thanks for reporting this. We are investigating it
abhishek.dutta
Posted 9 March 2018, 6:49 am EST
I will update you about this on Monday.
manish.gupta
Posted 12 March 2018, 12:33 pm EST
Hi Holly,
We are sorry for the delay because of System Configuration unavailability. We will update you tomorrow.
~Manish
manish.gupta
Posted 13 March 2018, 5:53 am EST
Hi Holly,
We are sorry for the delay and inconvenience.
We are able to replicate the issue at our end and reverted to the concerned team back.
We will let you know as we get any update on this.
~Manish
holly.anderson
Posted 23 March 2018, 9:33 am EST
Any update?
abhishek.dutta
Posted 26 March 2018, 7:32 am EST
Hi,
Please go through the attached sample which implements the fix, Let me know in case you are still facing issues.
holly.anderson
Posted 26 March 2018, 8:03 am EST
I don’t see an attached sample.
abhishek.dutta
Posted 26 March 2018, 8:15 am EST
holly.anderson
Posted 26 March 2018, 3:02 pm EST
Thanks for the update. The issue seems to be resolved in the sample that you provided.
Is this the official fix for this issue? It still seems more like a workaround than a true fix.
manish.gupta
Posted 27 March 2018, 12:16 am EST
Hi Holly,
Yes, this is a fix for your issue from the team. Above suggested approach is recommended way to make a cell in full edit mode with frozen column.
Since we are overriding default behavior, this is an fix for the specific issue. You may use it in your project.
~Manish
