1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 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 12 * 13 * http://www.apache.org/licenses/LICENSE-2.0 14 * 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. 21 * 22 ***********************************************************--> 23 24<helpdocument version="1.0"> 25<meta> 26<topic id="textscalcguidemainxml" indexer="include" status="PUBLISH"> 27<title id="tit" xml-lang="en-US">Instructions for Using $[officename] Calc</title> 28<filename>/text/scalc/guide/main.xhp</filename> 29</topic> 30</meta> 31<body> 32<bookmark xml-lang="en-US" branch="index" id="bm_id3150770"><bookmark_value>HowTos for Calc</bookmark_value> 33<bookmark_value>instructions; $[officename] Calc</bookmark_value> 34</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> 35</variable></paragraph> 36<embed href="text/shared/00/00000099.xhp#table"/> 37<paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="2" l10n="U" oldref="2">Formatting Tables and Cells</paragraph> 38<embed href="text/scalc/guide/line_fix.xhp#line_fix"/> 39<embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/> 40<embed href="text/scalc/guide/currency_format.xhp#currency_format"/> 41<embed href="text/scalc/guide/auto_off.xhp#auto_off"/> 42<embed href="text/scalc/guide/format_table.xhp#format_table"/> 43<embed href="text/scalc/guide/autoformat.xhp#autoformat"/> 44<embed href="text/scalc/guide/design.xhp#design"/> 45<embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/> 46<embed href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> 47<embed href="text/shared/guide/undo_formatting.xhp#undo_formatting"/> 48<embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/> 49<embed href="text/scalc/guide/mark_cells.xhp#mark_cells"/> 50<embed href="text/scalc/guide/table_cellmerge.xhp#table_cellmerge"/> 51<embed href="text/scalc/guide/format_value.xhp#format_value"/> 52<embed href="text/scalc/guide/format_value_userdef.xhp#format_value_userdef"/> 53<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> 54<embed href="text/scalc/guide/numbers_text.xhp#numbers_text"/> 55<embed href="text/scalc/guide/note_insert.xhp#note_insert"/> 56<embed href="text/scalc/guide/rename_table.xhp#rename_table"/> 57<embed href="text/scalc/guide/row_height.xhp#row_height"/> 58<embed href="text/scalc/guide/table_view.xhp#table_view"/> 59<embed href="text/scalc/guide/rounding_numbers.xhp#rounding_numbers"/> 60<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> 61<embed href="text/shared/guide/paintbrush.xhp#formatpaintbrush"/> 62<embed href="text/shared/guide/breaking_lines.xhp#breaking_lines"/> 63<embed href="text/scalc/guide/text_rotate.xhp#text_rotate"/> 64<embed href="text/scalc/guide/text_wrap.xhp#text_wrap"/> 65<embed href="text/scalc/guide/super_subscript.xhp#super_subscript"/> 66<embed href="text/shared/guide/insert_specialchar.xhp#insert_specialchar"/> 67<embed href="text/shared/guide/text_color.xhp#text_color"/> 68<embed href="text/shared/guide/textmode_change.xhp#textmode_change"/> 69<embed href="text/shared/guide/space_hyphen.xhp#space_hyphen"/> 70<embed href="text/shared/guide/redlining_enter.xhp#redlining_enter"/> 71<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="2" l10n="U" oldref="3">Entering Values and Formulas</paragraph> 72<embed href="text/scalc/guide/cell_enter.xhp#cell_enter"/> 73<embed href="text/scalc/guide/formulas.xhp#formulas"/> 74<embed href="text/scalc/guide/formula_value.xhp#formula_value"/> 75<embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/> 76<embed href="text/scalc/guide/formula_copy.xhp#formula_copy"/> 77<embed href="text/scalc/guide/calculate.xhp#calculate"/> 78<embed href="text/scalc/guide/calc_date.xhp#calc_date"/> 79<embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/> 80<embed href="text/scalc/guide/fraction_enter.xhp#fraction_enter"/> 81<embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/> 82<embed href="text/scalc/guide/multitables.xhp#multitables"/> 83<embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/> 84<embed href="text/scalc/guide/calc_series.xhp#calc_series"/> 85<embed href="text/scalc/guide/sorted_list.xhp#sorted_list"/> 86<embed href="text/scalc/guide/filters.xhp#filters"/> 87<embed href="text/scalc/guide/autofilter.xhp#autofilter"/> 88<embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> 89<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> 90<embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/> 91<embed href="text/scalc/guide/table_rotate.xhp#table_rotate"/> 92<embed href="text/scalc/guide/userdefined_function.xhp#userdefined_function"/> 93<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> 94<embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/> 95<embed href="text/scalc/guide/address_auto.xhp#address_auto"/> 96<embed href="text/scalc/guide/cellreference_dragdrop.xhp#cellreference_dragdrop"/> 97<embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> 98<embed href="text/scalc/guide/cellreferences_url.xhp#cellreferences_url"/> 99<embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> 100<embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/> 101<embed href="text/scalc/guide/webquery.xhp#webquery"/> 102<paragraph role="heading" id="hd_id3155382" xml-lang="en-US" level="2" l10n="U" oldref="5">Database Ranges in Tables</paragraph> 103<embed href="text/scalc/guide/database_define.xhp#database_define"/> 104<embed href="text/scalc/guide/database_filter.xhp#database_filter"/> 105<embed href="text/scalc/guide/database_sort.xhp#database_sort"/> 106<paragraph role="heading" id="hd_id3159229" xml-lang="en-US" level="2" l10n="U" oldref="6">Advanced Calculations</paragraph> 107<embed href="text/scalc/guide/datapilot.xhp#datapilot"/> 108<embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> 109<embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/> 110<embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/> 111<embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/> 112<embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/> 113<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/> 114<embed href="text/scalc/guide/consolidate.xhp#consolidate"/> 115<embed href="text/scalc/guide/goalseek.xhp#goalseek"/> 116<embed href="text/scalc/guide/multioperation.xhp#multioperation"/> 117<embed href="text/scalc/guide/validity.xhp#validity"/> 118<embed href="text/scalc/guide/scenario.xhp#scenario"/> 119<paragraph role="heading" id="hd_id3153070" xml-lang="en-US" level="2" l10n="U" oldref="7">Printing and Page Preview</paragraph> 120<embed href="text/scalc/guide/printranges.xhp#printranges"/> 121<embed href="text/scalc/guide/print_details.xhp#print_details"/> 122<embed href="text/scalc/guide/print_exact.xhp#print_exact"/> 123<embed href="text/scalc/guide/print_landscape.xhp#print_landscape"/> 124<embed href="text/scalc/guide/print_title_row.xhp#print_title_row"/> 125<embed href="text/shared/guide/background.xhp#background"/> 126<paragraph role="heading" id="hd_id3150437" xml-lang="en-US" level="2" l10n="U" oldref="8">Importing and Exporting Documents</paragraph> 127<embed href="text/scalc/guide/csv_files.xhp#csv_files"/> 128<embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/> 129<embed href="text/scalc/guide/dbase_files.xhp#dbase_files"/> 130<embed href="text/scalc/guide/html_doc.xhp#html_doc"/> 131<embed href="text/shared/guide/email.xhp#email"/> 132<embed href="text/shared/guide/import_ms.xhp#import_ms"/> 133<embed href="text/shared/guide/export_ms.xhp#export_ms"/> 134<paragraph role="heading" id="hd_id3166464" xml-lang="en-US" level="2" l10n="U" oldref="9">Miscellaneous</paragraph> 135<embed href="text/scalc/guide/keyboard.xhp#keyboard"/> 136<embed href="text/shared/guide/pasting.xhp#pasting"/> 137<embed href="text/shared/guide/workfolder.xhp#workfolder"/> 138<embed href="text/scalc/guide/cell_protect.xhp#cell_protect"/> 139<embed href="text/scalc/guide/cell_unprotect.xhp#cell_unprotect"/> 140<embed href="text/scalc/guide/line_fix.xhp#line_fix"/> 141<embed href="text/scalc/guide/note_insert.xhp#note_insert"/> 142<embed href="text/scalc/guide/table_rotate.xhp#table_rotate"/> 143<embed href="text/scalc/guide/userdefined_function.xhp#userdefined_function"/> 144<embed href="text/scalc/guide/webquery.xhp#webquery"/> 145<embed href="text/scalc/guide/year2000.xhp#year2000"/> 146<embed href="text/shared/guide/insert_bitmap.xhp#insert_bitmap"/> 147<embed href="text/shared/guide/linestyles.xhp#linestyles"/> 148<embed href="text/shared/guide/lineend_define.xhp#lineend_define"/> 149<embed href="text/shared/guide/linestyle_define.xhp#linestyle_define"/> 150<embed href="text/shared/guide/macro_recording.xhp#macro_recording"/> 151</body> 152</helpdocument> 153