Is there a way to make lines in cell automatically go to new row when comma is used?

[danix]

I have made a picture that hopefully fully explains what I want:

[Album] Imgur: The magic of the Internet

If you can’t see the picture. I have a cell that has “apes, monkeys, elephants, aabbbbaaa hh jlhlhilh, dinosaurs, fish, crab”. Calc displays that cell as something like this:
“apes, monkeys,
elephants,
aabbbbaaa hh
jlhlhilh, dinosaurs,
fish, crab”

Is there a way to make all values separated by comma be on their own line, like this:
“apes,
monkeys,
elephants,
aabbbbaaa hh
jlhlhilh,
dinosaurs,
fish,
crab”

[Lupp]

0. Avoid images if not the question is specifically about the view.
1. Line breaks inside cells are made with Ctrl+Enter. The commas or any other list separators are superfluous then. (Avoid this. It spoils row heights.)
2. If you want to create content of the cell below in the next row simply use CursorDown instead of a line break.
3. Did you thoroughly distinguish “NewLine” from “NextRow”?

[danix]

I am aware of ctrl-enter. I’d prefer it to be automatic instead of having to do it manually.

I don’t understand your 3rd point.

[Lupp]

Once again: Ctrl+Enter creates a new line, but doesn’t go to the next row. Your question was worded “…go to new row when comma…”.
Now I find:

@danix

…I’d prefer it to be automatic instead of having to do it manually.

You will need to be precise about what’s meant by “it”.

[danix]

I’m thinking is there is a formatting option (similar to centering text in cell or wrap text) that separates text inside cell into separate lines inside the cell based on something. Like with csv you can set comma as separator for example.

[Lupp]

Now your question seems to be
“Is there an automatism that could be activated to the effect that inside a Calc cell after every comma a line break is inserted?”
This is nothing to do with “new row”.
The answer is “No.”
You can somehow get near what you want to achieve with the help of user code. The result won’t pay.

[joshua4]

Sure. Let’s keep it simple–very simple–by assuming the following:

1. You have your original data in A1. Of course, just use “pull down” or use other adjustments to point toward any (other) original cell or cells.
2. Your data are in a column (or multiple columns). Otherwise, “pull across”, and adjust accordingly.
3. Your original data do not have any linefeeds or carriage returns in them to begin with.

That said, just create another column using:

=REGEX(A1,", *",","&CHAR(10),"g")

Now your new column will be formatted as you have pictured. You can then hide the old column if you need to.

CommaStack.ods (12.3 KB)

[danix]

This works perfect!