From: <de...@de...> - 2011-09-08 00:44:01
|
Author: PeterThoeny Date: 2011-09-07 19:43:54 -0500 (Wed, 07 Sep 2011) New Revision: 22269 Trac url: http://develop.twiki.org/trac/changeset/22269 Modified: twiki/trunk/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt Log: Item6803: Updating docs with proper INT() behaviour, e.g. truncating towards zero, not rounding towards left (e.g. not like FLOOR) Modified: twiki/trunk/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt =================================================================== --- twiki/trunk/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt 2011-09-08 00:27:45 UTC (rev 22268) +++ twiki/trunk/SpreadSheetPlugin/data/TWiki/SpreadSheetPlugin.txt 2011-09-08 00:43:54 UTC (rev 22269) @@ -1,4 +1,4 @@ -%META:TOPICINFO{author="TWikiContributor" date="1315398413" format="1.1" version="$Rev$"}% +%META:TOPICINFO{author="TWikiContributor" date="1315399267" format="1.1" version="$Rev$"}% ---+!! TWiki Spreadsheet Plugin <!-- Contributions to this plugin are appreciated. Please update the plugin page at @@ -309,7 +309,7 @@ * Related: =[[#FuncFIND][$FIND()]]=, =[[#FuncLEFTSTRING][$LEFTSTRING()]]=, =[[#FuncREPLACE][$REPLACE()]]=, =[[#FuncRIGHTSTRING][$RIGHTSTRING()]]=, =[[#FuncSEARCH][$SEARCH()]]=, =[[#FuncSUBSTITUTE][$SUBSTITUTE()]]=, =[[#FuncSUBSTRING][$SUBSTRING()]]=, =[[#FuncTRANSLATE][$TRANSLATE()]]= #FuncINT ----+++ INT( formula ) -- evaluate formula and round down to nearest integer +---+++ INT( formula ) -- evaluate formula and return integer truncated towards 0 * Addition, substraction, multiplication, division and modulus of numbers are supported. Any nesting is permitted * Numbers may be decimal integers (=1234=), binary integers (=0b1110011=), octal integers (=01234=), hexadecimal integers (=0x1234=) or of exponential notation (=12.34e-56=) * If you expect a single decimal integer value with leading zeros, use ==$INT( $VALUE( number ) )== |