David, I am not really able to replicate this behavior since to my knowledge, there is no IFCOUNT formula. I am not seeing that in the formula reference either:
http://documents.google.com/support/spreadsheets/bin/answer.py?answer=82712 Can you confirm that this is working for you in the Spreadsheet UI? The next step would be to see if you can run a packet trace of the actual request so that we can figure out whether the XML is being sent and interpreted correctly. Thanks - jochen On Sep 4, 1:51 pm, eathaiku <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
