Reply To: Excel formulas

[Bernhard Kantz]

Please let us know how you import the Excel file. Do you import it using ODBC or do you use the ‘Import Excel’ command?
What do you understand under “correct”? Do you get formula texts or wrong values?

If you are using the ‘Import Excel’ command (available only if Excel is present on your system) Excel itself is started embedded in FlexPro. It should be able to resolve all links to other sheets as in stand-alone mode.

Normally FlexPro should be able – depending on the type of import you are using (see above) – to figure out the datatype in a correct manner. We could imagine that the decimal point in FlexPro and Excel are different which could lead to the described behaviour. Please check the decimal point settings under Tools/Options/Country Settings to match those of Excel (or your system).

If you think FlexPro behaves not correct please send us a test case to support@weisang.com. Include the following information:
[list]

Excel file (including references) you want to import

exact FlexPro version number (7.0.NN)

your version of Excel (including service pack information)

your Windows version and locale information

what do you expect to happen

an exact description of what you are doing
[/list]
Support
support@weisang.com