Problems with apostrophes

Topics: Developer Forum, User Forum
Mar 15, 2012 at 12:27 AM

I'm having problems inserting apostrophes into my cells.  They are in the db correctly, but when I put the db filed into the cell it's losing the data after the ' - does anyone know how to get around this.  My code currently looks like this:

      ->setCellValue('B'.$att_cnt, $row['Name'])

I've also tried addslashes($row['Name']), but that didn help either.

Any ideas?