Item11523: $comma token not used in SUBSTITUTE and other Spreadsheet macros

Priority: Normal
Current State: Closed
Released In: 1.1.5
Target Release: patch
Applies To: Extension
Component: SpreadSheetPlugin
Branches: Release01x01 trunk
Reported By: GeorgeClark
Waiting For:
Last Change By: GeorgeClark
SUBSTITUTE macro should substitute $comma in the from and to strings, since comma is the input delimiter.

It probably ought to use the standard FormatTokens just for consistency (probably not!) in SUBSTITUTE and in the other places $comma is supported, TRANSLATE, SPLIT, and LISTJOIN.

REPLACE probably has the same issue.

-- GeorgeClark - 15 Feb 2012

Topic revision: r8 - 11 Apr 2012, GeorgeClark - This page was cached on 27 Nov 2015 - 19:01. Get a fresh version here.
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License