Free Support Forum - aspose.com

Format of formula's change when sending excel over a service

Hello


I’m picking an excel file on the client side. I put it in a bytearray and it goes through a wcf service to the server. When it gets there, I recreate the file and save it there. When i try to open the excel, I get an error. Apparently all “;” characters are changed to “,” characters, which causes the error.

{“Error in Cell: D37-Invalid formula:”=IFERROR(VLOOKUP(“V”,$AD32:$AK35,3,FALSE),"")
& IF(AD32=“V”,"","

"&AF32)
& IF(AD33=“V”,"","

"&AF33)
& IF(AD34=“V”,"","

"&AF34)
& IF(AD35=“V”,"","

"&AF35)"."}

When I open it manually in excel, I have no problem whatsoever.

Is this a familiar problem?

Kind regards

Hi,


Could you give us your sample code/sample application with Excel file(s) to reproduce and show the issue on our end, we will check it soon.

Also, could you try our latest version/fix v7.0.0.1:(Please download: Aspose.Cells for .NET v7.0.0.1) if it makes any difference.

Thank you.

Hi


Thanks for your response.
Using a later version of the dll works better.
The problem were the “enter” characters in the formula stated above.
It wasn’t processed in my 4.4.3 version of the dll, this is solved in 7.0.0.1 version you linked.