1<?xml version="1.0" encoding="UTF-8"?>
| 1<?xml version="1.0" encoding="UTF-8"?>
|
2<helpdocument version="1.0"> 3
| 2
|
4<!--***********************************************************
| 3<!--***********************************************************
|
5 *
| 4 *
|
6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information 9 * regarding copyright ownership. The ASF licenses this file 10 * to you under the Apache License, Version 2.0 (the 11 * "License"); you may not use this file except in compliance 12 * with the License. You may obtain a copy of the License at
| 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file 9 * to you under the Apache License, Version 2.0 (the 10 * "License"); you may not use this file except in compliance 11 * with the License. You may obtain a copy of the License at
|
13 *
| 12 *
|
14 * http://www.apache.org/licenses/LICENSE-2.0
| 13 * http://www.apache.org/licenses/LICENSE-2.0
|
15 *
| 14 *
|
16 * Unless required by applicable law or agreed to in writing, 17 * software distributed under the License is distributed on an 18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19 * KIND, either express or implied. See the License for the 20 * specific language governing permissions and limitations 21 * under the License.
| 15 * Unless required by applicable law or agreed to in writing, 16 * software distributed under the License is distributed on an 17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18 * KIND, either express or implied. See the License for the 19 * specific language governing permissions and limitations 20 * under the License.
|
22 *
| 21 *
|
23 ***********************************************************--> 24
| 22 ***********************************************************--> 23
|
25 26 27
| 24<helpdocument version="1.0">
|
28<meta>
| 25<meta>
|
29 <topic id="textscalcguidecellcopyxml" indexer="include" status="PUBLISH"> 30 <title xml-lang="en-US" id="tit">Only Copy Visible Cells</title> 31 <filename>/text/scalc/guide/cellcopy.xhp</filename> 32 </topic> 33 </meta> 34 <body>
| 26<topic id="textscalcguidecellcopyxml" indexer="include" status="PUBLISH"> 27<title xml-lang="en-US" id="tit">Only Copy Visible Cells</title> 28<filename>/text/scalc/guide/cellcopy.xhp</filename> 29</topic> 30</meta> 31<body>
|
35<bookmark xml-lang="en-US" branch="index" id="bm_id3150440"><bookmark_value>cells; copying/deleting/formatting/moving</bookmark_value>
| 32<bookmark xml-lang="en-US" branch="index" id="bm_id3150440"><bookmark_value>cells; copying/deleting/formatting/moving</bookmark_value>
|
36 <bookmark_value>rows;visible and invisible</bookmark_value> 37 <bookmark_value>copying; visible cells only</bookmark_value> 38 <bookmark_value>formatting;visible cells only</bookmark_value> 39 <bookmark_value>moving;visible cells only</bookmark_value> 40 <bookmark_value>deleting;visible cells only</bookmark_value> 41 <bookmark_value>invisible cells</bookmark_value> 42 <bookmark_value>filters;copying visible cells only</bookmark_value> 43 <bookmark_value>hidden cells</bookmark_value>
| 33<bookmark_value>rows;visible and invisible</bookmark_value> 34<bookmark_value>copying; visible cells only</bookmark_value> 35<bookmark_value>formatting;visible cells only</bookmark_value> 36<bookmark_value>moving;visible cells only</bookmark_value> 37<bookmark_value>deleting;visible cells only</bookmark_value> 38<bookmark_value>invisible cells</bookmark_value> 39<bookmark_value>filters;copying visible cells only</bookmark_value> 40<bookmark_value>hidden cells</bookmark_value>
|
44</bookmark><comment>mw changed "cells;"</comment> 45<paragraph xml-lang="en-US" id="hd_id3150440" role="heading" level="1" l10n="U" oldref="1"><variable id="cellcopy"><link href="text/scalc/guide/cellcopy.xhp" name="Only Copy Visible Cells">Only Copy Visible Cells</link> 46</variable></paragraph>
| 41</bookmark><comment>mw changed "cells;"</comment> 42<paragraph xml-lang="en-US" id="hd_id3150440" role="heading" level="1" l10n="U" oldref="1"><variable id="cellcopy"><link href="text/scalc/guide/cellcopy.xhp" name="Only Copy Visible Cells">Only Copy Visible Cells</link> 43</variable></paragraph>
|
47 <paragraph xml-lang="en-US" id="par_id3148577" role="paragraph" l10n="CHG" oldref="2">Assume you have hidden a few rows in a cell range. Now you want to copy, delete, or format only the remaining visible rows.</paragraph> 48 <paragraph xml-lang="en-US" id="par_id3154729" role="paragraph" l10n="CHG" oldref="3">$[officename] behavior depends on how the cells were made invisible, by a filter or manually.</paragraph> 49 <table id="tbl_id3154942"> 50 <tablerow> 51 <tablecell> 52 <paragraph xml-lang="en-US" id="par_id3155603" role="tablehead" l10n="U" oldref="4">Method and Action</paragraph> 53 </tablecell> 54 <tablecell> 55 <paragraph xml-lang="en-US" id="par_id3150751" role="tablehead" l10n="U" oldref="5">Result</paragraph> 56 </tablecell> 57 </tablerow> 58 <tablerow> 59 <tablecell> 60 <paragraph xml-lang="en-US" id="par_id3149018" role="tablecontent" l10n="U" oldref="6">Cells were filtered by AutoFilters, standard filters or advanced filters.</paragraph> 61 <paragraph xml-lang="en-US" id="par_id3150044" role="tablecontent" l10n="CHG" oldref="7">Copy, delete, move, or format a selection of currently visible cells.</paragraph> 62 </tablecell> 63 <tablecell> 64 <paragraph xml-lang="en-US" id="par_id3146918" role="tablecontent" l10n="CHG" oldref="8">Only the visible cells of the selection are copied, deleted, moved, or formatted.</paragraph> 65 </tablecell> 66 </tablerow> 67 <tablerow> 68 <tablecell> 69 <paragraph xml-lang="en-US" id="par_id3166427" role="tablecontent" l10n="U" oldref="12">Cells were hidden using the <emph>Hide</emph> command in the context menu of the row or column headers, or through an <link href="text/scalc/01/12080000.xhp" name="outline">outline</link>.</paragraph> 70 <paragraph xml-lang="en-US" id="par_id3152990" role="tablecontent" l10n="CHG" oldref="13">Copy, delete, move, or format a selection of currently visible cells.</paragraph> 71 </tablecell> 72 <tablecell> 73 <paragraph xml-lang="en-US" id="par_id3154371" role="tablecontent" l10n="CHG" oldref="14">All cells of the selection, including the hidden cells, are copied, deleted, moved, or formatted.</paragraph> 74 </tablecell> 75 </tablerow> 76 </table> 77 78 <section id="relatedtopics"> 79 <embed href="text/scalc/guide/filters.xhp#filters"/> 80 <embed href="text/scalc/guide/autofilter.xhp#autofilter"/> 81 <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> 82 </section> 83 </body>
| 44<paragraph xml-lang="en-US" id="par_id3148577" role="paragraph" l10n="CHG" oldref="2">Assume you have hidden a few rows in a cell range. Now you want to copy, delete, or format only the remaining visible rows.</paragraph> 45<paragraph xml-lang="en-US" id="par_id3154729" role="paragraph" l10n="CHG" oldref="3">$[officename] behavior depends on how the cells were made invisible, by a filter or manually.</paragraph> 46<table id="tbl_id3154942"> 47<tablerow> 48<tablecell> 49<paragraph xml-lang="en-US" id="par_id3155603" role="tablehead" l10n="U" oldref="4">Method and Action</paragraph> 50</tablecell> 51<tablecell> 52<paragraph xml-lang="en-US" id="par_id3150751" role="tablehead" l10n="U" oldref="5">Result</paragraph> 53</tablecell> 54</tablerow> 55<tablerow> 56<tablecell> 57<paragraph xml-lang="en-US" id="par_id3149018" role="tablecontent" l10n="U" oldref="6">Cells were filtered by AutoFilters, standard filters or advanced filters.</paragraph> 58<paragraph xml-lang="en-US" id="par_id3150044" role="tablecontent" l10n="CHG" oldref="7">Copy, delete, move, or format a selection of currently visible cells.</paragraph> 59</tablecell> 60<tablecell> 61<paragraph xml-lang="en-US" id="par_id3146918" role="tablecontent" l10n="CHG" oldref="8">Only the visible cells of the selection are copied, deleted, moved, or formatted.</paragraph> 62</tablecell> 63</tablerow> 64<tablerow> 65<tablecell> 66<paragraph xml-lang="en-US" id="par_id3166427" role="tablecontent" l10n="U" oldref="12">Cells were hidden using the <emph>Hide</emph> command in the context menu of the row or column headers, or through an <link href="text/scalc/01/12080000.xhp" name="outline">outline</link>.</paragraph> 67<paragraph xml-lang="en-US" id="par_id3152990" role="tablecontent" l10n="CHG" oldref="13">Copy, delete, move, or format a selection of currently visible cells.</paragraph> 68</tablecell> 69<tablecell> 70<paragraph xml-lang="en-US" id="par_id3154371" role="tablecontent" l10n="CHG" oldref="14">All cells of the selection, including the hidden cells, are copied, deleted, moved, or formatted.</paragraph> 71</tablecell> 72</tablerow> 73</table> 74<section id="relatedtopics"> 75<embed href="text/scalc/guide/filters.xhp#filters"/> 76<embed href="text/scalc/guide/autofilter.xhp#autofilter"/> 77<embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> 78</section> 79</body>
|
84</helpdocument>
| 80</helpdocument>
|