[Libreoffice-bugs] [Bug 125595] New: FORMATTING: Validity cell range with invisible characters (e.g. newline) stripped

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 125595
           Summary: FORMATTING: Validity cell range with invisible
                    characters (e.g. newline) stripped
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: m-Matti-a.Lehtonen at IKI.Fi

Description:
When there is defined a validity check with cell range and those cells contain
invisible characters, especially newline character there are multiple issues.

1) The selection menu has stripped the invisible characters e.g. newline
2) When the value selected to cell,  the invisible characters e.g. newline are
stripped (visually). How ever vlookup() finds correctly
3) When opening document, then the vlookup() fails, and is fixed after
reselection



Steps to Reproduce:
1. Fill several cells with normal text and newline characters
2. Set a validity for some cell with the cells as a range above
3. Have at another cell a vlookup() to verify validity of selected value
4. save, close and reopen the document
5. Notice the vlookup() to fail

Actual Results:
1. After selection newline characters have no  effect of causing a visual new
line 
2. vlookup() fails after loading document

Expected Results:
1. Pulldown menu can have a fixed height cells for value selection
2. When a value is selected, newlines work as expected
3. after loading a document, vlookup() do not fail


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.5
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-CA (en_CA.UTF-8); Calc: group

-- 
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/20190530/3b49fc2c/attachment-0001.html>