Dennis -

Thank you.

That is an "elegant" solution to the problem posted.

On Sat, Nov 29, 2014 at 7:33 AM, Dennis E. Hamilton <dennis.hamil...@acm.org
> wrote:

> Open the problematic sheet in Calc.
>
> With the cursor initially in cell A1, Click Ctrl-End on your keyboard.
> This will move to the lower-right corner cell of the sheet such that all
> used cells are included in the rectangular grid having that A1 and that as
> corners.
>
> From there, you can start deleting rows or columns as necessary to shrink
> that grid back to one that just includes the necessary cells and excludes
> blank strays.
>
> This is better than setting print area because that often ends up
> excluding information when changes are made or, as seems to be the case
> here, there may be inconsistency in handling multiple sheets in the Calc
> document.
>
>  - Dennis
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Reply via email to