"Expression error. Formula string can''t be empty"

[Ilya Golovkine]

I’m trying to copy formulas from the grid into excel spreadsheet. Simple formulas which only reference neighboring columns on the same line work absolutely fine. However I get that exception whenever the formula I’m trying to copy references cells on different lines for example: =K3*100 / (K133 + K132)

Any ideas? Thanks

[Administrator]

>I’m trying to copy formulas from the grid into excel spreadsheet. Simple formulas which only reference neighboring columns on the same line work absolutely fine. However I get that exception whenever the formula I’m trying to copy references cells on different lines for example: =K3*100 / (K133 + K132)
>
>Any ideas? Thanks

Try to remove spaces from the formula string.

[Administrator]

Hi Ilya, On removing the Spaces in the Formula String , the Formulas works fine. I put together a sample based on your requirements. Please take a look at this sample and let me know if you have any questions. formulas.zip Best Regards, Seetha. >I’m trying to copy formulas from the grid into excel spreadsheet. Simple formulas which only reference neighboring columns on the same line work absolutely fine. However I get that exception whenever the formula I’m trying to copy references cells on different lines for example: =K3*100 / (K133 + K132) > >Any ideas? Thanks