Displayr

Allow conditional formatting of calculation grid cells

Allow users to dynamically sort the rows/columns of a calculation grid. Similar to what the Rule (Sort Rows Automatically when the data changes) does.

Like in excel - able to create a merged cell that exists within the normal structure of a grid.

A calculation grid is made up of individual R calculations, but there is no OUTPUT > Show raw R Output section available on a cell, which is used to troubleshoot R code. Users have to copy the code from the cell into a different calculation to be able to troubleshoot it effectively. Since the cells are so small, is there a different way of allowing some sort of preview or such of the raw r output for troubleshooting purposes?

When users copy over cells from a Qtable to a Calculation Grid and Paste Link , can we allow them to also bring over the significance testing - see example below?

Calculation grids don't have any attribute properties that can be referenced in R to allow for programmatically setting these values.

User wishes to be able to copy code for the calculation grid from Excel and for multiple cells in one go.

The item created by {{Anything > Page Deign > Controls > Text Box}} has an object inspector setting called {{Default value from calculation}} which shows a dropdown list of all RItems and lets the value be defaulted to the output of one. For this feature we want the Calculation Grid Cells to show up in this list as RItems do. (Some technical details below about why this is not trivial) Technical Details: That field in the object inspector expects a fully fledged RItem as input and will not work when passed something else, since CalcGridCells are referenceable in R and behave like a calculation it would make sense for them to work but they are not full fledged RItems as they are not an {{AnalysisItem}} directly. There is quite a bit of behaviour built around that field that relies on being passed an RItem, including assigning and referencing them in QScripts. If it proves too difficult to make these referenceable perhaps we can add another field for CalcGridCells