Issue 54706 - Calc doesn't handle large cells at all well
Summary: Calc doesn't handle large cells at all well
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO 2.0 Beta2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-09-16 14:53 UTC by osavill
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

What happens when the cell size exceeds the physical screen size ?! (6.13 KB, application/vnd.sun.xml.calc)
2005-09-16 14:55 UTC, osavill
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description osavill 2005-09-16 14:53:21 UTC
If the cell size exceeds that of the screen the cell becomes largely unuseable.
Once the cell is clicked it is not possible to view or edit the contents at the 
bottom of the cell. It is not even possible to grab the bottom resize bar.

Granted the contents do show up in the edit bar at the top, but this is not an 
easy way to edit such a cell.

The following attachment shows this. It was done at a screen size of 1280x1024. 
The same symptoms are exhibited when the Calc window itself is smaller than the 
cell, but it really becomes a problem when the physical screen size needs to be 
exceeded to see / edit the bottom of a cell !!!

A similar situation arrises when screen width is reached.

Contrast this with Excell which opens up a pop up editing pane. It's behaviour 
is odd to say the lease (mouse wheel scrolls the window underneath, no page up 
or down just cursor up / down) but it does allow you to get at the whole cell.
Comment 1 osavill 2005-09-16 14:55:56 UTC
Created attachment 29603 [details]
What happens when the cell size exceeds the physical screen size ?!
Comment 2 osavill 2005-09-16 14:56:48 UTC
Forgot to add, this is using m128.
Comment 3 jmm 2005-09-18 01:58:00 UTC
I confirm this and I've found a work around: right click the numbered or 
lettered portion of border and choose "row height" to change the size.

I've found Excel 2002 limits cell height to be 546 pixels no matter what 
resolution you're using.
Comment 4 osavill 2005-09-19 19:25:28 UTC
Thanks for that. Although it does now enable me to read the original spread 
sheet sadly it is not a solution. 
1) The method requires several mouse clicks / key entries. 
2) The height is shown in cm !!! What does that mean when you are looking at a 
17 inch monitor ! 
3) Optimal Row Height just does the same as Row Height. One might expect it to 
find the optimal height so the contents fit on the screen ! 
However, once the cell has bee resized it all works perfectly in fact, 
arguably, better than Excel. For a start, when the cell is clicked it presents 
an over flow cell which is the height of the Calc window, is a lot less 
confusing than the Excel solution and allows all the text to be viewed with 
the cursor keys. Surely if Calc realises that the cell overflows its own 
window size could not a similar solution be used ? 
Comment 5 frank 2005-09-29 11:00:55 UTC

not a defect from Calc but one of the design of the sheet. Such cells are IMHO

To answer your questions :

1. True, but what's about using your scrollwheel and CTRL key simultaneously ?
This will change the zoom factor for the sheet.

2. This is just a setting under tools options spreadsheet.

3. Optimal row height is there for changing the row height to fit all the text
to fill just the whole cell in case you have more content as the currently cell
height can fit. It has nothing to do with screen resolution and viewable screen

Comment 6 frank 2005-09-29 11:03:26 UTC
Hi Niklas,

your idea with scrolling if the cell is in edit mode sounds good. So please have
a look at this Issue.

Comment 7 osavill 2006-01-17 16:05:26 UTC

Please could you tell me if a target date has been set for a fix ?

Comment 8 Marcus 2017-05-20 11:13:31 UTC
Reset assigne to the default "".