Chapter 4 NextOffice Calc
Contents
1. 9 an o Fig 4 31 Fig 4 32 5 If the selected cells are not the ones you wish to sum up you can use your mouse to click and drag over the desired cells You can select non contiguous cell by pressing lt Ctrl gt while pressing your mouse button Statistics Functions Statistics functions are commonly used in spreadsheets They include COUNT Count how many numbers are in the list of arguments Text entries are ignored COUNTA Count how many values are in the list of arguments Text entries are also counted MAX Return the maximum value in the list of arguments LARGE Return the n th largest value in the list of arguments MIN Return the minimum value in the list of arguments SMALL Return the n th smallest value in the list of arguments RANK Return the rank of a number in the list of arguments AVERAGE _ Return the average of the list of arguments MEDIAN Return the median of the list of arguments STDEV Estimate the standard deviation based on the list of arguments 4 10 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Date and Time Functions Date and Time functions are used to manipulate data like year month day hour minute second and weekdays TODAY Return the current computer system date NOW Return the current computer system date and time DAYS Calculate the difference between 2 date values YEAR Return the value of year day month hour min2. Page Style dialog box Fig 4 61 2 Select the Page tab and specify the orientation as Landscape Fig 4 62 Fuge Ztyir Prial dt ee ee tal be ria fobs Thar pe z Te s EDE 7 i O lt a P Pr ig i ge 1 En oy Fig 4 61 L a Fig 4 62 Freeze and Split Window If the rows and columns in the spreadsheet are too long and cannot be displayed in full view you can choose to freeze some of the rows and columns By freezing their position and scrolling through other rows and columns you can easily cross reference two different sections in your spreadsheet at the same time 1 Select the cell just underneath the rows and on the right of the columns you wish to freeze 2 Select menu Window Freeze Fig 4 63 4 64 a fT xa am ise i P Diri Yes p Pmi b ha Emirs ibh fa E Bre maire CEE EE REQ We kK bA w 4 a4 OH eo Simer Ceh W h tat a ary baal BEI zang axe i E D siii MinT Ca a B T F q ar a TA ri 3 S 4 i ii id ii d aa ail 4 H T 5 2 2 i t T f aj 33 Fig 4 63 Fig 4 64 If you want to scroll through the frozen area as well select menu Window Freeze NextOffice User Manual 4 19 Chapter 4 NextOffice Calc NextOffice Sorting You can use the sorting functions to sort the data in a spreadsheet in a particular way l 2 4 First select the cells you wish to sort Select menu Data Sort to pop up th
3. Sheetl Sheet2 Sheet3 lt my EE Sheet 2 7 Default Fig 4 2 7 Fig 4 26 1 Move to the first or last worksheet 2 Move to the preceding or following worksheet 3 When the mouse is placed here the cursor will change into a double ended arrow and you then drag the mouse to widen the tab bar to display more worksheet tabs Fig 4 27 Hide Grid Lines To not display the grid lines select menu Tools Options Spreadsheet View Fig 4 28 un check the Grid lines check box Fig 4 29 4 8 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Formulas and Charts Basic Formula Symbols Formulas provide basic functions to the spreadsheet When setting the formulas you have to enter different formula symbols Following is a concise guideline Symbols Description Examples Equal 123 456 Add A 19 Subtract B3 C6 i Multiple 10 10 Divide 100 25 A Index 10 2 10 to the power of 2 lt Less than a condition i1f A1 lt A2 too much drop some gt Greater than a condition if A 1 gt A2 too little add more lt Less than or equal to a condition if B1 lt 100 too little return deal gt Greater than or equal to a condition if B1 gt 300 too expensive deal lt gt Not equal to a condition if D1 lt gt D2 no discrepancy b
4. liwt Roa Took Dai Wimhir Hila aE E E gt rE Eiee F Hs Bib N Ea a E a S E e p iml i0 BIUI memenne A BX Besa g 0 A ALIV1 fa EH Changing Row Height To change the height of a row position the mouse cursor in between the row tabs The cursor will turn to a double ended arrow and you can then click and drag the mouse cursor up and down to adjust the height Alternatively you can select the rows and right click with your mouse on the row tabs and select Height to adjust the height of the rows Fig 4 14 4 15 By choosing Optimal Row Height Calc will automatically set the optimal row height for you Fig 4 16 4 17 Row Height Row Height Format Cells Height 0 18 Row Height 4 2 E 5 Optimal Row Height 6 EN 8 9 Default value Insert Rows EH Delete Rows ff Delete Contents Delete Fig 4 15 10 Hide 11 Show _12 13 Cut CthX 14 tS Copy Che Fig 4 14 NextOffice User Manual 4 5 Chapter 4 NextOffice Calc NextOffice Optimal Row Height aA Forma Cells Optimal Row Height Row Hagh ram How Hngh i KH lien Rows J Es Lele Hiwi ET Deke Coamnts Delete l i I Hele I chow I I I A Cu Fig 4 16 Insert or Delete Rows To insert or delete a row right click on a row tab and select Insert Rows Fig 4 18 or Delete Rows accordingly Fig 4 19 J er
5. now set your desired format Fig 4 55 4 Finally click lt OK gt to confirm NextOffice User Manual 417 Chapter 4 NextOffice Calc NextOffice Switch between formula display and result display If you want to see the formulas used in a spreadsheet you normally have to click on each cell individually But this method is not effective if there are many formulas in the spreadsheet A simpler way is 1 Select menu Tools Options to pop up the Options dialog box Fig 4 57 2 Select Spreadsheet View Fig 4 58 Bie Bae Few ji Beet Toots nie Enies Hab oe A T irimi F ja a Leger f hp Lui Drin HBE 2 i fa T ipo eA i E FF gaii F mz Sree i E 3 eset Dex mer T i z 4 77 si Logitech rT Bi ais 7 IT kiaka Fire E j ence t Ec i ii ri amn poe HI Opina ioman E diag j kams io i 7 Hermes re ria minm Heong ian IHL Pies Demag UF has Le J ta j Pa Fig 4 57 3 Under Display check the Formula check box Fig 4 59 4 Finally click lt OK gt to confirm 5 If you want to revert to display the results of the formulas un check the Formula check box Fig 4 60 4 18 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Change Page Orientation The default page orientation of a spreadsheet is portrait It can be changed to landscape 1 Select menu Format Page to pop up the
6. 0 h Labani emg D Duri Pr t Pan jona OT pisk 4 Popi bakia bi D ih baliat Fisi he i biski Pi mh fom im U lah i el Et Ch Bagia ek Deed erie shl 4 16 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Duplicate Rows and Cells If the spreadsheet is too big and runs across multiple pages you can set to print out column labels and row labels on each page 1 Select menu Format Print Ranges Edit Fig 4 51 2 In the Row to Repeat or Column To Repeat field of the pop up dialog box select the row or column which you want to appear in every page If the title is in Row 1 enter 1 as the row If the title is in A column enter A in column Then press lt OK gt Fig 4 52 Fig 4 52 11 Lp Goel F Fi any g 4 51 Select non contiguous cells Sometimes we have to format different cells in a same way If we format each cell individually it could be quite inefficient and prone to error In this case you can format adjacent and non contiguous cells collectively by doing the following 1 Select a cell you wish to format Press Shift and left click with your mouse Fig 4 53 2 Press the lt Ctrl gt key and left click to select other cells applying the same format Fig 4 54 6 7 i PI Ja E iT I pa Fig 4 53 Fig 4 54 3 Release the lt Ctrl gt key right click on the mouse and then select m Format Cells You can
7. Chapter 4 NextOffice Calc Calc is the spreadsheet application of NextOffice with functions and capabilities comparable to MS Excel A spreadsheet usually comprises text numbers and formulas You can even make use of Function to perform complicated calculations You can also use spreadsheet for managing sorting searching and filtering information Data in a spreadsheet can be converted into a chart to make the presentation clearer When changes are made in the spreadsheet the changes will automatically be reflected in the chart Title I EE Men as a eA EEE i Toolbar pee m m toolbar Cali Status b lt Fig 4 1 A spreadsheet can contain many worksheets and each worksheet may contain many cells arranged in rows and columns Each cell can contain a formula text or numbers To directly enter information into a cell you can double click on it with your mouse Alternatively you can first select your desired cell and then input data into the Input Line field on the top Confirm your input by pressing the lt Enter gt key When entering information into a cell you will see the information being displayed in both the cell and the Input Line at the same time Fig 4 2 A cell can hold more text than it can show If the adjacent cell on its right is blank its content displayed can be extended to it However if the adjacent cell on the right is not blank you will see a small red triangle on the right margin of th
8. Edit View Insert Format Tools Data Window Help a Hw 2729S i J h 445 86 D amlaga als x A d Arial j o M BT u ea E al ox Fig 4 7 E iE c Monday 1 2 Fig 4 6 3 At this point hold down the mouse button and drag it down or drag it to the right The subsequent sequential data will be listed You can also drag the mouse up or to the left depending on how you wish to arrange the data Fig 4 7 4 Release the mouse button when you reach the last cell 4 2 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Automatic Line Break in Cell As mentioned before if the length of the text is longer than the cell can show the extra text can still be displayed if the adjacent cell on the right is blank However if the adjacent cell on the right is not blank apart from enlarging the cell you can also display the text by using the Automatic Line Break option 1 First select the cell 2 Right click on the mouse and select Format Cells Fig 4 8 Format Cell Ingert Cells Delete Cells fy Delete Contents Delete A Cut ChE Ls Copy Ctrtc belection List Fig 4 8 3 In the Format Cell dialog box select the Alignment tab and check Automatic Line Break check box Finally click lt OK gt to confirm Fig 4 9 Format Cells Cell Pistiechon Nimhe Foni Peni Effect Alignment Asa Typogeaphy Headers Hazh gratia Tex ahpn Hangot Vertical Te
9. L E i p HI EHk ERMEE Geometry F iiided nd gra Fa 7 owed depth i bad aimi Fonta ugk J b gE D 1 omy H ai a pire i E e a Fig 4 42 Fig 4 43 4 14 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Printing in Calc There are some differences between printing in a spreadsheet and other applications Page Header and Footer 1 Select menu Format Page and a Page Style dialog box will appear Fig 4 44 2 Select the Header or Footer tab and check the Header on check box Then click Edit 3 Now you can select the file name sheet name page number number of pages date or time to be displayed on the header or footer as well as the font type Fig 4 45 Fig 4 44 Setting Print Range 1 First select the section you wish to print 2 Select menu Format Print Ranges Define Fig 4 46 3 If you have define a print region before and now you want to define more then select Format Print ranges Add Bis Eis Yew aod F am Tooke st Feie fhb iad Ey ia ae Erini eating ahii ty Te BP oF i zs t xng E i p Ls i p Aaj ii Posu i ae p a of Gta toe z k hui We tel Homey L m Fig 4 46 NextOffice User Manual 4 15 Chapter 4 NextOffice Calc NextOffice 4 You may also select Format Print Range Edit Then under the Print Region
10. alance A range of cells sum A1 A9 summation of cells from Al to A9 A range of non contiguous cells sum A1 A3 A5 summation of cell Al A3 and A5 66__99 Note the symbol is very important All formulas must be preceded by the symbol or they will consider as a string instead of formulas Te Uatitled Maxtlttice Gale Be Eft Tee Aen Few Jol T A i nE E ee Ana EO In the Formula Bar there is a small Sum icon which can be used to quickly add up numbers Short cut to Sum function H eo E 1 First click on the cell you wish your sum to appear in al i J 2 Then click on the Sum icon in the Formula bar Fig 4 30 Fig 4 30 NextOffice User Manual 4 9 Chapter 4 NextOffice Calc NextOffice 3 At this moment the cell will display the sum formula and automatically select appropriate cells for sum up The selected cells are enclosed by a blue box Fig 4 31 4 Ifthe selected cells are the ones you wish to sum up press the lt Enter gt key to calculate the sum Fig 4 32 FE Tandedl Mextttice Cale Fue det Vere med Foe Jook aa Peete Helg TE Untitled WextOlfire Cak fue Ben Vere lihi Foot Took ow Moedor fel 2 saa e REa HG x de Bae eaea de ig Anal lt 7 BIU EZ fa Ariel zo BFU EZ sM fa Rw g if 5 i G c D i 1 2 T 12 z yn E 33 i 2 Ea 2 4 44 i dd 5 72 1 KA 133 T 7 a a g
11. e Sort dialog box Fig 4 65 Select the Sort Criteria tab Here you can set a maximum of 3 sorting criteria Fig 4 66 ak Fig 4 6 For more sorting options select the Options tab For example Case Sensitive and Range contains column labels are available additional options Using Auto filter The Auto filter function inserts a combo box on one or more data columns and allows you to select the data to be displayed l PA 4 20 First select the column that you wish to apply Auto filter Select menu Data Filter Auto filter Fig 4 67 or click once in the Auto filter icon on the Tool Bar You will see a combo box arrow in the first row of your selected range Fig 4 68 fue Ben Few not Foot ook Dab Wodow ele D dag lan tag ba iod 10 Hf U EZA rob ALDI ja E ia von A Ba c D E pu ee ome F 33 3 33 3 3 7 E BE I i 44 4s 4a 44 5 PR 2 44 23 Fig 4 67 5 7 45 44 3 T fi NextOffice User Manual NextOffice Chapter 4 NextOffice Calc 3 Single click on the drop down arrow in the column heading and select an item Only those rows whose contents meet the filter criteria are displayed The other rows will be hidden Using Standard Filtering For standard filter you can set a maximum of 3 filtering criteria 1 First select the area you wish to use standard filter on Fig 4 69 2 Select menu Data Filt
12. e T t rr E E Fa Fig 4 71 3 An Import Text File dialog box will appear Click lt OK gt You can select the typeface for the text to be imported and also the field delimiters When you have finished click lt OK gt to confirm Fig 4 73 nal eel TL Be aa es ae ee i To MA Se Ue eo ed Fe i Po Se ee ee Th cee ar an Fig 4 73 4 22 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Export CSV File 1 Select the spreadsheet you wish to export as a CSV file 2 Select menu File Save as to pop up the Save as dialog box Fig 4 74 3 In the File type field select the format Text CSV Enter the name for the file and click Save Fig 4 75 D mri Tenge Of he tas l G bmi Ceat j m Seep p te a pe a O Fig 4 74 4 An Export to text files dialog box will appear Select the character set the field and the text delimiters then click lt OK gt to confirm Fig 4 76 Export of text files Feb opit hacer ter get Shines tedibonal Widower bed debe Test deleraiier C Fosd colum wielth Fig 4 76 Note that if the text uses commas for decimal or thousands separators do not select the comma as a delimiter Or if the text uses double quotation marks you must use single quotation marks as a separator NextOffice User Manual 4 23
13. e cell This triangle indicates that there is more text in this cell than displayed Eb Bit Few ma Foot Took Don Ha ep Be Efe Dew oer Pye Took Dam Bodie Help ims ot id N Q wh ahk DE g iS nE E Be s DE oe a Arial it EFU EBREI p Anal J EIU ENII AJ J jq E Tmn taae el Al e fog D o Tetka than the leegthel fell 4 U D I BT et lost thana length of field Fig 4 3 NextOffice User Manual 4 Chapter 4 NextOffice Calc NextOffice Sometime the content is longer than it can displayed In this case it simply displays marker HHH You can widen the cell or set your cell property to Optimal width Select menu Format Column Optimal Width Fig 4 4 4 5 Optimal Row Height h Goo Gem Hien bi rimi te bar r i Fag bir SPS Sipe F ESA ai oe eet ee i _ y iin f i Haap ai Irs i mr e Py Lige f Bp Pym w batj iama os r r Fig 4 4 ig 4 Setting up the cells Auto fill in Data When you input sequential data such as months or days of the week you can make use of sort lists Instead of filling in every cell you can quickly drag and fill out the content 1 For example input days of the week In the first cell enter the word Monday Fig 4 6 2 Position the cursor to the bottom right corner of the cell The cursor will turn into a small cross W Untitled NextOffice Calc Brai Gentine CC ir ew feet eet jd fe Sete fe File
14. eet before or after the current worksheet the name of the new worksheet and the number of worksheets If you insert more than 1 worksheet they will automatically be numbered and arranged accordingly Fig 4 23 22 23 7 25 Delete Sheet A Rename Sheet 38 MovefCopy Sheet 99 Select All Sheets x A Cut Cti X iS Copy Sheetl 7 T Sheet 1 3 Default Fig 4 22 Fig 4 23 4 When you have finished click lt OK gt You can delete worksheets in a similar way A confirmation dialog box will appear and you can click Yes to confirm the deletion Renaming worksheet 1 Position your mouse cursor on the tab label of the sheet that you want to rename 2 Right click on the worksheet tab and select Rename Sheet Fig 4 24 3 In the dialog box enter the new name and then click lt OK gt The name of the worksheet can contain English words or Chinese characters or numbers Fig 4 25 NextOffice User Manual 4 7 Chapter 4 NextOffice Calc NextOffice i Rename Sheet Insert Sheet Delete She 26 Delete et 7I 28 Move Copy Sheet 23 Select All Sheets 30 a 31 Cut Ctr X it i s Copy Chc Sheet 1 3 Default Fig 4 24 Navigating Worksheets If you have inserted many worksheets and their tabs cannot all be displayed the Tab bar will show more navigation options Fig 4 26 31 La 2 3 _4 Sheetl_ Sheet2_ Sheet3 IE ae 7 7 7 TEN Aa A A i f PIETA 2 34
15. er Standard Filter to bring up the Standard Filter dialog box Fig 4 70 Fig 4 69 3 For example you may want to filter out from some weather data such as only temperatures exceeding 20 degrees humidities greater than 80 and months with rainfall exceeding 80mm You can input these criteria in the relevant fields in the dialog box 4 Finally click lt OK gt to confirm You can also copy the filter results into another cell Click on More button for more filter options You can check the Copy results to check box then click on the Shrink icon on the far right The dialog box will shrink and you can select the cell you wish to copy the results into Then you can click on the icon on the far right of the dialog box again to resize its size Finally click lt OK gt NextOffice User Manual 4 2 Chapter 4 NextOffice Calc NextOffice Import and Export Text Files CSV files are text files that contain plain text CSV files usually use commas semicolons or other characters as the field delimiters Text strings in a CSV file are enclosed by quotation marks numbers are written without quotation marks Import CSV File 1 Select menu File Open to pop up the Open dialog box Fig 4 71 2 Select the CSV file you wish to import and click Open Fig 4 72 De E i ie ec a3 i a AL Loy Ley lj D Tae Tiup fagar Diagiiki hah ip hu pg i
16. mal Dek l Prati Rov Hih Row Hahi i A ate Opbanal Bere Hih b Opiral Row Haigh i E ike Arn i E Depe Conka Deki E Bes ghee i 1s 1 J Lis i D Geer Cadet F i Ea EE if 16 7 17 Fig 4 18 Fig 4 19 Show or Hide Row To hide or show a row right click on a row tab and select Hide Fig 4 20 or Show accordingly Fig 4 21 a 8B ermal Calli Kew Regt oy Optional Rew Bighi FE kmr Rowe BR Dabi Fiet E Deke Cockak Tie ete eat a a e z hoys m m a e Lear EPE A Cot Cot D Gap iht on om T Fig 4 21 4 6 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Managing Worksheets A spreadsheet can contain a number of worksheets On the bottom of the window you can see different tabs each identifying a worksheet marked Sheet 1 Sheet 2 etc By default a new spreadsheet contains only 3 worksheets However you can add or delete worksheets at any time according to your needs You can also name each worksheet to clearly show that information each one contains Adding New Worksheet 1 Move the mouse cursor to the bottom of the window and click on a worksheet tab to select the worksheet The new worksheet can be inserted before or after the selected worksheet 2 Right click on the mouse and select Insert Sheet Fig 4 22 3 In the Insert Sheet dialog box select whether you wish to insert the new worksh
17. pear oe 2 Click the arrow besides Borders icon in the Object Bar A menu of different border line types will pop up for you to choose from Fig 4 33 3 When border lines have been added in they will be visible when printed out i 4 If you want further settings with borders you can select menu 7 cae Format Cell to make further customization Fig 4 34 ii 5 In the Format Cells dialog box select the Borders tab s im Fig 4 35 6 Here you can set the style thickness color and even shadow __ of the border lines When you have finished click lt OK gt Fig 4 35 4 12 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Merging and Centering Cells f amp tm Oi Exa ng BN MEE ls 2 Click Merge Cells and Centered icon in the Object Bar Fig 4 36 1 First select the cells you wish to merge Creating Charts Charts can help to present data in a spreadsheet more clearly NextOffice provides many different types of charts for your choice 1 First select the section of data you wish to present as a chart 2 Click the Insert Chart icon on the Tool Bar Fig 4 37 Gi Bia Pee jen Feet Took oe Fite Eb a HE a0 Boo N a 45 o H by iid BIU Zm eH S T E a I fea E a ey pme a e En i a L a i 4 rs l E E Fig 4 37 3 Move the cursor to where you wi
18. section enter the desired print area 5 To cancel print region section select menu Format Print Region Cancel Another method is to 1 Select menu View Page Break Preview Fig 4 47 2 Now you will see that the areas to be printed is displayed against a white background while the areas that will not be printed is displayed against a gray background Each page will be framed by a dark blue border To define the printed area you can first select the area and then right click to select Add Print Range Or you can click and drag the dark blue border to adjust the print ranges Fig 4 48 Ene Edt Yorw imest Format Jook Deh Widow Help i te gt a oo 2 aa lt p Normal CE E ue b Jo 2 2 odkaz t ETag amp A i im 2 epi anan pug E oe ik Pi O ageDoakPevey O O o O Fet rt U i j i m j j ey Jooltess i T Aj Focnvela Bar i v Dites Blas H fp i 2 P Cohn amp Row Healers i a 3 t gt k i Value Haghkighang Cebe j z f I Dai Sources Mj i i H 7 G Py Semen Crha t 8 L Zoom S j i 10 Main Titia By os Fig 4 47 Fig 4 48 Select Print Objects 1 Select menu Format Page Fig 4 49 2 In the pop up dialog box click Sheet and select print objects under the Print title For example Column and row headers Grid Charts etc Fig 4 50 ratar Raih Smi vga Jarh Lett kii
19. sh the chart to appear on the worksheet The cursor will change into a cross Click on the mouse and drag out an area for the chart After the chart is inserted you can still adjust its size and position 4 When you release the mouse button an Auto format chart dialog box will appear Fig 4 38 Follow the guidelines to set the chart format such as choosing the axes labels the chart type the variant the title the axes etc Finally click lt OK gt to confirm Fig 4 39 Uie ehi oik ir mi aan Bp deed die mii Da iaa mag mrs l en i i i aT ane Fig 4 39 NextOffice User Manual 4 13 Chapter 4 NextOffice Calc NextOffice 3D Charts If you feel that 2D charts are too plain you can try changing them to 3D 1 First double click on the chart At this moment 8 black control points appear on the border of the chart 2 Right click on the chart and select Chart type Fig 4 40 3 In the Chart type dialog box select 3D and then choose the desired chart type Finally click lt OK gt to confirm Fig 4 41 Fig 4 40 After you have finished creating a 3D chart you can right click on the chart and select 3D effects to adjust effects such as shading illumination etc Fig 4 42 4 43 While the black control points are still visible you can single click on the chart and red control points will appear around the chart Now you can rotate and tilt the chart using your mouse i
20. st onenibon Degrees _ Wepiealhr cached T ACD Rejra od ce F s i ac Feoperes Li Wisp teat cuiomancally Shamik to ft call oe Fig 4 9 NextOffice User Manual 4 3 Chapter 4 NextOffice Calc NextOffice Restricting Input Data Validity When entering data you can set the validity of the data For example you can set dates as the only valid data that can appear in column C This can prevent erroneous data entry 1 Select column C 2 Select menu Data Validity Fig 4 10 W Untitled2 NextOffice Calc File Edit wiew Insert Format Tools Data Window Help T N Es id fe i g Define Range Select Range Q dy Arial 10 iea C1 C65536 P f4 Eiter gt Subtotals Validity Multiple Operations Consolidate Outline gt DataPilot Fig 4 10 3 Click on the Criteria tab and in the Allow field select Date Fig 4 11 4 Click on the Error Alert tab and check the show error message when invalid values are entered check box Fig 4 12 Fig 4 11 5 Finally click lt OK gt 4 4 NextOffice User Manual NextOffice Chapter 4 NextOffice Calc Managing Row and Column Managing rows and columns are quite similar We will use rows as an example To select the entire row for example Row 1 click on the row tab marked 1 Fig 4 13 T fotited Hartonen Cak Ee Eda Yes
21. ute and second respectively DAY MONTH HOUR MINUTE SECOND Today and Now are updated automatically when you re open or modify the document Logic Functions Using logic functions AND Return true if both TRUE otherwise return FALSE OR Return false if both FALSE otherwise return TRUE NOT Reverse the boolean result IF Specify a logic test to be performed based on the boolean result Mathematical Functions MOD Return the remainder after a number is divided by a denominator ABS Return the absolute value of a number INT Round a decimal number down to the nearest integral value ROUND Return a decimal number rounded to a certain number of decimal places COUNTIF Return the number of elements that meets with certain criteria within a cell range SUMIF Add the cells specified in a given criteria RAND Return a random number between 0 and 1 NextOffice User Manual 4 11 Chapter 4 NextOffice Calc NextOffice Trigonometry Functions SIN Return the sine cosine and tangent of an angle COS TAN ASIN Return the arc sine arc cosine and arc tangent of a number ACOS ATAN Setting Cell Border The border lines around each cell mark its boundary By default they will not be visible when printed out However you can choose to have the border lines printed Gr He msoua 1 First select the cells which you wish their border lines to ap
Download Pdf Manuals
Related Search