Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
You need to be logged in to view a user's profile.
View Replies (4)

Resolved Cell padding in grid datawindows

  1. How-to
0
Votes
Undo
  1. Konstantin Goldobin
    Konstantin Goldobin
  2. PowerBuilder
  3. Thursday, 4 May 2023 09:10 AM UTC

Hello,

How do you guys make your grid datawindows more readable? I am not aware of any ways to define cell padding for datawindows, and cell content is placed very close to grid lines. As a result, if a right-aligned column is followed by a left-aligned column, their values look like one.

I tried playing with adding a blank space to the format, like " [General]", but it looks ridiculous for multiline strings.

Best regards,
Konstantin

  1. DataWindow
  2. PowerBuilder
Problems retrieving an Oauth Token from the server
Running out of memory allocating a blob
Responses (4)
Konstantin Goldobin
Konstantin Goldobin Accepted Answer Pending Moderation
  1. Wednesday, 10 May 2023 13:00 PM UTC
  2. PowerBuilder
  3. # 1

Turns out that blank spaces added to columns' formats seem ignored by the width.autosize property. If let's say it is set to 3 (widest retrieved), and the format is " [General]" (values are left-padded with a blank space), then the last character does not fit into the width of the column...

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 10 May 2023 18:47 PM UTC
Hi Konstantin;

Please report this as a PB (or even IM) "bug" though the Appeon Support Ticket system. Many thanks in advance!

Regards ... Chris
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 4 May 2023 11:42 AM UTC
  2. PowerBuilder
  3. # 2

As requested by me some time ago:

https://www.appeon.com/standardsupport/search/view?id=5267

Comment
There are no comments made yet.
Mark Goldsmith
Mark Goldsmith Accepted Answer Pending Moderation
  1. Thursday, 4 May 2023 16:28 PM UTC
  2. PowerBuilder
  3. # 3

Hi Konstantin,

Yes, would be nice if there was a built-in way to handle this, hence Miguel's ticket. Other than utilizing editmasking and formatting properties,
you could 1) turn borders on  2) make sure all columns are justified the same way and  3) turn background colour to something that alternates from column to column. While any of the three suggestions would make the separation more clear visually, these may not be ideal or suitable for your use case...that's all I can think of at the moment.

HTH...regards,

Mark

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 4 May 2023 19:27 PM UTC
  2. PowerBuilder
  3. # 4

Hi Konstantin;

   FWIW: Since PB 2.0, I have been using the DWO column's "Display Format" mask feature.

For example, I would use a leading space(s) in the display format mask, as follows:

Before:

After:

Quarter display format mask "  @@@@@@"

Amount display format mask "  #,##0.00"

Food for thought .... HTH!  ;-)

Regards ... Chris

 

Comment
Konstantin Goldobin
  1. Konstantin Goldobin
  2. Wednesday, 10 May 2023 12:51 PM UTC
Thank you, Chris! As you can see in my original post I mentioned using a blank space in columns' formats.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 10 May 2023 18:44 PM UTC
Yes, that's pretty well the way us "seasoned" PB developers have been doing it since the PB 2/3 days. ;-)

I would suggest though - if you like - creating an "Enhancement" support ticket to automatically provide a gap (definable # of spaces, PBUs, Pixels, etc) at the start of left justified column's starting grid line. Food for thought.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.