We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Cell.FormulaR1C1Local and Cell.NumberFormatLocal?

The MS Excel API refers to two different formula values:

* FormulaR1C1 - Returns or sets the formula for the object, using R1C1-style notation in the language of the macro.
* FormulaR1C1Local - Returns or sets the formula for the object, using R1C1-style notation in the language of the user.

What is the behavior of the Apose version of this property?

Also, is there a Cell.NumberFormatLocal?

Thanks,

Jeff

Hi,

Well, the R1C1 style is only for MS Excel and we do not support it. If you want to get R1C1 Formula, please use Cell.R1C1Formula attribute. For NumberFormatLocal, please use Style.CultureCustom attribute.

Thank you.