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

Free Support Forum - aspose.com

Resolve hardcoded enumerations in UDF

dear aspose.cells

I have an Excel with formula’s that contains fixed values seys, using the {…} statement ( cfr screenshot )
when opening with aspose.cells, it gives me the formula as a string

=MWORKS_CURRENT({"“TAGr2"”,"“TAGr1"”},1)
Now the statement within {…} depends on the local settings.

Does Aspose.cells provide a way to resolve this Excel specific list inside the {…} into a string array, or another mechanism to resolve this ?

kind regards

guido

ScreenHunter_1057 Apr. 08 17.59.jpg (63.6 KB)

@GuidoDeBouver,

Thanks for the screenshot and details.

We are not entirely certain about your issue. But Aspose.Cells should/will give you same formula string as shown in MS Excel (when you manually open the file into MS Excel). If you find anything different, kindly provide us your sample file and paste your sample code to show the issue, we will check it soon.