Re: [libreoffice-users] Contribute to 'Copy only visible cells' extension project

 Hi Miguel!

  Do you use a filter (AutoFilter, Sardard Filter, Advanced Filter) to hide
some rows?
  In this case, yes, copy only the visible cells is the normal behavour.

  But, if you hide your cells by the Hide command, all cells should be
pasted.

  You can see the diference at:
  http://help.libreoffice.org/Calc/Only_Copy_Visible_Cells

 'Copy only visible cells' extension keep the same result in the first case
(with filters) and copy only the visible cells in the second case (with Hide
command).

Best regards!
Gustavo Pacheco.


2011/9/21 MiguelAngel <mariosv@miguelangel.mobi>

> Thanks for the answer Gustavo,
> but copy only the visible cells is the normal behavour in Libo and OOo,
> in 3.3 and 3.4.
> Regards
>
> El 21/09/11 2:21, Gustavo Pacheco escribió:
> > Hi Miguel!
> >
> >  The purpose of the extension is just copy the non hidden rows or
> columns.
> >  In other words, suppose two ways to copy a cell range with hidden
> columns
> > or rows: with the simple Copy command or with the Edit > 'Copy only
> visible
> > cells' command provided by the extension.
> >
> >  In the simple Copy case, If you need to copy the cell range to other
> sheet,
> > you select the range, go to Edit > Copy command, go to the destination
> sheet
> > and Paste the cell range.
> >
> >  The result is: all cells of the original range are copied, including the
> > hidden columns or rows.
> >
> >  With the 'Copy only visible cells' extension, you can use the Edit >
> Copy
> > only visible cells command instead of Edit > Copy command on the range.
> > Then, go to the destination sheet and Paste the cell range.
> >
> >  The result is: only the visible cells are copied, not including the
> hidden
> > columns or rows.
> >
> >  Please, do the tests and check if your results are the same. If you have
> an
> > unexpected result, send me an e-mail with details of your tests!
> >
> >  Thanks,
> >  Gustavo Pacheco.
> >
> >
> >
> >
> > 2011/9/20 MiguelAngel <mariosv@miguelangel.mobi>
> >
> > > I'm
> > >        sorry, but in Libo 3.3 or
> > >    OOo 3.3, only non hidden rows and columns are copied.I think the
> problem
> > > is paste on the non hidden cells.Miguelngel.El 21/09/11 0:39, Gustavo
> > > Pacheco escribi:Hi people!
> > >
> > >
> > >  I would invite you to collaborate with the development of "Copy only
> > > visible cells" extension. In many cases, "Copy only visible cells"
> provides
> > > an alternative to the 'Select Visible Cells' command in Microsoft Excel.
> > > Its useful to use with subtotals or ranges with hidden columns or rows.
> > >
> > >
> > >  At moment, the extension supports only English, Portuguese, French,
> > > German,
> > > Italian and Spanish languages. My goal is to add more languages with the
> > > help of the community.
> > >
> > >
> > >  If you want to contribute, just send me a private email (to: gbpacheco
> AT
> > > gmail.com) with a translation of the phrase "Copy only visible cells",
> > > your
> > > language, your country and your name (for the credits).
> > >
> > >
> > >  Its simple and you can help other people who speak your language. You
> can
> > > try 'Copy only visible cells' extension at the new extension repository:
> http://extensions-test.libreoffice.org/extension-center/copy-only-visible-cellsThanks
> > > ,
> > >  Gustavo Pacheco.
> > > --
> > > For unsubscribe instructions e-mail to:
> users+help@global.libreoffice.org
> > > Problems?
> > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> > > List archive: http://listarchives.libreoffice.org/global/users/
> > > All messages sent to this list will be publicly archived and cannot be
> > > deleted
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted