Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

 

Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit JETPRO-I-149 Add capability to filter Excel data used as table source for NL function.

Jet Reports should honor the Excel range dimensions when used as a table source for the NL function Merged

Jet Reports accepts an Excel range or named range as a table source in the NL function. However, a multi column range is just transposed into a single column (e.g a 3x2 range of Chicago, IL~Denver, CO~Orrville, OH would be displayed vertically as Chicago, Denver, Orrville, IL, CO, OH if used as a table source for the NL function.

Change the NL function to parse the range and honor its dimensions with explicit names ColA, ColB, ColC, etc. Alternatively, you could just use a ones based index as well. The implicit column names would be relative to the range used so that the first column in the range would be ColA, etc. So, given the example above, if no columns were specified, only implicit ColA would be returned (e.g. the vertical list Chicago, Denver, Orrville).

The NF function could also be tweaked to allow selection of other columns in an m by n range. Again, using the above example, if the NL function had $C$2:$D4 as the table source, then NF could allow you to specify ColB to pick up the states, IL, CO, OH.

Actually, since the columns are relative to the range, the implicit list should probably be named something like RangeCol1, RangeCol2, ..., RangeColN to avoid confusion with sheet range that was selected.

  • Gary Winey
  • Jul 20 2017
  • Under Consideration