You are here: Foswiki>Tasks Web>Item11049 (04 Jan 2015, GeorgeClark)Edit Attach

Item11049: Specify table to be used in Spreadsheet CALC

Priority: Enhancement
Current State: Proposal Required
Released In: n/a
Target Release: n/a
Applies To: Extension
Component: SpreadSheetPlugin
Reported By: VickiBrown
Waiting For:
Last Change By: GeorgeClark
The current rules for SpreadSheet plugin state
  • Formulae can only reference cells in the current or preceding row of the current table; they may not reference cells below the current table row
  • Formulae can also be placed outside of tables; they can reference cells in the preceding table

It would be very useful if SpreadSheet plugin could reference a specific table.

As a suggestion, Spreadsheet use a table parameter in the way that Extensions/ChartPlugin does. Or it could use a name parameter in the same way.

From Extensions/ChartPlugin:

table     Foswiki table used to build the chart. A numerical value refers to the table number, where "1" is the first table seen in a topic. Any other non-numeric string refers to a named table defined by the TABLE variable with a name parameter. For example, table="trends" refers to the table that is preceded by %TABLE{ name="trends" }%. 

Given that this code is already present in ChartPlugin, copying it to SpreadSheet might be relatively simple (and we'd have some consistency of usage).

I frequently want to refer to cells of table A from within table B (e.g. combining cells from two tables into a third table.) The only way to do this now is to manually SET and GET a lot of variables.

-- VickiBrown - 17 Aug 2011

Marking this proposal required. ChartPlugin is not a core extension, and we need some design review before adding a table reference.

-- GeorgeClark - 04 Jan 2015

ItemTemplate edit

Summary Specify table to be used in Spreadsheet CALC
ReportedBy VickiBrown
SVN Range
AppliesTo Extension
Component SpreadSheetPlugin
Priority Enhancement
CurrentState Proposal Required
TargetRelease n/a
ReleasedIn n/a
Topic revision: r3 - 04 Jan 2015, GeorgeClark
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy