1<?xml version="1.0" encoding="UTF-8"?> 2 3 4 5<!-- 6 *********************************************************************** 7 * 8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 9 * 10 * Copyright 2000, 2010 Oracle and/or its affiliates. 11 * 12 * OpenOffice.org - a multi-platform office productivity suite 13 * 14 * This file is part of OpenOffice.org. 15 * 16 * OpenOffice.org is free software: you can redistribute it and/or modify 17 * it under the terms of the GNU Lesser General Public License version 3 18 * only, as published by the Free Software Foundation. 19 * 20 * OpenOffice.org is distributed in the hope that it will be useful, 21 * but WITHOUT ANY WARRANTY; without even the implied warranty of 22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 23 * GNU Lesser General Public License version 3 for more details 24 * (a copy is included in the LICENSE file that accompanied this code). 25 * 26 * You should have received a copy of the GNU Lesser General Public License 27 * version 3 along with OpenOffice.org. If not, see 28 * <http://www.openoffice.org/license.html> 29 * for a copy of the LGPLv3 License. 30 * 31 ************************************************************************ 32 --> 33 34 35 <helpdocument version="1.0"> 36<meta> 37<topic id="textscalcguidemainxml" indexer="include" status="PUBLISH"> 38<title id="tit" xml-lang="en-US">Instructions for Using $[officename] Calc</title> 39<filename>/text/scalc/guide/main.xhp</filename> 40</topic> 41</meta> 42<body> 43<bookmark xml-lang="en-US" branch="index" id="bm_id3150770"><bookmark_value>HowTos for Calc</bookmark_value> 44<bookmark_value>instructions; $[officename] Calc</bookmark_value> 45</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> 46</variable></paragraph> 47<embed href="text/shared/00/00000099.xhp#table"/> 48<paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="2" l10n="U" oldref="2">Formatting Tables and Cells</paragraph> 49<embed href="text/scalc/guide/line_fix.xhp#line_fix"/> 50<embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/> 51<embed href="text/scalc/guide/currency_format.xhp#currency_format"/> 52<embed href="text/scalc/guide/auto_off.xhp#auto_off"/> 53<embed href="text/scalc/guide/format_table.xhp#format_table"/> 54<embed href="text/scalc/guide/autoformat.xhp#autoformat"/> 55<embed href="text/scalc/guide/design.xhp#design"/> 56<embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/> 57<embed href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> 58<embed href="text/shared/guide/undo_formatting.xhp#undo_formatting"/> 59<embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/> 60<embed href="text/scalc/guide/mark_cells.xhp#mark_cells"/> 61<embed href="text/scalc/guide/table_cellmerge.xhp#table_cellmerge"/> 62<embed href="text/scalc/guide/format_value.xhp#format_value"/> 63<embed href="text/scalc/guide/format_value_userdef.xhp#format_value_userdef"/> 64<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> 65<embed href="text/scalc/guide/numbers_text.xhp#numbers_text"/> 66<embed href="text/scalc/guide/note_insert.xhp#note_insert"/> 67<embed href="text/scalc/guide/rename_table.xhp#rename_table"/> 68<embed href="text/scalc/guide/row_height.xhp#row_height"/> 69<embed href="text/scalc/guide/table_view.xhp#table_view"/> 70<embed href="text/scalc/guide/rounding_numbers.xhp#rounding_numbers"/> 71<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> 72<embed href="text/shared/guide/paintbrush.xhp#formatpaintbrush"/> 73<embed href="text/shared/guide/breaking_lines.xhp#breaking_lines"/> 74<embed href="text/scalc/guide/text_rotate.xhp#text_rotate"/> 75<embed href="text/scalc/guide/text_wrap.xhp#text_wrap"/> 76<embed href="text/scalc/guide/super_subscript.xhp#super_subscript"/> 77<embed href="text/shared/guide/insert_specialchar.xhp#insert_specialchar"/> 78<embed href="text/shared/guide/text_color.xhp#text_color"/> 79<embed href="text/shared/guide/textmode_change.xhp#textmode_change"/> 80<embed href="text/shared/guide/space_hyphen.xhp#space_hyphen"/> 81<embed href="text/shared/guide/redlining_enter.xhp#redlining_enter"/> 82<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="2" l10n="U" oldref="3">Entering Values and Formulas</paragraph> 83<embed href="text/scalc/guide/cell_enter.xhp#cell_enter"/> 84<embed href="text/scalc/guide/formulas.xhp#formulas"/> 85<embed href="text/scalc/guide/formula_value.xhp#formula_value"/> 86<embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/> 87<embed href="text/scalc/guide/formula_copy.xhp#formula_copy"/> 88<embed href="text/scalc/guide/calculate.xhp#calculate"/> 89<embed href="text/scalc/guide/calc_date.xhp#calc_date"/> 90<embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/> 91<embed href="text/scalc/guide/fraction_enter.xhp#fraction_enter"/> 92<embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/> 93<embed href="text/scalc/guide/multitables.xhp#multitables"/> 94<embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/> 95<embed href="text/scalc/guide/calc_series.xhp#calc_series"/> 96<embed href="text/scalc/guide/sorted_list.xhp#sorted_list"/> 97<embed href="text/scalc/guide/filters.xhp#filters"/> 98<embed href="text/scalc/guide/autofilter.xhp#autofilter"/> 99<embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> 100<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> 101<embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/> 102<embed href="text/scalc/guide/table_rotate.xhp#table_rotate"/> 103<embed href="text/scalc/guide/userdefined_function.xhp#userdefined_function"/> 104<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> 105<embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/> 106<embed href="text/scalc/guide/address_auto.xhp#address_auto"/> 107<embed href="text/scalc/guide/cellreference_dragdrop.xhp#cellreference_dragdrop"/> 108<embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> 109<embed href="text/scalc/guide/cellreferences_url.xhp#cellreferences_url"/> 110<embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> 111<embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/> 112<embed href="text/scalc/guide/webquery.xhp#webquery"/> 113<paragraph role="heading" id="hd_id3155382" xml-lang="en-US" level="2" l10n="U" oldref="5">Database Ranges in Tables</paragraph> 114<embed href="text/scalc/guide/database_define.xhp#database_define"/> 115<embed href="text/scalc/guide/database_filter.xhp#database_filter"/> 116<embed href="text/scalc/guide/database_sort.xhp#database_sort"/> 117<paragraph role="heading" id="hd_id3159229" xml-lang="en-US" level="2" l10n="U" oldref="6">Advanced Calculations</paragraph> 118<embed href="text/scalc/guide/datapilot.xhp#datapilot"/> 119<embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> 120<embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/> 121<embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/> 122<embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/> 123<embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/> 124<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/> 125<embed href="text/scalc/guide/consolidate.xhp#consolidate"/> 126<embed href="text/scalc/guide/goalseek.xhp#goalseek"/> 127<embed href="text/scalc/guide/multioperation.xhp#multioperation"/> 128<embed href="text/scalc/guide/validity.xhp#validity"/> 129<embed href="text/scalc/guide/scenario.xhp#scenario"/> 130<paragraph role="heading" id="hd_id3153070" xml-lang="en-US" level="2" l10n="U" oldref="7">Printing and Page Preview</paragraph> 131<embed href="text/scalc/guide/printranges.xhp#printranges"/> 132<embed href="text/scalc/guide/print_details.xhp#print_details"/> 133<embed href="text/scalc/guide/print_exact.xhp#print_exact"/> 134<embed href="text/scalc/guide/print_landscape.xhp#print_landscape"/> 135<embed href="text/scalc/guide/print_title_row.xhp#print_title_row"/> 136<embed href="text/shared/guide/background.xhp#background"/> 137<paragraph role="heading" id="hd_id3150437" xml-lang="en-US" level="2" l10n="U" oldref="8">Importing and Exporting Documents</paragraph> 138<embed href="text/scalc/guide/csv_files.xhp#csv_files"/> 139<embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/> 140<embed href="text/scalc/guide/dbase_files.xhp#dbase_files"/> 141<embed href="text/scalc/guide/html_doc.xhp#html_doc"/> 142<embed href="text/shared/guide/email.xhp#email"/> 143<embed href="text/shared/guide/import_ms.xhp#import_ms"/> 144<embed href="text/shared/guide/export_ms.xhp#export_ms"/> 145<paragraph role="heading" id="hd_id3166464" xml-lang="en-US" level="2" l10n="U" oldref="9">Miscellaneous</paragraph> 146<embed href="text/scalc/guide/keyboard.xhp#keyboard"/> 147<embed href="text/shared/guide/pasting.xhp#pasting"/> 148<embed href="text/shared/guide/workfolder.xhp#workfolder"/> 149<embed href="text/scalc/guide/cell_protect.xhp#cell_protect"/> 150<embed href="text/scalc/guide/cell_unprotect.xhp#cell_unprotect"/> 151<embed href="text/scalc/guide/line_fix.xhp#line_fix"/> 152<embed href="text/scalc/guide/note_insert.xhp#note_insert"/> 153<embed href="text/scalc/guide/table_rotate.xhp#table_rotate"/> 154<embed href="text/scalc/guide/userdefined_function.xhp#userdefined_function"/> 155<embed href="text/scalc/guide/webquery.xhp#webquery"/> 156<embed href="text/scalc/guide/year2000.xhp#year2000"/> 157<embed href="text/shared/guide/insert_bitmap.xhp#insert_bitmap"/> 158<embed href="text/shared/guide/linestyles.xhp#linestyles"/> 159<embed href="text/shared/guide/lineend_define.xhp#lineend_define"/> 160<embed href="text/shared/guide/linestyle_define.xhp#linestyle_define"/> 161<embed href="text/shared/guide/macro_recording.xhp#macro_recording"/> 162</body> 163</helpdocument> 164