As I mentioned here, Coda has a behavior where it tries to “guess” the column type for CSV data that I’m pasting into a predefined data table.
Unfortunately, the previous post is now closed, so I am reposting it here as I believe Coda’s behavior has developed to be even more problematic.
For my particular situation, I see these behaviors…
- CSV fields that only have digits have the Coda Table’s column type change from Text to Number,
- CSV fields that similar values have Coda’s Table’s column type change from Text to Select List,
- CSV fields that have text in the format of xx:yy have Coda’s Table column type change from Text to Time.
In the first two instances, I have to manually change the Column Type back to Text and sanity is restored. However, in the third instance, while this used to work, it doesn’t any more so a pasted value of “00:30” gets changed to “12:30 AM” and when I change they type back to Text it stays as “12:30 AM” instead of reverting back to the original value of “00:30”.
This evolution in behavior here, for the worse, is untenable. I appreciate the helpful “guess” that Coda is trying to do here for pasted values, but there should be a table-level option to disable this, especially when it is completely unhelpful as in the situation I outlined above.
At a minimum, the bug here, where the original value is not restored when Coda thinks it is a Time value, needs to be fixed so that I can continue to work around the remainder of the behavior. As it stands with this bug in place, I am completely stuck and can’t work with data and a document that used to work (albeit, in a less than desirable way).
Update: I also linked this via my contacting of Support via my doc and was informed it was logged as a bug but they’re unable to give me a timeline as to when it will be resolved.
Update: My client found a workaround that is worth sharing to others running into this problem. First, delete all data from the data table where you’re trying to paste data into. Next, paste 1 row into the table, change all the columns to the proper format, and manually adjust the time column. Finally, copy/paste the remaining rows. It’s not pretty, but it helps until the bug is fixed. (emjoi added at request of my client)
Update - 2023-12-13: My client let me know today that they pasted in their data into the table and all of the column formats did not change! This is great! Was the bug fixed @Nicole_Macdonald ?