excel-streaming-reader icon indicating copy to clipboard operation
excel-streaming-reader copied to clipboard
verified publisher icon monitorjbl

Cell value with type "Formula string (str)" placed between double quotation marks

Open nmsakos opened this issue 7 years ago • 4 comments

Hi,

In our Excel file we have cells which are containing formulas, which are evaluated into strings. During processing such cells we found that these values are placed between double quotation marks by the StreamingSheetReeder.

I want to understand the root cause and the need for this behavior. Can it turned off somehow?

Btw, the library is awesome, and saved us!

Thanks! Akos

nmsakos avatar Jan 30 '18 10:01 nmsakos

I would like to know the reason behind this as well?

imranzahid01 avatar Mar 02 '18 16:03 imranzahid01

same question here

hansih91 avatar May 02 '18 10:05 hansih91

I too need help on this. How to retrieve the value which has a formula in its cell .

hariharansethu avatar May 04 '18 21:05 hariharansethu

same question here

CMemorY180819 avatar May 14 '19 08:05 CMemorY180819