Bug 125595 - FORMATTING: Validity cell range with invisible characters (e.g. newline) stripped
Summary: FORMATTING: Validity cell range with invisible characters (e.g. newline) stri...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.1.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
 
Reported: 2019-05-30 16:17 UTC by Teraslilja
Modified: 2019-08-20 20:43 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Demonstrating the issues (11.92 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-05-30 16:18 UTC, Teraslilja
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Teraslilja 2019-05-30 16:17:16 UTC
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
Comment 1 Teraslilja 2019-05-30 16:18:21 UTC
Created attachment 151786 [details]
Demonstrating the issues
Comment 2 raal 2019-08-12 18:53:26 UTC
Please test with newer version. 
5. Notice the vlookup() to fail -  works for me. I doesn't see fail after reload of document

I can confirm: 2) When the value selected to cell,  the invisible characters e.g. newline are stripped (visually).

Version: 6.4.0.0.alpha0+
Build ID: 2812610f4f39ed5892da08864893c758325d1d39
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 3 Teraslilja 2019-08-20 20:43:26 UTC
I tried with 
Version: 6.3.0.4
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-CA (en_CA.UTF-8); UI-Language: en-US
Calc: threaded

The cases
1) Not working as expected (invisible characters stripped)
2) Not working as expected (invisible characters stripped), but VLOOKUP Okay
3) Working as expected