Gruss Forum • View topic - change A1

by **davez** » Thu Jul 29, 2010 6:03 am

Hi, firstly congrats to the developers of this great sotware, Im a new convert & loving what I can achieve with BA

One question I have is it possible to change the default location of A1 - the default top left hand cell shown in the log current prices screen?

Reason I ask is that I have incorporated triggered betting into an existing excel worksheet that I use to create rating etc for my daily betting, & currently log prices to GT3, which of course means I must continually change the reference.

Thanks in advance for any help.

by **osknows** » Thu Jul 29, 2010 6:46 am

Yes, in Excel/log current prices/ there's an option named 'top left cell', the default is A1

by **osknows** » Thu Jul 29, 2010 6:49 am

Sorry I think I misread your question. It's also possible to use Excel/mutiple sheets quick link but use only 1 sheet. When saved it will always recall your saved version with the changed top left cell reference

by **davez** » Fri Jul 30, 2010 4:31 am

thanks osknows, so i assume the answer is no - one cannot change the default 'A1' as shown in the 'log current prices' screen?

Yes, the default value cannot be changed. I will change this in a future release.

by **osknows** » Fri Jul 30, 2010 8:37 am

I thought it was possible but on my version 66x13 I can only change it to between A1 - An , it won't link when I try column B onward?

Gary, is this by design or a bug?

by **GaryRussell** » Fri Jul 30, 2010 10:02 am

osknows wrote:I thought it was possible but on my version 66x13 I can only change it to between A1 - An , it won't link when I try column B onward?

Gary, is this by design or a bug?

Strange. It seems fine here. I will have to investigate. Is it when using the quick link or when using the normal link option?

by **osknows** » Fri Jul 30, 2010 10:53 am

The normal link. I didn't try the quick link as was running other sheets

by **GaryRussell** » Fri Jul 30, 2010 10:57 am

Can you try again when you get chance and let me know if does it consistently. I should be able to track it down from a log file if this is the case. Also what exactly happens when you say it doesn't link?

by **osknows** » Fri Jul 30, 2010 12:33 pm

I'll send some details when I get home tonight. Essentially, if any other column other than A is used as the top left cell the workbook still opens but no data appears in excel.

by **osknows** » Fri Jul 30, 2010 8:37 pm

Gary,

I've just retried this and all is working fine now?? I know I'm not particularly good in the mornings but seems like senility is also approaching faster than expected too

Apologies for wasting your time
Os

by **osknows** » Fri Jul 30, 2010 9:34 pm

davez wrote:thanks osknows, so i assume the answer is no - one cannot change the default 'A1' as shown in the 'log current prices' screen?
release.

Yes it can be changed to whatever cell you need

by **davez** » Sat Jul 31, 2010 1:55 am

osknows wrote:
davez wrote:thanks osknows, so i assume the answer is no - one cannot change the default 'A1' as shown in the 'log current prices' screen?
release.

Yes it can be changed to whatever cell you need

yes, manually changed, but I assume it is not possible to permanently change A1 to whatever cell i desire?

by **GaryRussell** » Sat Jul 31, 2010 7:43 am

Sorry, it's not currently possible to change the default cell from A1.

by **GaryRussell** » Tue Aug 10, 2010 6:10 am

The latest Beta version remembers the last cell position you entered and will display it next time.

Install version 1.1.0.66x15 from the link below.
http://www.gruss-software.co.uk/Betting ... _Beta2.msi

by **Fixador** » Wed Aug 11, 2010 1:02 pm

Lovely job ! Thanks Gary - I too am an "A10" fella !

change A1 - top left hand cell reference

change A1 - top left hand cell reference

Who is online

Sports betting software from Gruss Software