Thank Gustavo, I understand now. Regards. El 21/09/11 17:52, Gustavo Pacheco escribió: > 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 <mari...@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 <mari...@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+h...@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+h...@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+h...@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
