Project

General

Profile

Bug #11430

phpSpreadsheet Exception: Numeric value is not a number

Added by Marc Egger 28 days ago. Updated 15 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
30.10.2020
Due date:
% Done:

0%

Estimated time:
Discuss:

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'
#1

Updated by Marc Egger 28 days ago

  • Status changed from Closed to Feedback
#2

Updated by Carsten Rose 15 days ago

  • Status changed from Feedback to Closed
  • Target version changed from 20.11.1 to 20.11.0

Also available in: Atom PDF