EnvironmentSettingsExporter.exe and blank cells (ss:Index)

I found a bug in the EnvironmentSettingsExporter.exe that gives us some headache. Consider the SettingsFileGenerator.xml file in the Samples\BizTalk2009\BasicMasterBindings\BasicMasterBindings.Deployment\EnvironmentSettings folder.

Now open it and enter 'foobar' into the cell D8. Save. Now move the cell by draging the rectangle around D8 to E8 and save again.

If you now run EnvironmentSettingsExporter.exe you'll notice that 'foobar' is written to DEVL_settings.xml instead of 'QA_settings.xml'. This is because Excel now uses the attribute Index to skip blank colums:

Sorry that you ran into this issue. It causes a lot of confusion. If you grab EnvironmentSettingsExporter.exe from the latest source code download, you can overwrite your current version in order to fix this problem.