Paging the spreadsheetisti

Discussion in 'UK Motorcycles' started by Derek Turner, Oct 28, 2010.

  1. Derek Turner

    Derek Turner Guest

    I'm using PHP to generate a spreadsheet from a MySQL database.

    One of the cells (total yeses in column above) contains this formula:

    =COUNTIF(B5:B44,"Yes")

    This works fine in OpenOffice.org Calc and in Gnumeric but borks in MS
    Excel with some sortof out-of-range error, I'm told.

    What do I need to change to make Excel play nicely?
     
    Derek Turner, Oct 28, 2010
    #1

    1. Advertisements

  2. Derek Turner

    Krusty Guest

    Works fine in Excel 2010.
     
    Krusty, Oct 28, 2010
    #2

    1. Advertisements

  3. Derek Turner

    Ace Guest

    Looks fine.
    It ain't the formula. Something else wrong with it, and I'd presume
    it's related to the fact that it's not a 'real' excel spreadsheet. OO
    is not 100% compatible, sadly.
    Start again using only Excel.

    Or look to formulae within the contents of the cell range you
    specified, or the underlying SQL of where it's being resolved.
     
    Ace, Oct 28, 2010
    #3
  4. Derek Turner

    darsy Guest

    a clue.
     
    darsy, Oct 28, 2010
    #4
  5. Derek Turner

    boots Guest

    Seems to work fine in Excel2003
     
    boots, Oct 28, 2010
    #5
  6. Derek Turner

    CT Guest

    http://www.linuxmint.com

    Oh, hang on...
     
    CT, Oct 28, 2010
    #6
  7. Derek Turner

    darsy Guest

    darsy, Oct 28, 2010
    #7
  8. Derek Turner

    Derek Turner Guest

    It's being created on-the-fly using the PEAR package Spreadsheet Excel
    Writer in a PHP script.

    But if the formula looks OK and works (as others have reported) it must
    be something else in the sheet that Excel doesn't 'like'.
     
    Derek Turner, Oct 28, 2010
    #8
  9. Derek Turner

    Derek Turner Guest

    <bad form>

    Thanks for your help: it's now sorted.
     
    Derek Turner, Oct 28, 2010
    #9
  10. Derek Turner

    DozynSleepy Guest


    These pain killers must be playing with my mind, laughed at that too.
     
    DozynSleepy, Oct 28, 2010
    #10
  11. Derek Turner

    darsy Guest

    flashback time - when I broke my collarbone, the docs prescribed some
    painkillers (I forget exactly what they were, but ISTR they were
    opiates of some kind) and I was completely off my face when I was
    taking them.

    I could still completely feel all the pain from the broken bone, but
    it just seemed to not really matter - a bizarre feeling.

    That feeling is why I've never tried injecting downers of any kind,
    because I suspect if I started I might not ever start.
     
    darsy, Oct 28, 2010
    #11
  12. Derek Turner

    darsy Guest

    this would be the time-machine edited version of what I meant to post,
    BTW.
     
    darsy, Oct 28, 2010
    #12
  13. Derek Turner

    DozynSleepy Guest

     
    DozynSleepy, Oct 28, 2010
    #13

    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. Global Warming is caused by the Sun, the Moon and the Stars.

  2. paging the Pip, DNC or the banditisti

  3. Anyone got the horn? Paging the trumpetisti

  4. 30 MPH limits and the law (& possibly paging the NorthWiltsisti)

  5. Paging the Care for the Elderlyisti

  6. Paging the racers: bums on seats - getting the hump right

  7. Paging the SV rider on the M27 at 14:30

  8. Paging those in the IoM for the Manx, or locals.

Loading...