Question

SpreadSheetPlugin currently does not recognize time values (eg 10:43) for minutes in a table and thus cannot max/min/sum/average such values properly.

Is there any work underway to allow SpreadSheetPlugin (and maybe ShartPlugin if necessary) to understand such values? It may be necessary to either denote a header row/column to state the data type in that row/column (can rows/columns be hidden?) or maybe a number of conversion routines which can be added to %CALC functions to make the conversions...

thx

• TWiki version:
• Perl version:
• Web server & version:
• Server OS:
• Web browser & version:
• Client OS:

-- MathiasKoerber - 09 Jan 2003

Answer

Correct, the current plugin does not understand times. Could be added by anyone, it's open source

FYI, the TablePlugin does some simple homegrown time conversions, the ActionTrackerPlugin does time parsing based on the Time::ParseDate module.

-- PeterThoeny - 14 Jan 2003