2 GS-Calc 3 \nGS-Calc\nGS-Calc Document\nGS-Calc (*.gsc)\n.gsc\nGS-Calc.Document.2\nGS-Calc Document\nGSC\nGS-Calc\n 4 GS-Calc - data\nGS-Calc - data 5 Text\nText 6 GS-Calc - Object\nGS-Calc - Object 7 Too many functions. 8 Delete protected cells? 9 Can't insert a new column if the last column is not empty. 10 Can't insert a new row if the last row is not empty. 11 Do you want the respective records to be deleted together with spreadsheet rows?\n(This action can not be undone.) 12 Valid page numbers are between 1 and 9182. 13 Failed to create object. Make sure the object is entered in the system registry. 14 Invalid row or column range. 15 Invalid password. 16 Invalid number. 17 OLE initialization failed. Make sure that the OLE libraries are the correct version. 18 Invalid password. 19 Invalid file format. 20 Selected data range is too big. 21 Constants can not be negative numbers. 22 Solution not found. 23 The database does not exist. This database format must use an existing file. 24 Save Text File 27 Black 28 Maroon 29 Green 30 Olive 31 Navy 32 Purple 33 Teal 34 Gray 35 Silver 36 Red 37 Lime 38 Yellow 39 Blue 40 Fuchsia 41 Aqua 42 White 43 Automatic 44 New 45 Chart 46 Properties 47 Ellipse 48 Rectangle 49 Selected object is too big. 50 Save Database 51 Open Database 100 Server is still busy. 106 Integration 32796 Insert a new chart.\nChart 32797 Sorts selected cells.\nSort 32798 Changes font for the current selection.\nFont Name 32799 Changes font size for the current selection.\nFont Size 32800 Inserts a new column. 32801 Removes columns from the active document. 32802 Inserts a new row. 32803 Removes rows from the active document. 32804 Sets or removes cells protection. 32806 Aligns text to the left side of a cell.\nLeft 32807 Aligns text to the right side of a cell.\nRight 32808 Centers text horizontally.\nCenter Horizontally 32810 Displays numbers as a currency.\nCurrency 32811 Displays numbers with the percent sign.\nPercent 32812 Displays numbers with separators.\nSeparator in Numbers 32814 Sets or removes bold format.\nBold (Ctrl+B) 32815 Sets or removes Italic format.\nItalic (Ctrl+I) 32816 Sets or removes underline format.\nUnderline (Ctrl+U) 32823 Changes the page options.\nPage Setup 32831 Recalculates all formulas of the active document. 32832 Sets or removes strikeout format.\nStrikeout 32833 Selects normal format.\nNormal 32834 Sets the default style of displaying numbers. 32835 Enables you to select frames for the current selection.\nFrame 32837 Removes frames. 32838 Enables you to change cell and font colors.\nColors 32839 Sets the default row heights. 32850 Inserts a new ellipse.\nEllipse 32851 Inserts a new rectangle.\nRectangle 32855 Hides or shows the selected cells. 32858 Sets or removes breaking text. 32859 Removes cell and font colors. 32861 Enables you to change font shadow.\nShadow 32864 Removes font shadow. 32869 Moves the selected object to foreground. 32870 Moves the selected object to background. 32874 &Update Records 32875 Removes frames. 32876 Solves a linear equation system. 32877 Finds an optimal solution using linear programming. 32878 Inverses matrix. 32882 Calculates the determinant of a square matrix. 32883 Performs Interpolation. 32884 Performs Integration. 32885 Calculates correlation. 32888 Pastes selected formula. 32890 Enables you to change the number of displayed decimal digits.\nDecimal Places 32892 Enables you to change the password. 32895 Enables you to change the program settings. 32900 Displays and changes information about the current document. 32901 Inserts series of numbers or text. 32903 Shows or hides the Formatting toolbar. 32905 Changes the current displaying scale.\nZoom 32906 Shows or hides the grid. 32907 Inserts series of numbers or text. 32908 Aligns text to the upper cell edge. 32909 Aligns text to the down cell edge. 32910 Centers text vertically. 32966 Edits object properties. 32967 View or edit the settings of the selected cells. 32968 Insert selected formula. 32969 Removes formatting for the selected cells. 32970 Changes width or height of the selected columns or rows. 32971 Replaces all formulas within the selected cells by their values. 57344 GS-Calc 57345 For Help, press F1 57346 57347 %1 in %2 57349 %1 - %2 57600 Creates a new document.\nNew (Ctrl+N) 57601 Opens an existing document.\nOpen (Ctrl+O) 57602 Closes the active document.\nClose 57603 Saves the active document.\nSave (Ctrl+S) 57604 Saves the active document with a new name.\nSave As 57605 Changes page layout. 57606 Changes the printer and printing options.\nPrint Setup 57607 Prints the active document.\nPrint (Ctrl+P) 57609 Displays full pages.\nPrint Preview 57610 Updates the container to show any changes.\nUpdate 57611 Save a copy of the active document with a new name.\nSave Copy 57612 Sends the active document through electronic mail.\nSend Mail 57616 Opens this document. 57617 Opens this document. 57618 Opens this document. 57619 Opens this document. 57632 Cuts the selection.\nDel (Del) 57634 Copies the selection and puts it on the Clipboard.\nCopy (Ctrl+C) 57635 Cuts the selection and puts it on the Clipboard.\nCut (Ctrl+X) 57636 Searches the current document for text.\nFind (Ctrl+F) 57637 Inserts Clipboard contents.\nPaste (Ctrl+V) 57638 Inserts Clipboard contents with link.\nPaste Link 57639 Inserts Clipboard contents with options.\nPaste Special 57640 Repeats the last action.\nRepeat (Ctrl+R) 57641 Searches the current document for text and replaces it.\nReplace (Ctrl+H) 57643 Undoes the last action.\nUndo (Ctrl+Z) 57644 Redoes the undone action.\nRedo (Ctrl+A) 57648 Opens another window for the active document.\nNew Window 57649 Arranges icons at the bottom of the window.\nArrange Icons 57650 Arranges windows so they overlap.\nCascade Windows 57651 Arranges windows as non-overlapping tiles. 57652 Arranges windows as non-overlapping tiles. 57653 Splits the active window into four panes. 57664 Displays program information, version number and copyright.\nAbout 57665 Quits the application; prompts to save documents.\nExit 57667 Lists Help topics.\nHelp Topics 57669 Displays help for clicked on buttons, menus and windows.\nHelp 57670 57680 57681 57696 Enables you to change font name, size and style.\nFont 57856 Inserts a new embedded object.\nNew Object 57857 Edits linked objects.\nEdit Links 57872 Activates embedded or linked object. 57873 Activates embedded or linked object. 57874 Activates embedded or linked object. 57875 Activates embedded or linked object. 59136 EXT 59137 CAPS 59138 NUM 59139 SCRL 59140 OVR 59141 REC 59392 Shows or hides the Standard toolbar. 59393 Shows or hides the status bar. 61184 Changes the window size. 61185 Changes the window position. 61186 Reduces the window to an icon. 61187 Enlarges the window to full size. 61188 Switches to the next document window. 61189 Switches to the previous document window. 61190 Switches to the previous document window. 61202 Restores the window to normal size. 61203 Activates Task List. 61215 Activates this window. 61221 ABS\nABS(Number)\n\nReturns the absolute value of Number.\nExample: ABS(-10) = 10 61222 SGN\nSGN(Number)\n\nReturns -1 if Number < 0, 0 if Number = 0 and 1 if Number > 0.\nExample: SGN(10) = 1 61223 AND\nAND(Number1; Number2)\n\nReturns the bitwise AND of Number1 and Number2.\nExample: AND(12; 4) = 4 61224 NOT\nNOT(Number)\n\nReturns the bitwise negation of Number.\nExample: NOT(10) = -11 61225 OR\nOR(Number1; Number2)\n\nReturns the bitwise OR of Number1 and Number2.\nExample: OR(8; 4) = 12 61226 XOR\nXOR(Number1; Number2)\n\nReturns the bitwise XOR of Number1 and Number2.\nExample: XOR(12; 4) = 8 61227 ARCOSH\nARCOSH(Number)\n\nReturns the inverse hyperbolic cosine of Number.\nExample: ARCOSH(1.5) = 0.96242365 61228 ARSINH\nARSINH(Number)\n\nReturns the inverse hyperbolic sine of Number.\nExample: ARSINH(1.5) = 1.19476322 61229 ARTGH\nARTGH(Number)\n\nReturns the inverse hyperbolic tangent of Number.\nExample: ATGH(0.5) = 0.54930614 61230 COSECH\nCOSECH(Number)\n\nReturns the hyperbolic cosecant of Number.\nExample: COSECH(1.5) = 0.46964244 61231 COSH\nCOSH(Number)\n\nReturns the hyperbolic cosine of Number.\nExample: COSH(1.5) = 2.35240962 61232 SECH\nSECH(Number)\n\nReturns the hyperbolic secant of Number.\nExample: SECH(1.5) = 0.42509603 61233 SINH\nSINH(Number)\n\nReturns the hyperbolic sine of Number.\nExample: SINH(1.5) = 2.12927946 61234 TANH\nTANH(Number)\n\nReturns the hyperbolic tangent of Number.\nExample: TANH(1.5) = 0.90514825 61235 ACOS\nACOS(Number)\n\nReturns the arccosine of Number.\nExample: ACOS(0.5) = 1.04719755 (=PI/3) 61236 ASIN\nASIN(Number)\n\nReturns the arcsine of Number.\nExample: ASIN(0.5) = 0.52359878 (=PI/6) 61237 ATAN\nATAN(Number)\n\nReturns the arctangent of Number.\nExample: ATAN(1) = 0.78539816 (PI/4) 61238 COS\nCOS(Number)\n\nReturns the cosine of Number.\nExample: COS(PI(1)/3) = 0.5 61239 SIN\nSIN(Number)\n\nReturns the sine of Number.\nExample: SIN(PI(1)/6) = 0.5 61240 TAN\nTAN(Number)\n\nReturns the tangent of Number.\nExample: TAN(PI(1)/4) = 1 61241 BJ0\nBJ0(Number)\n\nReturns the value of the Bessel function of the first kind and zero level for Number.\nExample: BJ0(0.9) = 0.8075238 61242 BJ1\nBJ1(Number)\n\nReturns the value of the Bessel function of the first kind and second level for Number.\nExample: BJ1(0.9) = 0.40594955 61243 BJN\nBJN(Level; Number)\n\nReturns the value of the Bessel function of the first kind for the given Level and Number.\nExample: BJN(1;0.9) = 0.40594955 61244 BY0\nBY0(Number)\n\nReturns the value of the Bessel function of the second kind and zero level for Number.\nExample: BY0(0.9) = 0.00562831 61245 BY1\nBY1(Number)\n\nReturns the value of the Bessel function of the second kind and first level for Number.\nExample: BY1(0.9) = -0.87312658 61246 BYN\nBYN(Level; Number)\n\nReturns the value of the Bessel function of the second kind for the given Level and Number.\nExample: BY1(1; 0.9) = -0.87312658 61247 DEGREES\nDEGREES(Number)\n\nConverts Number, which represents an angle in radians, to degrees.\nExample: DEGREES(PI(1)/4) = 45 61248 RADIANS\nRADIANS(Number)\n\nConverts Number, which represents an angle in degrees, to radians.\nExample: RADIANS(45) = 0.78539816 (=PI(1)/4) 61249 EXPM\nEXPM(Number)\n\nReturns the mantissa m of Number (m is greater than or equal to 0.5 and less than 1) so that Number = m*2^k, where k is the exponent.\nExample: EXPM(1.5) = 0.75 61250 EXPE\nEXPE(Number)\n\nReturns the exponent k of Number so that Number = m*2^k, where m is the mantissa.\nExample: EXPE(1.5) = 1 61251 EXP\nEXP(Number)\n\nReturns the base of the natural logarithm ("e") raised to the power of Number.\nExample: EXP(2) = 7.3890561 61252 FACT\nFACT(Number)\n\nReturns the factorial of Number: the product of all integers greater than zero and not greater than Number.\nExample: FACT(5) = 120 61253 GCD\nGCD(Number1; Number2)\n\nReturns the greatest common divisor of Number1 and Number2.\nExample: GCD(24;16) = 8 61254 SCM\nSCM(Number1; Number2)\n\nReturns the smallest common multiplicity of Number1 and Number2.\nExample: SCM(12; 8) = 24 61255 LOG10\nLOG10(Number)\n\nReturns the base 10 logarithm of Number.\nExample: LOG10(100) = 2 61256 LOG\nLOG(Number)\n\nReturns the natural logarithm of Number.\nExample: LOG(EXP(2)) = 2 61257 LOGX\nLOGX(Number; Base)\n\nReturns the Base logarithm of Number.\nExample: LOGX(2^5; 2) = 5 61258 MOD\nMOD(Number1; Number2)\n\nReturns the reminder of Number1 / Number2.\nExample: MOD(9; 4) = 1 61259 POW10\nPOW10(Number)\n\nReturns 10 to the power of Number.\nExample: POW10(2) = 100 61260 PI\nPI(Number)\n\nReturns the product of Number and the value PI (3.141592653589).\nExample: PI(1) = 6.2831853 61261 CEIL\nCEIL(Number)\n\nReturns a number representing the smallest integer greater than or equal to Number.\nExample: CEIL(2.6) = 3 61262 ROUND\nROUND(Number)\n\nReturns Number rounded to the nearest integer.\nExample: ROUND(2.4) = 2 61263 ROUNDE\nROUNDE(Number)\n\nReturns Number rounded to the nearest even number.\nExample: ROUNDE(3.1) = 4 61264 EVEN\nEVEN(Number)\n\nReturns Number rounded to the nearest even number.\nExample: EVEN(3.1) = 4 61265 ROUNDO\nROUNDO(Number)\n\nReturns Number rounded to the nearest odd number.\nExample: ROUNDO(2.1) = 3 61266 ODD\nODD(Number)\n\nReturns Number rounded to the nearest odd number.\nExample: ODD(2.1) = 3 61267 ROUNDX\nROUNDX(Number; Precision)\n\nReturns Number rounded to the factor specified by Precision.\nExample: ROUNDX(2.1; 0.5) = 2.5 61268 TRUNC\nTRUNC(Number)\n\nReturns the integer portion of Number.\nExample: TRUNC(2.5) = 2 61269 SHIFTL\nSHIFTL(Number; Positions)\n\nReturns the value of Number after shifting its bits by Positions to the left.\nExample: SHIFTL(2; 3) = 16 61270 SHIFTR\nSHIFTR(Number; Positions)\n\nReturns the value of Number after shifting its bits by Positions to the right.\nExample: SHIFTR(16; 3) = 2 61271 SQR\nSQR(Number)\n\nReturns the square of Number.\nExample:SQR(3) = 9 61272 SQRT\nSQRT(Number)\n\nReturns the square root of Number.\nExample: SQRT(9) = 3 61273 INTERPOL\nINTERPOL(X_range; Y_range; Point)\n\nPerforms interpolation of a function in Point based on points from X_range and function values from Y_range.\nExample: INTERPOL(A1:A10; B1:B10; 3) = 2.3 61274 COMBNR\nCOMBNR(n;k)\n\nReturns the number of k-element combinations with repeating from the n-element set.\nExample: COMBNR(5; 3) = 35 61275 COMBNS\nCOMBNS(n; k)\n\nReturns the number of k-element combinations without repeating from the n-element set.\nExample: COMBNS(5; 3) = 10 61276 GRANDTOTAL\nGRANDTOTAL(Range)\n\nReturns the sum of values of formulas containing the SUBTOTAL function in the given range.\nExample: GRANDTOTAL(A1:B10) = 12 61277 SUBTOTAL\nSUBTOTAL(Range)\n\nReturns the sum of numbers from the given range.\nExample: SUBTOTAL(A1:B10) = 12 61278 MAX\nMAX(Range)\n\nReturns the largest number in the given range.\nExample: MAX(A1:B10) = 5 61279 MIN\nMIN(Range)\n\nReturns the smallest number in the given range.\nExample: MIN(A1:B10) 61280 RAND\nRAND(Number)\n\nReturns a random number greater or equal to 0 and less or equal to Number.\nExample: RAND(60) = 34.56 61281 SUM\nSUM(Range)\n\nReturns the sum of numbers from the given range.\nExample: SUM(A1:B10) 61282 SUM2\nSUM2(Range)\n\nReturns the sum of squares of numbers from the given range.\nExample: SUM2(A1:B10) 61283 SUM3\nSUM3(Range)\n\nReturns the sum of cubes of numbers from the given range.\nExample: SUM3(A1:B10) 61284 PRODUCTIF\nPRODUCTIF(Value1; Value2; ConditionsRange; InputRange)\n\nReturns the product of numbers from InputRange.\nExample: PRODUCTIF(10248; 10252; A2:A7; C2:C7) 61285 SUMIF\nSUMIF(Value1; Value2; ConditionsRange; InputRange)\n\nReturns the sum of numbers from InputRange.\nExample: SUMIF(10248; 10252; A2:A7; C2:C7) 61286 SUM2IF\nSUMIF2(Value1; Value2; ConditionsRange; InputRange)\n\nReturns the sum of squares of numbers from InputRange.\nExample: SUM2IF(10248; 10252; A2:A7; C2:C7) 61287 SUM3IF\nSUMIF3(Value1; Value2; ConditionsRange; InputRange)\n\nReturns the sum of cubes of numbers from InputRange.\nExample: SUM2IF(10248; 10252; A2:A7; C2:C7) 61288 61289 61290 AREA\nAREA(Range)\n\nReturns the number of cells in Range.\nExample: AREA(A1:B10) 61291 AVE\nAVE(Range)\n\nReturns the arithmetic mean for cells in Range.\nExampe: AVE(A1:B10) = 1.1 61292 AVE2\nAVE2(Range)\n\nReturns the square mean for cells in Range.\nExample: AVE2(A1:B10) = 1.1 61293 AVEG\nAVEG(Range)\n\nReturns the geometric mean for cells in Range.\nExample: AVEG(A1:B10) = 1.1 61294 AVEH\nAVEH(Range)\n\nReturns the harmonic mean for cells in Range.\nExample: AVEH(A1:B10) = 1.1 61295 CHI2\nCHI2(Degree; Chi2Expression)\n\nReturns the confidence level for Chi2Expression, which has the chi-square distribution.\nExample: CHI2(4; 1.1) = 0.89427221 61296 STD\nSTD(Degree; TExpression)\n\nReturns the confidence level for TExpression, which has the Student distribution.\nExample: STD(4; 1.1) = 0.33308365 61297 CORREL\nCORREL(Range1; Range2)\n\nReturns the correlation between numbers from Range1 and Range2.\nExample: CORREL(A1:A10; B1:B10) = 0.9 61298 ENTROPY\nENTROPY(Range)\n\nReturns the entropy of an information source based on probability factors from the given range.\nExample: ENTROPY(A1:A2) = 1 61299 ERF\nERF(Number)\n\nReturns the integral of the Gauss function in the range {-Number*sqrt(2), Number*sqrt(2)}.\nExample: ERF(1.5) = 0.96610809 61300 ERFV\nERFV(Number)\n\nReturns the argument for which the ERF function returns Number.\nExample: ERFV(0.96610809) = 1.5 61301 EST\nEST(Range)\n\nReturns the standard deviation of a sample from the given range.\nExample: EST(A1:B10) = 1.1 61302 ESTN\nESTN(Range)\n\nReturns the standard deviation of a population.\nExample: ESTN(A1:B10) = 1.1 61303 61304 61305 CHAR\nCHAR(Number)\n\nReturns a text string consisting of one character with the character set code equal to Number.\nExample: CHAR(65) = "A" 61306 CODE\nCODE(Text)\n\nReturns the character set code of the first character in Text.\nExample: CODE("Word") = 87 61307 HEX\n\nHEX(Number)\nReturns the text string representing Number in the hex notation.\nExample: HEX(1998) = "7ce" 61308 OCT\nOCT(Number)\n\nReturns the text string representing Number in the octal notation.\nExample: OCT(1998) = "3716" 61309 TEXT\nTEXT(Number)\n\nReturns the text string representing Number in textual ("verbal") form.\nExample: TEXT(23) = "twenty three" 61310 EXACT\nEXACT(Text1; Text2)\n\nCompares two text strings. If Text1 = Text2, 1 (True) is returned. If they are different, 0 (False) is returned. The comparison is case-sensitive.\nExample: EXACT("Thing"; "Thing") = 1\n 61311 FIND\nFIND(Text1; Text2; Position)\n\nReturns the position (as a 1-base index) of Text1 in Text2. Searching starts in Text2 from Position.\nExample: FIND("word"; "two words"; 1) = 5 61312 LEFT\nLEFT(Text; Number)\n\nReturns the first Number characters from Text.\nExample: LEFT("abcdef"; 3) = "abc" 61313 LENGTH\nLENGTH(Text)\n\nReturns the length of Text.\nExample: LENGTH("abcdef") = 6 61314 LOWER\nLOWER(Text)\n\nConverts all letters in Text to lowercase.\nExample: LOWER("ABCDEF") = "abcdef" 61315 REPLACE\nREPLACE(Text1; Number1; Number2; Text2)\n\nReplaces Number2 characters in Text1 starting from Number1 position by Text2. For the first character in Text1 Number1 = 1.\nExample: REPLACE("abcdef"; 3; 2; "x") = "abxef" 61316 STEXT\nSTEXT(Text)\n\nConverts all letters in Text to lowercase.\nExample: STEXT("ABCDEF") = "abcdef" 61317 MID\nMID(Text; StartPosition; EndPosition)\n\nReturns the substring of Text. The substring starts at StartPosition and includes all characters up to EndPosition. The position of the first character in Text is 1.\nExample: MID("abcdef"; 3; 4) = "cd"\n 61318 PROPER\nPROPER(Text)\n\nConverts first letters of words in Text to uppercase and all other letters to lowercase.\nExample: PROPER("two WORDS") = "Two Words" 61319 REPEAT\nREPEAT(Text; Number)\n\nReturns string that consists of Text repeated Number times.\nExample: REPEAT("abc "; 3) = "abc abc abc " 61320 RIGHT\nRIGHT(Text; Number)\n\nReturns the last Number characters from Text.\nExample: RIGHT("abcdef"; 3) = "def" 61321 TRIM\nTRIM(Text)\n\nRemoves all trailing and leading whitespaces from Text.\nExample: TRIM(" abcdef ") = "abcdef" 61322 LTRIM\nLTRIM(Text)\n\nRemoves all leading whitespaces from Text.\nExample: LTRIM(" abcdef") = "abcdef" 61323 RTRIM\nRTRIM(Text)\n\nRemoves all trailing whitespaces from Text.\nExample: RTRIM("abcdef ") = "abcdef" 61324 UPPER\nUPPER(Text)\n\nConverts all letters in Text to uppercase.\nExample: UPPER("abcdef") = "ABCDEF" 61325 ETEXT\nETEXT(Text)\n\nConverts all letters in Text to uppercase.\nExample: ETEXT("abcdef") = "ABCDEF" 61326 TRAIL\nTRAIL(Text; Number)\n\nIf Text length is less than Number, this function adds trailing spaces to Text so that Text contains exactly of Number characters.\nExample: TRAIL("abc", 6) = "abc "\n 61327 VALUE\nVALUE(Text)\n\nConverts Text to number.\nExample: VALUE("123") = 123 61328 NUM2STR\nNUM2STR(Number; Radix)\n\nReturns the text string representing Number in the Radix notation.\nExample: NUM2STR(1998; 10) = "1998" 61329 MERGE\nMERGE(Text1; Text2)\n\nReturns the text string consisting of merged Text1 and Text2.\nExample: MERGE("abc"; "def") = "abcdef" 61330 61331 61332 CTERM\nCTERM(Rate; Fv; Pv)\n\nReturns the number of compounding periods after which the initial amount (Pv) will obtain the value specified by Fv at the given interest rate Rate.\nExample: CTERM(9%/12; 10000; 5000) = 92.76576606 61333 FVAL\nFVAL(Pv; Rate; Periods)\n\nReturns the future value of an investment or loan Pv (with no periodic payments) at the given interest rate and the given number of periods.\nExample: FVAL(5000; 9%/12; 93) = 10017.52 61334 FV\nFV(Payment; Rate; Periods)\n\nReturns the future value of an investment (with periodic payments) after the given number of periods and with the given interest rate.\nExample: FV(500; 9%/12; 24) = 13094.24 61335 PMT\nPMT(Pv; Rate; Periods)\n\nReturns the payment amount for a loan during the given number of periods.\nExample: PMT(20000; 9%/12; 24) = 913.69 61336 PV\nPV(Payment; Rate; Periods)\n\nReturns the present value for a loan or investment.\nExample: PV(500; 9%/12; 24) = 10944.57 61337 RATE\nRATE(Fv; Pv; Periods)\n\nReturns the periodic interest rate for a loan or investment (Pv) at the given number of periods.\nExample: RATE(10000; 5000; 48) = 0.01454533 61338 SLN\nSLN(Cost; Salvage; Life)\n\nReturns the straight-line depreciation for one period.\nExample: SLN(3000; 400; 5) = 520 61339 SYD\nSYD(Cost; Salvage; Life; Period)\n\nReturns the sum-of-the-years'-digits' depreciation for the given period.\nExample: SYD(3000; 400; 5; 4) = 346.67 61340 TERM\nTERM(Payment; Rate; Pv)\n\nReturns the number of payment periods for an investment or loan (Pv) with the given interest rate and payment.\nExample: TERM(500; 9%/12; 10000) = 18.71 61341 61342 61343 DATE\nDATE(Year; Month; Day)\n\nReturns the date/time number for the given Year, Month and Day. This integer portion represents the number of days from 30 December 1899, midnight and the fractional portion represents hours.\nExample: DATE(1998; 1; 1) = 35796 61344 TIME\nTIME(Hour; Minute; Second)\n\nReturns the date/time number for the given Year, Month and Day. This integer portion represents the number of days from 30 December 1899, midnight and the fractional portion represents hours.\nExample: TIME(11; 53; 44) = 0.49564815 61345 DATEDIF\nDATEDIF(DateNumber1; DateNumber2; Type)\n\nCalculates the difference between two dates. The result depends on Type.\nExample: DATEDIF(DATE(1998;3;1)+TIME(10;45;0); DATE(1998;1;1)+TIME(9;45;0); 6) = 85020 (minutes) 61346 DATEVALUE\nDATEVALUE(Text)\n\nReturns the date/time number for the given date formatted as Text. To be parsed correctly, the text string must conform to the currently defined in system short date/time format.\nExample: DATEVALUE("13/1/98") = 35808 61347 TIMEVALUE\nTIMEVALUE(Text)\n\nReturns the date/time number for the given time formatted as Text. To be parsed correctly, the text string must conform to the currently defined in system short date/time format.\nExample: TIMEVALUE("9:45:34 PM") = 0.90664352 61348 DAY\nDAY(DateNumber)\n\nReturns the day of the month (1-31) for the DateNumber.\nExample: DAY(DATE(1998;1;1)) = 1 61349 HOUR\nHOUR(DateNumber)\n\nReturns the hour(0-23) for the DateNumber.\nExample: HOUR(TIME(23;12;56)) = 23 61350 MINUTE\nMINUTE(DateNumber)\n\nReturns the minute (0-59) for the DateNumber.\nExample: MINUTE(TIME(23;12;56)) = 12 61351 SECOND\nSECOND(DateNumber)\n\nReturns the second (0-59) for the DateNumber.\nExample: SECOND(TIME(23;12;56)) = 56 61352 MONTH\nMONTH(DateNumber)\n\nReturns the month (1-12) for the DateNumber.\nExample: MONTH(DATE(1998;1;1)) = 1 61353 YEAR\nYEAR(DateNumber)\n\nReturns the year for the DateNumber.\nExample: YEAR(DATE(1998;1;1)) = 1998 61354 DAYOFWEEK\nDAYOFWEEK(DateNumber)\n\nReturns the day of the week (Sun = 1) for the DateNumber.\nExample: DAYOFWEEK(DATE(1998;1;1)) = 5 61355 DAYOFYEAR\nDAYOFYEAR(DateNumber)\n\nReturns the day of the year (Jan 1 = 1) for the DateNumber.\nExample: DAYOFYEAR(DATE(1998;1;1)) = 1 61356 FORMATDATE\nFORMATDATE(DateNumber; FormattingText)\n\nReturns the text representing date/time formatted according to FormattingText. If FormattingText is an empty string (""), the default Windows format for the date representation is used. 61357 FORMATTIME\nFORMATTIME(DateNumber; FormattingText)\n\nReturns the text representing date/time formatted according to FormattingText. If FormattingText is an empty string (""), the default Windows format for the date representation is used. 61358 TODAY\nTODAY(DaysNumber)\n\nReturns the current date/time number +/- DaysNumber.\nExample: TODAY(0) = "12/11/97" 61359 NOW\nNOW(HoursNumber)\n\nReturns the current date/time number +/- HoursNumber.\nExample: NOW(0) = "2:49:43 PM" 61360 61361 61362 COLS\nCOLS(Range)\n\nReturns the number of columns in Range.\nExample: COLS(A1:B10) = 2 61363 ROWS\nROWS(Range)\n\nReturns the number of rows in Range.\nExample: ROWS(A1:B10) = 10 61364 HLOOKUP\nHLOOKUP(SearchItem;SearchRange;RowIndex)\n\nSearchItem is compared against values in the first row of SearchRange. If a matching value is found, the contents of the cell from the corresponding column and the RowIndex row is returned. 61365 VLOOKUP\nVLOOKUP(SearchItem;SearchRange;ColumnIndex)\n\nSearchItem is compared against values in the first column of SearchRange. If a matching value is found, the contents of the cell from the corresponding row and the ColumnIndex column is returned. 61366 INDEX\nINDEX(Range; ColumnNumber; RowNumber)\n\nReturns the contents of the cell from Range. The cell position is relative to Range, i.e. ColumnNumber equal to 1 and RowNumber equal to 1 refers to the upper left corner of Range.\nExample: INDEX(A1:B10; 1; 1) (= A1) 61367 RANGE\nRANGE(LeftColumn; TopRow; RightColumn; BottomRow)\n\nCreates and returns the cell range specified by two columns LeftColumn, RightColumn (1-512) and two rows TopRow, BottomRow (1-8192).\nExample: RANGE(1; 1; 2; 10) (=A1:B10) 61368 MATCH\nMATCH(SearchItem; SearchRange; SearchType)\n\nSearchItem is compared against values in the given range. If found, the position of the matching value is returned. If there is no matching value, the error value is returned.\nMATCH("abc"; A2:D7; 0) = 14 61369 ADDRESS\nADDRESS(ColumnNumber; RowNumber)\n\nReturns the cell address specified as ColumnNumber (1 - 512) and RowNumber (1 - 8192).\nExample: ADDRESS(3; 4) (=C4) 61370 CELL\nCELL(FeatureType; CellAddress)\n\nReturns the chosen feature of a cell.\nExample: CELL(0; B5) = 2 61371 OFFSET\nOFFSET(Range; ColumnsNumber; RowsNumber)\n\nReturns Range shifted horizontally and/or vertically by ColumnsNumber and RowsNumber.\nExample: OFFSET(A1:B10; 1; 1) (=B2:C11) 61372 GETEXVAL\nGETEXVAL(Document; CellAddress; AutoOpen)\n\nReturns the value of the specified cell from another spreadsheet document.\nExample: GETEXVAL("d:\gscalc35\analyze.gsc"; E9; 1) = 100 61373 COUNT\nCOUNT(Range)\n\nReturns the number of not empty cells in the given range.\nExample: COUNT(A1:B10) = 4 61374 COUNTV\nCOUNTV(Value; SearchRange)\n\nReturns the number of cells containing Value in the given range. Value may represent a number or a text.\nExample: COUNTV(2.2; A1:B10) = 3 61375 61376 61377 TEST\nTEST(Number; TrueValue; FalseValue)\n\nIf Number is greater than or equal to 0, the TrueValue is returned. If Number is less than 0, FalseValue is returned.\nExample: TEST(10; "abc"; "cde") = "abc" 61378 IF\nIF(Condition; TrueValue; FalseValue)\n\nIf Condition, which may be any expression returning numbers, is different than 0, the TrueValue is returned. If Condition is equal to 0, FalseValue is returned.\nExample: IF((A1>1)*(A1<10); 1; 2) = 1 61379 ISERROR\nISERROR(Value)\n\nReturns 1 (True) if Value represents the error value or a cells range containing at least one error value. If no error is found, 0 is returned.\nExample: ISERROR(1/0) = 1 61380 ISNUMBER\nISNUMBER(Value)\n\nReturns 1 (True) if Value represents a number or a cells range containing only numbers. Otherwise 0 (False) is returned.\nExample: ISNUMBER(12) = 1 61381 ISSTRING\nISSTRING(Value)\n\nReturns 1 (True) if Value represents a text string or a cells range containing only text. Otherwise 0 (False) is returned.\nExample: ISSTRING("abc") = 1 61382 ISFILE\nISFILE(Text)\n\nReturns 1 (True) if Text represents a name of an existing file or 0 (False) otherwise.\nExample: ISFILE("d:\gscalc35\bnalyze.gsc") = 1 61383 ISOPEN\nISOPEN(Text)\n\nReturns 1 (True) if Text represents a name (full path) of the currently open spreadsheet document or 0 (False) otherwise.\nExample: ISOPEN("d:\gscalc35\analyze.gsc") = 1 61384 61385 61386 PLAYSOUND\nPLAYSOUND(Condition; SoundName; Type)\n\nIf Condition, which may be any expression returning numbers, is different than 0, this function plays sound specified as SoundName.\nExample: PLAYSOUND(ISERROR(B15); "c:\sound\theme.wav"; 1) 61387 OPENDOC\nOPENDOC(Condition; Document)\n\nIf Condition is different than 0, this function opens Document. This can be a complete file path of the given document, executable file or an Internet URL.\nExample: OPENDOC(B15 >10000; "d:\report.txt") 61388 OPENSHEET\nOPENSHEET(Condition; SheetName)\n\nIf Condition is different than 0, this function opens an existing document specified as SheetName. SheetName must contain a full path name of a given document.\nExample: OPENSHEET(B15<100; "d:\form1.gsc") 61389 MESSAGE\nMESSAGE(Condition; MessageText)\n\nIf Condition, which may be any expression returning numbers, is different than 0, this function displays a message specified as MessageText.\nExample: MESSAGE(ISERROR(B15); "Error Value in B15!") 61440 Open 61441 Save As 61442 All Files (*.*) 61443 Untitled 61444 Save Copy As 61457 &Hide 61472 No error message is available. 61473 An unsupported operation was attempted. 61474 A required resource was unavailable. 61475 Out of memory. 61476 An unknown error has occurred. 61504 on %1 61505 &One Page 61506 &Two Page 61507 Page %u 61508 Page %u\nPages %u-%u\n 61509 prn 61510 Output.prn 61511 Printer Files (*.prn)|*.prn|All Files (*.*)|*.*|| 61512 Print to File 61513 to %1 61577 &Update %1 61580 E&xit && Return to %1 61581 Updating OLE objects 61582 Picture (Metafile)\na picture 61583 Device Independent Bitmap\na device independent bitmap 61584 Bitmap\na bitmap 61585 %s\n%s 61586 %s\n%s 61588 Linked %s 61589 Unknown Type 61590 Rich Text (RTF)\ntext with font and paragraph formatting 61591 Unformatted Text\ntext without any formatting 61592 Invalid Currency. 61593 Invalid DateTime. 61594 Invalid DateTimeSpan. 61696 Invalid filename. 61697 Failed to open document. 61698 Failed to save document. 61699 Save changes to %1? 61700 Failed to create empty document. 61701 The file is too large to open. 61702 Could not start print job. 61703 Failed to launch help. 61704 Internal application error. 61705 Command failed. 61706 Insufficient memory to perform operation. 61712 Please enter an integer. 61713 Please enter a number. 61714 Please enter an integer between %1 and %2. 61715 Please enter a number between %1 and %2. 61716 Please enter no more than %1 characters. 61717 Please select a button. 61718 Please enter an integer between 0 and 255. 61719 Please enter a positive integer. 61720 Please enter a date and/or time. 61721 Please enter a currency. 61728 Unexpected file format. 61729 %1\nCannot find this file.\nPlease verify that the correct path and file name are given. 61730 Destination disk drive is full. 61731 Unable to read from %1, it is opened by someone else. 61732 Unable to write to %1, it is read-only or opened by someone else. 61733 An unexpected error occurred while reading %1. 61734 An unexpected error occurred while writing %1. 61824 Can not activate a static OLE object. 61825 Failed to connect.\nLink may be broken. 61826 Unable to process command, server busy. 61827 Failed to perform server operation. 61829 %1\nUnable to register document.\nThe document may already be open. 61830 Failed to launch server application. 61831 Update %1 before proceeding? 61832 Could not update client. 61833 Failed to register. OLE features may not work properly. 61834 Failed to update the system registry.\nPlease try using REGEDIT. 61835 Failed to convert OLE object. 61836 Unable to read write-only property. 61837 Unable to write read-only property. 61838 OLE objects cannot be saved while exiting Windows!\nDiscard all changes to %1? 61839 Failed to create object. Make sure the application is entered in the system registry. 61840 Unable to load mail system support. 61841 Mail system DLL is invalid. 61842 Send Mail failed to send message. 61856 No error occurred. 61857 An unknown error occurred while accessing %1. 61858 %1 was not found. 61859 %1 contains an invalid path. 61860 %1 could not be opened because there are too many open files. 61861 Access to %1 was denied. 61862 An invalid file handle was associated with %1. 61863 %1 could not be removed because it is the current directory. 61864 %1 could not be created because the directory is full. 61865 Seek failed on %1 61866 A hardware I/O error was reported while accessing %1. 61867 A sharing violation occurred while accessing %1. 61868 A locking violation occurred while accessing %1. 61869 Disk full while accessing %1. 61870 An attempt was made to access %1 past its end. 61872 No error occurred. 61873 An unknown error occurred while accessing %1. 61874 An attempt was made to write to the reading %1. 61875 An attempt was made to access %1 past its end. 61876 An attempt was made to read from the writing %1. 61877 %1 has a bad format. 61878 %1 contained an unexpected object. 61879 %1 contains an incorrect schema. 61888 pixels 62081 Attempt to connect to datasource failed 62082 Recordset supports forward movement only. 62083 Attempt to open a table failed - there were no columns to retrieve were specified. 62084 Unexpected column data types were returned from query. 62085 Attempt to Update or Delete failed. 62086 Multiple rows were updated. 62087 Operation failed, no current record. 62088 No rows were affected by the update or delete operation. 62089 Recordset is read-only 62090 ODBC driver doesn't support MFC LongBinary data model. 62091 Attempt to load required component ODBC32.DLL failed. 62092 ODBC driver does not support dynasets. 62093 ODBC static cursors required for snapshot support. 62094 ODBC driver incompatible with MFC database classes (API_CONFORMANCE >= SQL_OAC_LEVEL1 required). 62095 ODBC driver incompatible with MFC database classes (SQL_CONFORMANCE >= SQL_OSC_MINIMUM required). 62096 Attempt to scroll past end or before beginning of data. 62097 Dynasets not supported by ODBC driver. 62098 ODBC Level 2 compliant driver required. 62099 Positioned updates not supported by ODBC driver. 62100 Requested lock mode is not supported. 62101 Data truncated. 62102 Error retrieving record. 62103 A required ODBC entry point was not found. Make sure ODBC is installed correctly. 62104 Update or Delete failed. 62105 Dynamic cursors not supported by ODBC driver. 62112 Unable to initialize DAO/Jet db engine. 62113 Bad DFX value parameter. 62114 DAO TableDef or QueryDef not Open. 62115 GetRows failed. Not enough memory allocated for row. 62116 GetRows binding error. Probably caused by datatype mismatch. 62117 GetRows failed. The requested column is not a member of this recordset.