Item11239: LEFTSTRING inconsistently presented with leading spaces from cells

Priority: Normal
Current State: Closed
Released In: 1.1.4
Target Release: patch
Applies To: Engine
Component: SpreadSheetPlugin
Branches:
Reported By: GeorgeClark
Waiting For:
Last Change By: GeorgeClark
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