Formatted Text when pasted onto Grid comes with additional double quotes ("") surrounding it. Why is that so? I tried pasting following data from excel to grid.
It appeared on grid like this:
237 Customer 4579 70 16 Sep 2021
3259 Customer 1614 42 12 Mar 2017
9588 Customer 4777 81 08 Oct 1937
4099 "This
is
a
<Formatted>
Text." 45 08 May 2016
237 | Customer 4579 | 70 | 16-Sep-21 |
3259 | Customer 1614 | 42 | 12-Mar-17 |
9588 | Customer 4777 | 81 | 08-Oct-37 |
4099 | This is a <Formatted> Text. |
45 | 08-May-16 |
It appeared on grid like this:
237 Customer 4579 70 16 Sep 2021
3259 Customer 1614 42 12 Mar 2017
9588 Customer 4777 81 08 Oct 1937
4099 "This
is
a
<Formatted>
Text." 45 08 May 2016