Yes, Chen. You are right, The file is too large and having many merged areas. But the problem is solved after making array mergehandling(300) to mergehandling(3000).
thanks for prompting. regards, Ashish Aghera -----Original Message----- From: 陈浩(Chen Hao) [mailto:[email protected]] Sent: Tuesday, July 21, 2009 6:05 AM To: [email protected] Subject: 答复: [users] insert row in Calc The range of your Merge area? Maybe the Area is too large. It works well on my computer. If you could give more informations , others could help u maybe . -----邮件原件----- 发件人: Ashish P Aghera [mailto:[email protected]] 发送时间: 2009年7月20日 17:17 收件人: [email protected] 主题: RE: [users] insert row in Calc I added the extension 'CalcEasy Toolbar 1.1.2'. When I tried to insert a row in merged area with pressing new toolbar button, It took a considerable time and then It resulted giving error in macro as 'inadmissible value or data type. Index out of defined range'. Do I need any other setting to run this macro properly. Thanks & regards, Ashish Aghera -----Original Message----- From: Gene Young [mailto:[email protected]] Sent: Saturday, July 18, 2009 11:00 PM To: [email protected] Subject: Re: [users] insert row in Calc James E. Lang wrote: > I cannot access that link. Are you sure it's valid? > > I might add that I've had some interesting experiences with merged > ranges recently in that I've been able to paste data from a merged range > into another merged range without first unmerging it. I'm not sure > whether the file I was working on was an Excel spread sheet since I've > worked with both using OOo. > > --On Saturday, July 18, 2009 10:34:45 PM +1000 Jean Lear > <[email protected]> wrote: > >> There is an extension available that allows inserting columns >> >> and rows through merged cells. >> >> (www.extensions.services.openoffice.org/project/CalcEasyToolbar) >> > Try this link; http://extensions.services.openoffice.org/project/CalcEasyToolbar -- Gene Y. --------------------------------------------------------------------- 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] --------------------------------------------------------------------------------------------------- Confidentiality Notice: The information contained in this e-mail and any accompanying attachment(s) is intended only for the use of the intended recipient and may be confidential and/or privileged of Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of this communication is not the intended recipient, unauthorized use, forwarding, printing, storing, disclosure or copying is strictly prohibited, and may be unlawful.If you have received this communication in error,please immediately notify the sender by return e-mail, and delete the original message and all copies from your system. Thank you. --------------------------------------------------------------------------------------------------- Standard Disclaimer Conditions as per Tatachemicals Ltd Email Security Policy apply --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
