EPPlus
EPPlus copied to clipboard
Formatted text for cells with boolean values should return TRUE or FALSE
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.
Fixed in v7 via PR 1278. Will be available in next release.