​When copying a value in a Select column, if the value has a comma, when pasting it into other rows, it only pastes the content before the comma

[ms4sman]

What happened?

I discovered this by chance, but I have a Select column in one of my tables, and it has author names of books, listed with last name first, then first name, separated by a comma. When I copied a value from one of these and pasted it into others, only the last name (before the comma) was inserted properly. And it didn't create a new select value either, when clicking in the cell to edit it, it acted as though I had just typed it myself to create a new option, but hadn't submitted it.

Distribution version

Windows x64

What browsers are you seeing the problem on if you're using web version?

No response

Are you self-hosting?

• Yes

Relevant log output

No response

Anything else?

No response

[zanwei]

hi @ms4sman would you mind provide us a screen recording to help us locate the issue?

[ms4sman]

Certainly! In this video, I guess it did go ahead and create a new option, but I thought it didn't when I originally discovered it.

Regardless though, you can see in the second part of the clip that when I copied multiple cells to a new row, it didn't get the second part and just created a new option with only the last name in it. Copying only that cell works OK I think, it seems to happen when copying multiple cells at once maybe.

The first part actually shows a second bug though that I just discovered now when trying to record it. When I already had "Crichton, Michael" in a text cell and then turned it into a Select, it did something similar, only getting the last name before the column. And then when I did Ctrl+Z to undo, it blanked the column...but then when I went to edit the cell, the one I edited got a random value in it (guessing its some kind of leftover pointer for the Select value, and the other cell went back to its old value. Odd!

Let me know if you need anything more! I am really loving AFFiNE so I want to do anything I can to make it great!

AFFiNE_lyb1FQe3TK.mp4