This project has moved. For the latest updates, please go here.
1
Vote

Some source code leaks into cell`s value during calculations

description

Hi, I'm trying to process the CSV file by loading it's data into the EpplusPackage's worksheet and calculating it. In a few result files I get the strange source code in the values of the cell`s like such one: "OfficeOpenXml.FormulaParsing.EpplusExcelDataProvider+RangeInfo/Sneaker"
instead of
"Damen/Sneaker"
when using the formula
"IF(INDIRECT("Sheet2!A"&ROW()-ROW(C$2)+2)="","",INDIRECT("Sheet2!AC"&ROW()-ROW(C$2)+2)&"/"&INDIRECT("Sheet2!S"&ROW()-ROW(C$2)+2))"
or this one
"OfficeOpenXml.FormulaParsing.EpplusExcelDataProvider+RangeInfo/Clothing & Accessories -> Clothing Accessories -> Bags"
instead of
"Female/Clothing & Accessories -> Clothing Accessories -> Bags"
for formula
"=INDIRECT("Sheet2!BT"&ROW()-ROW(C$2)+2)&"/"&LEFT(INDIRECT("Sheet2!F"&ROW()-ROW(C$2)+2),FIND("^",SUBSTITUTE(INDIRECT("Sheet2!F"&ROW()-ROW(C$2)+2)&">>>",">","^",3))-1)"
Do you need any additional info for finding the reason of this bug?
P.S. Thank you for your work. :)

comments