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