Ok, so I got this huge ods file, with lots of indirects and calc hyperlinks, and usually each cell has more than 100 text characters (via indirects).
I can’t expand cell height and width, that would severely limit the amount of cells I can see on the screen. I can’t use overflow because there is always a cell to the right of it and overflowing stops.
I usually need to read only cell at a time, I am currently using the hyperlinks
=IF( 'Human format ids'.HQ14=0 ,"" ,HYPERLINK( "#'Human format'."&'Human format ids'.HQ14 ,INDIRECT('Human format ids'.HQ14) ) )
to get me to the original cell (because if I click on the original cell then the text appears word wrapped in the input line (that thing that you write or edit formula of the current cell), which thank God can be set to have more rows) and I can read the cell. But it’s difficult getting back to the location I was before the hyperlink. Other times I just change the width and height so I can read the cell and then just undo the changed.
Ok, so, is there a way for me to view the cell output in the input line, NOT THE FORMULA?
Or hover over a cell and view the text (NOT THE FORMULA)? Or maybe make a a new toolbar that has a modified input line that shows output instead of formula?