|
main0218.xhp par_idN106A8 help.text
|
<link href="text/scalc/01/12090100.xhp">Start</link>
|
|
|
main0218.xhp par_idN106C0 help.text
|
<link href="text/shared/autopi/01150000.xhp" name="Euro Converter">Euro Converter</link>
|
|
|
main0218.xhp par_idN106D8 help.text
|
<link href="text/scalc/01/04070100.xhp">Define</link>
|
|
|
main0218.xhp par_idN106F0 help.text
|
<link href="text/scalc/01/06040000.xhp" name="Goal Seek">Goal Seek</link>
|
|
|
main0503.xhp tit help.text
|
$[officename] Calc Features
|
|
|
main0503.xhp hd_id3154758 help.text
|
<variable id="main0503"><link href="text/scalc/main0503.xhp" name="$[officename] Calc Features">$[officename] Calc Features</link></variable>
|
|
|
main0503.xhp par_id3149457 help.text
|
$[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.
|
|
|
main0503.xhp hd_id3148797 help.text
|
Calculations
|
|
|
main0503.xhp par_id3145172 help.text
|
$[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.
|
|
|
main0503.xhp par_id3145271 help.text
|
You can also use the <link href="text/scalc/01/04060000.xhp" name="AutoPilots">Function Wizard</link> to help you create your formulas.
|
|
|
main0503.xhp hd_id3152596 help.text
|
What-If Calculations
|
|
|
main0503.xhp par_id3156444 help.text
|
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.
|
|
|
main0503.xhp hd_id3148576 help.text
|
Database Functions
|
|
|
main0503.xhp par_id3154011 help.text
|
Use spreadsheets to arrange, store, and filter your data.
|
|
|
main0503.xhp par_id3154942 help.text
|
$[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.
|
|
|
main0503.xhp hd_id3145800 help.text
|
Arranging Data
|
|
|
main0503.xhp par_id3154490 help.text
|
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.
|
|
|
main0503.xhp hd_id3155601 help.text
|
Dynamic Charts
|
|
|
main0503.xhp par_id3149121 help.text
|
$[officename] Calc lets you present spreadsheet data in dynamic charts that update automatically when the data changes.
|
|
|
main0503.xhp hd_id3153707 help.text
|
Opening and Saving Microsoft Files
|
|