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