CALC Spreadsheet


Definition lists:


bla fasel


Overwriting Variable definitions ??

Not the way one might think: The last definiton made overwrites all the others!

  • Set TESTVAR = 1
    • TESTVAR = 3
  • Set TESTVAR = 2
    • TESTVAR = 3
  • Set TESTVAR = 3
    • TESTVAR = 3

INCLUDE VARIABLES from other files (1)

What happens when including it? See IncludePlaygroundPeterZumbruch

INCLUDE VARIABLES from other files (2)

Trying to include PlaygroundIncludePeterZumbruch, where MY_PRIVATE_VARIABLE is defined.

  • Set MY_PRIVATE_VARIABLE = Tach auch

Three Variables are defined


  • Set MY_PRIVATE_VARIABLE = Nobody there ?
    • MY_PRIVATE_VARIABLE = Tach auch
  • Set MY_PRIVATE_VARIABLE = Hello everybody
    • MY_PRIVATE_VARIABLE = Tach auch


  • Set PRIVATE_VARIABLE = Nobody there ?
  • Set PRIVATE_VARIABLE = Hello everybody


  • Set TEST_VAR = a1a a1a
  • Set TEST_VAR = b2b b2b
  • Set TEST_VAR = c3c c3c

Rèsumè: INCLUDE VARIABLES from other files

It seems when that the last variable definition/processing takes place in the including topic.

  • already defined variables cannot be changed by includes
  • what about undefined variables?
    • currently it seems as they are also not available probalby considered as defined, but undefined in the including topic
      • is this a feature or can it be changed?

Including an attached Makefile (plus Beautifier?)

This site does not allow %INCLUDE% of URLs
<div style="background-color:#ffffcc">


Including with predefined Variables

Set var1 = bla bla %TOPIC%: Set var2 = bla bla %INCLUDETOPIC%:
  • Set var2 = bla bla %INCLUDETOPIC%

Now, including PlaygroundIncludePredefinedPreferencesPeterZumbruch :

Using the spreadsheet plugin:

Set var1s = bla bla %CALC{" %TOPIC%"}%: Set var2s = bla bla %CALC{" %INCLUDETOPIC%"}%:
  • Set var2s = bla bla %INCLUDETOPIC%

Now, including PlaygroundIncludePredefinedPreferencesSpreadsheetPeterZumbruch :

Eternal Link / Permanent Link à la Wikipedia


Including table part into existing table ??




Edit Table Plugin

This plugin allows you to edit TWiki tables using edit fields and drop down boxes. Tables have an [ Edit table ] button if preceeded by an %EDITTABLE{...}% variable. Each column can be a text field, a drop down box, a date field, etc. Multiple tables per topic are editable, but only one at a time can be edited.

Per Table Settings

Add a %EDITTABLE{...}% variable just before an existing table to make it editable, or add the variable anywhere in a topic to start a new table. Parameters:

Parameter Comment Default
header Specify the header format of a new table like "|*Food*|*Drink*|". Useful to start a table with only a button (no header)
format The format of one column when editing the table. A cell can be a text input field, or any of these edit field types:
- Text input field (1 line):
  | text, <size>, <initial value> |
- Textarea input field:
  | textarea, <rows>x<columns>, <initial value> |
- Drop down box:
  | select, <size>, <option 1>, <option 2>, etc |
- Fixed label:
  | label, 0, <label text> |
- Row number:
  | row, <offset> |
- Date:
  | date, <size>, <initial value>, <DHTML date format> |
"text, 16"
for all cells
changerows Rows can be added and removed if "on";
Rows can be added but not removed if "add"
Plugin setting
quietsave Quiet Save button is shown if "on", hidden if "off" QUIETSAVE
Plugin setting
include Other topic defining the EDITTABLE parameters. The first %EDITTABLE% in the topic is used. This is useful if you have many topics with the same table format and you want to update the format in one place. (none)
helptopic Topic name containing help text shown below the table when editing a table. The %STARTINCLUDE% and %STOPINCLUDE% variables can be used in the topic to specify what is shown. (no help text)
headerislabel Table header cells are read-only (labels) if "on"; header cells can be edited if "off" or "0" "on"
editbutton Set edit button text, e.g. "Edit this table"; set button image with alt text, e.g. "Edit table, %PUBURL%/%SYSTEMWEB%/DocumentGraphics/edittopic.gif"; hide edit button at the end of the table with "hide" (Note: Button is automatically hidden if an edit button is present in a cell) EDITBUTTON
Plugin setting

Initial Values

By default, variables in <initial value> (of text input field) and <label text> (of fixed label) get expanded when a new row is added. This can be used for example to add a timestamp to a label. You can escape characters if you do not want that:
Text: To Escape:
$quot Double quote ("). Alternatively write \" to escape it
$percnt Percent sign (%)
$dollar Dollar sign ($)
$nop or $nop() Is a "no operation"

Date Field Type

Edit Table Calendar Example The date field type allows one to choose a date with a popup calendar. Popup calendar works for Netscape 6.0 or better, all other Gecko-based browsers, Internet Explorer 5.0 or better for Windows, Opera 7 and Konqueror 3.1.2. The ... button is inactive if the browser cannot support the popup calendar. It uses the nice Mishoo DHTML calendar, see also TWiki:Codev/JavaScriptDatePickerForForm

Table Playground

Projekt Gruppe Wer? für wen? / FAIR? Prior Kurzinfo und Status Meilensteine,
erwartetes Projektende
letzter Bericht n. Meeting, DatumSorted ascending
EPICS Control for HADES-RPC (TRBv2 and HADControl)
KS-SW PZ GSI/HADES/FAIR 3 Unterstützung beim Aufbau der RPC Threshold Settings / Temperature Montoring / Low Voltage Control
~7.000 Kanäle basiert auf EPICS embedded - ETRAX; Reaktivierung des Projekts um Performance/Memory/Manpower zu optimieren
Status: Projekt Version „1.0” (SPI interface, EPICS database und GUI) an Kunde
weitere Meilensteine:
1. neue Version der API implementieren
2. Redesign der EPICS database (sequencer) mit Ziel Performance opitimieren
3. kleinere TODOs
4. Kundentest
weitere Projektdauer: ~2 Monate
26-May-08 29-Sep-08
EPICS based temperature readout of HADControl, version 2
KS-SW PZ GSI/HADES/FAIR 2 Bisherige DIM-EPICS Lösung ersetzen durch reinen EPICS Ansatz (s.a. HADES Mdc Gas Monitor) basiert auf EPICS embedded - ETRAX, das Projekt wird im Januar 2008 angegangen;
Status: Design
1. Designüberlegung: (asyn, sync/async) stream device, genSub
2. Design
3. device support module
4. IOC
Projektdauer: ~6 Monate
26-May-08 29-Sep-08

-- PeterZumbruch - 15 Sep 2008

Include HTM ?








Redmine is a flexible project management web application. Written using the Ruby on Rails framework, it is cross-platform and cross-database.

Redmine is open source and released under the terms of the GNU General Public License v2 (GPL).


Some of the main features of Redmine are:

  • Multiple projects support
  • Flexible role based access control
  • Flexible issue tracking system
  • Gantt chart and calendar
  • News, documents & files management
  • Feeds & email notifications
  • Per project wiki
  • Per project forums
  • Time tracking
  • Custom fields for issues, time-entries, projects and users
  • SCM integration (SVN, CVS, Git, Mercurial, Bazaar and Darcs)
  • Issue creation via email
  • Multiple LDAP authentication support
  • User self-registration support
  • Multilanguage support
  • Multiple databases support

Read more about Redmine features.


You can read the Redmine guide.

Other resources:

Online demo

A shared online demo can be found at It's been setup to give registered users the ability to create their own projects. This means once you register, you can create your own project on there and try out the project administration features.

Alternatively, you can get your own Redmine demo environment at with full administrator privileges after filling a simple form.

Support & getting help

For getting help or discussing about Redmine, you can browse the Redmine forums hosted right here in Redmine. We also have a fairly active chatroom - join #redmine on the freenode IRC network. Some more information about IRC is here

Before submitting a bug report, a patch or a feature request here, please read the Submission guidelines.

Contributing and helping out

Redmine is built and maintained by community volunteers. If you enjoy using it and would like to give back to the community, the Contribute page has several ideas. Software development experience is not required. Check out the Teams Page if you are interested in a specific area to contribute regularly.

You can also make a donation and get listed on the Redmine Donors page.

Who uses Redmine?

This page lists some companies and projects using Redmine.

Redmine books

Mastering Redmine is a comprehensive guide with tips, tricks and best practices for using Redmine.
You can buy it online.
Redmine Plugin Extension and Development provides an overview of the tools available to developers who want to extend Redmine to work their way.
You can buy it online.
Redmine Cookbook: over 80 hands-on recipes to improve your skills in project management, team management, process improvement, and Redmine administration.
You can buy it online.

-- PeterZumbruch - 30 May 2016
Topic attachments
I Attachment Action Size Date Who Comment
CONFIG_USER.linux-x86linux-x86 CONFIG_USER.linux-x86 manage 0.1 K 2007-08-20 - 11:20 PeterZumbruch Makefile
Overview_-_Redmine.htmhtm Overview_-_Redmine.htm manage 11.7 K 2016-05-30 - 13:03 PeterZumbruch test.htm datei zum lokalen einbinden
Topic revision: r14 - 2016-05-30, PeterZumbruch
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding GSI Wiki? Send feedback
Imprint (in German)
Privacy Policy (in German)