Ctrlk
About CoherentAPI referenceSupportYouTube
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Circular references (Xcircular_switch)

Syntax: Xcircular_switch

Calculate circular references in your Spark service.

  1. Anywhere in your workbook, select a blank cell.

  2. Enter TRUE into the cell.

  3. Give it the name Xcircular_switch.

  4. Find your circular reference.

  5. Select any cell within the circular reference loop.

  6. Update your formula to only run the function when Xcircular_switch=TRUE.

  7. Check your iterative settings in Excel from File, Options, Formulas.

  8. Check Enable iterative calculation to enable circular references in Excel. By default, Excel will set Maximum Iterations to 100, and Maximum Change to 0.001.

  9. Upload the file to Spark. The Upload log will include a similar entry: INFO: Cell Sheet1!B2: INFO: Circular references detected in workbook. Spark will process the circular references with the following settings: max iterations 100, max change 0.001.

Spark will match the Maximum Iterations up to 250. If Enable iterative calculation is not enabled in the file, Spark will default Maximum Iterations to 100 and Maximum Change to 0.001 in the Spark service.

Sample file

This service can be uploaded to Spark to use as a simple example.

Circular reference example.xlsx
17KB
Open

Last updated