Receiving #NAME? on seemingly correct formula

[mjf-acqyrexchange]

I have a cell with the following formula

=DATEVALUE(LEFT(D2,10))+TIMEVALUE(MID(D2,12,8))

D2 contains 2022-04-21T00:58:37.875Z The viewer renders it with the #NAME? error. These work in Excel.

Another cell contains =NOW()-F2 and also gets the #NAME? error.

Is there a list of allowed functions?

[jjuback]

Here is the list of supported functions:

https://www.grapecity.com/wijmo/docs/Topics/Grid/FlexSheet/FlexSheet-Fomulas

DATEVALUE./TIMEVALUE are not supported. NOW is supported by itself, but not in an expression as in your example. I'll open a support issue for the underlying control.

[mjf-acqyrexchange]

Thanks. I guess I didn't poke around enough to find this.