>>>Hi everybody,
>>>
>>>I got this email from my former boss:
>>>
>>>I did some more testing and here is the interesting point.
>>>
>>>If I take the program xlsxfile and run it from the command window I get the correct results. If I make the routine a project and call it from my main program it returns the first column label in all the fields.
>>>
>>>There must be some setting that is causing the routines not to retrieve the correct values in the individual cells.
>>>
>>>I suspect it may be 'SET EXACT and SET ANSI' settings, but I think there is a way to get all these settings somehow saved, but I just don't remember how.
>>>
>>>Do you know how to get all the settings from IDE vs. run-time?
>>>
>>>Thanks in advance.
>>
>>Going just a step further from the Help file (but I'll be really embarrassed if there is a simpler solution...):
>>
>>

>>LOCAL regfile, oReg
>>LOCAL ARRAY aFoxOptions[1,2]
>>LOCAL Option
>>
>>m.regfile = HOME(2)+"classes\registry.prg"
>>SET PROCEDURE TO (m.regfile) ADDITIVE
>>m.oReg = CreateObject("FoxReg")
>>m.nErrNum = m.oReg.EnumFoxOptions(@m.aFoxOptions) 
>>
>>SET ALTERNATE TO "Settings.txt"
>>SET ALTERNATE ON
>>
>>FOR m.Option = 1 TO ALEN(m.aFoxOptions, 1)
>>	? m.aFoxOptions[m.Option, 1],"=",m.aFoxOptions[m.Option, 2]
>>ENDFOR
>>
>>SET ALTERNATE OFF
>>SET ALTERNATE TO
>>
>>MODIFY FILE Settings.txt
>>

>
>Somewhat relatedly, ISTR there is/was a keyboard combination that would dump all these values into either a Debugger window or the Command window (?) Anyone recall what that was? I thought I might have seen a post from Tore Bleken about that but I can't find it.

UPDATE: found the Message#1633474 . Just tried it in one of my development VMs, it doesn't look comprehensive. I have no idea where it's getting what it's displaying.