Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.