--
PeterThoeny - 2012-06-24
Salut guys. In trying to do this:
%CALC{$EVAL(13 - $FORMATTIME($TIME(), $month))}%
I found that this breaks:
%CALC{$EVAL(13 - 08)}%
5
While this works:
%CALC{$EVAL(13 - 07)}%
6
--
AaronLWalker - 2010-08-03
Ah, Perl eval side-effect. Perl treats numbers with leading zeros as octal numbers. The user input needs to be sanitized to remove leading zeros. Tracked in
TWikibug:Item6537.
--
PeterThoeny - 2010-08-04
This is now fixed. Please download the latest
SpreadSheetPlugin.
--
PeterThoeny - 2010-08-05
The CALC currently uses the
commonTagsHandler
. This is needed because registered tags cannot access topic content surrounding the CALC as required for spreadsheet calculations in tables. As a disadvantage, the CALC variable is evaluated after other variables, e.g. not inside-out & left-to-right like other variables that use the register tag handler. How about adding a new CALCULATE variable that is evaluated inside-out & left-to-right like other variables? Tracked at
TWikibug:Item6866 - feedback appreciated.
--
PeterThoeny - 2012-04-05
I enhanced the plugin with compatibility in mind. In addition to the
handleCommonTags
based CALC, I added a
registerTagHandler
based CALCULATE. As indicated before, CALCULATE does not support functions specific to tables. Once TWiki's API is enhanced to pass long content surrounding the CALCULATE variable we can support table specific functions as well.
--
PeterThoeny - 2012-04-05
The recent additional of variables ($FILTER, $ISDIGIT, etc) seems not included when upgrading from my configure ?
--
MichaelSevero - 2012-09-08
I unpacked and I checked the attached zip file, everything looks OK with the latest release. I am puzzled why you don't see the latest 2012-06-30 release in configure.
--
PeterThoeny - 2012-09-08
HI! I went and re-upgrade the plugin again in the configure and still no positive result. In my configure it says:
Most recent version |
installed version |
2012-06-30 |
22788 </br>(2012-04-05) |
It seems I'm not getting the new version for this plugin. It works for other plugin (Backuprestore, etc) but not the spreadsheet.
--
MichaelSevero - 2012-09-08
Yes, the latest version is 2012-06-30. Check the permissions of the plugin files & dirs in
lib/TWiki/Plugins
and
data/TWiki
. They need to be owned by the webserver user if you use configure to install plugins.
Please open a
Support question if you need further help.
--
PeterThoeny - 2012-09-08
I find the recently added hash functions
$GETHASH()
,
$HASH2LIST()
,
$HASHCOPY()
,
$HASHEACH()
,
$HASHEXISTS()
,
$HASHREVERSE()
,
$LIST2HASH()
,
$SETHASH()
are quite useful for advanced TWiki apps. For example I use it to pivot tables, then create a chart from the pivoted table. Specific example: Create monthly resource allocation tables, rows are people, columns are projects. Pivot those tables into a summary table that shows resource allocation in percent, rows are month, columns are projects. The
ChartPlugin shows bar charts where you can see resource allocation trends over time.
Hash variables are explained at
SpreadSheetPlugin.
--
Peter Thoeny - 2013-05-22
New
SpreadSheetPlugin version posted with new functions
ADDLIST()
,
GETLIST()
,
SETLIST()
. Enjoy!
--
Peter Thoeny - 2014-01-23