Text overflow means to show text exceeding the column width in the adjacent cells. Like "Hello brave new world" in A1 going into A2, if empty. If A2 contains any content a small triangle is shown. And per Tools > Options > Calc > View > Text Overflow only this triangle can be disabled. 

The request is to block overflow completely- expected this with the option. And actually I'd like to clock overflow per column respectively cell. In some cases you want to read the full text but there are as many situations where empty cells in the adjacent column are normal and you search for the few that have content. This workflow is not possible with the overflow mechanism.