Re: Listbox Spacing Between Columns

Mon, 25 Sep 2017, Arnaud de Montard said: > Use unbreakable space instead, it works (alt+space with keyboard, char code = > 0x00A0 / 160). I have tried and tried this without success. Forgetting about number format, even a text field (horizontal alignment = right) will not display trailing

Re: Listbox Spacing Between Columns

I too made the switch a year or so ago. For me it was relatively easy as, is my habit, I wrapped nearly all the AeaList commands and so only had to modify my wrapping methods to make the switch. I have not looked back and to date have not found anything I could do with AreaList that I could not

Re: Listbox Spacing Between Columns

Nigel: It sounds like list boxes suit your needs. Good to hear that. -- Douglas von Roeder 949-336-2902 On Mon, Sep 25, 2017 at 6:50 AM, Nigel Greenlee via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Douglas > > I undertook a project a long long long time back to convert a pretty rich >

Re: Listbox Spacing Between Columns

Douglas I undertook a project a long long long time back to convert a pretty rich framework(for its time) from Area List to Listbox..to put that in time context it was when you could not buy any licences for Area List! At the time LB did not have anything like the abilities it had now but i

Re: Listbox Spacing Between Columns

Miyako, That's a really good point. So the better way would be to get the local thousands separator and filter that. I suppose the best approach would be to convert each string value to a real and then string in back in with no formatting. But that gets complicated when the string is from a

Re: Listbox Spacing Between Columns

I guess string like "123,456" evaluates as an undefined, variable name in v15 or later. http://doc.4d.com/4Dv15/4D/15/Get-pointer.300-2018637.en.html 2017/09/25 7:43、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール： (in v15 they started choking execution)

Re: Listbox Spacing Between Columns

even if it doesn't seem applicable to your immediate deployment target, it is good practice as a programmer to not assume that a thousand (decimal) separator would always be a comma (period). 2017/09/25 7:43、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール：

Re: Listbox Spacing Between Columns

Sannyasin, It works with any text. Outside of listboxes I let users write formulas for things like pricing and commissions. It's nice to let them do this in terms of things they understand so a formula can look like: P= (Cost * x) + Z P= (MSRP * (1 - x)) + Z There are two ways you can evaluate

Re: Listbox Spacing Between Columns

Thanks. This does work reasonably well for this circumstance. As I’m using field based listboxes, I used the following to make the spacer column: LISTBOX INSERT COLUMN FORMULA(*;"CCTransactionsLB";3;"SpacerCol";" ";Is text;"";$HeaderVar) LISTBOX SET COLUMN WIDTH(*;"SpacerCol";10) OBJECT SET

Re: Listbox Spacing Between Columns

Very cool idea! Does this formula evaluation only work with arrays? Or text fields too? Sannyasin Siddhanathaswami On Sep 24, 2017, 3:20 AM -1000, wrote: Next approach is to read the real arrays into text arrays. In this case since they are just display it doesn't really matter. In lots of

Re: Listbox Spacing Between Columns

Kirk: Interesting idea - convert to text so that users can enter formulas. Thanks for posting that. -- Douglas von Roeder 949-336-2902 On Sun, Sep 24, 2017 at 6:20 AM, Kirk Brooks via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Sannyasin, > Sorry about that - could have sworn I'd used that

Re: Listbox Spacing Between Columns

Sannyasin, Sorry about that - could have sworn I'd used that before. Next approach is to read the real arrays into text arrays. In this case since they are just display it doesn't really matter. In lots of cases it's a benefit using text arrays for user input as it lets you accept formulas for

Re: Listbox Spacing Between Columns

I reformat the text on the fly, adding spaces to the start. Not tidy, but it does work. Jeremy Jeremy Roussak j...@mac.com > On 24 Sep 2017, at 03:40, Sannyasin Siddhanathaswami via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Excellent idea, unfortunately trailing spaces are ignored. Too

Re: Listbox Spacing Between Columns

This may not work for your situation, but I have used a dummy column to provide visual spacing between columns. Not a great solution but it has worked well enough for me in the past. John > On Sep 23, 2017, at 5:10 PM, Sannyasin Siddhanathaswami via 4D_Tech > <4d_tech@lists.4d.com> wrote: >

Re: Listbox Spacing Between Columns

Me too! (well not a couple of decades—at least 1 decade) I’m looking again seriously at Listboxes as a replacement for ALP. It’s close, but there’s a couple things that don’t quite work well in Listboxes for heavy data editing. I do both the programming and the data editing for this, so little

Re: Listbox Spacing Between Columns

Sorry, that’s about it for me. I’ve been using AreaList Pro for a couple of decades… On Sat, Sep 23, 2017 at 7:40 PM Sannyasin Siddhanathaswami via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Excellent idea, unfortunately trailing spaces are ignored. Too bad, as > that would have been perfect for

Re: Listbox Spacing Between Columns

Excellent idea, unfortunately trailing spaces are ignored. Too bad, as that would have been perfect for this circumstance. Any other ideas? Sannyasin Siddhanathaswami On Sep 23, 2017, 12:03 PM -1000, wrote: Have you tried a format that has a trailing space?

Re: Listbox Spacing Between Columns

Have you tried a format that has a trailing space? Something along these lines: "$###,###,##0.00 ;($###,###,##0.00 ) ; " -- Douglas von Roeder 949-336-2902 On Sat, Sep 23, 2017 at 2:21 PM, Sannyasin Siddhanathaswami via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Aloha! > > I have a listbox

Re: Listbox Spacing Between Columns

Aloha, Probably the simplest solution is to tweak the format in the number column and add a couple of spaces at the right. eg. "$###,##0.00 ;($###,##0.00) ; - " Add more spaces if you like. On Sat, Sep 23, 2017 at 2:21 PM, Sannyasin Siddhanathaswami via 4D_Tech < 4d_tech@lists.4d.com> wrote:

Listbox Spacing Between Columns

Aloha! I have a listbox column for dollar amounts (aligned right) followed by a Description column with text aligned left. Unfortunately, that means the text of those two columns are butting up against each other. Is there a way to add a bit more space between columns? See screen shot: