It turns out that OO _can_ copy visible cells only. Page 205 of User Guide: "Only Copy Visible Cells Assume the user has hidden are a few rows or columns visible cells are to be copied. Calc behaves differently depending on the method the intended action to be performed upon them."
So required infrastructure is already in place and just some modification to existing code is needed. > -----Original Message----- > From: Walter A. March [mailto:[EMAIL PROTECTED] > Sent: Friday, July 28, 2006 5:39 AM > To: [email protected] > Subject: Re: [users] Calc - copying subtotals without original data? > > For those who are familiar with M$ Excel, I can, I think > express what we are trying to do. > > We do our subtotal and then collapse the outline so that only > the subtotal and grand total lines are displayed. > > Now we select the data. In Excel, our next step would be > Edit > Go To. > Click Special. Click Visible Cells Only. Click OK > > Now we would copy and paste. Its that selecting only the > visible cells that we either can't do or don't know how to. > > WalterAM --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
