# Partial display of data in Data grids

**URL:** <https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981>\
**Category:** Toad for Oracle - Beta\
**Created:** [February 20, 2024, 12:03pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981 "2024-02-20T12:03:35Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [February 20, 2024, 12:03pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/1 "2024-02-20T12:03:35Z")

</div>

I can't see the data in the grids in its entirety, some are partially hidden with the "..." mark. Displaying the same query result in the GA works fine. My settings are the same in the two versions.

 ![image](https://global.discourse-cdn.com/quest/original/3X/d/a/dac0da5176ee376539b2b8a96d867ace941049aa.png)  
 ![image](https://global.discourse-cdn.com/quest/original/3X/1/e/1e8df833b3bfdef44f91c43a24f525f28157b76a.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 20, 2024, 5:52pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/2 "2024-02-20T17:52:49Z")

</div>

Hi Tamas,

I'm not seeing that problem when I select \* from dba\_objects on Windows 10.

Do you see this on every query? What if you right-click in the grid and choose "reset columns"?

If your beta is not up to date (17.1.559.3176) then please update and try again. There was some changes in for a couple of betas before that which may have caused this, and those changes were removed in this latest beta.

-John

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [February 20, 2024, 8:10pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/3 "2024-02-20T20:10:19Z")

</div>

Hello John,

I'm on the latest beta  
_Toad for Oracle Professional (64-bit)_  
_17.1.559.3176_

Yes, I've experienced the same thing in most (but not all) cases, no matter of using Schema Browser or using the same query in the Editor. "Reset columns" was the first thing I tried to solve the problem, but using it made no difference.

I'm using a 4k display with 200% display scale (maybe it matters).

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 21, 2024, 10:19pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/4 "2024-02-21T22:19:12Z")

</div>

I can reproduce this and it will be approximately roughly more or less fixed next beta.

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [April 8, 2024, 7:18pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/5 "2024-04-08T19:18:51Z")

</div>

Hello John!

This issue occurs again in the latest beta (17.1.654.3493) and in the previous one version also.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [April 8, 2024, 7:53pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/6 "2024-04-08T19:53:37Z")

</div>

did it go away and then come back or did my change not fix it?  
Can you give me a "select from dual" to reproduce it and let me know your screen resolution?

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [April 8, 2024, 8:44pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/7 "2024-04-08T20:44:10Z")

</div>

It went away but I realized the same issue again, today. Updated to the latest beta, it is a problem in that version also.

 ![image](https://global.discourse-cdn.com/quest/original/3X/a/6/a6ead0dddd0cc30bcc5e3dc20293a8b30f8f8ed7.png)

Screen resolution:

 ![image](https://global.discourse-cdn.com/quest/original/3X/2/1/21dc81ba0fb430f6eb3579ca61c9d313d473dd6d.png)

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [May 2, 2024, 9:40am UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/8 "2024-05-02T09:40:19Z")

</div>

Hello John,

Do you have a solution for this bug? Can this be fixed in the final 17.11GA version?  
Thank you for your answer.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 2, 2024, 12:18pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/9 "2024-05-02T12:18:31Z")

</div>

Hi Tamas,

Sorry, I forgot about this. I can reproduce it on a 200% display. Let me see if there is something more I can do here.

-John

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 2, 2024, 5:22pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/10 "2024-05-02T17:22:09Z")

</div>

Actually, I am having trouble reproducing this consistently and I don't know how I reproduced it earlier today.

I am running Toad beta on a 200% scaled display, with a freshly reset user files folder.

What font settings are you using in the grid?

Options -\> Data Grids -\> Visual. Just check with "Simple".

 ![image](https://global.discourse-cdn.com/quest/original/3X/5/6/56798c82453cd6f841cd892136b5880e2d28295d.png)

-John

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [May 3, 2024, 9:21am UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/11 "2024-05-03T09:21:02Z")

</div>

![image](https://global.discourse-cdn.com/quest/original/3X/b/a/bac1dd6af3f339cf69cd435772ea9c69e4666334.png)

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [June 10, 2024, 7:15pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/12 "2024-06-10T19:15:24Z")

</div>

Hello John,

I don't know if this bug has been fixed for 17.1GA version, but I've data grids where the full content of the cell is not visible in the GA version.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 10, 2024, 7:32pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/13 "2024-06-10T19:32:20Z")

</div>

Hi Tamas,

I did make a change when you initially reported this, and I think I also made some further changes, but I am now unable to reproduce any more problem here, so I'm not sure what I need to change.

using you SQL from before:

`select '"beginning _____122123231231321___ itistheend"' from dual`

this is what I see on my 4K display at 200% scaling.

 ![image](https://global.discourse-cdn.com/quest/original/3X/c/e/ce9548f42b543b71352763e0f9d519d16a5ac0c4.png)

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [June 10, 2024, 7:41pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/14 "2024-06-10T19:41:57Z")

</div>

it's tricky. Please try the following queries...

```auto
select '*begin __1234567890987654321__ end*' as x from dual
union all
select '*begin __5678901234321098765__ end*' as x2 from dual;

```

 ![image](https://global.discourse-cdn.com/quest/original/3X/e/e/ee1780e6c841d74faca60af3ed7a54a695206a07.png)

```auto
select '*begin __1234567890987654321__ end*' from dual
union all
select '*begin __5678901234321098765__ end*' as x2 from dual;

```

![image](https://global.discourse-cdn.com/quest/original/3X/9/0/901781fb3d95827f8511467505a353fddc53bece.png)

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [June 10, 2024, 7:52pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/15 "2024-06-10T19:52:10Z")

</div>

And sometimes I can see the same situations in SB| Tables RHS|Data tab.

 ![image](https://global.discourse-cdn.com/quest/original/3X/6/3/631ae2b17851ba98a99eda2204713b39ec0c3902.png)  
 ![image](https://global.discourse-cdn.com/quest/original/3X/4/5/4548f5577ea686b4d64656a92a339a88bdd614e5.png)

View/Edit Query and send the query to Editor, do some alias change in the column list

 ![image](https://global.discourse-cdn.com/quest/original/3X/d/1/d179925989649003f54081538569bf277822617a.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 10, 2024, 8:03pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/16 "2024-06-10T20:03:24Z")

</div>

For me your example came out fine:

 ![image](https://global.discourse-cdn.com/quest/original/3X/9/c/9c5f88b7465f732c9497ed0837ee17795819cf3b.png)

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [June 10, 2024, 8:09pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/17 "2024-06-10T20:09:21Z")

</div>

What about using Tahoma font for display of 'Data'? Or do you have the same settings as me?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 10, 2024, 8:35pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/18 "2024-06-10T20:35:11Z")

</div>

Ahh, I can reproduce this with Tahoma 9. Both Tahoma 8 and Tahoma 10 work ok.

I have a hard time typing "Tahoma". After the "T", my fingers go for "o" and "a". 😃

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [June 10, 2024, 8:38pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/19 "2024-06-10T20:38:40Z")

</div>

I just tested the opposite. Using the Segoe UI font with a font size of 9, it works fine. However, setting the font size to 10 or 11 again cuts off some of the cell content.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 10, 2024, 9:16pm UTC](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981/20 "2024-06-10T21:16:15Z")

</div>

I've recorded steps to reproduce this in our bug tracking system.

The problem is either in Delphi (development environment) or Dev Express (3rd party grid component). I'll have to work up a demo app and submit the bug to them.

[Next page](https://forums.toadworld.com/t/partial-display-of-data-in-data-grids/58981.md?page=2)
