No announcements
Found 2681760 threads
-
0 VotesListObject: inserted row in Excel disappears
doesn't matter if I press tab, return or click away with the mouse in the Excel sheet. What we want is: 1. User adds a new row ...Unanswered | 6 Replies | 3337 Views | Created by blauber1 - Thursday, March 1, 2012 7:26 PM | Last reply by blauber1 - Thursday, March 15, 2012 8:09 AM
-
0 Votes
ListObject behavior in Excel
How does the ListObject behaves in Excel when its databinding is changed. I mean if it is placed over a range and when the binding changes the format of the cells ...Answered | 1 Replies | 4909 Views | Created by ssouki - Sunday, May 7, 2006 7:02 PM | Last reply by Rufus Littlefield - MSFT - Thursday, May 11, 2006 12:17 AM -
0 Votes
Excel ListObject
quite well to get the list right." Also, is there a way to control the column heading in a ListObject?Unanswered | 3 Replies | 6384 Views | Created by DanHaligas - Tuesday, October 25, 2005 7:00 PM | Last reply by greatwhitenorth - Friday, June 16, 2006 9:07 PM -
2 Votes
Add a row to a ListObject in Excel with VBA
The following code adds a row to a ListObject. Contrary to your comment in initial post "ListObjects.resize" can be used by first extracting the range and ...Answered | 4 Replies | 13547 Views | Created by Looshsmoot - Wednesday, August 29, 2012 5:55 PM | Last reply by OssieMac - Thursday, August 30, 2012 1:54 AM -
0 Votes
Excel ListObject Problems
You may want to try the BorderAround function on the Range of the ListObject to set the color of the border.You cannot get rid of the header row from a ListObject.Hope that ...Answered | 1 Replies | 5274 Views | Created by DaveTrux - Wednesday, November 16, 2005 4:46 PM | Last reply by Mohit Gupta - MSFT - Wednesday, November 16, 2005 7:28 PM -
0 Votes
Inserted row after DB_E_ABORTLIMITREACHED
DB_E_ABORTLIMITREACHED means that the response from the server timed out. If you need to be sure that the row is inserted only once you could wrap your insert into a transaction. You ...Answered | 1 Replies | 7702 Views | Created by dimitar lazarov - Wednesday, June 4, 2008 11:05 AM | Last reply by Anton Klimov - MSFT - Wednesday, June 4, 2008 7:39 PM -
0 Votes
Excel ListObject issue
Hi, My problem is the following : I've added a ListObject to an Excel-sheet. It has no rows to start with. Let's say i'm ...Answered | 3 Replies | 5576 Views | Created by Ben Van Mulders - Monday, January 29, 2007 3:32 PM | Last reply by XL-Dennis - Tuesday, January 30, 2007 1:49 PM -
0 Votes
Excel ListObject Blue Border
Hi Jon I doubt very much whether this can be changed. But if anyone knows, it'll be the experts in the Excel newsgroups.Answered | 1 Replies | 4374 Views | Created by WheresRandleNow - Wednesday, August 9, 2006 9:47 AM | Last reply by Cindy Meister MVP - Wednesday, August 9, 2006 10:21 AM -
0 Votes
Help with Excel ListObject control
have multiple values or List values? Can i use Excel controls in databound listobject? So that when a user clicks on the cell which has list of values, it shows a list box ...Answered | 2 Replies | 3816 Views | Created by Niranjan_Marathe - Wednesday, November 10, 2010 4:20 PM | Last reply by Niranjan_Marathe - Thursday, November 11, 2010 4:06 PM -
1 Votes
Excel ListObject Last Remaining Row Does Not Get Deleted
;there is only one row in a databound ListObject, and the user deletes this row (by any of the possiblities the Excel user interface offers for ...Answered | 6 Replies | 3176 Views | Created by GeorgU - Monday, July 30, 2012 2:56 PM | Last reply by GeorgU - Monday, August 6, 2012 10:35 AM -
0 Votes
Excel ListObject Not Updating
Hi there. I have a ListObject in Excel and I am having trouble getting the display to update correctly. I have a dataset where I ...Unanswered | 1 Replies | 3900 Views | Created by michaelloveusa - Monday, September 24, 2007 8:07 PM | Last reply by michaelloveusa - Tuesday, September 25, 2007 5:47 PM -
0 Votes
Excel VBA Code to delete Empty ListObject Row
The code below will check every fields on a specific row of a ListObject (a table in Excel). If every fields (which synonymous with column in ...Answered | 3 Replies | 3940 Views | Created by nomen86 - Wednesday, October 28, 2015 1:33 AM | Last reply by James Cone - Wednesday, October 28, 2015 2:26 PM -
1 Votes
Caching ListObject and bindng excel sheet databack to ListObject
user 'RE-Open' the excel, by using caching or someother process, I can have this columns in the list and just read from listobject rather than reading from ...Answered | 3 Replies | 1481 Views | Created by R R Varma - Monday, February 11, 2013 6:41 AM | Last reply by 许阳(无锡) - Wednesday, February 20, 2013 5:06 AM -
0 Votes
email with trigger inserted row
I'm trying to create a trigger which, upon a row insert, an email is sent containing some of the inserted row information. Apparently the built-in stored ...Answered | 3 Replies | 6724 Views | Created by AL_G4 - Friday, February 16, 2007 10:49 PM | Last reply by Rob Farley - Sunday, February 18, 2007 10:26 PM -
0 Votes
DataGrid Row disappears!
problem comes up. If I switch to the second rectangle after editing something inside the combobox in the datagrid a row disappears although the two rectangles are ...Unanswered | 1 Replies | 2026 Views | Created by Sternze1 - Wednesday, August 12, 2009 3:31 AM | Last reply by Mog Liang - Tuesday, August 18, 2009 4:49 AM -
0 Votes
bug in listobject binding? (Excel 2013, .NET4.5)
Here is the Listobject in excel after I’ve populated some data to the BindingList via C# from my data source:Answered | 3 Replies | 2015 Views | Created by Allen Anderson_Cireson - Friday, March 21, 2014 7:53 PM | Last reply by Luna Zhang - MSFT - Wednesday, March 26, 2014 1:33 AM -
0 Votes
Excel project problem with ListObject
a comboBox (a list in excel). But i can't see the combo in the grid (list Object). Maybe it's not possible, it's my question. Could you specify ...Answered | 3 Replies | 4212 Views | Created by fix105 - Wednesday, August 23, 2006 2:10 PM | Last reply by Mohit Gupta - MSFT - Monday, August 28, 2006 6:21 AM -
0 Votes
Excel ListObject with Vertical table heading
Hi, How do i create ListObject(Table) in Excel with Table Headings vertically? Is it possible? or any other work around instead of ...Answered | 1 Replies | 3588 Views | Created by sKarthick - Wednesday, August 19, 2009 2:32 PM | Last reply by incre-d - Thursday, August 20, 2009 11:48 AM -
0 Votes
[Excel] binding xml to ListObject
AutoSetDataBoundColumnHeaders. Also, I couldn't understand from [lacking] documentation if I can provide just one cell in the target range, or if I have to ...Answered | 1 Replies | 4380 Views | Created by Gustavo Frederico - Tuesday, April 15, 2008 6:06 PM | Last reply by Gustavo Frederico - Tuesday, April 15, 2008 8:10 PM -
2 Votes
Performance Problem Excel 2010 ListObject
Populate 100K records in this kind of system is taking more than 120sec. This much time is taken by SetDataBinding method of ListObject itself and it freezes the excel as ...Answered | 5 Replies | 4591 Views | Created by Harald Pichler - Tuesday, July 3, 2012 3:09 PM | Last reply by Anonymous6282 - Wednesday, January 4, 2017 8:18 PM - Items 1 to 20 of 2681760 Next ›
No announcements
