1<?xml version="1.0" encoding="UTF-8"?> 2 3 4 5<!--*********************************************************** 6 * 7 * Licensed to the Apache Software Foundation (ASF) under one 8 * or more contributor license agreements. See the NOTICE file 9 * distributed with this work for additional information 10 * regarding copyright ownership. The ASF licenses this file 11 * to you under the Apache License, Version 2.0 (the 12 * "License"); you may not use this file except in compliance 13 * with the License. You may obtain a copy of the License at 14 * 15 * http://www.apache.org/licenses/LICENSE-2.0 16 * 17 * Unless required by applicable law or agreed to in writing, 18 * software distributed under the License is distributed on an 19 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20 * KIND, either express or implied. See the License for the 21 * specific language governing permissions and limitations 22 * under the License. 23 * 24 ***********************************************************--> 25 26 27 28 29 <helpdocument version="1.0"> 30<meta> 31<topic id="textscalcguidemainxml" indexer="include" status="PUBLISH"> 32<title id="tit" xml-lang="en-US">Instructions for Using $[officename] Calc</title> 33<filename>/text/scalc/guide/main.xhp</filename> 34</topic> 35</meta> 36<body> 37<bookmark xml-lang="en-US" branch="index" id="bm_id3150770"><bookmark_value>HowTos for Calc</bookmark_value> 38<bookmark_value>instructions; $[officename] Calc</bookmark_value> 39</bookmark><comment>MWdeleted one entry and added one</comment><paragraph role="heading" id="hd_id3150770" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="main"><link href="text/scalc/guide/main.xhp" name="Instructions for Using $[officename] Calc">Instructions for Using $[officename] Calc</link> 40</variable></paragraph> 41<embed href="text/shared/00/00000099.xhp#table"/> 42<paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="2" l10n="U" oldref="2">Formatting Tables and Cells</paragraph> 43<embed href="text/scalc/guide/line_fix.xhp#line_fix"/> 44<embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/> 45<embed href="text/scalc/guide/currency_format.xhp#currency_format"/> 46<embed href="text/scalc/guide/auto_off.xhp#auto_off"/> 47<embed href="text/scalc/guide/format_table.xhp#format_table"/> 48<embed href="text/scalc/guide/autoformat.xhp#autoformat"/> 49<embed href="text/scalc/guide/design.xhp#design"/> 50<embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/> 51<embed href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> 52<embed href="text/shared/guide/undo_formatting.xhp#undo_formatting"/> 53<embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/> 54<embed href="text/scalc/guide/mark_cells.xhp#mark_cells"/> 55<embed href="text/scalc/guide/table_cellmerge.xhp#table_cellmerge"/> 56<embed href="text/scalc/guide/format_value.xhp#format_value"/> 57<embed href="text/scalc/guide/format_value_userdef.xhp#format_value_userdef"/> 58<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> 59<embed href="text/scalc/guide/numbers_text.xhp#numbers_text"/> 60<embed href="text/scalc/guide/note_insert.xhp#note_insert"/> 61<embed href="text/scalc/guide/rename_table.xhp#rename_table"/> 62<embed href="text/scalc/guide/row_height.xhp#row_height"/> 63<embed href="text/scalc/guide/table_view.xhp#table_view"/> 64<embed href="text/scalc/guide/rounding_numbers.xhp#rounding_numbers"/> 65<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> 66<embed href="text/shared/guide/paintbrush.xhp#formatpaintbrush"/> 67<embed href="text/shared/guide/breaking_lines.xhp#breaking_lines"/> 68<embed href="text/scalc/guide/text_rotate.xhp#text_rotate"/> 69<embed href="text/scalc/guide/text_wrap.xhp#text_wrap"/> 70<embed href="text/scalc/guide/super_subscript.xhp#super_subscript"/> 71<embed href="text/shared/guide/insert_specialchar.xhp#insert_specialchar"/> 72<embed href="text/shared/guide/text_color.xhp#text_color"/> 73<embed href="text/shared/guide/textmode_change.xhp#textmode_change"/> 74<embed href="text/shared/guide/space_hyphen.xhp#space_hyphen"/> 75<embed href="text/shared/guide/redlining_enter.xhp#redlining_enter"/> 76<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="2" l10n="U" oldref="3">Entering Values and Formulas</paragraph> 77<embed href="text/scalc/guide/cell_enter.xhp#cell_enter"/> 78<embed href="text/scalc/guide/formulas.xhp#formulas"/> 79<embed href="text/scalc/guide/formula_value.xhp#formula_value"/> 80<embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/> 81<embed href="text/scalc/guide/formula_copy.xhp#formula_copy"/> 82<embed href="text/scalc/guide/calculate.xhp#calculate"/> 83<embed href="text/scalc/guide/calc_date.xhp#calc_date"/> 84<embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/> 85<embed href="text/scalc/guide/fraction_enter.xhp#fraction_enter"/> 86<embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/> 87<embed href="text/scalc/guide/multitables.xhp#multitables"/> 88<embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/> 89<embed href="text/scalc/guide/calc_series.xhp#calc_series"/> 90<embed href="text/scalc/guide/sorted_list.xhp#sorted_list"/> 91<embed href="text/scalc/guide/filters.xhp#filters"/> 92<embed href="text/scalc/guide/autofilter.xhp#autofilter"/> 93<embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> 94<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> 95<embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/> 96<embed href="text/scalc/guide/table_rotate.xhp#table_rotate"/> 97<embed href="text/scalc/guide/userdefined_function.xhp#userdefined_function"/> 98<paragraph role="heading" id="hd_id3152899" xml-lang="en-US" level="2" l10n="U" oldref="4">Entering References<comment>mw deleted link to Calc guide address_byname.xhp</comment></paragraph> 99<embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/> 100<embed href="text/scalc/guide/address_auto.xhp#address_auto"/> 101<embed href="text/scalc/guide/cellreference_dragdrop.xhp#cellreference_dragdrop"/> 102<embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> 103<embed href="text/scalc/guide/cellreferences_url.xhp#cellreferences_url"/> 104<embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> 105<embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/> 106<embed href="text/scalc/guide/webquery.xhp#webquery"/> 107<paragraph role="heading" id="hd_id3155382" xml-lang="en-US" level="2" l10n="U" oldref="5">Database Ranges in Tables</paragraph> 108<embed href="text/scalc/guide/database_define.xhp#database_define"/> 109<embed href="text/scalc/guide/database_filter.xhp#database_filter"/> 110<embed href="text/scalc/guide/database_sort.xhp#database_sort"/> 111<paragraph role="heading" id="hd_id3159229" xml-lang="en-US" level="2" l10n="U" oldref="6">Advanced Calculations</paragraph> 112<embed href="text/scalc/guide/datapilot.xhp#datapilot"/> 113<embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> 114<embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/> 115<embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/> 116<embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/> 117<embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/> 118<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/> 119<embed href="text/scalc/guide/consolidate.xhp#consolidate"/> 120<embed href="text/scalc/guide/goalseek.xhp#goalseek"/> 121<embed href="text/scalc/guide/multioperation.xhp#multioperation"/> 122<embed href="text/scalc/guide/validity.xhp#validity"/> 123<embed href="text/scalc/guide/scenario.xhp#scenario"/> 124<paragraph role="heading" id="hd_id3153070" xml-lang="en-US" level="2" l10n="U" oldref="7">Printing and Page Preview</paragraph> 125<embed href="text/scalc/guide/printranges.xhp#printranges"/> 126<embed href="text/scalc/guide/print_details.xhp#print_details"/> 127<embed href="text/scalc/guide/print_exact.xhp#print_exact"/> 128<embed href="text/scalc/guide/print_landscape.xhp#print_landscape"/> 129<embed href="text/scalc/guide/print_title_row.xhp#print_title_row"/> 130<embed href="text/shared/guide/background.xhp#background"/> 131<paragraph role="heading" id="hd_id3150437" xml-lang="en-US" level="2" l10n="U" oldref="8">Importing and Exporting Documents</paragraph> 132<embed href="text/scalc/guide/csv_files.xhp#csv_files"/> 133<embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/> 134<embed href="text/scalc/guide/dbase_files.xhp#dbase_files"/> 135<embed href="text/scalc/guide/html_doc.xhp#html_doc"/> 136<embed href="text/shared/guide/email.xhp#email"/> 137<embed href="text/shared/guide/import_ms.xhp#import_ms"/> 138<embed href="text/shared/guide/export_ms.xhp#export_ms"/> 139<paragraph role="heading" id="hd_id3166464" xml-lang="en-US" level="2" l10n="U" oldref="9">Miscellaneous</paragraph> 140<embed href="text/scalc/guide/keyboard.xhp#keyboard"/> 141<embed href="text/shared/guide/pasting.xhp#pasting"/> 142<embed href="text/shared/guide/workfolder.xhp#workfolder"/> 143<embed href="text/scalc/guide/cell_protect.xhp#cell_protect"/> 144<embed href="text/scalc/guide/cell_unprotect.xhp#cell_unprotect"/> 145<embed href="text/scalc/guide/line_fix.xhp#line_fix"/> 146<embed href="text/scalc/guide/note_insert.xhp#note_insert"/> 147<embed href="text/scalc/guide/table_rotate.xhp#table_rotate"/> 148<embed href="text/scalc/guide/userdefined_function.xhp#userdefined_function"/> 149<embed href="text/scalc/guide/webquery.xhp#webquery"/> 150<embed href="text/scalc/guide/year2000.xhp#year2000"/> 151<embed href="text/shared/guide/insert_bitmap.xhp#insert_bitmap"/> 152<embed href="text/shared/guide/linestyles.xhp#linestyles"/> 153<embed href="text/shared/guide/lineend_define.xhp#lineend_define"/> 154<embed href="text/shared/guide/linestyle_define.xhp#linestyle_define"/> 155<embed href="text/shared/guide/macro_recording.xhp#macro_recording"/> 156</body> 157</helpdocument> 158