This question about Using an extension: Asked

Spreadsheet plugin LISTEACH and nested function formulas

-- BramVanOosterhout - 25 Jan 2016 The code:
               $item: $DEC2HEX($COUNTSTR(,,,,,, $item  ),6),
     ,, )" 

Produces: 6): $DEC2HEX(0, $DEC2HEX(4, $DEC2HEX(1, $DEC2HEX(1

The above demonstrates that a straightforward implementation of listeach with a nest function formula appears to parse the bracketing incorrectly. The second parameter of DEC2HEX (...,6) [the ,6)] is taken as the first entry in the list defining EACH in the listeach.

The sequence below shows that the functionilty works in non-nested funtions.

Is there a way to escape the nesting so that the parsing will behave correctly?

Count the items in a string 4 1

Translate to hex 000004

Show each item,,

Count each item,,

Count each item in hex

6): $DEC2HEX(0, $DEC2HEX(4, $DEC2HEX(1, $DEC2HEX(1


QuestionForm edit

Subject Using an extension
Extension SpreadSheetPlugin
Version Foswiki 2.0.3
Status Asked
Related Topics
Topic revision: r1 - 25 Jan 2016, BramVanOosterhout - This page was cached on 10 Jan 2018 - 19:11.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License