From 8362bf63dea22bbf6736609b0f49c152f975eb63 Mon Sep 17 00:00:00 2001 From: tpearson Date: Wed, 20 Jan 2010 01:29:50 +0000 Subject: Added old abandoned KDE3 version of koffice git-svn-id: svn://anonsvn.kde.org/home/kde/branches/trinity/applications/koffice@1077364 283d02a7-25f6-0310-bc7c-ecb5cbfe19da --- doc/kspread/Makefile.am | 4 + doc/kspread/a11y.docbook | 320 ++++++++ doc/kspread/advanced.docbook | 815 ++++++++++++++++++++ doc/kspread/basics.docbook | 637 ++++++++++++++++ doc/kspread/cellformat0.png | Bin 0 -> 6925 bytes doc/kspread/cellformat1.png | Bin 0 -> 9948 bytes doc/kspread/cellformat2.png | Bin 0 -> 12133 bytes doc/kspread/cellformat3.png | Bin 0 -> 12308 bytes doc/kspread/cellformat4.png | Bin 0 -> 9813 bytes doc/kspread/cellformat5.png | Bin 0 -> 7634 bytes doc/kspread/cellformat6.png | Bin 0 -> 7048 bytes doc/kspread/cellformat7.png | Bin 0 -> 1831 bytes doc/kspread/cellprotection1.png | Bin 0 -> 6591 bytes doc/kspread/cellprotection2.png | Bin 0 -> 5189 bytes doc/kspread/chart1.png | Bin 0 -> 5447 bytes doc/kspread/commands.docbook | 1540 ++++++++++++++++++++++++++++++++++++++ doc/kspread/config.docbook | 145 ++++ doc/kspread/configdialog.docbook | 377 ++++++++++ doc/kspread/configure1.png | Bin 0 -> 35860 bytes doc/kspread/configure2.png | Bin 0 -> 44409 bytes doc/kspread/configure3.png | Bin 0 -> 37037 bytes doc/kspread/configure4.png | Bin 0 -> 27384 bytes doc/kspread/configure5.png | Bin 0 -> 32763 bytes doc/kspread/configure6.png | Bin 0 -> 38047 bytes doc/kspread/copy1.png | Bin 0 -> 4863 bytes doc/kspread/currency.png | Bin 0 -> 1366 bytes doc/kspread/decreasedecimal.png | Bin 0 -> 1299 bytes doc/kspread/faq.docbook | 45 ++ doc/kspread/format.docbook | 693 +++++++++++++++++ doc/kspread/hideformula1.png | Bin 0 -> 2590 bytes doc/kspread/hideformula2.png | Bin 0 -> 2460 bytes doc/kspread/hideformula3.png | Bin 0 -> 2367 bytes doc/kspread/hideformula4.png | Bin 0 -> 2383 bytes doc/kspread/hideformula5.png | Bin 0 -> 2518 bytes doc/kspread/importexport.docbook | 105 +++ doc/kspread/increasedecimal.png | Bin 0 -> 1162 bytes doc/kspread/index.docbook | 207 +++++ doc/kspread/kbd-focus-ext.png | Bin 0 -> 7097 bytes doc/kspread/mousenav.png | Bin 0 -> 3673 bytes doc/kspread/newdocument.png | Bin 0 -> 14253 bytes doc/kspread/percent.png | Bin 0 -> 1039 bytes doc/kspread/sheetproperties.png | Bin 0 -> 7446 bytes doc/kspread/shortcut1.png | Bin 0 -> 11011 bytes doc/kspread/shortcut2.png | Bin 0 -> 4078 bytes doc/kspread/shortcut3.png | Bin 0 -> 5379 bytes doc/kspread/sort1.png | Bin 0 -> 5301 bytes doc/kspread/starting1.png | Bin 0 -> 6107 bytes doc/kspread/tts.png | Bin 0 -> 17345 bytes 48 files changed, 4888 insertions(+) create mode 100644 doc/kspread/Makefile.am create mode 100644 doc/kspread/a11y.docbook create mode 100644 doc/kspread/advanced.docbook create mode 100644 doc/kspread/basics.docbook create mode 100644 doc/kspread/cellformat0.png create mode 100644 doc/kspread/cellformat1.png create mode 100644 doc/kspread/cellformat2.png create mode 100644 doc/kspread/cellformat3.png create mode 100644 doc/kspread/cellformat4.png create mode 100644 doc/kspread/cellformat5.png create mode 100644 doc/kspread/cellformat6.png create mode 100644 doc/kspread/cellformat7.png create mode 100644 doc/kspread/cellprotection1.png create mode 100644 doc/kspread/cellprotection2.png create mode 100644 doc/kspread/chart1.png create mode 100644 doc/kspread/commands.docbook create mode 100644 doc/kspread/config.docbook create mode 100644 doc/kspread/configdialog.docbook create mode 100644 doc/kspread/configure1.png create mode 100644 doc/kspread/configure2.png create mode 100644 doc/kspread/configure3.png create mode 100644 doc/kspread/configure4.png create mode 100644 doc/kspread/configure5.png create mode 100644 doc/kspread/configure6.png create mode 100644 doc/kspread/copy1.png create mode 100644 doc/kspread/currency.png create mode 100644 doc/kspread/decreasedecimal.png create mode 100644 doc/kspread/faq.docbook create mode 100644 doc/kspread/format.docbook create mode 100644 doc/kspread/hideformula1.png create mode 100644 doc/kspread/hideformula2.png create mode 100644 doc/kspread/hideformula3.png create mode 100644 doc/kspread/hideformula4.png create mode 100644 doc/kspread/hideformula5.png create mode 100644 doc/kspread/importexport.docbook create mode 100644 doc/kspread/increasedecimal.png create mode 100644 doc/kspread/index.docbook create mode 100644 doc/kspread/kbd-focus-ext.png create mode 100644 doc/kspread/mousenav.png create mode 100644 doc/kspread/newdocument.png create mode 100644 doc/kspread/percent.png create mode 100644 doc/kspread/sheetproperties.png create mode 100644 doc/kspread/shortcut1.png create mode 100644 doc/kspread/shortcut2.png create mode 100644 doc/kspread/shortcut3.png create mode 100644 doc/kspread/sort1.png create mode 100644 doc/kspread/starting1.png create mode 100644 doc/kspread/tts.png (limited to 'doc/kspread') diff --git a/doc/kspread/Makefile.am b/doc/kspread/Makefile.am new file mode 100644 index 000000000..085981d9b --- /dev/null +++ b/doc/kspread/Makefile.am @@ -0,0 +1,4 @@ + +KDE_LANG = en +KDE_DOCS = AUTO + diff --git a/doc/kspread/a11y.docbook b/doc/kspread/a11y.docbook new file mode 100644 index 000000000..c7ceaee57 --- /dev/null +++ b/doc/kspread/a11y.docbook @@ -0,0 +1,320 @@ + + + + +Gary +Cramblitt + + + + + +For Users with Disabilities +This section of the documentation discusses accessibility features in &kspread; +for users with disabilities. Some of these features apply to &kde; as a whole and are controlled from +&kcontrolcenter;. Some apply to all &koffice; applications, +and some are specific to &kspread;. + + +Installing the <command>kdeaccessibility</command> Module +kdeaccessibility + +Most of the features described in this chapter are enabled by installing the +kdeaccessibility module. +The kdeaccessibility module is part of the &kde; project +http://www.kde.org. The kdeaccessibility +package can be obtained from &kde-ftp;, the +main ftp site of the &kde; project. + + +Many distributions offer precompiled binaries on their ftp sites. Please check your distribution's web sites for more information. + +More information about &kde; accessibility can be obtained by +visiting http://accessibility.kde.org/. + + + + +Visual Impairments +Visual Impairments + +&kspread; is not usable by totally blind users. It is hoped that +a general screen reader for the blind will be available in future versions of &kde;. + + + +Theming +Theming +For low-sighted or light allergic users, several features are available in the &kcontrolcenter; +Appearance & ThemesTheme Manager, +like high contrast color themes. If you are light allergic, the +HighContrastDark or HighContrastLight themes +may be helpful. If you have difficulty reading small fonts or seeing small icons, the +HighContrastDark-big or HighContrastLight-big +themes will increase the size of text, buttons, and icons. You may also customize +background, colors, fonts, and icons from the same dialog. A set of monochrome icons +is available. + + +If you choose one of the Big themes, you may discover that +some windows are too large to fit your monitor. Purchasing a larger monitor will be helpful. +You can drag the portions of the window not visible into the visible area by +holding down the &Alt; key and dragging with the &LMB; anywhere +within the screen. If you have trouble operating a mouse, you can also move screens by pressing +&Alt;F3. In +the dropdown Windows Operations Menu, choose +Move. +Move the screen with the arrow keys and press &Esc; to finish the move. + + + + + +&kmagnifier; +magnifier +The kdeaccessibility module includes a screen magnifier +application called &kmagnifier;. +If it is installed, you can run it from +K-ButtonUtilities +KMag (Screen Magnifier). + + + + +Text-to-Speech +Text-to-Speech +TTS +The kdeaccessibility module includes a Text-to-Speech +component called KTTS. If KTTS is installed, you can configure &kspread; to +speak the text that is under the mouse pointer or speak the text of each +screen widget as it receives focus. Before using this feature, first configure +KTTS. See The KTTS Handbook for details. +To turn on the TTS feature in &kspread;, +select SettingsConfigure +&kspread;... from the menubar. +This will display a dialog box. +Clicking on TTS will allow you to change +the following. + + + + + + + + + +Speak widget under mouse pointer +When checked, &kspread; will speak the text of each widget +as the mouse pointer moves over the widget. + + + +Speak widget with focus +When checked, &kspread; will speak the text of each widget +as it receives focus. + + + +Speak tool tips +When checked, &kspread; will speak the popup tool tip +for each widget in addition to the text of the widget. + + + +Speak Whats This +When checked, &kspread; will speak the Whats This help +for each widget in addition to the text of the widget. + + + +Say whether disabled +When checked, &kspread; will speak the word "disabled" +if the widget is currently disabled (grayed). + + + +Speak accelerators +When checked, &kspread; will speak the accelerator +of the widget in addition to the text of the widget. +Accelerators are the underlined letters you see in the text of the +widget. For example, in the main menu, the +Quit menu item +has the "Q" underlined. You can choose it by pressing Q. +To speak the accelerator, check this option and enter the +word you want to speak before the accelerator in the +Prefaced by the word box. In this +example shown above, &kspread; will speak "Accelerator Q". + + + +Polling interval +This option determines how often &kspread; will +check for a change in the widget under the mouse pointer or +a new focused widget. You should leave this option on the +default setting. + + + + + +If the TTS option does not appear +on this screen, you do not have the KTTS component installed +in your system. + + +Not all widgets are spoken. For example, +the items on the main menubar are not spoken. + + + + + + + +Motor Impairments and Mouseless Operation +Motor Impairments +Mouseless Operation + + +KMouseTool +If you can operate a mouse, but have trouble clicking, the +KMouseTool application may help. Run it from +K-ButtonUtilities +KMouseTool (Automatik Mouse Click). + + + + +XAccess Features +XAccess +Sticky Keys +Slow Keys +Bounce Keys + +The &kcontrolcenter; offers several keyboard features collectively called XAccess. +They include: + + +Sticky Keys +This feature permits operation of meta keys, such as +&Alt;, &Ctrl;, and &Shift; without having to hold the keys down. It is useful +when you can only use one finger or one hand to operate the keyboard. +With Sticky Keys on, press and release a &Alt;, &Ctrl;, or &Shift; key, then +press another key. The result is as if you pressed both keys at once. +Press the &Alt;, &Ctrl;, or &Shift; key again to turn off the sticky key. +Activate this feature in +K-Button&kcontrolcenter; +Regional & AccessibilityAccessibility +Modifier Keys. + + + +Slow Keys +This feature is useful if you have hand tremors or difficulty +accurately pressing keys. It prevents +inadvertent key presses by requiring that a key be held down for a minimum +time before it is accepted. Activate this feature in +K-Button&kcontrolcenter; +Regional & AccessibilityAccessibility +Keyboard Filters. + + + +Bounce Keys +This feature is also useful if you have hand tremors. It prevents +inadvertent repeated key presses by preventing another keystroke for +a certain amount of time. Activate this feature in +K-Button&kcontrolcenter; +Regional & AccessibilityAccessibility +Keyboard Filters. + + + + + + + +Mouse Emulation +Mouse Emulation +Mouse Emulation permits you to move and click the mouse using the keyboard. +Press &Alt;F12 to activate it. Use the arrow keys +to move the mouse pointer to the desired location, and press spacebar +to "click" the mouse. Unfortunately, you cannot use Mouse Emulation to perform +&RMB; clicks or dragging. + + + + +Mouse Navigation +Mouse Navigation +This feature permits you to emulate the mouse using the numeric keypad +of your keyboard. To activate it, go to +K-Button&kcontrolcenter; +PeripheralsMouse +Mouse Navigation. +Check the Move pointer with keyboard (using the num pad) box. When you do this, the other settings will become enabled, and you can customize the keyboard pointer behavior further, if required. + The various keys on the number pad move in the direction you would expect. Note that you can move diagonally as well as up, down, left and right. The 5 key emulates a click to a pointer button, typically &LMB;. You change which button is emulated by using the / key (which makes it &LMB;), +* key (which makes it middle mouse button) and - (which makes it &RMB;). + Using the + emulates a doubleclick to the selected pointer button. You can use the +0 key to emulate holding down the selected pointer button (for easy dragging), +and then use the . to emulate releasing the selected pointer button. + + + + + + + + + + + +Keyboard shortcuts + +Use the Menu key to pop up the context +menu. On most keyboards, the Menu key is on the righthand +side of the keyboard between the &Windows; and &Ctrl; +keys. It has a menu icon on it. + + + + + +Resizing panels + +If you have activated two or more views of a spreadsheet, +you can move the sizing bar between the views by pressing F8. A sizing icon appears +overtop the sizing bar. Use the arrow keys to move the bar up or down, or left or right. +Press F8 again or &Esc; when finished sizing. + + + + + +Setting focus to widgets + +Normally, one can use the and &Shift; +to move focus from one widget to the next in any application. However, in &kspread;, +pressing does not move the focus; instead it moves the cell selection forwards. +You can set focus to any widget that can receive focus by +pressing &Alt;F8. A small lettered box appears +overtop each widget on the screen that can receive focus. + + + + + + + + +Press the letter to move focus to the corresponding widget. Press +&Alt;F8 again or &Esc; +to abandon moving the focus. + + + + + + + diff --git a/doc/kspread/advanced.docbook b/doc/kspread/advanced.docbook new file mode 100644 index 000000000..f6aadfab6 --- /dev/null +++ b/doc/kspread/advanced.docbook @@ -0,0 +1,815 @@ + + + + +Pamela +Robert + +
pamroberts@blueyonder.co.uk
+ + + +Anne-Marie +Mahfouf + +
annemarie.mahfouf@free.fr
+ + + + + +Advanced &kspread; + +Series +When constructing a spreadsheet you often need to include a series of +values, such as 10, 11, 12..., in a row or column. There are several ways you +can do this in &kspread;. +For a simple short series such as 5, 6, 7, 8... the Drag and Copy + method is the simplest. Enter the starting value into the starting +cell and the next value of the series into an adjacent cell. +Then select both cells and move the mouse pointer so that it is over the small +square at the bottom right corner; the cursor will change to a +diagonal double headed arrow. Then hold the left +mouse button down while you drag the cells down or across as needed. +The step size is calculated as the difference between the two starting +values that you have entered. +For example if you enter 4 into cell A1 and +3.5 into A2 then select both cells and Drag and Copy +them down, the step size will be the value in A2 minus the value +in A1, -0.5 in this case so you will get the series 4, 3.5, 3, 2.5, 2... + +The Drag and Copy method will even cope with series where +the step value is not a constant value but is itself a series. So that if you +start with 1, 3, 4, 6 Drag and Copy will extend it to 1, 3, 4, 6, 7, 9, 10, +12..., the step value in this example being the series 2, 1, 2, 1... + +&kspread; also recognizes some special series such as +the days of the week. Try entering Friday into a cell +(note the capitalization) then Drag and Copy it down. To see what special series +are available, and perhaps create your own, select Tools +Custom Lists... . + +If you select a cell and choose Series... +from the Insert menu you will see the Series + dialog box. This is useful for creating series that are too long +to be conveniently constructed using the Drag and Copy method, or for +creating geometric series such as 1, 1.5, 2.25, 3.375... where the step value, +1.5 in this case, is used as a multiplier. +If the type of series that you want is too complicated for any of the +previous methods, consider using a formula and Drag and Copying that. For +example to create a series with the values 2, 4, 16, 256... enter +2 into A1, =A1*A1 into A2, and +Drag and Copy cell A2 down. + + + +Formulae + +Built in Functions +&kspread; has a huge range of built in mathematical and other functions +that can be used in a formula cell. They can be seen and accessed by selecting +a cell then choosing Function... from the +Insert menu. This brings up the Function + dialog box. +Select the function you want to use from the listbox at the left of the +dialog box. The Help tab page will then display a description, +the return type, Syntax, Parameters, and Examples for this function. +In addition this page provides often links to Related Functions. +Then press the button with the down arrow key symbol on it to paste +it into the text edit box at the bottom of the dialog. +The Parameters tab page will then be displayed +to let you enter the parameter(s) for the function you have just +chosen. If you want to enter an actual value for a parameter, just type it +into the appropriate text box in the Parameters page. To +enter a cell reference rather than a value, left +click on the appropriate text box in the Parameters page; +then left click on the target cell in +the spreadsheet. +Instead of using the Parameters page, cell +references such as B6 can be entered by typing them +directly into the edit box at the bottom of the Function +dialog. If a function has more than one parameter separate them with a +semi-colon (;). +Pressing the OK button will insert the +function into the current cell and close the Function +dialog. +You can of course do without the Function +dialog and simply type the complete expression into the Formula toolbar's +main edit box. Function names are not case sensitive. Do not forget that all +expressions must start with an = symbol. + + + +Logical Comparisons +Logical functions such as IF(), AND(), OR() take parameters which have the +logical (boolean) values True or False. This type of value can be produced by +other logical functions such as ISEVEN() or by the comparison of values in +spreadsheet cells using the comparison expressions given in the following +table. + + + + + Expression + Description + Example + + + +== +Is equal to +A2==B3 is True if the value in A2 is equal to +the value in B3 + + +!= +Is not equal to +A2!=B3 is True if the value in A2 is not equal +to the value in B3 + + +<> +Is not equal to +Same as A2!=B3 + + +< +Is less than +A2<B3 is True if the value in A2 is less than +the value in B3 + + +<= +Is less than or equal to +A2<=B3 is True if the value in A2 is less than +or equal to the value in B3 + + +> +Is greater than +A2>B3 is True if the value in A2 is greater +than the value in B3 + + +>= +Is greater than or equal to +A2>=B3 is True if the value A2 is greater than +or equal to the value in B3 + + + + +Thus if you enter =IF(B3>B1;"BIGGER";"") into +a cell it will display BIGGER if the value in B3 is greater than that in B1, +otherwise the cell will show nothing. + + + +Absolute Cell References +If a formula contains a cell reference that reference will normally be +changed when the cell is copied to another part of the worksheet. To prevent +this behavior put a $ symbol before the column letter, row +number or both. + + + +If A1 contains the formula =D5 then on copying the +cell to B2 it will become =E6 (the normal behavior). + + +If A1 contains the formula =$D5 then on copying the +cell to B2 it will become =D6 (column letter not +changed). + + +If A1 contains the formula =D$5 then on copying the +cell to B2 it will become =E5 (row number not +changed). + + +If A1 contains the formula =$D$5 then on copying the +cell to B2 it will remain as =D5 (neither the column +letter nor the row number are changed). + + + +When you are entering or editing a cell reference in a formula the +shortcut key F4 can be used to step through these four +possibilities. +Named cells can be used in a similar +way to include a unchanging cell reference in a formula. + + + + + +Arithmetic using Special Paste +Sometimes you may want to add a single value to a number of +cells, or subtract a value from them, or multiply or divide them all by a +single value. The Special Paste... option lets you +do this quickly and easily. +First, enter the modifier value into any spare cell on your spreadsheet +and Copy it. Then select the area of cells you want +to change, choose Special Paste... from the +Edit or right mouse button menu +and select Addition, Subtraction, +Multiplication or Division from the +Operation section of the dialog box. +You can also apply different modifier values to different rows or +columns of the target area by copying an area containing the wanted modifiers +before selecting the target area and doing Special Paste... + . For example, if you enter 5 into cell +A1, 10 into B1, select both cells and do a +Copy then Special Paste... +Addition into cells A10 to D15, 5 will be added to A10:A15 and +C10:C15, and 10 to B10:B15 and D10:D15. +Note that a modifier value can be a formula as well as a simple numeric +value. If it is a formula then &kspread; will adjust the cell references as +for a normal Paste operation. + + + +Goal Seeking +&kspread; can be used to solve algebraic expressions such as +x + x^2 = 4 or For what value of x does x + x squared +equal 4 ? +For this example you could enter =A2+A2*A2 +into A1 then either try different values in A2 until the result in A1 is as +close as you wish to 4 or, preferably, use &kspread;'s +Goal Seek feature which automatically adjusts the +value in one cell to try to make the value in another cell as close as +possible to a target value. +It is invoked by selecting Goal Seek from +the Data menu. This brings up a dialog box in which you +should enter the reference of the target value cell (A1 +in this case) into the Set cell: box, the target value +itself (4) into the To value: box +and the reference of the cell that is to be changed +(A2) into the By changing cell: +box. Note that you need to have entered some initial value into the cell that +is to be changed before starting Goal Seek. +Pressing the Start button will start the +calculation. When it finishes and if it has found a solution press the +OK button to accept the result or +Cancel to keep the original value. + + + + +Using more than one Worksheet +When you start a new, empty, document with &kspread; it will create a +number of blank worksheets. The number of sheets it creates is determined +by the Number of sheets open at the beginning: setting in +the Interface page of &kspread;'s +configuration dialog box. +InsertSheet + will add another sheet to the document. +If the Show tabs box in the Interface + page of &kspread;'s configuration dialog box is checked a small +tab will be shown near the bottom left of &kspread;'s window for each sheet. +Left click on one of these tabs to see that sheet. + +You can also switch between worksheets by using the +&Ctrl;PageDown +to move to the next sheet, +&Ctrl;PageUp to move to +the previous one. +Worksheets are given the default names of Sheet1, +Sheet2... You can give a sheet a different name by +right clicking on the tab and selecting +Rename Sheet.... +To remove a sheet from the document use the Remove Sheet + option in the Format +Sheet submenu or in the little +menu that pops up when you right click on the tab +for the sheet you want to remove. +Other entries in the Format +Sheet submenu allow you to show or hide a sheet in +much the same way as rows and columns can be hidden. +If you want a formula in one sheet to refer to a cell in another sheet, +the cell reference must start with the sheet name followed by an exclamation +mark (!). For example if you enter =Sheet2!A2 + into a cell in Sheet 1, that cell will take the value from A2 of +Sheet2. Note that sheet names are case sensitive. + + + +Consolidating Data +You may have constructed a document containing several worksheets +containing similar data but for, say, different months of the year, and wish +to have summary sheet containing the consolidated (⪚, sum or average) values +of the corresponding data items in the other sheets. +This task can be made slightly easier by using the +Consolidate... item from the Data menu. +Selecting this option brings up the Consolidate +dialog box. +For each of the source sheets, enter a reference to the desired data area +in the Reference: box. Press Add to +transfer it to the Entered references: box. The reference +should include the name of the sheet containing the source data, such as +January!A1:A10, and can be entered automatically by +selecting the area in the appropriate sheet. +After entering the references for all of the source data sheets +select the cell in the target sheet where you want the top left corner of the +consolidated results to appear. Then choose the appropriate function from +the Function: combo box and press the +OK button. +If you check the Copy data box in the +Consolidate dialog the values resulting from the consolidation will +be placed into the target cells rather than the formulae to calculate them. + + + + + +Inserting a Chart +You can insert a chart into a sheet to give a graphical view of your +data. +First select the area of cells containing the data and choose +InsertChart +. The cursor will change to a small cross shape which you +should drag across the sheet while holding the left + mouse button down to define the area where you want the +chart to appear, there is no need to be too accurate at this stage as the +chart size can easily be changed at any time. When you release the mouse +button a chart wizard dialog box will appear. +The wizard allows you to define the type of chart, labels and legend +that you need. You may wish to refer to the &kchart; Handbook at this stage, +but again if you make a wrong choice you can correct it later. +When you press the Finish button the wizard will +vanish and you will see the chart embedded into the worksheet. + + + + + + +Screenshot of embedded chart + + + +To move, resize or even delete the embedded chart click anywhere +within the chart area. It should now appear with a diagonal hatch border +and with a small black square at each corner and in the middle of each edge. + +If you move the cursor over any of the black squares it should change +to a double headed arrow. You can resize the chart by dragging one of these +squares with the left mouse button pressed. To +delete the chart right click on one of the +squares and select Delete Embedded Document. +To move the chart move the cursor so that it is over one of the +hatched borders. The cursor should then change to a hand, press the +left mouse button and you will be able to drag the +chart to where you want it to be. +To restore the chart to its normal appearance simply click anywhere +outside of the chart area. +To change the format of the chart itself left +click twice within the chart area. It should then appear with a diagonal +hatch border without any small black squares and &kchart;'s +Chart Toolbar should appear in &kspread;'s window. You can then +use these &kchart; tools or a selection from the menu that pops up when you +right click in the chart area to change the chart. + + + +Inserting External Data +You can insert data from a text file or from the clipboard into a +worksheet by first selecting the cell where you want the top left item of the +inserted data to appear, then choosing From Text File... + or From Clipboard... from the +InsertExternal Data + sub menu. +In both cases &kspread; will assume that the data is in +CSV form and will open a +dialog box allowing you to control how the data is extracted from the file or +clipboard and placed into the worksheet cells. +If support for it has been included in your system, &kspread; can also +insert data from a SQL database into a worksheet. This is +done by using the Insert +External DataFrom Database... + option. + + + +Link Cells +A spreadsheet cell can be linked to an action so that +left clicking on the cell will, for example, open your +browser. To make a cell act in this way select it and choose +InsertLink... +. This will bring up the Insert Link +dialog box, which lets you choose between four types of link: + + +An Internet link cell will try to +open your default browser at the &URL; entered in the +Internet address: text box of the Insert +Link dialog when it is clicked. This could be, for example, +http://www.koffice.org. + + +Clicking on a cell containing a Mail +link will open your email composer using the address entered in the +Email: text box as the To: address. For example +anon@example.com. + + +A File link cell holds the path to +a file or folder, as entered into the File location: +text box, and will try to open that file or folder with a suitable +application when clicked on. + + +The Cell type of link cell holds a +&kspread; cell reference, entered in the Cell: text box. +Left clicking on this type of link cell causes +&kspread;'s focus to move to the target cell. + + + +All four types of link cell need some suitable text to be entered into +the Comment: field of the Insert Link +dialog. This is the text that appears in the cell, you can set +its style to Bold or Italic if you +wish. + + + +Validity Checking +&kspread; can automatically check the validity of entered data against +a number of criteria, and pop up a message box if the data is invalid. +To enable this feature, select the cell(s) to be monitored and choose +EditValidity... +. This will bring up &kspread;'s Validity +dialog box which has two tabbed pages. +In the Values page select what type of data is to +be considered valid from the Allow: combo box list then +define the valid range of values by choosing one of the options in the +Data: combo box and entering suitable value(s) into +one or both of the edit box(es). +When you have done this change to the Error Alert +tab page. Here you can choose the type of message box +(Stop, Warning +or Information) that will appear when an invalid +value is entered, and define the message box title and message text. +Note that this feature only checks data that you enter into the cell, +for a way of checking the results from formulae cells see the Conditional Cell Attributes section of this +Handbook. + + + +Protection + + +Document Protection +Protecting the document means that without the password a user cannot add +or delete sheets. Document protection does not protect cells. +Select ToolsProtect +Document.... +A dialog appears asking you for a password. The Password: strength meter +indicates if your password is secure enough. The longer the indicator is, the +more secure your password. + + + + + + +The Protect Document dialog + + + +That password will then be required to unprotect the document. + + + + + + +The Unprotect Document dialog + + + +When a document is protected, you may not: + + +Rename a sheet + + +Insert a sheet + + +Remove a sheet + + +Hide a sheet + + +Show a sheet + + +See the sheet properties + + +Merge or dissociate cells + + + + + +Sheet protection +Protecting a sheet means protecting the contents of all protected cells +and objects on a sheet. Individual cells or a selection of cells can be +unprotected within a protected sheet, see next section. +To protect a sheet, select +ToolsProtect Sheet.... +A dialog appears asking you for a password. The Password strength meter +indicates if your password is secure enough. The longer the indicator is, the +more secure will be your password. +That password will then be required to unprotect the sheet. +When a sheet is protected, you may not: + + +Insert any object or chart + + +Format any cell + + +Insert a row or a column + + +Edit and change cell content + + +Change any content in the sheet + + + +Protecting a sheet is especially useful for preventing accidental +erasure of formulae. + + + +Cell or selected cells protection +Cell protection is active for all cells by default and is +effective when you enable sheet protection. So if you keep the default and if +you protect the sheet, all cells will be protected. +If you want only certain cells to be protected, this default protection +must be turned off for all other cells. For example you might want most cells +to accept user input so you will uncheck Protected for +those and choose to keep protected cells that should stay unchanged (such as +titles). So you need 3 steps in order to protect only some cells: unprotect all +the cells, select the cells to protect and protect them and then protect the +whole sheet. +To unprotect all the cells: + + +Select the entire spreadsheet with the mouse. + + +In the menubar, select FormatCell +Format.... + + +In the dialog that appears, go to the Cell Protection tab. + + +Check Hide all and uncheck Protected +to remove the protection on all cells. The cells are now all unprotected. + + +To protect a range of selected cells or a selection of non-contiguous +cells: + + +Highlight the range of cells that are to be protected or use the &Ctrl; key to select non-contiguous cells. + + +When all of the desired cells are selected, go to +the FormatCell +Format... menu. + + +In the dialog that appears, go to the Cell Protection tab. + + +Click on the box next to Protected then click +on OK. + + +Once the cells are marked for protection, the protection option must be +enabled at the sheet level, that means you must protect the entire sheet for the +cell to be effectively protected: + + +Select +ToolsProtect Sheet.... + + +In the dialog that appears, provide a safe password, then confirm it by typing +it again. Click on OK. + + +Protected cells in a protected sheet cannot be edited without unprotecting the +whole sheet, and any sheet changes are disabled. For example, no one can +insert rows or columns, change column width, or create embedded charts. + + + + + +Hide cell formula +You might want to hide your formulae so other people cannot see +them. By default, every cell is protected and not hidden. But it is important to +remember that these attributes have no effect unless the sheet itself is +protected. + + + + + + +A default cell with a formula + + + +To hide cell formulae, select the appropriate cell or range of cells or +non-contiguous cells with &Ctrl; and +then choose the FormatCell +Format... menu. In the Cell format +dialog, click the Cell Protection tab and select Hide formula. +After you protect the sheet, the results of the formulae will be visible, but +the formulae will not. +You have now to protect the sheet: choose +ToolsProtect Sheet... +to display the Protect Sheet dialog box. Enter a safe password twice to prevent +others from unprotecting the sheet. +When Hide formula is enabled and +Protected is disabled, the formula is hidden after +protecting the sheet but the cell content can be changed. + + + + + + +Hide formula is enabled but the cell is not protected and the +sheet is protected + + + +When Hide formula and Protected +are enabled, the formula is hidden after protecting the sheet and the cell +content cannot be changed. + + + + + + +Hide formula and Protected are enabled in Cell Protection and the +sheet is protected + + + +Keep in mind that it is very easy to break the password for a +protected sheet so if you are looking for real security, this is not the +best solution. + + + +Hide all in the cell +You can hide both the formula and the content of the cell by +choosing Hide all in the Cell Protection tab in the +FormatCell +Format... menu. In the screenshot below, the +cell itself is not protected (Protected is unchecked) thus +the cell content can be changed. + + + + + + +Hide all only is enabled (no cell protection) and +the sheet is protected + + + +Here the cell itself is protected so it cannot be overwritten. + + + + + + +Hide all and Protected are +enabled in Cell Protection and the sheet is protected + + + + + + + + +Other Features + + +Splitting the View +If your spreadsheet is so large that you cannot see all of it at once, +splitting &kspread;'s window into two or more views can help you work on it. +This is done by selecting View +Split View which will split the current view into +two parts. ViewSplitter Orientation + lets you choose between +Horizontal and Vertical +splitting. +This technique is particularly useful when you want to select an area +of the spreadsheet that is larger than can be shown in one view, perhaps to +paste a copied cell into it. +Use the scrollbars to position the two views to show the top left and +bottom right cells of the wanted area, select the top left cell in one +view then hold the &Shift; key pressed while you select the +bottom right cell with the left mouse button. +If there is more than one sheet in your document, you can show a +different sheet in each of the split views. +The relative sizes of the views can be changed by dragging the thick bar +separating the views. +To remove a view select View +Remove View + + + + +Named Cells and Areas +You can give a name such as foo to a cell or to +any area of a sheet by selecting the cell or area then selecting +Area Name... from the right mouse +button menu. This will bring up the Area Name dialog box +where you can enter any name you wish. +You can also name a cell or area by selecting it then typing the name +into the small text box at the left end of the Formula toolbar, overwriting the +cell reference that normally appears here. +If you enter a name that has already been used into this text box +&kspread;'s selection will change to show the named cell(s). +The DataShow Area... + option will give you a list of existing names +and let you change &kspread;'s focus to any of them or let you remove a name. + +Named cells are particularly useful in formulae as an alternative to + absolute cell references as the names can +be used in place of normal cell references and do not change when the +cell containing the formula is copied. When a name is used in this way it +should be enclosed in single quotation marks. +For example, if cell A1 has been given the name fred + then you can enter a formula such as ='fred' + 2 + into another cell which would always give the result of adding +2 to the value in A1 no matter where the formula cell was copied to. +Note that cell and area names are treated as being in lowercase. + + + +Cell Comments +A cell can contain a text comment that can be viewed when working on +the spreadsheet but which is not printed and not normally seen. +To add a comment select the cell and choose Add/Modify +Comment... from the right mouse +button menu or from the Insert +Cell Comment menu and type your comment into the +resulting Cell Comment dialog box. +To see the comment hover the mouse pointer over the top right corner of +the cell. The comment will appear as if it were a Tooltip. + +If you check the Show comment indicator box of the +Sheet Properties dialog, those +cells containing comments will be highlighted by a small red triangle in the +top right corner. +To open this dialog, click with the right mouse +button onto the sheet tab at the bottom of the main window and select +Sheet Properties from the popup menu. Or select it from the +FormatSheet menu. + +To remove a comment from a cell, select Remove Comment + from the right mouse button menu or +choose EditClear +Comment. + + + + + + + diff --git a/doc/kspread/basics.docbook b/doc/kspread/basics.docbook new file mode 100644 index 000000000..2a06be215 --- /dev/null +++ b/doc/kspread/basics.docbook @@ -0,0 +1,637 @@ + + + + +Pamela +Robert + +
pamroberts@blueyonder.co.uk
+ + + + + +&kspread; Basics + +Like the rest of &kde;, &kspread; is highly configurable, which can +cause problems for readers trying to compare the text in a document such as +this with what they see on the version of &kspread; running on their desktop. +To cut down on some of the possibilities for confusion, it it suggested that +when you first start to use &kspread; you set the default options in all pages +of the &kspread; configuration dialog (obtained by selecting +SettingsConfigure +&kspread;...) except for Completion mode: + in the Misc page, which should be set to +None. + +You may also find it helpful to globally Enable tooltips +in &kcontrolcenter; in Appearance & +ThemesStyle +on the Style page. + + +Spreadsheets for Beginners + +This section attempts to explain by example what a spreadsheet program +such as &kspread; actually does, and why it is such a useful tool in any +situation where you have to deal with numbers. If you have already used a +spreadsheet program you may wish to skip to the next section. + +The first thing to do is to start up &kspread;. You can do this by +left clicking on a &kspread; icon if there is one +on your desktop or panel, or you can select +Office&kspread; + +from the K menu. + + + + + + + +&kspread; at first run + + +When it has started you will be given the choice of opening a recent +document, creating a new document from a template (with templates categories) or +opening an existing document . Select the General category +on the left and choose the Blank Worksheet template. Then +click the Use This Template button. + +Looking at &kspread; once it has started up, you will see a sheet of +empty rectangular cells arranged in numbered rows and lettered columns. This +is where you enter data or formula, text or charts. + + + + + +Screenshot starting1 + + + +Now, enter the text and values shown in the first 5 rows of the above +screenshot into the same cells of your spreadsheet. Ignore what is in row 7 +for the moment. To enter anything into a cell first select the cell by +left clicking inside it, then type whatever you +want, then press Enter or use the arrow keys to move the +selection point to another cell. + +What we have entered so far could be a simple budget for the next two +months, listing how much we think we will be spending for Food, Shelter, +Clothing and any Other expenditure. Now select cell B7 (column B, row 7), +type in =B2+B3+B4+B5 and press Enter. +Because it begins with a = symbol &kspread; sees this as a +formula, something it has to calculate, in this case by adding together the +values in the 4 cells B2 to B5, and what is shown in the cell B7 is the result +of that calculation. +You could enter a similar formula into cell C7, except that in this case +it would have to be =C2+C3+C4+C5, but there is an +easier way which is to Copy cell B7 and Paste it into C7. &kspread; will +automatically adjust the cell references from B.. to C.. when the Paste is +done. +At this point you may think that &kspread; is doing no more than you +could manage with pencil, paper and a calculator, and you could be right, but +remember that this is a very small example of a spreadsheet, doing simple +calculations on only a few numbers. For any reasonably amount of values or data +using a spreadsheet to do the calculations is much quicker and more accurate +than doing them manually. +Also, a spreadsheet lets you play the What if? game. +Because each formula is automatically recalculated whenever any of the values +it refers to are changed, you can quickly see what happens if you alter any of +them. Using our example you can see the effect of reducing the amount spent on +food in December by just entering a new value into cell C2. If you had a +spreadsheet that modelled the greenhouse effect accurately you could perhaps +see the effect of a 50 percent reduction in the amount of methane released +into the atmosphere. + + + +Selecting Cells +You can select a single cell or a rectangular area of cells in the +spreadsheet. The selected cell(s) are displayed with a thick black border. + + +You can select a single cell in one of the following ways +left click on it +enter the cell reference (for example B5) +into the cell reference box at the left end of the Formula toolbar and press +Enter +use the ViewGoto +Cell... menu option + + +You can also steer your way around with the arrow keys. +Pressing the Enter key will move the current selection one +position up, down, left or right depending on the setting in the Misc + page of &kspread;'s configuration dialog +box. If you hold the &Shift; key down while using the +arrow keys the selection will move to the start or end of the +block of occupied cells. +To select an area of contiguous cells drag the mouse cursor across the +desired area with the left button held down, or enter +the references of the top left and bottom right cells separated by a colon into +the Formula toolbar cell reference box (for example B7:C14 +) and press Enter, or enter these cell references +in a similar format into the dialog box brought up by +ViewGoto Cell.... +You can also select an area of cells by selecting the cell in one corner +of the wanted area then holding the &Shift; key down while using the +left mouse button to select the cell in the opposite +corner. + +To select a complete row or column of cells left + click on the row number at the left of the worksheet or on the +column letters at the top. To select adjacent rows or columns drag the mouse +pointer over the appropriate row numbers or column letters with the +left button held down. + +To select non-contiguous cells, click on the first cell you want to select +then hold the &Ctrl; key and select the other +cells. + + + + +Entering Data +Entering data into a cell can be as simple as selecting the cell, typing +your data, then pressing Enter or moving the selection to +another cell with one of the arrow keys. Depending on how you +enter the data, &kspread; will interpret it as a number, date, time or text: + + +Numbers are entered in the obvious way; 123, +-123, 456.7 or in scientific notation +-1.2E-5. + + +Dates should be entered in your System format, as defined in +the &kcontrolcenter; in +Regional & Accessibility +Country/Region & LanguageTime & Dates + dialog box. If, for example, you are using the DD/MM/YYYY form +you should enter 30/03/2002 for 30th March 2002. +Leading zeroes can be omitted from the day and month fields and only the last +one or two digits of the year need to be entered if the date is in the current +century, for example 9/1/2 for 9th January 2002. + + +Times should also be entered using the System format. For +example if you are using a 12 hour clock then enter times in HH:MIN am|pm or +HH:MIN:SS am|pm format such as 9:42 am or +10:30:52 pm. + + +&kspread; defines any input data as text if it cannot +recognize the data as being a number, date or time. + + +By default, &kspread; right justifies numbers, dates and times +within a cell and left justifies anything else. This can be a useful guide +to whether you have entered a date or time in the correct format. But +remember that how items are displayed can be changed by altering +the cell format. + +The main text entry box in the Formula toolbar provides an easy way of +editing the contents of a selected cell. Press Enter or +left click on the green tick mark when you are +happy with what you have entered, or click on the red cross to cancel your +edits. + + +Generic Cell Format + +&kspread; uses the Generic cell format as default. As long +as this format is used, &kspread; autodetects the actual data type depending +on the current cell data. For example if you enter some text into a cell and +later enter a number into the same cell, &kspread; automatically interprets +the new data as a number. If you want to define the type of data yourself, you +can explicitly set it in the cell format. +You can change the format back to Generic at any time. + + + + + + +Copy, Cut and Paste + +At first glance, &kspread;'s Cut, +Copy and Paste appear +to be similar to these functions in other &kde; applications. Having selected +a cell or cells, you can choose Copy or +Cut from the Edit menu or from +the drop down menu you get by holding the right +mouse button down on a selected cell. You can also use the shortcuts +&Ctrl;C + or &Ctrl;X +, then move the selection to the target cell and choose +Paste or press +&Ctrl;V. However there are some +subtleties associated with these functions in &kspread; and these are discussed +below. + +If a cell contains a formula then the formula itself is copied rather +than the displayed result, and if the formula contains a reference to another +cell, then that reference is changed by the Cut +or Copy and Paste +operation to point to the cell that is in the same relative position as in +the original cell. For example if cell A2 contains the formula +=B3 and is copied to C4, cell C4 will contain =D5 +. +This may seem to be a rather strange way of doing a copy, but +99 percent of the time it is exactly what is wanted (if it is not then see the +section about absolute cell references). +For example in the simple shopping list shown below, cell D2 should contain +=B2 * C2, D3 should be =B3 * C3, +D4 should be =B4 * C4 and so on. Instead of having to +enter a different formula in each cell, you can just enter the first formula +into D2 and then copy it into the cells below, letting &kspread; adjust the +cell references to suit. + + + + + +Screenshot copy1 + + + + +Copying and Pasting Cell Areas +In the above example D2 can be copied into all three cells D3 to D5 at +once by just copying D2 then selecting the complete cell area D3:D5 before +doing the paste. +A rectangular area of cells can be cut or copied in one operation by +selecting the area before doing the cut or copy. Then select the top left +corner cell of the area you want to paste into before doing the paste. +If you cut or copy a rectangular area of cells, say B2:C3, and paste it +into a larger area such as A10:D13 the original pattern of cells will be +repeated to fill the target area. +&kspread; also provides a Drag and Copy method for +copying cells down into other cells immediately below or to the +right of the original cell(s). To use this method select the cell(s) to be +copied then position the mouse pointer over the small black square at the +bottom right corner of the selected cell(s) so the cursor changes to a double +headed arrow. Then hold the left mouse button down +while you drag the selected cell(s) as far as you wish. Note that cell +references in formulae are incremented according to the +relative position change. Absolute references are not changed. + + + +Other Paste Modes +A cell may contain text, a value, or a formula, and may also contain +special font, border or background formatting +information. &kspread; has special versions of Paste that let +you handle these items in different ways. + +EditSpecial +Paste...brings up the Special +Paste dialog box. By selecting the appropriate item from +the top part of this dialog you can choose to paste just +Text , the cell Format, any +Comment in the cell(s) or Everything +without border. The items in the bottom part of this dialog +box allow you to do simple arithmetic +on an area of cells. + + +Paste with Insertion... inserts the copied +cell(s) into the sheet by moving the cells that would otherwise be overwritten +a suitable number of rows of columns down or to the right. It can also be used +to insert complete copied row(s) or column(s) into the worksheet. + + + + + +Insert and Delete +Use the Delete key or Edit +ClearText + to remove the text, value or formula from selected cell(s), +row(s) or column(s) without affecting anything else. + +To delete everything in the selected cell(s), row(s) or column(s), +including comments and special formatting, use +&Shift;Delete or choose the Delete + option from the Edit menu or from the pop +up menu you get when you right click on a selection. + +To remove selected row(s) or column(s) completely, use the +Delete Rows or Delete +Columns options from the right mouse +button pop up menu. +If you select a cell or cells and choose Remove Cells... + from the right mouse button pop up +menu, you can then choose whether other cells in the worksheet will be moved +up or to the left to fill in the space left by the cell(s) you have chosen to +remove. +If you want to insert new, blank, row(s) or column(s) into the +sheet, select row(s) or column(s) where you wish the new row(s) or +column(s) to be placed and choose the Insert Rows, +Insert Columns option from the +right mouse button pop up menu. +You can insert new cells into the worksheet by selecting the +area where you want them to appear then choosing the +Insert Cells... option from the right +mouse button pop up menu. You will then be asked whether the existing cell(s) +in the selected area should be moved down or to the right to make room for the +new ones. + + + + +Simple Sums +If the first character in a cell is an equals sign (=) +&kspread; will take the cell contents to be a formula which is to be +calculated. The result of the calculation will be displayed in the cell rather +than the formula itself. For example, enter =2+3 +into a cell and it should display 5. +More usefully, a formula can contain references to other cells, so +that =B4+A3 will calculate the sum of the values in +cells B4 and A3, and this calculation will be updated whenever cells B4 or A3 +are changed. +As well as addition, a formula can make use of the - +symbol for subtraction, * for multiplication, and +/ to perform division. The round bracket symbols ( +and ) can also be used as in normal algebra, so you could +enter more complex formulae such as =((B10 + C3) *5 - F11) / 2 +. + +Cells containing a formula will be marked with a small blue triangle +at the bottom left corner if the Show formula indicator +check box in the Format +SheetSheet Properties + dialog is checked. +&kspread; also includes a large number of built-in functions for +applications such as statistical, trigonometrical and financial calculations. +Their use will be examined in more depth in a +later section of this manual, but if you are interested at this stage +choose Function... from the Insert + menu and take a look through the Function + dialog box that will be displayed.. +For the time being, however, the SUM function may +be of interest as it calculates the sum of all values in a specified area of +cells. For example =SUM(B4:C10) calculates the sum of +all values in the cell area B4 to C10. +If &kspread; displays a row of # symbols when you have +entered your formula this usually means that it cannot understand what +you have entered, but if the row of # symbols ends with a +small red arrow this just means that the cell is not wide enough to display +the complete result, in which case you should either make the cell(s) wider +or change their format so that the result +does fit properly. + + +Recalculation +If the Automatic recalculation box in the +Format +SheetSheet Properties + dialog box is +checked, &kspread; will recalculate the values of cells whenever anything that +affects them is changed in the sheet. +When Automatic recalculation is not checked for the current sheet, you can instruct &kspread; to perform a recalculation at any time by +using the Recalculate Sheet or +Recalculate Document option in the Tools +menu or their shortcuts &Shift;F9 + or F9. + + + + +Sorting Data +In the simple example shown below, the data consist of the names and +countries of a number of mountains together with their height above sea level. +&kspread; can sort data such as this in different ways. + + + + + + +Screenshot of sorted data + + + +We may want the data sorted so that the names are in +alphabetical order. To do this select the area containing the data (A2:C7 +in this case) and choose Sort... from the Data +menu. This opens the Sorting dialog box. +Sorting is done alphanumerically, and the default is case sensitive, numbers coming +before uppercase letters which come before lowercase letters, so that cells +containing the entries Cat, bar, +77 and Bat would be sorted into +the following order: 77 Bat Cat bar. + +Using the Sort Criteria page of this dialog box +lets you Sort Rows or Sort Columns. +If you check the First row contains headers box data in the +first row will not be included in the sort operation. +You can choose which column or which row of the data is to be used as a primary sort key and, +if you wish, other columns or rows to be used as secondary and tertiary keys. Using +the example in the above screenshot, choosing column B as the first key and +column C as the second would sort the data by country and, for each country, +by height. + +The Options page of the dialog allows you to sort using the +order of items in a custom list such as January, February... instead +of alphanumerically. +The cell format is moved with the cell content, if you select +Copy cell Formatting (Borders, Colors, Text Style) +Uncheck the option Case sensitive sort to get a sort +not depending on capitalization. + + + + + +The Status bar Summary Calculator +The left hand end of the Status bar shows a summary of the values in +the selected cell(s). According to the setting of the Method of +calc: combo box in the Misc page of +&kspread;'s configuration dialog the summary can be: + + + +Sum +The value displayed is the sum of the values in the selected +cells. + + + + +Min +The value displayed is the minimum of the values in the selected +cells. + + + + +Max +The value displayed is the maximum of the values in the selected +cells. + + + + +Average +The value displayed is the average of the values in the selected +cells. + + + + +Count +The value displayed is the number of cells containing numeric +values. + + + + +None +No summary calculation is performed. + + + +The method of calculation can also be changed by right + clicking on the summary calculation result area of the +Status bar and choosing an item from the pop up menu. + + + + +Saving your Work +&kspread; saves the complete document, which may include more than one +worksheet, as a single document file. +If you have created a new document, or want to save an existing one +under a different name, use File +Save As.... This will bring up &kde;'s common +Save Document As dialog box. +Choose the folder where you want to save the document and enter a +suitable file name into the Location: text box. &kspread; +documents are normally automatically saved with a .ods +extension, you do not need to add this to the filename but do make sure that +the Filter: selection is set to +OASIS OpenDocument SpreadSheet. +To save your document without changing its name, just use +FileSave. + +You can also save a &kspread; document in a foreign format: see + the Import/Export section for more information +about doing this. +When you save a modified version of an existing document +&kspread; will keep the previous version as a backup file, adding a +~ to the end of the filename. +&kspread; can provide some protection against losing your work because +of a computer crash or because you have closed &kspread; without saving the +current document. It does this by automatically saving the latest version of +the document you are working on every few minutes using a modified file name. +The autosaved version is normally removed when you next save your document, +so that it will only exist if it is more up to date than the version that was +saved manually. +When you open a document &kspread; checks to see if an autosaved +version exists, and if it finds one it will offer to open that instead. +Autosaved documents are saved with a file name of the form +.yourfilename.autosave (note the leading period), +so that spread1.ods would be autosaved as +.spread1.ods.autosave. The autosave feature is +user configurable in the settings dialog. + + +Templates +If you are going to be creating a lot of similar documents you can +save yourself time and trouble by first creating a template and then +using that as the basis for the individual documents. +To do this first create a document containing the common elements, +then save it as a template by choosing File +Create Template From Document.... +Doing this opens the Create Template dialog box. +Enter a name for your new template into the Name: text +box and press OK. The next time you start a new +document by choosing FileNew + or when you next start &kspread; the +startup dialog window will give you the option of creating the +new document from your template. +The Create Template dialog box also lets you +choose a different picture to be displayed above the template name in the +startup dialog window, and lets you save your templates +under different group names, which will appear as different pages in +the dialog. + + + + + +Printing a Spreadsheet +Printing a spreadsheet is basically done by selecting +FilePrint... which +brings up &kde;'s common Print dialog box where you can +choose, among other options, the printer to be used, the number of copies and +whether all or only selected pages are to be printed. +By default &kspread; will print all items in the current worksheet, but +you can restrict this by first selecting the area that you want to be +printed then choosing Define Print Range from the +FormatPrint Range + sub menu. +&kspread; will print as many pages as are necessary to include all +items in the current worksheet. You can quickly see how a worksheet will be +spilt into separate pages for printing by checking the +View +Show Page Borders box. The boundaries +of each printed page will then be marked by colored lines in the +worksheet. + +For a more detailed view of what is to be sent to the printer, including +anything you have asked to be included in the page headers and footers (see +below), choose FilePrint +Preview.... + +To improve the appearance of the printed output , you can change the +fonts, colors, borders and sizes of the cells in the worksheet, see the +Spreadsheet Formatting section for more +details about how to do this. + +You can also use the Page Layout dialog box, +invoked by selecting FormatPage +Layout..., to change the orientation of the printed +pages, the paper size (this should be suitable for your printer) and the size +of the page borders. +The Header & Footer page of the +Page Layout dialog box also lets you add text, including items such +as the filename, date and page number to the header and footer, of each +printed page. +The Ranges section of the Options + page of the Page Layout dialog box provides +an alternative way of restricting the printed output to just one part of the +worksheet and allows you to repeat selected column(s) or row(s) on each printed +page. This page also lets you select whether or not to print the grid, +comment indicators and formula indicators, objects and charts. +In the section Scale Printout you can set a scalefactor +or limit the number of pages for the print. + + + + + + diff --git a/doc/kspread/cellformat0.png b/doc/kspread/cellformat0.png new file mode 100644 index 000000000..fe692bf8f Binary files /dev/null and b/doc/kspread/cellformat0.png differ diff --git a/doc/kspread/cellformat1.png b/doc/kspread/cellformat1.png new file mode 100644 index 000000000..cf3a23331 Binary files /dev/null and b/doc/kspread/cellformat1.png differ diff --git a/doc/kspread/cellformat2.png b/doc/kspread/cellformat2.png new file mode 100644 index 000000000..a7752f036 Binary files /dev/null and b/doc/kspread/cellformat2.png differ diff --git a/doc/kspread/cellformat3.png b/doc/kspread/cellformat3.png new file mode 100644 index 000000000..eb36f521b Binary files /dev/null and b/doc/kspread/cellformat3.png differ diff --git a/doc/kspread/cellformat4.png b/doc/kspread/cellformat4.png new file mode 100644 index 000000000..2bb297061 Binary files /dev/null and b/doc/kspread/cellformat4.png differ diff --git a/doc/kspread/cellformat5.png b/doc/kspread/cellformat5.png new file mode 100644 index 000000000..5c4b7b150 Binary files /dev/null and b/doc/kspread/cellformat5.png differ diff --git a/doc/kspread/cellformat6.png b/doc/kspread/cellformat6.png new file mode 100644 index 000000000..358ede349 Binary files /dev/null and b/doc/kspread/cellformat6.png differ diff --git a/doc/kspread/cellformat7.png b/doc/kspread/cellformat7.png new file mode 100644 index 000000000..2760c71df Binary files /dev/null and b/doc/kspread/cellformat7.png differ diff --git a/doc/kspread/cellprotection1.png b/doc/kspread/cellprotection1.png new file mode 100644 index 000000000..6f95cb941 Binary files /dev/null and b/doc/kspread/cellprotection1.png differ diff --git a/doc/kspread/cellprotection2.png b/doc/kspread/cellprotection2.png new file mode 100644 index 000000000..eda1e10cf Binary files /dev/null and b/doc/kspread/cellprotection2.png differ diff --git a/doc/kspread/chart1.png b/doc/kspread/chart1.png new file mode 100644 index 000000000..3cdf6055c Binary files /dev/null and b/doc/kspread/chart1.png differ diff --git a/doc/kspread/commands.docbook b/doc/kspread/commands.docbook new file mode 100644 index 000000000..1c2ae0445 --- /dev/null +++ b/doc/kspread/commands.docbook @@ -0,0 +1,1540 @@ + + + + +Pamela +Robert + +
pamroberts@blueyonder.co.uk
+ + + + + +Command Reference + + +The <guimenu>File</guimenu> Menu + + + + + +&Ctrl;N + +File +New + +Create a new document. + + + + + +&Ctrl;O + +File +Open... + +Open an existing document. + + + + +File +Open Recent + +Open an existing document by selecting it +from a combo box of recently used files. + + + + + +&Ctrl;S + +File +Save + +Save the document. + + + + +File +Save As... + +Save the document with a new name or format. + + + + + +File +Reload + +Reloads the document. + + + + + +File +Import... + +Import other documents. + + + + + +File +Export... + +Save a document to any supported format. +The document does not become the exported file. + + + + + +File +Mail... + +Send the file as an email attachment. + + + + + +File +Create Template From Document... + +Create a &kspread; template +based on this document. + + + + + + +&Ctrl;P + +File +Print... + +Print the document. + + + + +File +Print Preview... + +View the document as it will be printed. + + + + + +File +Document Information + +View or enter information about the document and +author. + + + + + + +&Ctrl;W + +File +Close + +Close the current document but leave &kspread; running. + + + + + + +&Ctrl;Q + +File +Quit + +Quit &kspread;. + + + + + + + +The <guimenu>Edit</guimenu> Menu + + + + + + +&Ctrl;Z + +Edit +Undo + +Undo the last action. + + + + + +&Ctrl;&Shift;Z + +Edit +Redo + +Redo the last undone action. + + + + + + +&Ctrl;X + +Edit +Cut + +Put selected item(s) into the clipboard and remove +them from the original location. If you then +do a Paste the item(s) will be be inserted at +the new location. + + + + + + +&Ctrl;C + +Edit +Copy + +Copy selected item(s) to the clipboard. + + + + + + +&Ctrl;V + +Edit +Paste + +Paste item(s) from the clipboard to the selected +cell(s). + + + + + +Edit +Special Paste... + +Special forms of Paste. + See the sections Other Paste +Modes and Arithmetic using Special +Paste for more details. + + + + + +Edit +Paste with Insertion + +Move content of the paste area either to the right +or down and paste item(s) from the clipboard to the selected cell(s). + + + + + +Edit +Fill + +Fills up the selected area with the values from the +first item-set. All four directions are supported. Note that the +term "item-set" describes the first set of values seen in the fill direction. +If the fill direction is Left then the first item-set is the last column of the +selection. + + + + + + +&Ctrl;F + +Edit +Find... + +Find cell containing given text. + + + + + + +F3 + +Edit +Find Next + +Find the next cell containing given text. + + + + + + +&Shift;F3 + +Edit +Find Previous + +Find the previous cell containing given text. + + + + + + +&Ctrl;R + +Edit +Replace... + +Find and replace given text in cell(s). + + + + + +Edit +Clear + +Clear Text, +Comment, Validity or +Conditional Cell +Attributes from selected cell(s). + + + + + +Edit +Delete + +Delete everything from selected cell(s). + + + + + +Edit +Remove Link + +Remove the link while leave the displayed text. + + + + + +Edit +Conditional Cell Attributes... + +Add or modify conditional cell attributes. + + + + + +Edit +Validity... + +Set or modify the error checking criteria and error +alert message for selected cell(s). See +Validity Checking for more details. + + + + + + +&Ctrl;M + +Edit +Modify Cell + +To modify selected cell in-situ. + + + + + + + + +The <guimenu>View</guimenu> Menu + + + + + +View +New View + +Open a new instance of &kspread; +with the same document. + + + + + + +&Ctrl;&Shift;W + +View +Close All Views + +Close all open instances of &kspread; + + + + + +View +Split View + +Split current view into two parts. + + + + + +View +Remove View + +Remove current view. (Where the window +contains two or more views) + + + + + +View +Splitter Orientation + +Change view split to Horizontal or Vertical. + + + + + +View +Goto Cell... + +Change &kspread;'s focus to show defined cell. + + + + + +View +Show/Hide Page Borders + +Toggle marking of printed page borders in the sheet +with red lines. + + + + + + +View +Zoom + +Increase or decrease the magnification used to display +the spreadsheet. Range from 33% to 500%. + + + + + + + + + + +The <guimenu>Insert</guimenu> Menu + + + + + + + +Insert +Cell Comment + +Add/Modify Comment... or +Remove Comment. + + + + + +Insert +Function... + +Insert a mathematical function. See the +section Formulae for more details. + + + + + +Insert +Series... + +Insert a series. See the section +Series for more details. + + + + + +Insert +Link... + +Insert a link into the selected cell. +See the section +Link Cells for more details. + + + + + +Insert +Special Character... + +Insert a special character into the selected cell. + + + + + +Insert +Object + +Embed another &koffice; document into the sheet. + + + + + +Insert +Chart + +Insert a chart. See the section +Inserting a Chart for more details. + + + + + +Insert +Picture + +Opens the standard &kde; file dialog +to insert a picture. + + + + + +Insert +External Data + +Insert data From Database..., +From Text File... or From +Clipboard.... See the section Inserting +External Data for more details. + + + + + + + + +The <guimenu>Format</guimenu> Menu + + + + + +&Alt;&Ctrl;F + +Format +Cell Format... + +Format selected cell(s). See the +Spreadsheet Formatting section for more +details. + + + + + +Format +Properties + +Opens a dialog to change the properties of +an inserted object or picture. + + + + + +Format +Change Angle... + +Change angle of displayed text in selected cell(s). + + + + + + +Format +Decrease Indent + +Move text in selected cell(s) to the left. + + + + + +Format +Increase Indent + +Move text in selected cell(s) to the right. + + + + + +Format +Increase Precision + +Increase displayed precision of numbers in selected +cell(s). + + + + + +Format +Decrease Precision + +Decrease displayed precision of numbers in selected +cell(s). + + + + + +Format +Adjust Row & Column + +Set row and column sizes to show selected cell(s) +properly. + + + + + +Format +Row + +Resize, equalize, hide or show row(s). + + + + + +Format +Column + +Resize, equalize, hide or show column(s). + + + + + +Format +Sheet + +Remove, hide, show worksheet or configure +advanced sheet properties. + + + + + +Format +AutoFormat... + +Autoformat the selected cells: a dialog let you choose betwen two proposed formats. + + + + + +Format +Style Manager + +Create, Modify or delete cell format styles. + + + + + +Format +Style + +Apply a style to selected cell(s). +To manage styles use +FormatStyle Manager... + + + + + + +Format +Create Style From Cell... + +Create a new style from the format of the +selected cell. +To manage styles use +FormatStyle Manager... + + + + + + +Format +Page Layout... + +Format printed page layout. + + + + + +Format +Print Range + +Define or reset the print range. + + + + + + + +The <guimenu>Data</guimenu> Menu + + + + +Data +Sort... + +Sort data in selected cells. See the section +Sorting Data for more details. + + + + + +Data +Text to Columns... + +This option attempts to interpret text in the selected cell(s) +as CSV data, placing each +item into a different cell in the row. + + + + + +Data +Insert Columns + +Insert new column(s) at left of selected column(s). + + + + + + +Data +Insert Rows + +Insert new row(s) above selected row(s). + + + + + + +Data +Delete Columns + +Delete selected column(s). + + + + + +Data +Delete Rows + +Delete selected row(s). + + + + + +Data +Insert Cells... + +Insert new cell(s). + + + + + +Data +Remove Cells... + +Remove selected cell(s). + + + + + +Data +Merge Cells + +Merge selected cells. + + + + + +Data +Dissociate Cells + +Dissociate (split apart) previously merged cells. + + + + + + +Data +Show Area... + +Change &kspread;'s focus to show a previously +named area. See the section Named Cells +and Areas for further details. + + + + + +Data +Subtotals... + +Create different kinds of subtotals to a +database. + + + + + +Data +Goal Seek... + +Open the Goal Seek dialog box. See +Goal Seeking for details. + + + + + +Data +Consolidate... + +Consolidate data. See the section +Consolidating Data for more details. + + + + + + + +The <guimenu>Tools</guimenu> Menu + + + + +Tools +Spelling... + +Check spelling of words in the worksheet. + + + + + +Tools +Custom Lists... + +View or amend the special series of words recognized +by &kspread;. + + + + + +Tools +Protect Sheet... + + +Protect the sheet with a password. A dialog pops up prompting you for a password. Unchecking this option will prompt you for the password in order to unprotect the sheet. Protecting a sheet means protecting all cells in the sheet. In a protected sheet, the cells cannot be reformatted or overwritten. + + + + + +Tools +Protect Document... + + +Protect the whole document with a password. A dialog pops up prompting +you for a password. Unchecking this option will prompt you for the password in +order to unprotect the document. In a protected document you cannot rename or +remove a sheet. Document protection does not mean that each individual sheet +is protected. + + + + + + +&Shift;F9 + +Tools +Recalculate Sheet + +Recalculate formulae in the current sheet. + + + + + + +F9 + +Tools +Recalculate Document + +Recalculate all sheets. + + + + + +Tools +Insert Calendar... + +Insert a calendar in your sheet. A dialog asks you for the start and end dates. The corresponding calendar is then inserted from the current cell. + + + + + + +Tools +Script Manager... + +Opens the Scripts Manager dialog to execute, load, unload, install, uninstall and get more scripts. + + + + + +Tools +Scripts + +Here you can execute the script Export to HTML File or start the Script Editor. + + + + + + + +The <guimenu>Settings</guimenu> Menu + + + + +Settings +Show/Hide Status Bar + +Show or hide the Status Bar. +The Status Bar shows additional information for selected items and +instant calculations of the selected cells. + + + + + +Settings +Show/Hide Tab Bar + +Show or hide the Tab Bar. +All Sheets of the current Document can be accessed through the Tab Bar. + + + + + +Settings +Show/Hide Formula Bar + +Show or hide the Formula Bar. +The Formula Bar can be used to edit the content of the selected cell. + + + + + +Settings +Toolbars + +Show or hide the toolbars: File, +Edit, Navigation, +Format and Color/Border. + + + + + +Settings +Configure Shortcuts... + +Configure the keyboard shortcuts used by &kspread;. + See the section on configuring shortcuts + for more details. + + + + + + +Settings +Configure Toolbars... + +Configure the toolbars. The section on +configuring toolbars has more +information. + + + + + +Settings +Configure &kspread;... + +General &kspread; configuration. See the +section on &kspread; configuration for +more details. + + + + + + + + +The <guimenu>Help</guimenu> Menu + +&help.menu.documentation; + + + + +The Right Mouse Button Menu +This section describes the items in the pop up menu obtained by +right clicking on a selected cell or cells, +row(s) or column(s). + + + + + + +&Alt;&Ctrl;F + +Cell Format... + +Format selected cell(s). See the +Spreadsheet Formatting section for more +details. + + + + + + +&Ctrl;X + +Cut + +Put selected item(s) into the clipboard. If +you then do a Paste the item(s) will be moved from the +original location to the new one. + + + + + + +&Ctrl;C + +Copy + +Copy selected item(s) into the clipboard. + + + + + + +&Ctrl;V + +Paste + +Paste item(s) from the clipboard to the selected cells. + + + + + + +Special Paste... + +Special forms of Paste. + See the sections Other Paste +Modes and Arithmetic using Special +Paste for more details. + + + + + +Paste with Insertion + +Paste from the clipboard to the selected cell(s), moving the +previous cell(s) to make room. + + + + + +Delete + +Delete contents of selected cell(s). + + + + + +Adjust Row & Column + +Change size of row and column to display selected +cell(s) completely. + + + + + +Default + +Set default formats for selected cell(s). + + + + + +Area Name... + +Name selected area. See the section +Named Areas for more details. + + + + + +Resize Row... + +Change height of selected row. + + + + + +Adjust Row + +Change height of selected row to display cell(s) +completely. + + + + + +Resize Column... + +Change width of selected column. + + + + + +Adjust Column + +Change width of selected column to display cell(s) +completely. + + + + + +Insert Cells... + +Insert new cell(s) at selected location, moving +existing cell(s) to make room. + + + + + +Remove Cells... + +Remove selected cell(s), moving other cell(s) to +occupy the space left by the removed cell(s). + + + + + +Insert Rows + +Insert new row(s) above selected row(s). + + + + + + +Delete Rows + +Delete selected row(s). + + + + + +Hide Rows + +Hides selected row(s). + + + + + +Show Rows + +Shows selected row(s). +In order to show hidden rows you need to select a range of rows that +includes the hidden rows. + + + + + +Insert Columns + +Insert new column(s) at left of selected column(s). + + + + + + +Delete Columns + +Delete selected column(s). + + + + + +Hide Columns + +Hides selected column(s). + + + + + +Show Columns + +Shows selected column(s). +In order to show hidden columns you need to select a range of columns that +includes the hidden columns. + + + + + +Add/Modify Comment... + +Add or modify a comment to the selected cell. + + + + + +Selection List... + +Lets you select and paste text from any +cell of the current selection of cells into the selected cell. + + + + + +Show Related Words + +Opens the Related Words dialog box. + + + + + + + +Other Shortcuts +This section describes those &kspread; shortcut keys used for operations +that do not appear in any of the menus. + + + + + +&Ctrl;Arrow keys + +If the selected cell is occupied then move the +cell cursor to the start or end of the occupied block in the current row or +column. If the selected cell is not occupied then move the cell cursor to +the start or end of the block of unoccupied cells in the current row or column. + + + + + + +&Ctrl;&Shift;Arrow keys + +If the selected cell is occupied then select all +occupied cells to the start or end of that block of occupied cells in the +current row or column. +If the selected cell is not occupied then select all unoccupied cells to the +start or end of that block of unoccupied cells in the current row or column. + + + + + + +Page Down + +Move the cell cursor 10 cells down. + + + + + +Page Up + +Move the cell cursor 10 cells up. + + + + + +&Ctrl;Page Down + +Move to the next sheet. + + + + + +&Ctrl;Page Up + +Move to the previous sheet. + + + + + +F4 + +Change cell reference between normal and +absolute reference types. + + + + + +&Ctrl;& + +Add a border to the selected cell(s). + + + + + +&Ctrl;$ + +Display the value of the selected cell(s) in Money +format. + + + + + +&Ctrl;% + +Display the value of the selected cell(s) in +Percentage format. + + + + + +&Ctrl;^ + +Display the value of the selected cell(s) in +Scientific format. + + + + + +&Ctrl;# + +Display the value of the selected cell(s) in +Date format. The value is taken as the number of days since +1 January 1900. + + + + + +&Ctrl;@ + +Display the value of the selected cell(s) in +Time format. The value is taken as the number of seconds since +midnight. + + + + + +&Ctrl;! + +Display the value of the selected cell(s) in +normal Number format. + + + + + + + + + + diff --git a/doc/kspread/config.docbook b/doc/kspread/config.docbook new file mode 100644 index 000000000..23f1a29fe --- /dev/null +++ b/doc/kspread/config.docbook @@ -0,0 +1,145 @@ + + + + +Pamela +Robert + +
pamroberts@blueyonder.co.uk
+ + + + + +Configuring &kspread; Shortcuts and Toolbars + + +Shortcuts +To change the shortcut key arrangements used by &kspread; select +SettingsConfigure Shortcuts... +. This will launch a dialog box as shown below. + + + + + + +Shortcut config screenshot 1 + + +Search through the list box to find the action you want to add or +change the shortcut keys for and select it by left +clicking on the name. By entering the name of the action in the search bar at the +top you can quickly find the desired action. You will then be able to change the shortcut +by selecting the None, Default or +Custom radio button or by clicking on the large button in +the Shortcut for Selected Action area. +The Configure Shortcut dialog box will then open. + + + + + + +Simple shortcut configuration + + +You can now simply press the key combination you want to act as the +shortcut, for example +&Ctrl;&Shift;S. The Configure +Shortcut dialog box will then close by itself as soon as the shortcut +is configured. + + + + + + +Advanced shortcut configuration + + + +You can also click on the Advanced >> button in the +Configure Shortcut dialog to get more options. +There you can configure a Primary shortcut: and a secondary +Alternate shortcut:. +You can even choose Multi-key mode, which lets you add additional +keys to the shortcut. + + +Configuring the shortcut with the simple dialog sets the primary +shortcut. + + + +User Defined Menus +You can add your own pop up menu to &kspread; so that pressing one key +combination will make the menu appear then pressing a second key, or using the +Up arrow and Down arrow keys and pressing +Enter, will select an item from it. +To do this add a Custom shortcut for each of the +actions you want to appear in the menu and in the Configure Shortcut + dialog check the Multi-key mode box, press the +key combination that you want to bring up your new menu then, separately, +press the key that will choose that item from the menu. + + + + +Toolbars +&kspread; has five toolbars: File, +Edit, Navigation, +Format and Color/Border. +each of which may or may not be shown depending on the choices made in the +Settings menu. +You can choose whether a toolbar appears at the Top, +Left, Right or +Bottom of &kspread;'s window by right clicking on +the toolbar, which brings up the Toolbar Menu, and making +a selection from the Orientation sub menu. This +Toolbar Menu also has sub menus for choosing whether the +toolbar displays icons, text or both, and the size of the icons. + +Another way of moving a toolbar is by positioning the mouse pointer over +the two vertical bars at the left end of each toolbar and holding the +left mouse button down while you drag the toolbar +to the wanted position. When you drag the toolbar in this way you can release +the mouse button when it is some distance from any of &kspread;'s window +sides, and then you will get a floating toolbar, which is not locked to any +particular part of &kspread;'s window and can in fact be moved outside of +the window. To put a floating toolbar back into one of the traditional +positions right click on its titlebar to bring +up the Toolbar Menu then choose one of the options in +the Orientation sub menu. +You can also flatten a toolbar by left + clicking on the two vertical bars at the left end of the +toolbar or by selecting Orientation +Flat from the Toolbar +Menu. A flattened toolbar appears as a small +rectangle containing two horizontal bars just under &kspread;'s Menubar. It +can be restored to normal by left clicking on it. + +Selecting Configure Toolbars... from the +Settings menu will bring up a dialog box which lets you add +buttons to or remove them from &kspread;'s toolbars. +To use this Configure Toolbars dialog box first +select a toolbar from the Toolbar: combo box. The +right hand Current actions: window will then show the +buttons currently present on the toolbar. You can remove a button by selecting +it in this window then pressing the left arrow button, or move it around by +pressing the up and down arrow buttons. To add a new button to the toolbar +select it in the Available actions: list then press the +right arrow button. + + + + diff --git a/doc/kspread/configdialog.docbook b/doc/kspread/configdialog.docbook new file mode 100644 index 000000000..8936eef58 --- /dev/null +++ b/doc/kspread/configdialog.docbook @@ -0,0 +1,377 @@ + + + + +Pamela +Robert + +
pamroberts@blueyonder.co.uk
+ + + + + +The &kspread; Configuration Dialog Box + +Selecting Settings +Configure &kspread;... opens a dialog box +with several pages, selected with the icons at the left of the dialog box, +which allow you to change many aspects of &kspread;'s operation. + + +<guilabel>Locale Settings</guilabel> + + + + + + + Locale Settings Configuration. + + + +This page of &kspread;'s configuration dialog box shows how items +such as numbers, date, time and money are displayed. +If you have loaded a spreadsheet that was generated using a different +locale, then pressing the Update Locale Settings +button on this page will update it to conform to your locale settings as they are fixed in &kcontrolcenter;. + + + +<guilabel>Interface</guilabel> + + + + + + + Interface Configuration. + + + +This page of &kspread;'s configuration dialog box (obtained by selecting +Configure &kspread;... from the Settings + menu) controls some more &kspread; features: + + + +Number of sheets open at the beginning: +Controls how many worksheets will be created if the +option Blank Worksheet is chosen when +&kspread; is started. + + + + +Number of files to show in Recent Files list: +Controls the maximum number of filenames that are shown +when you select File +Open Recent. + + + + +Autosave Delay (minutes): +Here you can select the time between autosaves, or disable +this feature altogether by choosing Do not save automatically +(drag the slider to the far left). + + + + +Create backup files +Check this box if you want some backup files created. This is checked per default. + + + + +Show vertical scrollbar +Check or uncheck this box to show or hide the vertical +scrollbar in all sheets. + + + + +Show horizontal scrollbar +Check or uncheck this box to show or hide the horizontal +scrollbar in all sheets. + + + + +Show column header +Check this box to show the column letters across the top of each +worksheet. + + + + +Show row header +Check this box to show the row numbers down the left side. + + + + +Show tabs +This check box controls whether the sheet tabs are shown +at the bottom of the worksheet. + + + + +Show formula toolbar +Here is where you can choose to show or hide the Formula bar. + + + + +Show status bar +Uncheck this box if you want to hide the status bar. + + + + + + + + +<guilabel>Misc</guilabel> + + + + + + + Miscellaneous Configuration. + + + +The Misc page of &kspread;'s configuration +dialog box contains the following items; + + + +Completion mode: +Lets you choose the (auto) text completion mode from a +range of options in the drop down selection box. + + + + +Pressing enter moves cell cursor: +Select whether pressing the Enter +key will move the cursor Down, Up, +Right, Left or Down, +First Column as determined by the setting in this drop down selection box. + + + + +Method of calc: +This drop down selection box can be used to choose the +calculation performed by the Statusbar Summary + function. + + + + +Indentation step (cm): +Lets you define the amount of indenting used by the +Increase Indent option in the Format + menu. + +The unit taken here is the one you fixe in the Configure +&kspread; dialog, in the Page Layout tab in the Default page +unit: setting. + + + +Show error message for invalid formulae +If this box is checked a message box will pop up when what +you have entered into a cell cannot be understood by &kspread;. + + + + + + + + + + +<guilabel>Color</guilabel> + + + + + + + Color Configuration. + + + +This page of &kspread;'s configuration dialog box lets you choose the +color of the sheet grid. If you do not want the grid to appear at all, uncheck the Show grid box in +the FormatSheetSheet Properties dialog. + +This page also lets you select the color of the lines used to indicate +the printed page borders when the Show Page Borders +box in the View menu is checked. +Click on the current color to display the standard KDE Select Color dialog. + + + + +Grid color: +Click here to change the grid color &ie; the color of the borders of each cell. + + + + +Page borders: +When the ViewShow Page Borders menu item is checked, the page borders are displayed. Click here to choose another color for the borders than the default red. + + + + + + + + +<guilabel>Page Layout</guilabel> + + + + + + + Page Layout Configuration. + + + +This page of &kspread;'s configuration dialog box lets you set up the +default page size, orientation and units used by the printer and by the +Page Layout dialog box (obtained by selecting +Page Layout... from the Format + menu. + + + + +Default page size: +Choose the default page size for your worksheet among all the most common page sizes. Note that you can overwrite the page size for the current sheet using the FormatPage Layout... dialog. + + + + +Default page orientation: +Choose the default sheet orientation: portrait or landscape. +Note that you can overwrite the orientation for the current sheet using the +FormatPage +Layout... dialog. + + + + +Default page unit: +Choose the default unit that will be used in your all your sheets. Note that you can overwrite the unit for the current sheet using the FormatPage Layout... dialog. + + + + + + + + +<guilabel>Spelling</guilabel> + + + + + + + Spelling Configuration. + + + +This page lets you configure the behavior of &kspread;'s spell +checker. + + + +Create root/affix combinations not in dictionary + +If this box is checked then when &kspread; finds a word in +the document which it does not recognize but which consists of a recognized +root word plus a recognized prefix or suffix it will accept it, whereas if +the box is not checked the spell checker will reject it. + + + + +Consider run-together words as spelling errors + +If this box is checked then common words which are run +together will be considered to be spelling errors, for example +cannot. + + + + +Dictionary: +This drop down selection box can be used to select +alternative dictionaries. + + + + +Encoding: +To select the character encoding that should be used. + + + + +Client: +This combo box lets you select between different spell +checking programs that may be present on your computer. + + + + +Skip all uppercase words +Check this box if you want the spellchecker to ignore +uppercase words, which are usually acronyms such as &kde;. + + + + +Do not check title case +Check this box if you want the spellchecker to ignore +the title case, for example My Own Spreadsheet or My own spreadsheet. If this is unchecked, the spell checker will ask for a uppercase letter in the title nouns. + + + + + + +Configure Text-To-Speech options +See the Text-to-Speech section +in the accessibility chapter for further details. + + + + diff --git a/doc/kspread/configure1.png b/doc/kspread/configure1.png new file mode 100644 index 000000000..7d2271307 Binary files /dev/null and b/doc/kspread/configure1.png differ diff --git a/doc/kspread/configure2.png b/doc/kspread/configure2.png new file mode 100644 index 000000000..af956024d Binary files /dev/null and b/doc/kspread/configure2.png differ diff --git a/doc/kspread/configure3.png b/doc/kspread/configure3.png new file mode 100644 index 000000000..d12ca56a6 Binary files /dev/null and b/doc/kspread/configure3.png differ diff --git a/doc/kspread/configure4.png b/doc/kspread/configure4.png new file mode 100644 index 000000000..549b8f1b8 Binary files /dev/null and b/doc/kspread/configure4.png differ diff --git a/doc/kspread/configure5.png b/doc/kspread/configure5.png new file mode 100644 index 000000000..3d1794210 Binary files /dev/null and b/doc/kspread/configure5.png differ diff --git a/doc/kspread/configure6.png b/doc/kspread/configure6.png new file mode 100644 index 000000000..92910c625 Binary files /dev/null and b/doc/kspread/configure6.png differ diff --git a/doc/kspread/copy1.png b/doc/kspread/copy1.png new file mode 100644 index 000000000..4833e0d5a Binary files /dev/null and b/doc/kspread/copy1.png differ diff --git a/doc/kspread/currency.png b/doc/kspread/currency.png new file mode 100644 index 000000000..5143aeb19 Binary files /dev/null and b/doc/kspread/currency.png differ diff --git a/doc/kspread/decreasedecimal.png b/doc/kspread/decreasedecimal.png new file mode 100644 index 000000000..6167f5dda Binary files /dev/null and b/doc/kspread/decreasedecimal.png differ diff --git a/doc/kspread/faq.docbook b/doc/kspread/faq.docbook new file mode 100644 index 000000000..c8687449a --- /dev/null +++ b/doc/kspread/faq.docbook @@ -0,0 +1,45 @@ + + + + +Pamela +Robert + +
pamroberts@blueyonder.co.uk
+ + + + + +Questions and Answers + + + + +How many rows and columns can I have in a sheet? + +Theoretically up to 32767 rows and 32767 columns. + + + +Where are the templates stored? + +As .kst files under +~/.kde/share/apps/kspread/templates/. + + + + + + + + diff --git a/doc/kspread/format.docbook b/doc/kspread/format.docbook new file mode 100644 index 000000000..afe5787cc --- /dev/null +++ b/doc/kspread/format.docbook @@ -0,0 +1,693 @@ + + + + +Pamela +Robert + +
pamroberts@blueyonder.co.uk
+ + + +Raphael +Langerhorst + +
raphael.langerhorst@kdemail.net
+ + + +Anne-Marie +Mahfouf + +
annemarie.mahfouf@free.fr
+ + + + + +Spreadsheet Formatting + + + +Cell Format +To change the format and appearance of selected cell(s), row(s) or column(s) use +the Cell Format... option from the Format + menu or from the right mouse button popup +menu. + + + + + + +Right mouse button context menu. + + + +This will bring up the Cell Format dialog box +which has several tabbed pages: + + +Data Formats and Representation + + + + + + +Data Format page. + + + +The Data Format page of the Cell Format dialog box +lets you control how the values of cells are displayed. +The top part of this page lets you select the format to be used when +displaying numeric values, dates or times. A Preview pane +allows you to see the effect of the new format. + +You can set the same data format for a row or a column by selecting the +row or column and calling the Cell Format dialog with the &RMB;. +You can increase the precision decimal for any number in Generic, +Number, Percent, Money or +Scientific formats using the Increase decimal +precision icon in the Format toolbar: + + +You can decrease the precision decimal for any number in Generic, +Number, Percent, Money or +Scientific formats using the Decrease decimal precision icon +in the Format toolbar: + + + + + +Generic +This is the default format and &kspread; autodetects the +actual +data type depending on the current cell data. By default, &kspread; right +justifies numbers, dates and times within a cell and left justifies anything +else. +If the Generic format does not suit you, you can change to a specific +format among the choices below. + + + +Number +The number notation uses the notation you globally choose in +&kcontrolcenter; in Regional & +AccessibilityCountry/Region & LanguageNumbers. +Numbers are right justified by default. + + + +Percent +When you have a number in the current cell and you switch the +cell format from Generic to Percent, the current cell number will be multiplied +by 100%. +For example if you enter 2 and set the cell format to Percent, the number +will then be 200 %. Switching back to Generic cell format will bring it back to +2. +You can also use the Percent icon in the Format +Toolbar: + + + + + +Money +The Money format converts your number into money notation using +the settings globally fixed in &kcontrolcenter; in Regional +& AccessibilityCountry/Region & LanguageMoney. The +currency symbol will be displayed and the precision will be the one set in +&kcontrolcenter;. +You can also use the Currency icon in the Format toolbar to set the +cell formatting to look like your current currency: + + + + + + +Scientific +The Scientific format changes your number using the scientific +notation. For example, 0.0012 will be changed to 1.2E-03. Going back using +Generic cell format will display 0.0012 again. The Generic cell data format does +not keep scientific notation so if you want this notation, you have to specify +it using this menu item. + + + +Fraction +The Fraction format changes your number into a fraction. For +example, 0.1 can be changed to 1/8, 2/16, 1/10, &etc;. You define the type of +fraction by choosing it in the field on the right. If the exact fraction is not +possible in the fraction mode you choose, the nearest closest match is chosen. +For example: when we have 1.5 as number, we choose Fraction +and Sixteenths 1/16 the text displayed into cell is "1 +8/16" which is an exact fraction. If you have 1.4 as number in your cell and you +choose Fraction and Sixteenths 1/16 +then the cell will display "1 6/16" which is the nearest closest Sixteenth +fraction. + + + +Date format +To enter a date, you should enter it in one of the formats set +in &kcontrolcenter; in Regional & +AccessibilityCountry/Region & LanguageTime & +Dates. There are two formats set here: the date format +and the short date format. +A random natural number NN will be transformed in the date from 30st +December 1899 (which is 0) with the number of days NN added. For example if you +have a cell with 100 and you choose Date format, "1900-04-09" will be +displayed in the cell which is 100 days after 30st December 1899. This starting +date is two days early as it was a bug in Lotus 123 and then it stayed that way +in Excel in order to keep compatibility. Few people will need to calculate from +1st January 1900 anyway and adding 9 days to 1st November 2000 for example will +give you 10th November 2000 so all normal calculations on dates are +correct. +When a cell is in the Date format, you can drag this cell down as +you do with numbers and the next cells will also get +dates, each date being increased by one day. + + + +Time format +This formats your cell content as a time. To enter a time, you +should enter it in the Time format set in &kcontrolcenter; +in Regional & AccessibilityCountry/Region & +LanguageTime +& Dates. In the Cell Format +dialog box you can set how the time should be displayed by choosing one of the +available time format options. The default format is the system format set in +&kcontrolcenter;. When the number in the cell does not make sense as a time, +&kspread; will display 00:00 in the global format you have in +&kcontrolcenter;. + + + +Text +This formats your cell content as text. This can be useful if +you want a number treated as text instead as a number, for example for a ZIP +code. Setting a number as text format will left justify it. When numbers are +formatted as text, they cannot be used in calculations or formulas. It also +change the way the cell is justified. + + + +Custom +Does not work yet. To be enabled in the next release. + + + + +The lower part of the Data Format page lets you add +a Prefix: such as a $ symbol at the start of each item or +a Postfix: such as $HK to the end. You can also control +how many digits are displayed after the decimal point for numeric values, +whether positive values are displayed with a leading + sign and whether +negative values are shown in red. + + + + +Fonts and Text Settings + + + + + + +Font page. + + + +The Font page lets you select the font family, Style:, +Size:, Weight: +and Color: for the current cell, including some additional options like +underlined or striked out text. +The lower part of the page gives a Preview of the selected text format. +The default font is set for all cells in the +FormatStyle +Manager menu with the currently used style. + + + + +Style: +Choose the style for your font for the currently selected cells. +When you select several cells with different styles, the displayed style is set +to Varying (No Change) and leaving it that way will keep +all your current style settings for each cell. Changing to +Roman for example will change all the selected cells style +text to Roman. + + + +Size: +Choose the size for your font for the currently selected cells. +When you select several cells with different sizes, the displayed size is set to + (no number written) and leaving it that way will keep all +your current size settings for each cell. Changing to 14 +for example will change all the selected cells font size to +14. + + + +Weight: +Choose the weight for your font for the currently selected +cells. When you select several cells with different font weight, the displayed +weight is set to Varying (No Change) and leaving it that +way will keep all your current weight settings for each cell. Changing to +Bold for example will change all the selected cells font +weight to Bold. + + + +Color: +Choose the color for the currently selected cells' text. +Clicking on the color bar will bring you the standard KDE Select Color dialog +where you will be able to choose the new color. + + + +Underline +Underlines the currently selected cells' text if checked. This +is +not checked per default. + + + +Strike out +This will strike out the currently selected cells' text if this +is checked. This is not checked per default. + + + + + + + +Text Position and Rotation + + + + + + +Position page. + + + +From the Position page you can control the position +of text within a cell by making suitable selections in the Horizontal + and Vertical areas or by setting the +Indent value. You can also choose to have the text +appear vertically rather than horizontally, or even at an angle. + + + +Horizontal +Set the content position horizontally in the cell. +Standard is default and is set from the data format you choose. +Left means the content will be displayed on the left of the cell. +Center means the content will be in the center horizontally in the cell. +Right means the content of the cell will be displayed on the right of the +cell. + + + +Vertical +Set the content position vertically in the cell. +Top means the content will be displayed on top of the cell. +Middle means the content will be in the middle vertically in the cell. +Bottom means the content of the cell will be displayed at the bottom of the +cell. + + + +Text Option +This is only available when the rotation is 0°. +Wrap text wraps the text so it fits in the previous cell size. If this is not +checked, the text will stay on one line. +Vertical text puts your text vertically. + + + +Rotation +Your text will appear oriented in the angle you set here. +Positive values will move it counter-clockwise and negative values will move it +clockwise. + + + +Merge Cells +When checked, this has the same effect +as DataMerge +Cells. You need to have at least two +consecutive cells selected. Those consecutive cells are then merged into a +bigger one. +When a merged cell is selected and when you uncheck this, then all cells +come back to their original size as before the merging. It has the same effect +as DataDissociate +Cells. + + + +Indent +Set the amount of indent that will be used in the cell when you +choose the FormatIncrease +Indent or +FormatDecrease +Indent menus. + + + +Size of Cell +You set here the size of the cell, either a custom width and +height or choose the default width and height. + + + + + + +Cell Border + + + + + + +Border page. + + + +The Border page lets you set the appearance of the +cell borders. If you have selected more than one cell you can apply different +styles to the borders between the cells and that surrounding the selected area. + +First select the pattern and color from the Pattern +section of the Border page then apply that to +different parts of the border by clicking on the appropriate button in the +Border section, or on one of the Preselect + buttons. The left hand button in the Preselect + section will clear any previously applied border(s). Note that you +can also add a diagonal strike-through line to the cell(s). + + +Cell Background + + + + + + +Background page. + + + +The cell background pattern and color can be selected from the +Background page. +Simply choose a desired Pattern, then select the pattern +Color and the Background color. +At the bottom of this page you can see a Preview of the configured +cell background. + + +Cell Protection + + + + + + +Cell protection page. + + + +You can change the way the content of a cell is protected in the +Cell Protection page. +All cells are protected by default (that means cell content cannot be +changed) and for the cell protection to be active you also need to protect the +sheet using the ToolsProtect Sheet... +menu and to provide a password. +You can also hide the cell formula in order to protect the way you calculate the +formula. This also needs to enable sheet protection to work. +You can hide the cell content with Hide all and again this needs sheet +protection. +You can learn more about all these settings in the Advanced &kspread; chapter, Protection +section. + + +Hide all +This hides the cell content and works only when the sheet is +protected which means that changing the Hide all +attribute of a cell has no effect unless the sheet is protected. Whether the +cell itself is protected or not does not matter. + + + + + + +Hide all. + + + +When Hide all is selected, Protected +and Hide formula are disabled as when the +sheet is protected Hide all hides the cell content and the +formula and thus masks and protects the cell content. + + + +Protected +If checked, the cell content will be protected. This is +the default behaviour. You need to protect the whole sheet using the +ToolsProtect Sheet... +menu for this individual cell protection to work. When a cell is protected, its +content cannot be changed. + + + +Hide formula +When this is checked, the cell is still visible. However, +its contents do not appear in the Formula bar. Hiding formula is only working +for cells that contain formulae so the user cannot view the formula. And the +sheet must be protected for this to work. + + + + +Do not print text +If you check Do not print text then the +text in the cell will not be printed. This is unchecked per default which means +that the cell text will always be printed by default. + + + + + + + +Conditional Cell Attributes +You can make the appearance of a cell change according to the value it +contains, useful perhaps if you are using &kspread; to keep track of your +household expenses and want to highlight any item greater than, say, one +thousand dollars. +To do this select the cell(s) then choose Conditional Cell +Attributes... from the Edit menu. This will +bring up the Conditional Cell Attributes dialog box where +you can make the font type and color of a cell change when the value meets +one or more conditions. Note that the second and third conditions only apply +if the previous condition(s) are not met. +Use ClearConditional +Cell Attributes from the Edit +menu to clear any conditional attributes from selected cells. + + + +Changing Cell Sizes +The Position page in the Cell Format + dialog lets you alter the size of the selected cell(s). Note that +changing the height of a single cell will change the height for all cells in +that row, similarly changing the width will affect the entire column. +You can also select the row(s) or column(s) to be changed then select +Resize Row... or Resize Column... + from the right mouse button pop up +menu or from the FormatRow + or Format +Column menu. +If you move the mouse cursor so that its tip is over the line between +two of the row numbers at the left of &kspread;'s window the cursor will +change to show two parallel lines each with a short arrow headed line coming +from it. When the cursor is in this state you can hold the left + mouse button down and drag the border between the two rows, +changing the height of the upper row. A similar technique can be used to +change the width of a column. + +To set the row height or column width to the minimum needed to +display the contents, select the whole row or column, and click with the &RMB; +on the row or column label. In the menu which appears, select +Adjust Row or Adjust +Column. The row or column will resize to the minimum +necessary. You can also select a single cell or range of cells, and +click Adjust Row & Column from either +the &RMB; popup menu or the Format menu. + +You can make a number of adjacent rows or columns the same size by +selecting them then choosing Format +RowEqualize Row or +FormatColumn +Equalize Column. + + + + +Merging Cells +It is often convenient to have one cell that spreads across two or more +columns or down more than one row. This can be done by merging two or more +cells into one. Select the cells to be merged than choose +DataMerge Cells. +To reverse this process, select the merged cell then choose +Dissociate Cells from the Data menu. + + + +Hiding Rows and Columns +A finished spreadsheet can often be made to look more attractive by +hiding the cells containing intermediate calculations so that only the +important data input and result areas are shown. +In &kspread; you can hide selected rows or columns by +using the Hide Rows and Hide +Columns options from the Format +Row, Format +Column or +right mouse button menus. Hidden rows and columns +are not displayed on the screen or included in a print out. +Hiding cells in this way also makes them slightly less prone to +accidental change. +To un-hide a row or column select Row +Show Rows... or +ColumnShow Columns... + from the Format +menu. In the dialog box which appears, you can select any number of +rows to show (use &Ctrl; + click to select +multiple rows or columns). + + + +Sheet properties +You can access the current sheet properties either by right clicking +on the sheet tab and choosing Sheet Properties or by +using the Format +SheetSheet +Properties menu. Please note that you can only +access the Sheet Properties when the document or the sheet is not +protected. +You can set different properties that will be valid in the current +sheet. Clicking on OK will validate your changes +and Defaults will bring back the default settings. + + + + + + +Sheet Properties dialog. + + + + + +Layout direction: +Let you choose the sheet orientation. Default is that the first +column of the sheet is on the left. If you choose Right to Left, then the first +column will be on the right and the others added from right to left. + + + +Hide zero +If this box is checked any cell containing the value zero will +appear blank. + + + +Automatic recalculation + This setting controls whether formulae are recalculated +automatically when the value of any cell they refer to changes. + + + +Show column as numbers +If this box is checked the column headings will show as numbers +rather than as letters. Letters are default. + + + +Use LC mode +If this box is checked the cell reference shown at the left end +of the Formula Bar will be displayed in LC mode (i.e. L2C3) rather than in its +normal form B3. This does not seem to be of much use at the moment. + + + +Convert first letter to uppercase +Check this box and the first letter of any text you type in will +automatically be converted to uppercase. + + + +Show grid +If checked the grid (the cell limits) will be shown. This is +default. If you uncheck it, the grid will be hidden. + + + +Show page borders +If you check this option, the page borders will be drawn on your +current sheet. Per default the page borders are not displayed. It is useful to +see the page borders if you want to print your sheet. + + + +Show formula +If this box is checked &kspread; will display the actual +formulae in cells rather than the results. + + + +Show formula indicator +If this box is checked &kspread; will display a small blue +triangle at the bottom left corner of cells containing formulae. This is useful +if you want to protect cells with formulae. + + + +Show comment indicator +If this box is checked cells containing comments will be marked +by a small red triangle at the top right corner. + + + + + + + diff --git a/doc/kspread/hideformula1.png b/doc/kspread/hideformula1.png new file mode 100644 index 000000000..5a9b589a2 Binary files /dev/null and b/doc/kspread/hideformula1.png differ diff --git a/doc/kspread/hideformula2.png b/doc/kspread/hideformula2.png new file mode 100644 index 000000000..f4f1fe26c Binary files /dev/null and b/doc/kspread/hideformula2.png differ diff --git a/doc/kspread/hideformula3.png b/doc/kspread/hideformula3.png new file mode 100644 index 000000000..9b2c58ca1 Binary files /dev/null and b/doc/kspread/hideformula3.png differ diff --git a/doc/kspread/hideformula4.png b/doc/kspread/hideformula4.png new file mode 100644 index 000000000..cb5b5a7f5 Binary files /dev/null and b/doc/kspread/hideformula4.png differ diff --git a/doc/kspread/hideformula5.png b/doc/kspread/hideformula5.png new file mode 100644 index 000000000..a0ebc9e55 Binary files /dev/null and b/doc/kspread/hideformula5.png differ diff --git a/doc/kspread/importexport.docbook b/doc/kspread/importexport.docbook new file mode 100644 index 000000000..e5c36f3a9 --- /dev/null +++ b/doc/kspread/importexport.docbook @@ -0,0 +1,105 @@ + + + + +Pamela +Robert + +
pamroberts@blueyonder.co.uk
+ + + + + +Importing and Exporting Foreign Formats +&kspread; has a limited ability to import (read) and export (write) +spreadsheet files with foreign formats. &kspread;'s capabilities at the time +of writing are summarized in the table below, for more up to date +information visit +http://www.koffice.org/filters/status.phtml. + + + + + Format + Import + Export + + + +Applix Spreadsheet +Beta +None + + +Comma Separated Values (CSV +) +Good +Good + + +dBase +Beta +None + + +Excel 97/2000 +Good +None + + +Gnumeric +Beta +Beta + + +HTML +None +Beta + + +Quattro Pro +Beta +None + + + + +To import a foreign file just load it as though it were a &kspread; +native file with File +Open.... +To export a &kspread; file in a different format select +FileSave As... +and select the format from the Filter: combo box. +Although &kspread; automatically adds a +.ksp extension to the names of files saved in its native format, +you should add the correct extension for foreign formats. + + +<acronym>CSV</acronym> Data +Tables of data are often held in text files with the values in a +line being separated by a comma, space, tab or other character, +for example 123, 456, 789, abcd, efgh. Such files +are commonly called CSV (Comma Separated +Values) files, even though the separating character may not be a comma. +If you ask &kspread; to open a text file it assumes that the file is +in CSV format and launches a dialog box that allows you to +specify the delimiter (separating character) used by the file, and shows how +the data items will be placed into different spreadsheet cells. +Other options in this dialog box let you define the Format + of the spreadsheet cells, whether text quote characters should be +removed, and whether the first line(s) of the file should be ignored. + + + + + diff --git a/doc/kspread/increasedecimal.png b/doc/kspread/increasedecimal.png new file mode 100644 index 000000000..bb56dd929 Binary files /dev/null and b/doc/kspread/increasedecimal.png differ diff --git a/doc/kspread/index.docbook b/doc/kspread/index.docbook new file mode 100644 index 000000000..171b78a6e --- /dev/null +++ b/doc/kspread/index.docbook @@ -0,0 +1,207 @@ + + + + + + + + + + + + + + +]> + + + + +The &kspread; Handbook + + + + + +Pamela +Roberts + +
pamroberts@blueyonder.co.uk
+ + + +Anne-Marie +Mahfouf + +
annemarie.mahfouf@free.fr
+ + + +Gary +Cramblitt + +
garycramblitt@comcast.net
+ + + + + + +2002 +Pamela Roberts + + + +2005 +Anne-Marie Mahfouf + + + +2006 +Gary Cramblitt + + + + +&FDLNotice; + +2006-06-12 +1.5.2 + + + + +&kspread; is a full featured spreadsheet program. + + + + +KDE +Koffice +KSpread +Spreadsheet + + + + + +Introduction + +This handbook is dedicated to the memory of Visicalc. + +&kspread; is a full featured spreadsheet program. It is part of the &koffice; +productivity suite for the K Desktop Environment (&kde;). +Other &koffice; applications include &kword;, (word processing), +&kpresenter; (slide presentation creator) and &kchart; (for producing charts +and graphs) among others. + +You might care to visit +http://www.kde.org for more information about &kde; in general, or the +&koffice; web site at +http://www.koffice.org + + + +&basics; + +&format; + +&advanced; + +&config; + +&configdialog; + +&a11y; + +&commands; + +&faq; + + + +Credits and License + + +&kspread; + + +Program copyright 1998-2002 The KSpread Team: + + + +Torben Weis weis@kde.org + +Laurent Montel lmontel@mandrakesoft.com + +David Faure faure@kde.org + +John Dailey dailey@vt.edu + +Philipp Müller philipp.mueller@gmx.de + +Ariya Hidayat ariya@kde.org + +Norbert Andres nandres@web.de + +Shaheed Haque srhaque@iee.org + +Werner Trobin trobin@kde.org + +Nikolas Zimmerman wildfox@kde.org + +Helge Deller deller@gmx.de + +Percy Leonhart percy@eris23.org + +Eva Brucherseifer eva@kde.org + +Phillip Ezolt phillipezolt@hotmail.com + +Enno Bartels ebartels@nwn.de + +Graham Short grahshrt@netscape.net + + + + + +Documentation copyright 2002 Pamela Roberts +pamroberts@blueyonder.co.uk + + +Minor updates to documentation for &koffice; 1.3 by +&Philip.Rodrigues; &Philip.Rodrigues.mail;. + +&underFDL; +&underGPL; + + + +Installation + +&kspread; is part of &kde;'s &koffice; package and uses various +&koffice; libraries. &koffice; itself is part of &kde; and depends on the +general &kde; libraries. +For instructions on acquiring and installing &kde;, &koffice; and +&kspread; please visit +http://www.kde.org and +http://www.koffice.org. + + + +&documentation.index; + + + + diff --git a/doc/kspread/kbd-focus-ext.png b/doc/kspread/kbd-focus-ext.png new file mode 100644 index 000000000..f7aa6f585 Binary files /dev/null and b/doc/kspread/kbd-focus-ext.png differ diff --git a/doc/kspread/mousenav.png b/doc/kspread/mousenav.png new file mode 100644 index 000000000..462c6051f Binary files /dev/null and b/doc/kspread/mousenav.png differ diff --git a/doc/kspread/newdocument.png b/doc/kspread/newdocument.png new file mode 100644 index 000000000..923a61b6a Binary files /dev/null and b/doc/kspread/newdocument.png differ diff --git a/doc/kspread/percent.png b/doc/kspread/percent.png new file mode 100644 index 000000000..75649e5b9 Binary files /dev/null and b/doc/kspread/percent.png differ diff --git a/doc/kspread/sheetproperties.png b/doc/kspread/sheetproperties.png new file mode 100644 index 000000000..ee325f869 Binary files /dev/null and b/doc/kspread/sheetproperties.png differ diff --git a/doc/kspread/shortcut1.png b/doc/kspread/shortcut1.png new file mode 100644 index 000000000..df152f854 Binary files /dev/null and b/doc/kspread/shortcut1.png differ diff --git a/doc/kspread/shortcut2.png b/doc/kspread/shortcut2.png new file mode 100644 index 000000000..d47fab20d Binary files /dev/null and b/doc/kspread/shortcut2.png differ diff --git a/doc/kspread/shortcut3.png b/doc/kspread/shortcut3.png new file mode 100644 index 000000000..34a25dea4 Binary files /dev/null and b/doc/kspread/shortcut3.png differ diff --git a/doc/kspread/sort1.png b/doc/kspread/sort1.png new file mode 100644 index 000000000..cc1436b43 Binary files /dev/null and b/doc/kspread/sort1.png differ diff --git a/doc/kspread/starting1.png b/doc/kspread/starting1.png new file mode 100644 index 000000000..0bcc216e3 Binary files /dev/null and b/doc/kspread/starting1.png differ diff --git a/doc/kspread/tts.png b/doc/kspread/tts.png new file mode 100644 index 000000000..332d77bf8 Binary files /dev/null and b/doc/kspread/tts.png differ -- cgit v1.2.3