• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use View topic Item7848 for generic doc work for TWiki-6.1.1. Use View topic Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
Does this site look broken?. Use the LitterTray web for test cases.

Item6804: New functions FLOOR() and CEILING()

Item Form Data

AppliesTo: Component: Priority: CurrentState: WaitingFor: TargetRelease ReleasedIn
Extension SpreadSheetPlugin Enhancement Closed   patch 5.1.1

Edit Form Data

Summary:
Reported By:
Codebase:
Applies To:
Component:
Priority:
Current State:
Waiting For:
Target Release:
Released In:
 

Detail

Feature suggested in Item6803.

-- TWiki:Main/PeterThoeny - 2011-09-06

This is now in SVN trunk and 5.1 branch.

Test cases:

  • $INT(321.4) : |321|
  • $FLOOR(321.4) : |321|
  • $CEILING(321.4) : |322|
  • $ROUND(321.4) : |321|

  • $INT(1.4) : |1|
  • $FLOOR(1.4) : |1|
  • $CEILING(1.4) : |2|
  • $ROUND(1.4) : |1|

  • $INT(1.0) : |1|
  • $FLOOR(1.0) : |1|
  • $CEILING(1.0) : |1|
  • $ROUND(1.0) : |1|

  • $INT(0.51) : |0|
  • $FLOOR(0.51) : |0|
  • $CEILING(0.51) : |1|
  • $ROUND(0.51) : |1|

  • $INT(0.5) : |0|
  • $FLOOR(0.5) : |0|
  • $CEILING(0.5) : |1|
  • $ROUND(0.5) : |1|

  • $INT(0.49) : |0|
  • $FLOOR(0.49) : |0|
  • $CEILING(0.49) : |1|
  • $ROUND(0.49) : |0|

  • $INT(0) : |0|
  • $FLOOR(0) : |0|
  • $CEILING(0) : |0|
  • $ROUND(0) : |0|

  • $INT(-0.49) : |0|
  • $FLOOR(-0.49) : |-1|
  • $CEILING(-0.49) : |0|
  • $ROUND(-0.49) : |0|

  • $INT(-0.5) : |0|
  • $FLOOR(-0.5) : |-1|
  • $CEILING(-0.5) : |0|
  • $ROUND(-0.5) : |-1|

  • $INT(-0.51) : |0|
  • $FLOOR(-0.51) : |-1|
  • $CEILING(-0.51) : |0|
  • $ROUND(-0.51) : |-1|

  • $INT(-1.0) : |-1|
  • $FLOOR(-1.0) : |-1|
  • $CEILING(-1.0) : |-1|
  • $ROUND(-1.0) : |-1|

  • $INT(-1.4) : |-1|
  • $FLOOR(-1.4) : |-2|
  • $CEILING(-1.4) : |-1|
  • $ROUND(-1.4) : |-1|

  • $INT(-321.4) : |-321|
  • $FLOOR(-321.4) : |-322|
  • $CEILING(-321.4) : |-321|
  • $ROUND(-321.4) : |-321|
-- TWiki:Main.PeterThoeny - 2012-01-14

ItemTemplate
Summary New functions FLOOR() and CEILING()
ReportedBy TWiki:Main.PeterThoeny
Codebase ~twiki4, 5.1.0
SVN Range TWiki-5.1.0, Sat, 20 Aug 2011, build 22128
AppliesTo Extension
Component SpreadSheetPlugin
Priority Enhancement
CurrentState Closed
WaitingFor

Checkins TWikirev:22549 TWikirev:22550 TWikirev:22551 TWikirev:22552
TargetRelease patch
ReleasedIn 5.1.1
Edit | Attach | Watch | Print version | History: r7 < r6 < r5 < r4 < r3 | Backlinks | Raw View |  Raw edit | More topic actions
Topic revision: r7 - 2012-01-16 - GeorgeTrubisky
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback