Project

General

Profile

Actions

Bug #11430

closed

phpSpreadsheet Exception: Numeric value is not a number

Added by Marc Egger over 3 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Marc Egger
Target version:
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'
Actions #1

Updated by Marc Egger over 3 years ago

  • Status changed from Closed to Feedback
Actions #2

Updated by Carsten Rose over 3 years ago

  • Status changed from Feedback to Closed
  • Target version changed from next5 to 20.11.0
Actions

Also available in: Atom PDF