Difference: SpreadSheetPlugin (30 vs. 31)

Revision 312018-07-06 - TWikiContributor

Line: 1 to 1
 
    Page contents    
Line: 455 to 455
 

HASHREVERSE( name ) -- reverse a hash

  • All keys of a hash become values, and vice versa. Hash keys are always unique, e.g. multiple identical values will be reduced to one key. This function returns no output.
  • Syntax: $HASHREVERSE( name )
Changed:
<
<
  • Examples:
    %CALCULATE{$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 27)}%
    %CALCULATE{$HASHREVERSE(age)}% reverses the hash and returns nothing
    %CALCULATE{$HASH2LIST(age, $key: $value)}% returns 26: Jane, 27: Tim
>
>
  • Examples:
    %CALCULATE{$LIST2HASH(age, Jane, 26, Tim, 27, Sam, 28)}%
    %CALCULATE{$HASHREVERSE(age)}% reverses the hash and returns nothing
    %CALCULATE{$HASH2LIST(age, $key: $value)}% returns 26: Jane, 27: Tim, 28: Sam
 

Line: 578 to 578
 

LISTEACH( formula, list ) -- evaluate and update each element of a list

  • Specify a formula that should be applied to list element; $item indicates the element, $index the index of the list, starting at 1. If $item is omitted, the item is appended to the formula. This function returns no output.
  • Syntax: $LISTEACH( formula, list )
Added:
>
>
  • Deprecated syntax: $LISTMAP( formula, list )
 
Line: 766 to 767
 

PRODUCT( list ) -- product of a list or range of cells

  • Syntax: $PRODUCT( list )
Added:
>
>
  • Deprecated syntax: $MULT( list )
 
Line: 1259 to 1261
 
Plugin Author: TWiki:Main.PeterThoeny
Changed:
<
<
Copyright: © 2001-2015 Peter Thoeny, TWiki.org
© 2008-2015 TWiki:TWiki.TWikiContributor
© 2015 Wave Systems Corp.
>
>
Copyright: © 2001-2018 Peter Thoeny, TWiki.org
© 2008-2018 TWiki:TWiki.TWikiContributor
© 2015 Wave Systems Corp.
 
Sponsor: Wave Systems Corp. for hash functions
License: GPL (GNU General Public License)
Changed:
<
<
Plugin Version: 2015-06-07
>
>
Plugin Version: 2018-07-05
 
<--/twistyPlugin twikiMakeVisibleInline-->
Added:
>
>
2018-07-05: TWikibug:Item7841: Copyright update to 2018
2017-10-21: TWikibug:Item7826: Test case for HASHREVERSE now works with Perl's hash key randomization; TWikibug:Item7827: Workaround for SPLIT with unthreaded Perl
2017-10-19: TWikibug:Item7640: Fix bug for unit tests issue: DEC2HEX and DEC2BIN create longer strings with 64bit Perl
2016-07-05: TWikibug:Item7746: Fix bug LIST2HASH fails with empty list entries
2016-05-10: TWikibug:Item7703: Document deprecated LISTMAP() and MULT()
2016-01-08: TWikibug:Item7708: Copyright update to 2016
 
2015-06-07: TWikibug:Item7656: Rename COMMENT() to NOTE() - if someone uses COMMENT we can restore it as an undocumented function
2015-05-18: TWikibug:Item7656: Add COMMENT(), EQUAL()
2015-02-24: TWikibug:Item7617: Add range check in SUBSTRING()
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 1999-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback
Note: Please contribute updates to this topic on TWiki.org at TWiki:TWiki.SpreadSheetPlugin.