Item10540: LIST() does not flatten a list in a cell
Priority: Normal
Current State: No Action Required
Released In: n/a
Target Release: patch
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