Project

General

Profile

Feature #5223

SPREADSHEET: Implement formula circular references

Added by Hynek Cihlar over 3 years ago. Updated almost 3 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:

0%

billable:
No
vendor_id:
GCD
version_reported:
version_resolved:

History

#1 Updated by Hynek Cihlar over 3 years ago

  • Tracker changed from Bug to Feature

#2 Updated by Hynek Cihlar over 3 years ago

SPREADSHEET widget currently doesn't support circular references in formulas. The reason for this is that Keikai backend doesn't support circular references. Keikai team currently evaluates implementing this feature.

Once Keikai supports this, the widget method SetIteration must be added according to F1's OCX API.

#4 Updated by Hynek Cihlar almost 3 years ago

Keikai dev team released a test release with the added support of circular references and its parametrization through the Keikai API. The version is 5.9.0.FL.20210907-Eval. I added the required Spreadsheet widget method setIteration and implemented it based on this Keikai version and it seems to work OK. Once Keikai dev team releases the final relase I will check in my changes and close this issue.

Also see the related ticket https://potix.freshdesk.com/support/tickets/12856.

Also available in: Atom PDF