Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bug when hiding a table column and filtering
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/a...rent_table.jpg 5. Filter the table http://i997.photobucket.com/albums/a...ered_table.jpg 6. Hide one of the columns http://i997.photobucket.com/albums/a...ncol_table.jpg 7. Change the value of one of the columns http://i997.photobucket.com/albums/a...ange_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/a...ange_table.jpg Is this a bug? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bug when hiding a table column and filtering | Excel Worksheet Functions | |||
rename column header after filtering column results in the MS SQL | Excel Programming | |||
Hiding Column Also hiding text | Excel Programming | |||
Need help hiding/unhiding column based on autofilter selection in a different column | Excel Programming | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |