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

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

pencil
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
Topic revision: r1 - 25 Mar 2011, WillNorris
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy