KB1021

Unable to determine the compound range delimiter

Summary

When opening a plan file or report in the Axiom Software Desktop Client General term for using either the Excel Client or the Windows Client, both of which are installed to the user's desktop., you may encounter the following error: "We are unable to determine the compound range delimiter."

Details

The Axiom Software Desktop Client display formats (currency, dates, etc.) are determined by the regional format settings on your operating system. If you change a specific format to a setting that does not match the operating system's default setting, you may encounter errors. For example, for workstations in the United States, if you change the list separator format setting from comma (which is the default) to a pipe character, you will encounter the error below.

Example error when opening an Axiom plan file or report

Resolution

The following steps show how to restore the list separator format setting to comma on a Windows 10 workstation located in the United States.

  1. Click Start > Control Panel.

  2. Click Clock and Region.

  3. Click Region.

  4. On the Formats tab, click Additional Settings.

  5. Change the List separator setting to a comma and then click OK.

Outcome

With the list separator set to its default regional format setting, you will no longer encounter the error when opening an Axiom plan file or report.

See also

Article information

Category

Plan Files

Applies To

All versions

Tags

Error, Compound Range Delimiter, Formats, Locale

Issue Number(s)

N/A