Re: Editor / Renderer: data flow

zero wrote:
Register a TableModelListener on the TableModel, and if a tableChanged
event is raised, check if any formulas depend on the changed cell(s), and
update as needed. Checking which, if any, formulas depend on the changed
cell(s) can probably be optimised by subclassing TableModelListener, or
maybe a separate class can keep track of this info, depending on what best
fits your design.

But in this case I have to save all the information about any formula
on the model, right?
When an event tell me a cell is changed how can I find wich formula
need to be updated?
In my solution every cell involved in a formula have a Vector of
listeners (cells containing formula that require the current cell) to
inform. When a cell is updated, a message is send to all formulas to be
updated.

Is there an open source java grid to study?

Thanks.
DM

.

Relevant Pages

  • Re: Using COUNTIF to search for existence
    ... Blank Zero TRUE 3 ... In cell D1 I have the formula =COUNTIFcopied down ... Countif, however, correctly counts that there are 3 Zeros in the range, ... You get a FALSE because there is no duplicate. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Using COUNTIF to search for existence
    ... Then Sandy's test reveals that blank and null string have another story between the two of them not having zero as part of the picture this time. ... You get a FALSE because there is no duplicate. ... So you can see that the count for a totally Blank cell is the same as ... COUNTIF works on a single range. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Data validation when pasting data
    ... cell and then manually typed a value into the cell below. ... If Application.CutCopyMode = xlCopy Then ... I need to assign data validation to a single column in a worksheet to ensure ... that users can only enter 11 digits but the first one must be a zero. ...
    (microsoft.public.excel.programming)
  • Re: change cell colour when cell data changes
    ... what should happen if user changes the ... Should color be yellow in order to satisfy the 1st condition ("anything from ... blank or zero to 1.0 cell colour is yellow") ... work out how to do is to change the cell from the original colour to a new ...
    (microsoft.public.excel.misc)
  • Re: How to create a formula that results in a blank cell if required
    ... I know that because an ISBLANK test on this cell comes up as ... the graph plots this point as a zero even if I have the ... "Plot empty cells as - not plotted" option turned on. ... (which are used in the calculation) ...
    (microsoft.public.excel)