search

jjuback / gc-excelviewer

Visual Studio Code extension for viewing Excel spreadsheets and CSV files.
Other
216 stars 38 forks source link

Receiving #NAME? on seemingly correct formula #197

Open mjf-acqyrexchange opened 2 years ago

mjf-acqyrexchange commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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