Re: [TIP]: Esoteric method for calculating Excel column references

2018-12-05 Thread Arnaud de Montard via 4D_Tech
> Le 2 déc. 2018 à 00:00, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I had need to calculate column references for an Excel spreadsheet for > columns greater than 26. You know, so you can come up with the reference > like: A1:AG1. Hi Kirk, I had the same problem in the

RE: [TIP]: Esoteric method for calculating Excel column references

2018-12-02 Thread Randy Engle via 4D_Tech
oks Subject: [TIP]: Esoteric method for calculating Excel column references I had need to calculate column references for an Excel spreadsheet for columns greater than 26. You know, so you can come up with the reference like: A1:AG1. Fun stuff. Anyway, the scheme for this is deceptive. A

[TIP]: Esoteric method for calculating Excel column references

2018-12-01 Thread Kirk Brooks via 4D_Tech
I had need to calculate column references for an Excel spreadsheet for columns greater than 26. You know, so you can come up with the reference like: A1:AG1. Fun stuff. Anyway, the scheme for this is deceptive. A -> Z is easy. But A # 0 or 1 strictly. It's tricky. I suspect this is one reason