Copy and paste cells in table with some having formula

1

I understand that copying and pasting from/to cells with formulae is not technically possible (in Coda terms). However, I was able to copy and paste selected cells like the screenshot below:

image
image1701×434 56.7 KB

In this screenshot, Project, Residual, and Details columns do not have formulae, while G column content is determined by project entered using a formula. In the past, a few days ago, when I want to add a new entry, and its a duplicate from one behind it, I just select the cells like in the screenshot from the older row, and paste in the new row. I understand that the formula is not pasted, but the other normal cells were pasted normally.

Now, with some change you applied to the app, when I copy and paste following this scenario, paste is prevented because of, obviously, the cell that have formula in the middle. This forces me to copy and paste individual cells every time I want to do that.

I hope the old behavior is retuned back.

2

I’m having exactly the same problem. CODA has set up their system so that we cannot import to an existing table, so my only option to update the monthly data is to create new rows and paste the data in. The last time I made these updates, everything worked. Today, I find out that it no longer works.

Seriously - we need to have the ability to import new rows to an existing table. This is a huge issue for me as my data is shown to external users and they expect to see the updates.

It’s very concerning that this hasn’t been addressed as it’s a huge issue.