Thanks for your response, Karim.
You are right. Single quotes in OpenOffice generates the error. I copied a single quote from a working xlsx file and used it in the xlsx file where the error was generated. This solved the issue.
But it would great if you or someone else from the development community could explain the issue in detail for a fix would allow me to type in quotes from my keyboard rather than copy it from another xlsx file.
Thanks again!