HI Coda, I have a table (for client invoicing) that I paste new data into each month. Lately when I paste in my new row, values for several columns are being brought in as “Select List” format instead of the existing format. The table format gets changed upon pasting. This happens for my “task” “da…

Ah, I have more information for you. This only seems to happen if I paste data into my table when my table is EMPTY of rows (but still has column headers). In other words, when it looks like this: [image] if I paste on top of existing data, it seems to preserve the column formats. However, I wou…

I’m running into the same issue. Nothing I do seems to “lock” the column format; pasting always adapts the format to something else (namely the Select List). This seems more like a bug than an intended feature (I like the auto-adapt feature but I doubt Codans wanted it to convert columns of all numb…

Thank you both for the feedback! I’m passing this along to the team. It seems like the common occurrence here is a column being changed to Select List, so I’m passing it along with that bit of feedback as well.

Duplicate thread: [image] Pasting numbers sometimes turns cells into select list Bugs In the following number columns: [image] When I copy list of number values from another similar columns, their format turns into Select List: [image] having me to reformat the column…

Any update on this? This is very annoying… And is specially dumb when Coda tries to replace my lookup column with a selection list. Why replace a curated list with another “random” list?

Pasting data changes column formats

Product Feedback

Ian_Nicholson April 28, 2020, 12:11am 5

Duplicate thread:

Topic		Replies	Views
Pasting numbers sometimes turns cells into select list Bugs	4	812	April 28, 2020
Copy paste multipe rows from excel - changes column type to 'Select List' from 'Lookup'?	7	1488	March 1, 2022
Odd Copy / Paste Behavior BUGS Bugs	1	476	September 8, 2021
Pasting data on select or lookup from table column	12	2367	March 13, 2023
Format select list looks differant	3	618	August 19, 2019

Pasting data changes column formats

Related topics