Hi all, I'm having difficultly populating a cell with a funciton via the php zend api. Many thanks for any clarity, as I've been racking my brain all day trying to make heads or tails of this unexpected behavior.
short of it: '=IFCOUNT(sheet2!H:H,A1)' yeilds ''=IFCOUNT(sheet2! C[-11],A1)', a single cell reference, using a different cell reference. long of it: I have a spreadsheet with two worksheets. each row in sheet1 has a unique value in column A. In sheet2 is additional information, each row has several columns of data, one column, say column H, contains one of the unique keys form sheet1!A. I want to put a IFCOUNT function on sheet1 in column B that will tally the occurances of A in sheet2. If i manually put the function '=IFCOUNT(sheet2!H:H,A1) in to sheet!B1, the result is the number of times that unique key sheet!A1 appears in sheet2. However, when I try to use the api method updateCell( '1','2','=IFCOUNT(sheet2!H:H,A1)',$key,$wksht), B is populated with a different formula. Usually something like '=IFCOUNT(sheet2!C[-11],A1)': where C[-11]is, I guess, some column reference counting back (from where?). While the conversion from one column definition to another is not expected, I can (begrudgingly) deal with it. The PROBLEM is that I what the whole column, hence my 'H:H', but the conversion/update/insert removes the range, leaving a single cell reference. WHY? Do I need to change my function? Am I not providing the column range properly? is there cell reference convention that I'm missing? Again, thanks in advance -david --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---
