EPPlus icon indicating copy to clipboard operation
EPPlus copied to clipboard

Formatted text for cells with boolean values should return TRUE or FALSE

Open swmal opened this issue 1 year ago • 1 comments
trafficstars

Description of the issue:

I am currently using EPPlus version 7.0.3 and I have encountered an issue regarding cells with Excel functions that return Boolean values (for example, =A1=B1). When I retrieve the value of such a cell using Value and Text, I obtain "Value: True" and "Text: 1". However, my expectation is that when I retrieve the value using Text, it should return "TRUE" or "FALSE" as displayed when the Excel file is opened.

swmal avatar Feb 06 '24 09:02 swmal

Fixed in v7 via PR 1278. Will be available in next release.

swmal avatar Feb 06 '24 09:02 swmal