Issue 23446 - Allow Controlled Circular Reference
Summary: Allow Controlled Circular Reference
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-12-11 10:09 UTC by searob
Modified: 2013-07-30 02:17 UTC (History)
1 user (show)

See Also:
Issue Type: TASK
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description searob 2003-12-11 10:09:52 UTC
Circular references presently generate an error, but if properly allowed, it
could be useful for analyzing progression of values.

When a circular reference is detected, a dialog box should display alerting the
user.  It will default to the button "Error: Correct Formula" in which the user
can edit one of the cell references.  Below the separator in the dialog box,
there will be a form for making a controlled circular reference which will have
defaults assigned.  This form will have a vertical scroll bar for allowing a
large list of initial cell values and storage references.

List of control settings:
- Text box that accepts positive integers only; for milliseconds; defaults to
1000.  Labeled "Interval Time".
- Text box that accepts positive integers only; for the number of times the user
wants the circular reference to loop; defaults to 1000.  Labeled "Maximum Count".
- Select list in which the user selects which cell performs the initial
calculation.  Defaults to the last cell selected which initiated the circular
reference dialog box.  Labeled "Cell to Initiate Calculations".
- List of text boxes or cells to provide optional initial values for each cell
involved in the circular reference.  Defaults to no characters (passed on string
will be "", integer will be 0).  User may enter values or references to other
cells (no circular references here).  Listing header label will be "Initial
Values".  Each text box will be labeled with the cell row and column and name
(if named).
- Another column next ot the "Initial Values" column will be a text box or cell
to provide optional references to column locations on where to store the value
in each interval.  Everytime a cell is updated with a new value in each
interval, the storage column will have a new corresponding value added to its
list in the next row down.  The reference location will be the initial cell
where a value should be placed for that column which will start off with the
intitial value.  Listing header label will be "Interval Value Storage Reference".
Comment 1 ace_dent 2008-05-16 02:57:00 UTC Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 2 Rob Weir 2013-07-30 02:17:38 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.