LibreOffice spreadsheet question, can cells expand as you type?

[Chris Green]

Maybe this just isn't how spreadsheets work but here's hoping.

Is there a setting somewhere in LibreOffice spreadsheet that makes cells
expand as you enter characters?  By that I mean can you make the whole
column grow (and stay grown) rather than the default that grows just the
cell where you're entering text and then truncates the view when you
leave the cell.

... and as a corollary to that is there a way to show only cells with
data in them rather then the default 'much larger than the window'
layout? 

-- 
Chris Green