Copy, cut, and paste like using Excel

[petercreateParticipant]

Hi,

Just wondering if DG has considered these functions in its plan?

[dgteamModerator]

Thanks for the topic.

Sounds like you are referring to how you can move around a block of cells in a spreadsheet.  Our experience in spreadsheets is that data has to be moved around since you have to isolate the data you need to graph. In DataGraph, we encourage you to use a raw data set along with the commands and masks to process and parse larger data sets, eliminating the need to move data around (i.e., creating a data pipeline).

The data model of DataGraph is also fundamentally different than a spreadsheet, as spreadsheets are cell-based, and every cell can be a unique data type. DataGraph is column-based, so every row in a column has the same data type.

If you are missing the Excel way of moving data around, we would be curious to hear more about it.  For example, if you could describe more about the circumstances when this way of moving it around might be helpful.

Some actions we have added to handle specific circumstances that might be helpful:

1 – How to Flatten Data

2 – How to Append Groups of Data

 

[petercreateParticipant]

Thanks. For the moment, I don’t know how to auto fill a column with a series of number with the same gap. When I’m remove some cells in DG, I usually handle them in Excel first and import back to DG later.

[Jean-Yves Le StangParticipant]

Create a function based on the row number (#) with the value #*Gap (Data in the image attached, here Gap = 22.5). Once the function is entered you are asked to fill the number of rows you want to generate (Rows in the att).

Because “Data” is a function you cannot remove only one (several) row(s). You must do this on a pasted copy of Data (Copy as text then Paste), as follows:

1. Select the rows where you want to remove data, using Shift and Ctrl keys
2. Right-Click on the column header where you want to remove data.
3. Select the menu “empty selected rows”

Instead of Right-click in the column header, if you do it in the column, you can also delete the whole selected rows with the usual options (only one or several…).

[dgteamModerator]

@Jean-Yves Le Stang — Nice explanation for using an Expression column.

Here is an article that might also be helpful:
How to Fill a Column with a Series

 

[Jean-Yves Le StangParticipant]

Well noted those very useful tips – with many thanks

[petercreateParticipant]

Thanks.

[Author]

Posts