Excel-DNA / Excel-DNA/ExcelDna
ExcelAsyncUtil.QueueAsMacro error in WPS Office
- 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.

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.

Maybe WPS Spreadsheets is based on Excel 2007, because the value of "Microsoft.Office.Interop.Excel.Application.Version " is "12.0".
Contributor guide
Assessment
This issue has not been assessed yet.