Comment 43 for bug 1793124

Revision history for this message
In , Vsfoote (vsfoote) wrote :

(In reply to gulpen from comment #39)

> Please give this issue some love!

We have.

Two options for working with wide columns or tall rows. Or with undersized displays.

One would be to adjust the sheet scroll from default spreadsheet centric "scroll by cell edge" to a "scroll by screen pixel" and requiring new implementation.

The other option was implemented to expose the content of oversize cells to edit engine and UI control via an expandable input window on the FormulaBar (View -> Formula Bar) where you will find a "Expand Formula Bar" and "Collapse Formula Bar" toggle triangle.

The collapsed formula bar is one character row in height. The expanded formula bar input window can be dragged as tall as 25 lines. Default is 6 lines, but the UI value is recorded into the spreadsheet on save, so it keeps it handy. For really large cell content (an actual sc formula or text strings), the input window has a vertical scroll to work with the entire cell (up to 64,000 characters IANM).

Pixel level scrolling a sheet would be nice to implement, but you already are able to work with cells larger than the display or the app window using the Formula Bar's input window, without having to zoom the sheet out.