1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3cdf0e10cSrcweir 4*ce44d6c1SAndrew Rist<!--*********************************************************** 5cdf0e10cSrcweir * 6*ce44d6c1SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 7*ce44d6c1SAndrew Rist * or more contributor license agreements. See the NOTICE file 8*ce44d6c1SAndrew Rist * distributed with this work for additional information 9*ce44d6c1SAndrew Rist * regarding copyright ownership. The ASF licenses this file 10*ce44d6c1SAndrew Rist * to you under the Apache License, Version 2.0 (the 11*ce44d6c1SAndrew Rist * "License"); you may not use this file except in compliance 12*ce44d6c1SAndrew Rist * with the License. You may obtain a copy of the License at 13*ce44d6c1SAndrew Rist * 14*ce44d6c1SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 15*ce44d6c1SAndrew Rist * 16*ce44d6c1SAndrew Rist * Unless required by applicable law or agreed to in writing, 17*ce44d6c1SAndrew Rist * software distributed under the License is distributed on an 18*ce44d6c1SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*ce44d6c1SAndrew Rist * KIND, either express or implied. See the License for the 20*ce44d6c1SAndrew Rist * specific language governing permissions and limitations 21*ce44d6c1SAndrew Rist * under the License. 22*ce44d6c1SAndrew Rist * 23*ce44d6c1SAndrew Rist ***********************************************************--> 24*ce44d6c1SAndrew Rist 25*ce44d6c1SAndrew Rist<helpdocument version="1.0"> 26cdf0e10cSrcweir<meta> 27cdf0e10cSrcweir<topic id="textscalcmain0503xml" indexer="include" status="PUBLISH"> 28cdf0e10cSrcweir<title xml-lang="en-US" id="tit">$[officename] Calc Features</title> 29cdf0e10cSrcweir<filename>/text/scalc/main0503.xhp</filename> 30cdf0e10cSrcweir</topic> 31cdf0e10cSrcweir<history> 32cdf0e10cSrcweir<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 33cdf0e10cSrcweir<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> 34cdf0e10cSrcweir</history> 35cdf0e10cSrcweir</meta> 36cdf0e10cSrcweir<body> 37cdf0e10cSrcweir 38cdf0e10cSrcweir 39cdf0e10cSrcweir <section id="waskann"> 40cdf0e10cSrcweir <paragraph id="hd_id3154758" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><variable id="main0503"><link href="text/scalc/main0503.xhp" name="$[officename] Calc Features">$[officename] Calc Features</link></variable></paragraph> 41cdf0e10cSrcweir <paragraph role="paragraph" id="par_id3149457" l10n="U" xml-lang="en-US" oldref="2">$[officename] Calc is a spreadsheet application that you can use to calculate, analyze, and manage your data. You can also import and modify Microsoft Excel spreadsheets.</paragraph> 42cdf0e10cSrcweir </section> 43cdf0e10cSrcweir <paragraph role="heading" level="2" id="hd_id3148797" l10n="U" xml-lang="en-US" oldref="4">Calculations</paragraph> 44cdf0e10cSrcweir <paragraph xml-lang="en-US" role="paragraph" id="par_id3145172" l10n="U" oldref="5">$[officename] Calc provides you with <link href="text/scalc/01/04060100.xhp" name="functions">functions</link>, including statistical and banking functions, that you can use to create formulas to perform complex calculations on your data.</paragraph> 45cdf0e10cSrcweir <paragraph xml-lang="en-US" role="paragraph" id="par_id3145271" l10n="U" oldref="6">You can also use the <link href="text/scalc/01/04060000.xhp" name="AutoPilots">Function Wizard</link> to help you create your formulas.</paragraph> 46cdf0e10cSrcweir <paragraph role="heading" level="2" id="hd_id3152596" l10n="U" xml-lang="en-US" oldref="13">What-If Calculations</paragraph> 47cdf0e10cSrcweir <paragraph role="paragraph" id="par_id3156444" l10n="U" xml-lang="en-US" oldref="14">An interesting feature is to be able to immediately view the results of changes made to one factor of calculations that are composed of several factors. For instance, you can see how changing the time period in a loan calculation affects the interest rates or repayment amounts. Furthermore, you can manage larger tables by using different predefined scenarios.</paragraph> 48cdf0e10cSrcweir <paragraph role="heading" level="2" id="hd_id3148576" l10n="U" xml-lang="en-US" oldref="7">Database Functions</paragraph> 49cdf0e10cSrcweir <paragraph role="paragraph" id="par_id3154011" l10n="U" xml-lang="en-US" oldref="8">Use spreadsheets to arrange, store, and filter your data.</paragraph> 50cdf0e10cSrcweir <paragraph role="paragraph" id="par_id3154942" l10n="U" xml-lang="en-US" oldref="25">$[officename] Calc lets you drag-and-drop tables from databases, or lets you use a spreadsheet as a data source for creating form letters in $[officename] Writer.</paragraph> 51cdf0e10cSrcweir <paragraph role="heading" level="2" id="hd_id3145800" l10n="U" xml-lang="en-US" oldref="9">Arranging Data</paragraph> 52cdf0e10cSrcweir <paragraph role="paragraph" id="par_id3154490" l10n="U" xml-lang="en-US" oldref="10">With a few mouse-clicks, you can reorganize your spreadsheet to show or hide certain data ranges, or to format ranges according to special conditions, or to quickly calculate subtotals and totals.</paragraph> 53cdf0e10cSrcweir <paragraph role="heading" level="2" id="hd_id3155601" l10n="U" xml-lang="en-US" oldref="16">Dynamic Charts</paragraph> 54cdf0e10cSrcweir <paragraph role="paragraph" id="par_id3149121" l10n="U" xml-lang="en-US" oldref="17">$[officename] Calc lets you present spreadsheet data in dynamic charts that update automatically when the data changes.</paragraph> 55cdf0e10cSrcweir <paragraph role="heading" level="2" id="hd_id3153707" l10n="U" xml-lang="en-US" oldref="18">Opening and Saving Microsoft Files</paragraph> 56cdf0e10cSrcweir <paragraph xml-lang="en-US" role="paragraph" id="par_id3157867" l10n="U" oldref="19">Use the $[officename] filters to convert Excel files, or to open and save in a variety of other <link href="text/shared/00/00000020.xhp" name="formats">formats</link>.</paragraph> 57cdf0e10cSrcweir </body> 58cdf0e10cSrcweir</helpdocument> 59