• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use

Item7848 for generic doc work for TWiki-6.1.1. Use

Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
• Does this site look broken?. Use the LitterTray web for test cases.

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

Item Form Data

AppliesTo:	Component:	Priority:	CurrentState:	WaitingFor:	TargetRelease	ReleasedIn
Extension	SpreadSheetPlugin	Normal	Closed		patch	5.0.2

Detail

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

This is now in SVN trunk and 5.0 branch.

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

ItemTemplate
Summary	LIST() does not flatten a list in a cell
ReportedBy	TWiki:Main.PeterThoeny
Codebase	5.0.1, ~twiki4
SVN Range	TWiki-5.0.1, Tue, 11 Jan 2011, build 20174
AppliesTo	Extension
Component	SpreadSheetPlugin
Priority	Normal
CurrentState	Closed
WaitingFor
Checkins	TWikirev:20778 TWikirev:20779 TWikirev:20780 TWikirev:20781
TargetRelease	patch
ReleasedIn	5.0.2

Raw edit | More topic actions

Topic revision: r7 - 2011-05-07 - PeterThoeny

Account
- Log In

Edit
Attach

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

Item Form Data

Edit Form Data

Detail