Re: Listbox Spacing Between Columns

2017-09-24 Thread Sannyasin Siddhanathaswami via 4D_Tech
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

2017-09-24 Thread Douglas von Roeder via 4D_Tech
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

2017-09-24 Thread Sannyasin Siddhanathaswami via 4D_Tech
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

Is it possible to put a SVG file directly on a form?

2017-09-24 Thread Kirk Brooks via 4D_Tech
or does it have to be converted to a picture? -- Kirk Brooks San Francisco, CA === *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ** 4D Internet Users

Re: Listbox Spacing Between Columns

2017-09-24 Thread Keisuke Miyako via 4D_Tech
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

2017-09-24 Thread Keisuke Miyako via 4D_Tech
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

2017-09-24 Thread Kirk Brooks via 4D_Tech
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

2017-09-24 Thread Jeremy Roussak via 4D_Tech
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

2017-09-24 Thread Kirk Brooks via 4D_Tech
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

2017-09-24 Thread Kirk Brooks via 4D_Tech
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