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” “date” and “hours” (which were formatted as Text, Date, and Number, respectively, and which includes data values you might expect for those items.). My “time” column, format, oddly (containing a time, like 2:45 PM), comes in just fine.
In other words, I expect rows of data pasted into an existing table to inherit the column attributes of the existing table. Not sure why these are being made into “Select List” items. I think this is a new-ish “result” for me, but preceded Coda 2.0.
Any advice appreciated. If there is a more correct way to paste in information that would preserve these values, let me know!