PhpSpreadsheet

Commit Graph

Author	SHA1	Message	Date
MarkBaker	cba0e13b2a	Escape double quotes in a string value unless it's an empty string value	2022-03-05 12:44:44 +01:00
Jorge Casas	156ab360fe	Fixed Functions->ifCondition for allowing <> and empty condition In cells with formulas containing conditions like `=IFSUM(A1:A3;"";B1:B3)` to sum cells from range A1:A3 with empty value in range B1:B3, the function `Functions::ifCondition()` create in this case the code `=""""` instead of `=""`, so it didn't work. Closes #1206	2019-11-17 21:03:11 +01:00
Bill Blume	e3fb160f5f	Fixed parsing of conditionals in COUNTIF functions Conditional operators in the selection parameter of COUNTIF functions were not being parsed properly, causing evaluations of formulae with such functions to sometimes fail. Fixes #526 Closes #528	2018-06-10 14:25:33 +09:00

Author

SHA1

Message

Date

MarkBaker

cba0e13b2a

Escape double quotes in a string value unless it's an empty string value

2022-03-05 12:44:44 +01:00

Jorge Casas

156ab360fe

Fixed Functions->ifCondition for allowing <> and empty condition

In cells with formulas containing conditions like `=IFSUM(A1:A3;"";B1:B3)`
to sum cells from range A1:A3 with empty value in range B1:B3, the function
`Functions::ifCondition()` create in this case the code `=""""` instead of
`=""`, so it didn't work.

Closes #1206

2019-11-17 21:03:11 +01:00

Bill Blume

e3fb160f5f

Fixed parsing of conditionals in COUNTIF functions

Conditional operators in the selection parameter of COUNTIF
functions were not being parsed properly, causing evaluations
of formulae with such functions to sometimes fail.

Fixes #526
Closes #528

2018-06-10 14:25:33 +09:00

3 Commits