Using the latest download I have produced a spreadsheet that is based on data extracted from MySQL.
I have not experienced any issues extracting information and manipulating the data accordingly expect when I have the sterling symbol (pound sign) ‘£’ in the field.
Initially I discovered that a particular financial field had been entered using the ‘£’ symbol. (The particular resulting spreadsheet is essential y a financial breakdown.)
On output all the relevant cells appeared blank.
I removed the ‘£’ symbol and the numeric value was subsequently displayed. Firstly it was incorrect to use numbers VARCHAR field and have changed accordingly.
All changes now work.
However, in a field set as VARCHAR which is for ‘user notes’ I found that if the user enter the ‘£’ symbol it will truncate the remainder of the text thereafter.
I am probably missing the obvious but any ideas pointing me in the right direction would be most appreciated.
Thanks in advance.