What I've always wanted in the QGrid, and was disappointed to see still hadn't been implemented in QGrid6, is automatically expanding edit cells similar to Excel.
For example, if I have a cell on a grid which contains a multi-line block of text in a grid with auto row height enabled then, when the user does an in-place edit of this text, the height of the cell (and indeed the entire row) stays fixed and the text scrolls as necessary.
So, if the existing text took up three lines and more text was added, then when it wrapped onto a fourth line, the text would scroll and the first line would disappear off the top of the edit box.
Once the edit was completed, the grid would resize the height of the row to accomodate as many lines as were needed.
Now this isn't too much of a problem when there are already a few lines present but, when there's only a single line to start with, then as soon as enough text is added to wrap onto a second line, the first line disappears and the user is left with a blank edit field again. This continues for each new line until the end is complete, only then does all the text become visible. This "loss of context" when typing a lot of text can be very disconcerting as, with each line break, you're unable to see what you've typed to that point.
Contrast this with the way Excel does things. In Excel, the edit box itself automatically expands downwards to accomodate the new line, overlaying on top of whatever cells/rows are below it in the grid. When the edit is complete, the row resizes to "match" the height of the edit box.
Can such a feature be added to a future release of the QGrid please? Alternatively, is there any way to achieve such an effect with the current version of the grid?
Many thanks,
Toby.
Dear Toby,
Yes, the idea does have merit, and we already have such a request in our wish list - see report S1105 ("In-place Editor auto-size - Add the ability to automatically adjust the Grid cell's height while entering input into the active editor"). In the meantime, I should mention that it's unlikely that we'll be able to implement it in the near future because it requires too many critical changes in the ExpressQuantumGrid. In any case, we do have plans to improve our controls, and I hope to see that functionality sooner or later. Please track report A1105, to be aware of our progress on this subject.
Thanks,
Serge
Hi Serge,
Having looked at the other issue, I'm not entirely sure it's exactly the same. It looks as if the other user is asking whether the entire row could automatically resize vertically as additional text is entered into a single cell. I can see how this would be a major change to the Grid.
All I'm after is for the in-place editor itself to extend vertically down, not the underlying grid, so the cell editor overlays on top of lower rows of the grid as it extends. Only when editing is complete would the grid row resize, as it currently does anyway. Surely this would be an easier change as it's only the in-place editor that would need to be modified, not the grid itself?
Regards,
Toby.
Thank you for the update, Toby. We'll discuss this functionality with our developers. I've also corrected the report's subject accordingly.
Thanks,
Serge
SEE ALSO: S91231 ("Adjust the height of an in-place multi-line editor on the fly when typing into this editor") for the ExpressQuantumTreeList.
Can I possibly give this a gentle bump and ask if there's any chance it could be incorporated into the forthcoming major release of the Grid, later this year? :)
A1105 is private
Hello,
Yes, this article is private because it is outdated. Please refer to the In-place Editor auto-size - Add the ability to automatically adjust the Grid cell's height while entering input into the active editor ticket for the information.
I have updated the wrong link in comments.
I've seen it. see my comment in Q435104. EditAutoHeight help topic doesn't say that you need to hit Enter in order to automatically resize editor height when you edit previously entered value as demonstrated by your own sample there
Hello Vladimir,
This behavior is by design. The editor is resized only when editing.