Range Slicing

This sample is saved as Range slicing in the Samples subfolder of the Resolver One folder on your Start Menu. It consists of a table with stock data, two areas where you can specify slices to take from the table (one for rows and one for columns) and two areas where the results of the slicing are displayed. All the slicing is performed in Post-formulae user code.

Basic Slicing

The basics of slicing are covered in Worksheet slicing

Cell Range Slicing in Resolver One

Cell ranges can be sliced as if they were collections. You can use numbers and the names of header rows and cols in slices. Unlike worksheets, you can use negative numbers as either the start or end of a slice. Cell range slicing is right-exclusive. It may seem little counter-intuitive, especially when you use names from headers, but it's consistent with Python slicing.

Back to Sample Spreadsheets.

Comments