David, I'm again asking you personally to please remove the drama from your posts. I'm happy to discuss technical issues with you at length.
Regarding your question: When you specify the title in the record entry you send upon creation that title is ignored. The title in record entries is provided as a formality to comply with GData standards, but there is technically no title of a record entry. There is no concept of naming a record entry in a spreadsheet. That said, in order to comply with GData standards, we do return a title. The title of a record is the first column (positionally within the spreadsheet) of that record. Let me go through this in depth. If I create this table: <entry> ... <gs:data insertionMode="overwrite" numRows="2" startRow="2"> <gs:column index="B" name="Age"/> <gs:column index="C" name="Name"/> <gs:column index="A" name="Birthday"/> <gs:column index="D" name="CanVote"/> ... </entry> And this record: <entry xmlns="http://www.w3.org/2005/Atom"; xmlns:gs="http://schemas.google.com/spreadsheets/2006";> <title>Darcy</title> <gs:field name='Birthday'>2/10/1785</gs:field> <gs:field name='Age'>28</gs:field> <gs:field name='Name'>Darcy</gs:field> <gs:field name='CanVote'>No</gs:field> </entry> The title of that record will be "2/10/1785". If I add this record: <entry xmlns="http://www.w3.org/2005/Atom"; xmlns:gs="http://schemas.google.com/spreadsheets/2006";> <gs:field name='Birthday'>2/10/1785</gs:field> <gs:field name='Age'>28</gs:field> <gs:field name='Name'>Darcy</gs:field> <gs:field name='CanVote'>No</gs:field> </entry> The title of that record will be "2/10/1785". If we take another look at the table: <entry> ... <gs:data insertionMode="overwrite" numRows="2" startRow="2"> <gs:column index="B" name="Age"/> <gs:column index="C" name="Name"/> <gs:column index="A" name="Birthday"/> <gs:column index="D" name="CanVote"/> ... </entry> Notice how Birthday is assigned to index A, e.g. column A in the sheet. That will make Birthday the left-most/first column in the sheet. Thus, the title for all records in this table will be the Birthday. If there are duplicate values in the Birthday column, there will be duplicate titles returned in entries. Entry titles for spreadsheet records are _not reliable_. Hope this helps, -Vic On Wed, Jan 5, 2011 at 11:13 PM, David Bullock <dtbull...@gmail.com> wrote: > Previously I was told in this forum (since the documentation didn't address > it), that the <title/>of a record entry would basically be the column with > the earliest index of the columns identified in the table definition. > > This is definitely not the case. Of 5 tables in 5 sheets, there is no > pattern whatsoever to which column is bound to <title/>. Only in one of > them happens to be bound to column A. > > Again, I'd file a bug, but since there is no documentation specifying the > correct behaviour, it can't exactly be held to account, can it? > > gaping with the wrong kind of awe, > David. >
