Google Sheet write cell with \n

MIT App Inventor Help
1

Hi Folks,

I want to write a cell with a value
String1 \N
String2
So in the Google sheet cell a simular like ALT+ENTER? is this possible? or should i use another command
Currently l use the spreadsheet write cell command.

Thx

2

It is not clear what you want to achieve.

Can you show the output you want with a screenshot of a spreadsheet ?

If I understand correctly, this is how you might do it with google apps script.

Not sure if you can do the same with the Spreadsheet component, but you can try adding a \n

1 Like
3

Just tested, this works

image

image

1 Like
4

Just be careful about building up your text with text JOINs.
There is a bug that prevents the Sheet component from reading those.

1 Like
5

Hi ABG, this is the problem i want to Join 2 test bloxes

blocks (1)
blocks (1)806×318 13.8 KB

6

Do the join in a variable, then add the variable to the data socket

image

1 Like
7

Hi Tim,

image
I get an error code 400 Bad request.

8

Sorry, the workaround is to set the join to a label, then use the label text

image

1 Like
9

Search for textify on this board.
(Hallelujah)

1 Like
10

Works fine THX tim!

11

Note that the bug related to using joined strings directly in the WriteCell block should be fixed on ai2-test with the corresponding companion.

1 Like