Excel Formula > UNICHAR with @

[luca.demori]

Hi there !

For the first time I need to insert a symbol inside a cell: the easyest way I found is to use the UNICHAR(value) formula.


I'm using this syntax in my code:

Code: Select all

sheet.Range["D7"].Formula = "UNICHAR(10004)";

Unfortunately, the result is a @ inside my cell (value is "=@UNICHAR(10004)") ... and I don't know the reason why !


Can someone help me ?

[Abel.He]

Hello,

Thanks for your inquiry.
For your question, I have made the following reply in the email to you.

This is Abel from E-iceblue support team. I used SPIRE.XLS library (12.5.3.5046) to test your scenario, and I didn’t reproduce your issue. To help us to reproduce your issue and work out a solution for you, please offer the following message. Thanks for your assistance in advance.

1) Your input excel file.
2) Your simple test code that can reproduce your issue.
3) The screenshot of MS Excel version information you used.
4) Your test environment, such as OS info (E.g. Windows 7, 64-bit) and region setting (E.g. China, Chinese).
5) Application type, such as Console App, .NET Framework 4.8.

Sincerely,
Abel
E-iceblue support team