I’m trying to convert a spreadsheet from Excel to OpenCalc. Some of the syntax and methods are different, but I’ve managed to navigate through them, except there seems to be no solution that I can find to how to add a carriage return to text that you are having a formula generate.
In Excel, you merely need to press alt+enter inside quote marks. Close off the quotes and use an ampersand to join it to whatever else the formula is generating. But if you use the Calc equivalent ctrl+enter, your formula stops being a formula and turns into a text that reads as the formula reads, not as the text it’s supposed to generate.
I’ve tried putting in CHAR(13)&{formula}, but that does not result in a return appearing in the text, advancing the text to the next line in a cell with word wrap turned on.
I’ve searched Google, and there seems to be a lot of talk about using Regular Expressions to find carriage returns by searching for them as $, but nobody seems interested in how to just add them to text generated by a formula.
I’d appreciate it if someone could explain how this works. I have enough headaches ahead trying to do this conversion without finding that text can’t even be formatted the way it needs to be.