It works with Windows XP & OOo 3.0.0 in my case. But I don't know for Linux. Any Linux user can help.
regards, Ashish -----Original Message----- From: James E. Lang [mailto:[email protected]] Sent: Tuesday, August 04, 2009 9:06 AM To: [email protected] Subject: RE: [users] Duplicating Column Widths in Calc Thank you, Ashish, for your response. See my comments below: --On Tuesday, August 04, 2009 08:22:15 AM +0530 Ashish P Aghera <[email protected]> wrote: > Paste special is better than doing manual column width setting, I concur but only if it accomplishes the task. > 1) copy the columns I selected all the columns that I wanted to replicate in an empty row (no merged cells) and used Ctrl+C to copy them. > 2) select the equal nos. or 2x ,3x nos. of column, I selected an equal number of columns where I wanted the layout to be replicated. > 3) Right click & Paste special The right click menu did not include Paste special so I picked it out from the Edit menu. > 4) uncheck all options & check only 'format' I did this. > 5) It will paste column with along with other format(color, border, > fonts). Remove unwanted format. It did NOT paste column widths. Since I'm down to only 39 more columns to set, I suppose I might as well do it manually. However, for future use in similar situations, I still want a workable solution. For what it's worth, I am using OOo 3.0.1 on Kubuntu (Linux) though I also use it on Windows 2000 and Windows Vista from time to time. > -----Original Message----- > From: James E. Lang [mailto:[email protected]] > Sent: Tuesday, August 04, 2009 7:52 AM > To: [email protected] > Subject: [users] Duplicating Column Widths in Calc > > Is there a simple way to select a range of columns and then to duplicate > > their widths elsewhere in a Calc document? > > Here are two examples: > > 1) Using the widths of columns A through M on Sheet 1, duplicate the > layout > on Sheets 2, 3, .... > > 2) Take the widths of columns A through M on a selected sheet and > duplicate > the layout in columns N through Z, AA through AM, AN through AZ, ... on > the > same sheet. > > Copy/Paste does not appear to accomplish this nor does Copy/Paste > Special. > It is tedious yet possible to set all the column widths manually via > Alt+O, > M, W. -- Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] Standard Disclaimer Conditions as per Tatachemicals Ltd Email Security Policy apply --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
