Values may be written to wrong environment files when Excel use Cell Indexes when storing the settings file


Excel will in some situations use Cell indexes when storing data instead of including each individual cell. The purpose is to compact the stored files by skipping empty cells.
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s74"><Data ss:Type="String">Setting_2</Data></Cell>
<Cell ss:StyleID="s75"><Data ss:Type="String">DefaultValue_2</Data></Cell>
 <Cell ss:Index="4" ss:StyleID="s75"/>
<Cell ss:StyleID="s75"><Data ss:Type="String">Test_Value1</Data></Cell>
<Cell ss:StyleID="s75"/>
In the example above, cell #3 has been skipped. As a result, the environment settings manager will generate output files where the values are shifted one environment to the left.
It seems a bit random when Excel will do this "optimalization".
As a result of this error, we no longer trust Environment Settings Manager to support default values, so we have to enter a value into each cell, event though only the value for one single environment is different from the default value. This makes the Excel sheet more difficult to read and maintain.
See the attachemnt for example files and screen shots.

file attachments

Closed Jul 31, 2012 at 5:34 AM by tfabraham


tfabraham wrote Jul 5, 2011 at 4:36 PM

Thanks for the report. If you're using the Deployment Framework for BizTalk, you can download an updated EnvironmentSettingsExporter.exe from the latest Source Code there. There is also a new release here with the fix: http://envsettingsmanager.codeplex.com/releases/view/69552.

wrote Jul 31, 2012 at 5:34 AM

wrote Feb 13, 2013 at 9:13 PM

wrote May 16, 2013 at 2:59 AM