math1Add my vote for this tag spreadsheet1Add my vote for this tag create new tag
, view all tags

SpreadSheetPluginDev Discussion: Page for developer collaboration, enhancement requests, patches and improved versions on SpreadSheetPlugin contributed by the TWikiCommunity.
• Please let us know what you think of this extension.
• For support, check the existing questions, or ask a new support question in the Support web!
• Please file bug reports in the SpreadSheetPlugin bug database.
• See SpreadSheetPluginDevArchive for older discussions.

Feedback on SpreadSheetPlugin

-- 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)}%

While this works:

%CALC{$EVAL(13 - 07)}%

-- 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#HashVariables.

-- Peter Thoeny - 2013-05-22

New SpreadSheetPlugin version posted with new functions ADDLIST(), GETLIST(), SETLIST() . Enjoy!

-- Peter Thoeny - 2014-01-23

Edit | Attach | Watch | Print version | History: r314 < r313 < r312 < r311 < r310 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r314 - 2014-01-23 - PeterThoeny
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2018 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.