Thanks for reporting the issue, there was actually a bug in the client library that I just fixed in rev. 1191:
http://code.google.com/p/google-gdata/source/detail?r=1191 Claudio On Wed, May 16, 2012 at 12:53 PM, Marco Desira <[email protected]>wrote: > Colin, > I tried out your solution it works fine ..... Thanks > > I have found another method of adding a worksheet as I had my back to the > wall. > > > //spreadSheet is the handle to the SpreadSheet I am working > with > WorksheetFeed wsFeed = spreadSheet.Worksheets; > > WorksheetEntry worksheet = new WorksheetEntry(); > worksheet = ((WorksheetEntry)wsFeed.Entries[0]); > worksheet.Cols = 100; > worksheet.Rows = 100; > worksheet.Title.Text = "Marco"; > spreadSheetsService.Insert(wsFeed, worksheet); > It serves the intended purpose i.e. that of adding a worksheet. > > > > Colin, Thanks once again > > > > > > > > > > > > > On Wednesday, 16 May 2012 21:35:34 UTC+2, Colin Jones wrote: > >> We had this error last week. Unfortunately, I have since deleted the >> code. I believe we solved it with: >> >> worksheet.RowCount = new RowCountElement(20); >> worksheet.ColCount = new ColCountElement(10); >> >> hope this helps... >> >> On May 16, 1:24 pm, Marco Desira <[email protected]> wrote: >> > When the line workSheet.Cols = 10 is executed I get >> > >> > System.NullReferenceException was unhandled >> > Message=Object reference not set to an instance of an object. >> > Source=Google.GData.**Spreadsheets >> > StackTrace: >> > at Google.GData.Spreadsheets.**WorksheetEntry.set_Cols(UInt32 >> value) >> > >> > The error indicates that the object workSheet.Cols was not instantiated >> > Any ideas how I can solve this .... Thanks >> > >> > Marco >> > >> > >> > >> > >> > >> > >> > >> > On Wednesday, 16 May 2012 20:49:10 UTC+2, Claudio Cherubino wrote: >> > > Hi Marco, >> > >> > > What is the error you get? >> > > Thanks >> > >> > > Claudio >> > >> > > On Wed, May 16, 2012 at 11:47 AM, Marco Desira < >> [email protected]>wrote: >> > >> > >> Adding a worksheet to a spreadsheet using .Net triggers an error. >> > >> The error is triggered when setting the number of rows and cols of >> the >> > >> worksheet. >> > >> > >> It seems that there is a bug in the API >> > >> > >> The code is found at >> > >> > >>https://developers.google.**com/google-apps/spreadsheets/#** >> adding_a_work.<https://developers.google.com/google-apps/spreadsheets/#adding_a_work.>.. >> >> > >> > >> Refer to the code below. Setting the cols and rows trigegrs the >> error. >> > >> > >> WorksheetEntry worksheet = new WorksheetEntry(); >> > >> worksheet.Title.Text = "New Worksheet"; >> > >> worksheet.Cols = 10; >> > >> worksheet.Rows = 20; >> > >> > >> Any ideas for a work around? >> > >> > >> Thanks > >
