[Bug 163624] Multiline text field for pasting / typing multiline formulas in conditional formatting rules editor

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jeff Fortin Tam <nekohayo at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|INSUFFICIENTDATA            |---
     Ever confirmed|1                           |0

--- Comment #4 from Jeff Fortin Tam <nekohayo at gmail.com> ---
Sorry for not responding sooner, I was away on a business trip for a month.

> the line breaks are removed (as I would expect).

That is precisely what I would not expect. What I am requesting here is for the
field to be able to behave as a multiline textfield (or an expandable one, like
the formula bar in the main UI) that respects the linebreaks, for readability.

Your formula can serve as an example, but here's another simple one (with named
cells instead of regular cell references, which may be longer especially if
taken from another sheet):

  IF (TODAY() - date_limite >=-5)
  AND (ISBLANK(date_paiement))

(There can be much more complicated formulas out there, I remember writing some
that were 4-6 lines long for instance, but I don't remember where to find them,
and they are fairly straightforward to imagine from the example above)

-------

Version information:

Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded

-- 
You are receiving this mail because:
You are on the CC list for the bug.