• 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.

Item7418: VALUE function bug with incorrect exponential number; ability to delete SET variable

Item Form Data

AppliesTo: Component: Priority: CurrentState: WaitingFor: TargetRelease ReleasedIn
Extension SpreadSheetPlugin Normal Closed   patch 6.0.1

Edit Form Data

Reported By:
Applies To:
Current State:
Waiting For:
Target Release:
Released In:


  • $VALUE() bug:
    • If a value passed to $VALUE() contains a pattern that looks almost like an exponential number, value 0 is returned.
    • Example: $VALUE(AAA123eZZZ) returns 0, expected return 123

  • $SET() fix:
    • Variable is deleted if value is not defined, e.g. no comma after variable name.
    • Possible to set to empty value, such as $SET(foo,)

  • $SETIFEMPTY() fix:
    • No longer strip trailing spaces from value

-- TWiki:Main/PeterThoeny - 2014-01-22

This is now fixed in SVN trunk and 6.0 branch. New plugin released on TWiki.org.

-- TWiki:Main.PeterThoeny - 2014-01-23

Summary VALUE function bug with incorrect exponential number; ability to delete SET variable
ReportedBy TWiki:Main.PeterThoeny
Codebase ~twiki4, 6.0.0
SVN Range TWiki-6.0.1-trunk, Thu, 09 Jan 2014, build 26720
AppliesTo Extension
Component SpreadSheetPlugin
Priority Normal
CurrentState Closed

Checkins TWikirev:26936 TWikirev:26937 TWikirev:26938 TWikirev:26939 TWikirev:26940 TWikirev:26941 TWikirev:26942
TargetRelease patch
ReleasedIn 6.0.1
Edit | Attach | Watch | Print version | History: r10 < r9 < r8 < r7 < r6 | Backlinks | Raw View |  Raw edit | More topic actions
Topic revision: r10 - 2014-10-06 - PeterThoeny
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