You are here: Foswiki>Tasks Web>Item10540 (25 Mar 2011, WillNorris)Edit Attach

Item10540: LIST() does not flatten a list in a cell

Priority: Normal
Current State: No Action Required
Released In: n/a
Target Release: patch

Applies To: Extension
Component: SpreadSheetPlugin
Branches:

Reported By: WillNorris
Waiting For: Main.WillNorris
Last Change By: WillNorris

http://develop.twiki.org/~twiki4/cgi-bin/view/Bugs/Item6668

SpreadSheetPlugin#FuncLIST documents this: "Convert the content of a range of cells into a flat list, delimited by comma. Cells containing commas are merged into the list."

The actual implementation does not merge a comma-space delimited list in a cell, it is taken it verbatim. In most cases it does not matter unless the array size is used.

Test case:

A:	B:	C:	D:	E:	$LISTSIZE($LIST($LEFT())):	Expected:
a	b	c	d	e	5	5
a	b	c	d, e, f	g	7	7

-- TWiki:Main/PeterThoeny - 2011-03-25

nevermind, we already have these fixes ages ago. i think the other project grabbed our fixes (which is ok, of course...)

-- WillNorris - 25 Mar 2011

ItemTemplate edit

Summary	LIST() does not flatten a list in a cell
ReportedBy	WillNorris
Codebase
SVN Range
AppliesTo	Extension
Component	SpreadSheetPlugin
Priority	Normal
CurrentState	No Action Required
WaitingFor	WillNorris
Checkins
TargetRelease	patch
ReleasedIn	n/a