[Google-Docs-Data-APIs] display empty cellFeeds

[boaz]

Hi, i have a spreadsheet that has some empty cells.
i want to be able to get those cell as a NULL value.
it seems the $cellFeed doesn't include them in the query result.

for example, im running this code:

    $query = new Zend_Gdata_Spreadsheets_CellQuery();
        $query->setMinCol(5);
        $query->setMaxCol(6);
        $query->setMinRow(2);
    $query->setSpreadsheetKey($spreadsheetsKey);             //
spreadsheet id
    $query->setWorksheetId($worksheetId);                    //
worksheet id
    $cellFeed = $spreadsheetService->getCellFeed($query);


    $cellFeed = $spreadsheetService->getCellFeed($query);

    //  displays cells
    foreach($cellFeed as $cellEntery){
        $row=$cellEntery->cell->getRow();
        $col=$cellEntery->cell->getColumn();
        $val=$cellEntery->cell->getText();
        echo $row.",".$col."=".$val."\n";
    }

this is the result:

7,5=user1
7,6=password1
8,5=user2
8,6=password2
9,5=user3
10,6=password4

as you can see cells 9,6 and 10,5 are empty and they are not
displayed. i would still like their value to be "" or NULL.

thanks,
Boaz
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Google Docs Data APIs" group.
To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com
To unsubscribe from this group, send email to 
google-docs-data-apis+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---