Foswiki on GitHub is open for business! Next release meeting: Monday October 13, 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 distro:32be9015677c distro:a6e9eb2ee67c
TargetRelease patch
ReleasedIn 1.1.4
trunkCheckins distro:32be9015677c
Release01x01Checkins distro:a6e9eb2ee67c
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