Defining cell range as accepting formulas? #2872

New Issue

jeff20123 · 2023-02-08T12:39:14Z

jeff20123 commented

2023-02-08 12:39:14 +00:00

In a specific cell range, for ex. A4:A (from A4 to the last non-empty A cell), I would like the cells to accept formulas. I am not trying to run the same formula for each cell (for ex. B1+B2...) but rather build a custom formula in each cell in order to insert line breaks, like ="string1"&"string2"&car(10)&"string3". Where strings 1/2/3 are coming from the JSON data that I am exporting to the Excel file.

I get the data out fine in the Excel file, but it is not interpreted as a formula, so the result in Excel is something like: ="string1""string2"&car(10)&"string3", instead of (as it should be):
string1string2
string3

How can I do this? Or is there an easier way to insert line breaks in cells?

PS. also I have tried to get info on how to set up the Pro build by sending emails to pro@sheetjs.com but after an initial reply asking for details, I have no news.

In a specific cell range, for ex. A4:A (from A4 to the last non-empty A cell), I would like the cells to accept formulas. I am not trying to run the same formula for each cell (for ex. B1+B2...) but rather build a custom formula in each cell in order to insert line breaks, like ="string1"&"string2"&car(10)&"string3". Where strings 1/2/3 are coming from the JSON data that I am exporting to the Excel file. I get the data out fine in the Excel file, but it is not interpreted as a formula, so the result in Excel is something like: ="string1""string2"&car(10)&"string3", instead of (as it should be): string1string2 string3 How can I do this? Or is there an easier way to insert line breaks in cells? PS. also I have tried to get info on how to set up the Pro build by sending emails to pro@sheetjs.com but after an initial reply asking for details, I have no news.

Sign in to join this conversation.