Foswiki on GitHub is open for business! Next release meeting: Monday September 29, 1300Z

Item11239: LEFTSTRING inconsistently presented with leading spaces from cells

Priority: CurrentState: AppliesTo: Component: WaitingFor:
Normal Closed Engine SpreadSheetPlugin  
Irc discussion pointed out another example where spaces are not being properly stripped.
| 1 | 2 | 3 | 4 | 5 A | %CALC{"$LEFTSTRING($T(R$ROW():C5),1)"}% | 

Cell contents in Column 5 - "5 A" position 1 should be the number 5. However on 1.1.3, the 5 is in position 2. Leading and trailing spaces should be stripped

        Target Calculation
1 2 3 4 5 A 5
1 2 3 4 5 A 5
1 2 3 4 5 A 5
1 2 3 4 5 A 5

This is actually fixed by the changes made to fix Item11079, but the change is significant enough that the impact needs to be documented.

-- GeorgeClark - 05 Nov 2011

 

ItemTemplate edit

Summary LEFTSTRING inconsistently presented with leading spaces from cells
ReportedBy GeorgeClark
Codebase 1.1.3, 1.1.2, 1.1.1, 1.1.0, 1.0.10, trunk
SVN Range
AppliesTo Engine
Component SpreadSheetPlugin
Priority Normal
CurrentState Closed
WaitingFor
Checkins Foswikirev:13004 Foswikirev:13005
TargetRelease patch
ReleasedIn 1.1.4
trunkCheckins Foswikirev:13004
Release01x01Checkins Foswikirev:13005
Topic revision: r6 - 17 Dec 2011, GeorgeClark
 
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. see CopyrightStatement. Creative Commons License