Hi
I want to copy cells from Excel that contain formula e and be able to paste them into a GridControl.
I don't expect to see the formulae in the GridControl . I want to see the Excel cell Display value in the GridControl after pasting. That is, what the formulae evaluate to.
So, for example, if the A1 cell in Excel has '=B1' as it's formula and cell B1 has the value "DevExpress". Now I copy cell A1 to the clipboard and paste it into a cell in a GridControl. Nothing shows up. But what I want to show up is "DevExpress".
Is it possible to make GridControl deal with such a scenario?
Many thanks in advance for any help.
Hi,
To help I attach a sample project showing the problem.
and
TableView_ClipboardRowPasting
and
TableView_ClipboardRowCellValuePasting
ALL get hit and the cell correctly receives the pasted value.
GridControl_PastingFromClipboard
is being hit and NO value is pasted.
Now, in the docs HERE it says we can use the events
ClipboardRowPasting
and
ClipboardRowCellValuePasting
to modify pasted data.
In the absence of a existing setting / property that copes with Formulae, these would be an ideal place to query and amend the pasted data but as you have just noticed, NEITHER of these events are being rasied? It would seem the GridControl is making a decision about what's on the clipboard and cancelling the paste before I can get a chance to examine and amend the clipboard data for myself?
I can't find any GridControl property that would help, or, as I have explained above, got a workaround for the problem.
Please, this is a real deal breaker for me and my users. They need the ability to paste into the GridControl from Excel formula cells, but I'm stuck on how this can be achieved?
I am praying someone at DevExpress can help!
Many thanks for any help
Kind Regards,
Pete.
Hello Pete,
Thank you for bringing this to our attention. I reproduced the issue using your steps and passed it to our R&D team for further research. We will come back to this ticket once we make progress. Please stay tuned.
Hi Andrew
Thanks for your reply.
I look forward to hearing from you.
Pete.