Unplanned
Last Updated: 25 Sep 2017 14:04 by ADMIN
ADMIN
Tanya
Created on: 29 Jul 2015 15:04
Category: SpreadProcessing
Type: Feature Request
1
SpreadProcessing: Introduce support for functions with '_xlfn.' prefix (future functions)
Some functions are exported from Excel with the _xlfn. prefix as compatibility measure with older versions of MS Excel (future functions, see here https://msdn.microsoft.com/en-us/library/dd907480(v=office.12).aspx , https://support.office.com/en-ca/article/Issue-An-xlfn-prefix-is-displayed-in-front-of-a-formula-882f1ef7-68fb-4fcd-8d54-9fbb77fd5025 )

RadSpreadProcessing do not support these and the spreadsheet treats the function as not supported even when it is.

Example:

    <row r="1" spans="2:2" x14ac:dyDescent="0.25">
      <c r="B1" t="b">
        <f>_xlfn.ISFORMULA(C2)</f>
        <v>0</v>
      </c>
    </row>


This could be observed with the ISFORMULA function.
0 comments