phpSpreadsheet Exception: Numeric value is not a number
New version of phpSpreadsheet throws an exception when an empty string is passed for a number i.e. 'n='.
This was not the case before, so we have alot of applications where this error occurs.
We have decided to treat this situtation before writing the value to the excel the following way:
- If the value is an empty string or consists only of spaces: change the value to empty string and type string. i.e. 's='
- otherwise, if the value is not a number then replace the value by 'not a number' and set type to string. i.e. 's=not a number'