There is an extension available that allows inserting columns and rows through merged cells.
(www.extensions.services.openoffice.org/project/CalcEasyToolbar) I have used it for some time and find it most helpful saving that unmerge and insert and merge again. [email protected] On Fri, Jul 17, 2009 at 3:44 PM, Ashish P Aghera <[email protected]>wrote: > I have a spread sheet in which few rows are merged in a particular > column. All others column/row are not merged. > > If I want to insert rows in between the range where the column having > merged cells, Calc is not allowing the insert & gives error. But this > was possible with excel. It simply inserts the row & also expands the > merged cells to accommodate new row in it. > > Is this possible with Calc by any other way (without doing unmerge--> > insert --> merge again) or it is limitation of Calc? > > > > Ashish Aghera > > > Standard Disclaimer Conditions as per Tatachemicals Ltd Email Security > Policy apply >
