Bug 163624 - Multiline text field for pasting / typing multiline formulas in conditional formatting rules editor
Summary: Multiline text field for pasting / typing multiline formulas in conditional f...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency tree / graph
 
Reported: 2024-10-25 20:32 UTC by Jeff Fortin Tam
Modified: 2024-11-21 08:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jeff Fortin Tam 2024-10-25 20:32:11 UTC 
Calc (and Excel) allows formulas to be written and stored multi-line; i.e. in the main spreadsheet view's formulabar, if you unfold the formula bar and use shift+enter, you can use line breaks to nicely format your formula in a way that is understandable.

However, the conditional formatting dialog's rules editor sub-dialog, when editing a particular "Formula is" rule, does not allow pasting or writing such multiline formulas. When pasting, only the first line is shown.

It should allow writing complex formulas as multiline for clarity.
Comment 1 Nicole A. 2024-11-14 04:30:28 UTC 
UX Team -- please take a look at this enhancement. Thanks!
Comment 2 Heiko Tietze 2024-11-14 09:25:32 UTC 
Please share an example.

I test with =A1\n + A2\n + A3, copy the formula and paste into the edit field. That results in "A1+A2+A3", ie. the line breaks are removed (as I would expect).

Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 480(Build:1)
CPU threads: 32; OS: Linux 6.11; UI render: default; VCL: kf6 (cairo+xcb)
Locale: de-DE (en_US.UTF-8); UI: en-US
24.8.2-2
Calc: threaded
Comment 3 Heiko Tietze 2024-11-21 08:30:34 UTC 
Cannot confirm the issue, no version information, example is missing.