[Libreoffice-bugs] [Bug 131552] New: Ability to have line breaks in Calc spreadsheet formulas for readability

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131552

            Bug ID: 131552
           Summary: Ability to have line breaks in Calc spreadsheet
                    formulas for readability
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: nekohayo at gmail.com

Description:
It would be helpful if LibreOffice Calc registered and displayed new lines /
line breaks in formulas when the formula bar is expanded.

Steps to Reproduce:
Put (paste or type) this formula in a cell:

=
IF($L22="CAD", M22*I22/F22,
IF($L22="USD", M22*$R$3*I22/F22,
IF($L22="EUR", M22*$P$3*I22/F22,
"no")))

Then press Enter to validate the formula.

Actual Results:
When you select the formular bar again, even if the formula bar is expanded the
formular bar is expanded, the formula will have become one single line again:

= IF($L22="CAD", M22*I22/F22, IF($L22="USD", M22*$R$3*I22/F22, IF($L22="EUR",
M22*$P$3*I22/F22, "no")))

Expected Results:
It should respect the line breaks I have put there for readability.


Reproducible: Always


User Profile Reset: No



Additional Info:
Excel allows this (you create line breaks by hitting Alt+Enter, instead of
Shift+Enter like in LOo Calc).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200325/7c3e5fe2/attachment.htm>