Actions
Bug #11430
closedphpSpreadsheet Exception: Numeric value is not a number
Start date:
30.10.2020
Due date:
% Done:
0%
Estimated time:
Discuss:
Prio Planung:
Vote:
Description
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'
Updated by Carsten Rose over 3 years ago
- Status changed from Feedback to Closed
- Target version changed from next5 to 20.11.0
Actions