Open Office 4.01

[Jerry Slivka <je...@gmail.com>]

Hi,

I've been a loyal user of Open Office for the past several years.  The
spreadsheet does a nice job of replacing the basics of Excel.

Two things though that I really would like to see be improved or added for
future releases:

1) In a large spreadsheet I block several cells and only want to print
those cells.  Print Preview and Print wants to print the whole spreadsheet,
which could be several pages.  But, maybe I only need a half page or about
one page only.  Maybe there is a way of doing it, but try as I do I can't
seem to get to print only what I've blocked or highlighted.

2) Excel has a very nice block and move feature.  You can block or
highlight  a group of cells and just drag them to a different location and
keep the formatting of the moved cells.  This is slick and you don't have
to go thru a copy and paste procedure which is much more cumbersome.

Keep up the good work!

Jerry [?]

Re: Open Office 4.01

["F C. Costero" <fj...@gmail.com>]

On Fri, Oct 18, 2013 at 12:11 PM, Jerry Slivka <je...@gmail.com>wrote:

> Hi,
>
> I've been a loyal user of Open Office for the past several years.  The
> spreadsheet does a nice job of replacing the basics of Excel.
>
> Two things though that I really would like to see be improved or added for
> future releases:
>
> 1) In a large spreadsheet I block several cells and only want to print
> those cells.  Print Preview and Print wants to print the whole spreadsheet,
> which could be several pages.  But, maybe I only need a half page or about
> one page only.  Maybe there is a way of doing it, but try as I do I can't
> seem to get to print only what I've blocked or highlighted.
>
> 2) Excel has a very nice block and move feature.  You can block or
> highlight  a group of cells and just drag them to a different location and
> keep the formatting of the moved cells.  This is slick and you don't have
> to go thru a copy and paste procedure which is much more cumbersome.
>
> Keep up the good work!
>
> Jerry [?]
>
Hello Jerry,
   If I understand you correctly, the equivalent actions in Calc are:
1. Highlight the cells you want to print. Select the menu Format -> Print
Ranges -> Define. Selecting File -> Page Preview will then show only the
selected cells.
2. Highlight the cells you want to move. Left click and hold the mouse
button down inside the selected range (not at the edge of the range as in
Excel) and drag to the new location.

I hope that helps.
Francis

Re: Open Office 4.01

["Marcus (OOo)" <ma...@wtnet.de>]

Am 10/18/2013 08:11 PM, schrieb Jerry Slivka:
> Hi,
>
> I've been a loyal user of Open Office for the past several years.  The
> spreadsheet does a nice job of replacing the basics of Excel.
>
> Two things though that I really would like to see be improved or added
> for future releases:
>
> 1) In a large spreadsheet I block several cells and only want to print
> those cells.  Print Preview and Print wants to print the whole
> spreadsheet, which could be several pages.  But, maybe I only need a
> half page or about one page only.  Maybe there is a way of doing it, but
> try as I do I can't seem to get to print only what I've blocked or
> highlighted.

please have a look for the option "Selected cells" when opening the 
Print dialog via "File - Print". Then also the print preview is showing 
only the highlighted cells.

> 2) Excel has a very nice block and move feature.  You can block or
> highlight  a group of cells and just drag them to a different location
> and keep the formatting of the moved cells.  This is slick and you don't
> have to go thru a copy and paste procedure which is much more cumbersome.

Selecting cells and move via mouse is working fine and the cell content 
as well the formatting is moved. I don't see a problem here. Maybe you 
need to give us more details about what exact steps you are doing?

Thanks

Marcus


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org