Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
260
Worksheet formula references truncate worksheet name
posted

 

I've isolated a pretty serious bug in the Excel component. If I apply a formula to a cell that contains a reference to another worksheet cell i.e. Rows[0].Cells[0].ApplyFormula("='someotherworksheet'!A1*20"), the value is computed correctly, but when I look at the formula after it's been applied, the worksheet reference was truncated.

The Formula property will now return: "=A1*20"