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?
Cell sizes don't change to fix the data.
Cell sizes should change (expand or reduce) to fill the data
User Profile Reset: No
Attachment will be added in the next entry as unfortunately there is no option to add it now.
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3;
Linux Mint 19.3 Cinnamon 64-bit
Created attachment 159373 [details]
Wrap text automatically not working when value inserted using vlookup() function
Confirm with Version: 220.127.116.11.alpha0+
Build ID: aa191f35978ea48bbacc0e613ae8f0e6536ebcfc
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Version 18.104.22.168.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Please enable this to work correctly when "Protect Sheet..." has also been enable. Thank you