Download it now!
Bug 131944 - FORMATTING Wrap text automatically not working when value inserted using vlookup() function
Summary: FORMATTING Wrap text automatically not working when value inserted using vloo...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Anchor-and-Text-Wrap Function-Vlookup
  Show dependency treegraph
 
Reported: 2020-04-06 22:45 UTC by Óvári
Modified: 2020-08-13 19:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Wrap text automatically not working when value inserted using vlookup() function (9.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-06 22:46 UTC, Óvári
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Óvári 2020-04-06 22:45:51 UTC
Description:
FORMATTING Wrap text automatically not working when value inserted using vlookup() function

Steps to Reproduce:
For cells B6 and E2, Format Cells, Alignment have:
* Horizontal: Left
* Vertical: Top
* Wrap text automatically: Enabled 

In cell A6, change the values between: 0, 1 and 2.

It is understood that the B6 and E2 cell sizes should change when more or less space in required.

Are you able to reproduce and fix?

Thank you

Actual Results:
Cell sizes don't change to fix the data.

Expected Results:
Cell sizes should change (expand or reduce) to fill the data


Reproducible: Always


User Profile Reset: No



Additional Info:
Attachment will be added in the next entry as unfortunately there is no option to add it now.

LibreOffice
Version: 6.4.2.2
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3; 
Calc: threaded

Linux Mint 19.3 Cinnamon 64-bit
Comment 1 Óvári 2020-04-06 22:46:36 UTC
Created attachment 159373 [details]
Wrap text automatically not working when value inserted using vlookup() function
Comment 2 raal 2020-04-07 05:30:02 UTC
Confirm with Version: 7.0.0.0.alpha0+
Build ID: aa191f35978ea48bbacc0e613ae8f0e6536ebcfc
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
and 
Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 3 Óvári 2020-04-07 08:24:51 UTC
Please enable this to work correctly when "Protect Sheet..." has also been enable. Thank you