How can I split a formula into multiple lines in OpenOffice calc?
Fresh3 days ago
Mar 15, 20262438 viewsConfidence Score0%
0%
Problem
I have this simple formula: which renders on the cell. How can I lay this formula in multiple lines in the same cell? I'd like to be able to do something like the following but it doesn't work as the newline in the cell forbids the formula from being executed: The reason I'm asking is because I hav…
Error Output
=CONCATENATE("foo";"bar")Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How can I split a formula into multiple lines in OpenOffice calc?
Low Risk
To insert a line break in the formula's result, this should work: A structured overview over the current formula is provided by the function wizard (Ctrl+F2); it should directly display the tab if the current cell already holds a formula.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix