Bug when hiding a table column and filtering

  • Thread starter Kevin Hendrawan
  • Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top