On Tue, Oct 7, 2008 at 1:59 PM, Andre Schnabel <[EMAIL PROTECTED]>wrote:
> Hi, > > (i did not read the discussion from the beginning, so sorry if I > mention something that has already been written). > > > Von: Michael Adams <[EMAIL PROTECTED]> > > > > No, sorry it is out of my field of experience. Post it as a question on > > the user mailing list and see what response you get. No need to join up > > if you are not already a member. Try "Is it possible to copy and paste > > row height and column width from one spreadsheet to another?" ... > > This is possible: > > - select the columns / rows with the desired width (use column > / row header for selction with mouse) > > - copy to clipboard (ctrl+c) > > - move to the place where you like to apply the width / height. > Note: if you want to apply heights, you need to select a cell in column > "A". > If you like to apply widths you neet to select a cell in row "1" > > - paste special (ctrl+shift+v) and deselcet all but "formats" > > > This indeed copies all formats, not only width / height. > > André > -- > > > Thanks for the follow up but I can't make it work (OO version 2.41) > As an experiment I coloured some of the cell backgrounds to show me Paste Special was being applied Special pasting Formats coloured the receiving cells correctly but made no change to width or height. I have tried many times times including pasting Text as well as Formats at the same time which works I can change width and height using the Format function in the toolbar and also change width with the mouse, so it seems they are not locked Any idea what the trouble is?
