Excel-DNA / Excel-DNA/ExcelDna

ExcelAsyncUtil.QueueAsMacro error in WPS Office

Open
#568 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
1.5k
Forks
292
Avg merge
20d 12h
Merged PRs (30d)
1

Description

Hello, I want to add some comments for the caller cell in the Function. My Code like this:
``` C#
public static object NoteTest()
{
var caller = XlCall.Excel(XlCall.xlfCaller) as ExcelReference;
ExcelAsyncUtil.QueueAsMacro(() =>
{
XlCall.Excel(XlCall.xlfNote, "Tip", caller);
});
return "Tip";
}
```
It works fine in Microsoft Excel.
![image](https://user-images.githubusercontent.com/31381987/219675517-c6728009-b4d1-4449-a697-02dab186326a.png)

Now, I want this code to run in WPS Office, but I get "Registration [Error] IsInFormulaEditMode-PenHelper failed, result 32". Is there any suggestions? Thanks.
![image](https://user-images.githubusercontent.com/31381987/219676187-6f414001-0446-488b-87d1-2387f3ae55cd.png)

Maybe WPS Spreadsheets is based on Excel 2007, because the value of "Microsoft.Office.Interop.Excel.Application.Version " is "12.0".

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.