Posted on: 8/2/2013 4:58:50 PM | Views : 257

I'm not sure of the best place for this question. I'm using web forms but I'm not sure what's causing this issue so I'll just explain:
 
I have a 3rd party Excel-like component that accepts formulas. I store the formula in a database column and do some minor modifications before setting the formula in the component. My error however is being caused before this happens.
 
In my local log file, I pull out a value from the table and then log it. Here's what it looks like (starting with the 'IF'). This is local IIS.
2013-08-02 12:42:29,750 [6] INFO WPI._Grid - Final Calculation to use: IF(W1="","",(IF(AND(W1=0),"",(K1*1000/W1))))
 
On my dev server, here's the same entry in the log:
2013-08-02 12:47:19,419 [16] INFO WPI._Grid - Final Calculation to use: IF(W1=\"\",\"\",(IF(AND(W1=0),\"\",(K1*1000/W1))))
 
I am storing the escap ...

Go to the complete details ...