How to center the printsheet

How to center the printsheet

Anonymous (90.8.203.135) 1209802513|%e %b %Y, %H:%M %Z|agohover

Bonjour, Hello,

does anyone know how to center the printing in kspread?
It is the only feature I dunno (if it exists) as well as filters in kspread.
Otherwise it is quite a good material.

Thanks

Re: How to center the printsheet

Kingfisher 1209865781|%e %b %Y, %H:%M %Z|agohover

I don't see any way using the print instructions. You can, of course, centre the text using Format >Cell format : Position.

What is your requirement for filters?

Re: How to center the printsheet

Kingfisher 1210052398|%e %b %Y, %H:%M %Z|agohover

You can also use Format >Page Layout.

Re: How to center the printsheet

Anonymous (90.19.152.153) 1210170723|%e %b %Y, %H:%M %Z|agohover

Page Layout do not allow you to center the selection printed.

I wish I had filters on kspread like in Open office to filter a selection from a column header.

Re: How to center the printsheet

Kingfisher 1210222681|%e %b %Y, %H:%M %Z|agohover

I would use blank columns to centre the data. Could you not use the margins in Page Layout?

As far as filtering goes, can you use formulas together with companion columns?