1 files changed, 163 insertions, 0 deletions
diff --git a/source/text/scalc/guide/main.xhp b/source/text/scalc/guide/main.xhp
new file mode 100644
index 0000000000..8d23ff37ed
--- /dev/null
+++ b/source/text/scalc/guide/main.xhp
@@ -0,0 +1,163 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+
+<!--
+ ***********************************************************************
+ *
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+ * 
+ * Copyright 2000, 2010 Oracle and/or its affiliates.
+ *
+ * OpenOffice.org - a multi-platform office productivity suite
+ *
+ * This file is part of OpenOffice.org.
+ *
+ * OpenOffice.org is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License version 3
+ * only, as published by the Free Software Foundation.
+ *
+ * OpenOffice.org is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU Lesser General Public License version 3 for more details
+ * (a copy is included in the LICENSE file that accompanied this code).
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * version 3 along with OpenOffice.org.  If not, see
+ * <http://www.openoffice.org/license.html>
+ * for a copy of the LGPLv3 License.
+ *
+ ************************************************************************
+ -->
+
+
+		<helpdocument version="1.0">
+<meta>
+<topic id="textscalcguidemainxml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Instructions for Using $[officename] Calc</title>
+<filename>/text/scalc/guide/main.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3150770"><bookmark_value>HowTos for Calc</bookmark_value>
+<bookmark_value>instructions; $[officename] Calc</bookmark_value>
+</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>
+</variable></paragraph>
+<embed href="text/shared/00/00000099.xhp#table"/>
+<paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="2" l10n="U" oldref="2">Formatting Tables and Cells</paragraph>
+<embed href="text/scalc/guide/line_fix.xhp#line_fix"/>
+<embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/>
+<embed href="text/scalc/guide/currency_format.xhp#currency_format"/>
+<embed href="text/scalc/guide/auto_off.xhp#auto_off"/>
+<embed href="text/scalc/guide/format_table.xhp#format_table"/>
+<embed href="text/scalc/guide/autoformat.xhp#autoformat"/>
+<embed href="text/scalc/guide/design.xhp#design"/>
+<embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/>
+<embed href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/>
+<embed href="text/shared/guide/undo_formatting.xhp#undo_formatting"/>
+<embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/>
+<embed href="text/scalc/guide/mark_cells.xhp#mark_cells"/>
+<embed href="text/scalc/guide/table_cellmerge.xhp#table_cellmerge"/>
+<embed href="text/scalc/guide/format_value.xhp#format_value"/>
+<embed href="text/scalc/guide/format_value_userdef.xhp#format_value_userdef"/>
+<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/>
+<embed href="text/scalc/guide/numbers_text.xhp#numbers_text"/>  
+<embed href="text/scalc/guide/note_insert.xhp#note_insert"/>
+<embed href="text/scalc/guide/rename_table.xhp#rename_table"/>
+<embed href="text/scalc/guide/row_height.xhp#row_height"/>
+<embed href="text/scalc/guide/table_view.xhp#table_view"/>
+<embed href="text/scalc/guide/rounding_numbers.xhp#rounding_numbers"/>
+<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/>
+<embed href="text/shared/guide/paintbrush.xhp#formatpaintbrush"/>
+<embed href="text/shared/guide/breaking_lines.xhp#breaking_lines"/>
+<embed href="text/scalc/guide/text_rotate.xhp#text_rotate"/>
+<embed href="text/scalc/guide/text_wrap.xhp#text_wrap"/>
+<embed href="text/scalc/guide/super_subscript.xhp#super_subscript"/>
+<embed href="text/shared/guide/insert_specialchar.xhp#insert_specialchar"/>
+<embed href="text/shared/guide/text_color.xhp#text_color"/>
+<embed href="text/shared/guide/textmode_change.xhp#textmode_change"/>
+<embed href="text/shared/guide/space_hyphen.xhp#space_hyphen"/>
+<embed href="text/shared/guide/redlining_enter.xhp#redlining_enter"/>
+<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="2" l10n="U" oldref="3">Entering Values and Formulas</paragraph>
+<embed href="text/scalc/guide/cell_enter.xhp#cell_enter"/>
+<embed href="text/scalc/guide/formulas.xhp#formulas"/>
+<embed href="text/scalc/guide/formula_value.xhp#formula_value"/>
+<embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/>
+<embed href="text/scalc/guide/formula_copy.xhp#formula_copy"/>
+<embed href="text/scalc/guide/calculate.xhp#calculate"/>
+<embed href="text/scalc/guide/calc_date.xhp#calc_date"/>
+<embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/>
+<embed href="text/scalc/guide/fraction_enter.xhp#fraction_enter"/>
+<embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/>
+<embed href="text/scalc/guide/multitables.xhp#multitables"/>
+<embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/>
+<embed href="text/scalc/guide/calc_series.xhp#calc_series"/>
+<embed href="text/scalc/guide/sorted_list.xhp#sorted_list"/>
+<embed href="text/scalc/guide/filters.xhp#filters"/>
+<embed href="text/scalc/guide/autofilter.xhp#autofilter"/>
+<embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/>
+<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/>
+<embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/>
+<embed href="text/scalc/guide/table_rotate.xhp#table_rotate"/>
+<embed href="text/scalc/guide/userdefined_function.xhp#userdefined_function"/>
+<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>
+<embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/>
+<embed href="text/scalc/guide/address_auto.xhp#address_auto"/>
+<embed href="text/scalc/guide/cellreference_dragdrop.xhp#cellreference_dragdrop"/>
+<embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/>
+<embed href="text/scalc/guide/cellreferences_url.xhp#cellreferences_url"/>
+<embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/>
+<embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/>
+<embed href="text/scalc/guide/webquery.xhp#webquery"/>
+<paragraph role="heading" id="hd_id3155382" xml-lang="en-US" level="2" l10n="U" oldref="5">Database Ranges in Tables</paragraph>
+<embed href="text/scalc/guide/database_define.xhp#database_define"/>
+<embed href="text/scalc/guide/database_filter.xhp#database_filter"/>
+<embed href="text/scalc/guide/database_sort.xhp#database_sort"/>
+<paragraph role="heading" id="hd_id3159229" xml-lang="en-US" level="2" l10n="U" oldref="6">Advanced Calculations</paragraph>
+<embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
+<embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
+<embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/>
+<embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
+<embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
+<embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
+<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
+<embed href="text/scalc/guide/consolidate.xhp#consolidate"/>
+<embed href="text/scalc/guide/goalseek.xhp#goalseek"/>
+<embed href="text/scalc/guide/multioperation.xhp#multioperation"/>
+<embed href="text/scalc/guide/validity.xhp#validity"/>
+<embed href="text/scalc/guide/scenario.xhp#scenario"/>
+<paragraph role="heading" id="hd_id3153070" xml-lang="en-US" level="2" l10n="U" oldref="7">Printing and Page Preview</paragraph>
+<embed href="text/scalc/guide/printranges.xhp#printranges"/>
+<embed href="text/scalc/guide/print_details.xhp#print_details"/>
+<embed href="text/scalc/guide/print_exact.xhp#print_exact"/>
+<embed href="text/scalc/guide/print_landscape.xhp#print_landscape"/>
+<embed href="text/scalc/guide/print_title_row.xhp#print_title_row"/>
+<embed href="text/shared/guide/background.xhp#background"/>
+<paragraph role="heading" id="hd_id3150437" xml-lang="en-US" level="2" l10n="U" oldref="8">Importing and Exporting Documents</paragraph>
+<embed href="text/scalc/guide/csv_files.xhp#csv_files"/>
+<embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/>
+<embed href="text/scalc/guide/dbase_files.xhp#dbase_files"/>
+<embed href="text/scalc/guide/html_doc.xhp#html_doc"/>
+<embed href="text/shared/guide/email.xhp#email"/>
+<embed href="text/shared/guide/import_ms.xhp#import_ms"/>
+<embed href="text/shared/guide/export_ms.xhp#export_ms"/>
+<paragraph role="heading" id="hd_id3166464" xml-lang="en-US" level="2" l10n="U" oldref="9">Miscellaneous</paragraph>
+<embed href="text/scalc/guide/keyboard.xhp#keyboard"/>
+<embed href="text/shared/guide/pasting.xhp#pasting"/>
+<embed href="text/shared/guide/workfolder.xhp#workfolder"/>
+<embed href="text/scalc/guide/cell_protect.xhp#cell_protect"/>
+<embed href="text/scalc/guide/cell_unprotect.xhp#cell_unprotect"/>
+<embed href="text/scalc/guide/line_fix.xhp#line_fix"/>
+<embed href="text/scalc/guide/note_insert.xhp#note_insert"/>
+<embed href="text/scalc/guide/table_rotate.xhp#table_rotate"/>
+<embed href="text/scalc/guide/userdefined_function.xhp#userdefined_function"/>
+<embed href="text/scalc/guide/webquery.xhp#webquery"/>
+<embed href="text/scalc/guide/year2000.xhp#year2000"/>
+<embed href="text/shared/guide/insert_bitmap.xhp#insert_bitmap"/>
+<embed href="text/shared/guide/linestyles.xhp#linestyles"/>
+<embed href="text/shared/guide/lineend_define.xhp#lineend_define"/>
+<embed href="text/shared/guide/linestyle_define.xhp#linestyle_define"/>
+<embed href="text/shared/guide/macro_recording.xhp#macro_recording"/>
+</body>
+</helpdocument>