K
Kevin Hendrawan
Hi all,
Been having this strange behaviour in for months. This happens when I
created a table by drag-and-dropping a table from the "Data Sources" panel to
the Worksheet Designer in Visual Studio 2008. The table in Excel copies or
shifts values from the first column whenever the table is filtered and has a
column or some of its columns hidden.
To replicate the error, you need:
1. Visual Studio 2008 and
2. Excel 2007
How to replicate the error:
1. Create a new Excel 2007 workbook project, the format is arbitrary but I
chose .xlsm
2. Add a new data source and add any table into the worksheet
3. Compile the project
4. The table is there
http://i997.photobucket.com/albums/af95/kepinpin/current_table.jpg
5. Filter the table
http://i997.photobucket.com/albums/af95/kepinpin/filtered_table.jpg
6. Hide one of the columns
http://i997.photobucket.com/albums/af95/kepinpin/hiddencol_table.jpg
7. Change the value of one of the columns
http://i997.photobucket.com/albums/af95/kepinpin/beforechange_table.jpg
8. As soon as I press enter or tab, the value of the first column is copied
over the rest of the
columns!http://i997.photobucket.com/albums/af95/kepinpin/afterchange_table.jpg
Is this a bug?
Been having this strange behaviour in for months. This happens when I
created a table by drag-and-dropping a table from the "Data Sources" panel to
the Worksheet Designer in Visual Studio 2008. The table in Excel copies or
shifts values from the first column whenever the table is filtered and has a
column or some of its columns hidden.
To replicate the error, you need:
1. Visual Studio 2008 and
2. Excel 2007
How to replicate the error:
1. Create a new Excel 2007 workbook project, the format is arbitrary but I
chose .xlsm
2. Add a new data source and add any table into the worksheet
3. Compile the project
4. The table is there
http://i997.photobucket.com/albums/af95/kepinpin/current_table.jpg
5. Filter the table
http://i997.photobucket.com/albums/af95/kepinpin/filtered_table.jpg
6. Hide one of the columns
http://i997.photobucket.com/albums/af95/kepinpin/hiddencol_table.jpg
7. Change the value of one of the columns
http://i997.photobucket.com/albums/af95/kepinpin/beforechange_table.jpg
8. As soon as I press enter or tab, the value of the first column is copied
over the rest of the
columns!http://i997.photobucket.com/albums/af95/kepinpin/afterchange_table.jpg
Is this a bug?