Item1726: CALC in EditTablePlugin causes errors during editing

Priority: Normal
Current State: Closed
Released In: 1.0.6
Target Release: patch
Applies To: Extension
Component: EditTablePlugin
Reported By: KennethLavrsen
Waiting For:
Last Change By: KennethLavrsen
Two old problems with CALC (SpreadSheetPlugin) in labels in EditTablePlugin are

  • The CALCs are long and goof up the table with enormous field widths.
  • During editing the CALC result causes an error (SpreadSheetPlugin is not robust against invalid or missing indata)

I have tried many things and the far best I have tried is to simply replace the entire CALC Macro by the static text CALC during editing.

These 4 letters take little space, and they make sense to the user that can guess that this is the CALC macro not being able to return anything during editing.

I will check in this now. Maybe someone can come up with a nice graphic or similar but until then this will do well.

We could also have returned a simple 0. But then - CALC does not always return a number. It can also be a string. So I prefer the CALC word or a small graphic.

The idea we once has with an non-editable text field was also tested and it was more confusing to the users I tested it on. They would try and alter the text and got confused instead. That proposal (my own) was not as good a solution as I first throught. I have used this CALC thing in a locally hacked ETP and it has been simple and successful.

-- KennethLavrsen - 15 Jun 2009

I have 3 additions:
  1. Make it work in headers and footers
  2. Make it work with multiple CALCs on 1 line
  3. Make it possible to style with CSS

-- ArthurClemens - 15 Jun 2009

ItemTemplate edit

Summary CALC in EditTablePlugin causes errors during editing
ReportedBy KennethLavrsen
Codebase 1.0.5
SVN Range Foswiki-1.0.0, Thu, 08 Jan 2009, build 1878
AppliesTo Extension
Component EditTablePlugin
Priority Normal
CurrentState Closed
Checkins distro:a3b1344464cc distro:b297f06766a6 distro:8d088e8fb930
TargetRelease patch
ReleasedIn 1.0.6
Topic revision: r10 - 22 Jun 2009, KennethLavrsen
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