OOTP Developments Forums - View Single Post

Swimmer · 09-05-2006, 10:02 AM

Hi Guys,

Just spent a long holiday in PC hell with what turned out to be a bad video card.

Those of you having trouble getting the name generator to calculate:

I forgot that over the years Excel has had different bugs related to the calculate now shortcut key. They have also changed the key around different times, and it has even been different from the documented key in various builds of the same version of Excel.

Here are things to try:

1 - "ctrl =" has been an alternate shortcut key, try that.

2 - Go to Tools->Options. Select the "calculation" tab and change the preference to "calculate automatically".

If automatic calculation is enabled, then putting the cursor into a blank field and hitting delete should trip calculation.

Also, I uncovered a bug where if it happens to pick the first name off of a particular ethnicity's list, it generates a "#N/A" for the name... I'll post a fix for that soon. Meanwhile, just re-calculate and generate another name.

Sorry for the delay, guys.

09-05-2006, 10:02 AM	#103
Swimmer Minors (Double A) Join Date: Feb 2003 Location: Castle Rock, Colorado Posts: 165	Apologies for ignoring the thread Hi Guys, Just spent a long holiday in PC hell with what turned out to be a bad video card. Those of you having trouble getting the name generator to calculate: I forgot that over the years Excel has had different bugs related to the calculate now shortcut key. They have also changed the key around different times, and it has even been different from the documented key in various builds of the same version of Excel. Here are things to try: 1 - "ctrl =" has been an alternate shortcut key, try that. 2 - Go to Tools->Options. Select the "calculation" tab and change the preference to "calculate automatically". If automatic calculation is enabled, then putting the cursor into a blank field and hitting delete should trip calculation. Also, I uncovered a bug where if it happens to pick the first name off of a particular ethnicity's list, it generates a "#N/A" for the name... I'll post a fix for that soon. Meanwhile, just re-calculate and generate another name. Sorry for the delay, guys. __________________ People ask me what I do in the winter when there's no baseball. I'll tell you what I do. I stare out the window and wait for spring. --Rogers Hornsby Last edited by Swimmer; 09-05-2006 at 04:38 PM.