how can I see more than one spreadsheet on the screen at the same time, either horizontal or vertical display
There is no tiling in the strict sense in a LibreOffice window as far as I know. You may, however, create another window (> ‘Window’ > ‘New Window’) initally having opened the same document, and subsequently resize and rearrange the windows independently. You also can view different sheets in both of them.