Quoted value of a formula cell

[antone-sb]

Hi! I've noticed that for a formula cell the value is returned in quotes. Is this by design? What is the reason for it? In particular, if the value is an empty string, two quote marks are returned. SampleSum.xlsx I get the following values with attached file: -4 "minus" 4 ""

[apixandru]

Good catch, I have noticed similar behavior with the numbers, it should be fixed with this pull request https://github.com/monitorjbl/excel-streaming-reader/pull/118

Main file Main.java.txt Input SampleSum2.xlsx

Before #118

-4.0      "minus"        "minus"        minus      
 4.0           ""             ""      "minus"      
-4.0      "minus"      ""minus""      "minus"      

After #118

-4.0      minus        minus        minus      
 4.0                              "minus"      
-4.0      minus      "minus"      "minus"      

Native Apache Poi

-4.0      minus        minus        minus      
 4.0                              "minus"      
-4.0      minus      "minus"      "minus"