CALC.MSG 3.0 _ **************************************************** **************************************************** **************************************************** **************************************************** 241> 74+Arrange Blank Configure Delete Edit Format Global Insert< 71 Load Print Quit Replicate Save Title Xternal Zap < 35+Arr,Blk,Cfg,Del,Edit,Format,Global, 35 Insert,Load,Print,Quit,Rep,Save,Zap 13*FORMULA ERROR < < 13*FORMULA ERROR < < 59 Enter the file name. (Enter A:, B:, etc. for directory.) < < 20+Enter the file name. < 34 (Enter A:, etc. for directory.) < 44+Enter the file name to be deleted from disk. < 35 (Enter A:, B:, etc. for directory.) < 34+Enter the file name to be deleted.< 34 (Enter A:, etc. for directory.) < 67+The current spreadsheet was changed but not saved. Enter Y to quit. < 62 Enter N to return to spreadsheet. Enter S to save spreadsheet. < 31+Spreadsheet was changed but not < 27 saved. Quit? (Y or N or S). < 23 Enter the "from" range. < < 23 Enter the "from" range. < < 21 Enter the "to" range. < < 21 Enter the "to" range. < < 17 Replicating . . . < < 17 Replicating . . . < < 14 Error in range. < < 14 Error in range. < < 65 Enter the file name. (Enter A:, B:, etc. for directory.) < < 32+Enter the file name. (Enter A:, < 33 B:, etc. for directory.) < 34 Retrieving program. Stand by . . . < < 34 Retrieving program. Stand by . . .< < 45 Returning to the main program. Stand by . . . < < 30+Returning to the main program. < 14 Stand by . . . < 56 Enter page width (number of characters across printout). < < 27+Enter page width (number of < 27 characters across printout) < 45 Enter page length (number of lines per page). < < 17+Enter page length < 27 (number of lines per page). < 11*MEMORY FULL < < 11*MEMORY FULL < < 38+Enter printer setup codes, then ENTER. < 66 Epson printers: "A" = 10 cpi, "B" = 12 cpi, "C" = 17 cpi. < 33+Enter setup codes, then ENTER. < 35 Epson :A=10, B=12, C=17 cpi 68+Must be a single cell, or two cells separated by a colon. < 35 Examples: A5 C9:C20 D1:D5 < 35+Must be a single cell, or two cells 21 separated by a colon. < 24 Range must be ascending. < < 24 Range must be ascending. < < 52+Can replicate from a row or column, but not a block. < 28 Examples: A5:D5 A5:A20 < 35+Can replicate from a row or column, 16 but not a block. < 72+The program CALC3.EXE is not on the disk. This command cannot be used. < 26 Press any key to continue. < 31+CALC3.EXE is not on the disk. < 26 Press any key to continue. < 72+The program CALC4.EXE is not on the disk. This command cannot be used. < 26 Press any key to continue. < 31+CALC4.EXE is not on the disk. < 26 Press any key to continue. < 72+The program CALC5.EXE is not on the disk. This command cannot be used. < 26 Press any key to continue. < 31+CALC5.EXE is not on the disk. < 26 Press any key to continue. < 73 Format for SUM, MIN, MAX, etc. is: SUM(from:to) example: SUM(A1:A20) < < 34+Format for SUM, MIN, MAX, etc. is:< 34 SUM(from:to) example: SUM(A1:A20)< 49 Range in statistical functions must be ascending. < < 30+Range in statistical functions < 18 must be ascending. < 69 Format for NPV is NPV(rate,from:to) example: NPV(.10,B10:B30) < < 35 Format for NPV is NPV(rate,from:to) 25 example: NPV(.10,B10:B30) < 23 Mismatched parentheses. < < 23 Mismatched parentheses. < < 25 Clear contents? (Y or N). < < 25 Clear contents? (Y or N). < < 72 "To" range or adjusted cell ref. extends outside spreadsheet boundaries. < < 29+"To" range or adj cell ref is < 31 outside spreadsheet boundaries. < 68 Border, Row, Column, Manual, Auto, Formula, Zero-blank, Smart-cursor < < 34+Border, Row, Column, Manual, Auto,< 31 Formula,Zero-blank,Smart-cursor < 33 Clearing contents. Stand by . . . < < 33 Clearing contents. Stand by . . . < < 36 Enter range to be formatted (or ALL) < < 27+Enter range to be formatted < 08 (or ALL) < 69+Decimals Width Justify Commas $ ( % < 56 Protect Unprotect Hide Bargraph Zero-blank < 35+Decimals Width Justify Commas $ ( % 35 Prot Unprot Hide Bargraph Zero-blnk 38+Right-justify, Left-justify or Center. < 36 (Press ENTER to use global default.) < 30+Right-justify, Left-justify or < 35 Center. (ENTER for global default.) 63+Number of decimal places (0 to 12), or Floating, or Scientific. < 36 (Press ENTER to use global default.) < 35+Number of decimal places (0 to 12), 27 or Floating, or Scientific. < 34 Commas between thousands (Y or N). < < 34 Commas between thousands (Y or N).< < 64 Print numbers in bar graph format 1, 2 or 3 (or N for no graph). < < 33+Print numbers in bar graph format < 30 1, 2 or 3 (or N for no graph). < 50 Print leading dollar sign ($) on numbers (Y or N). < < 32+Print leading dollar sign ($) on < 17 numbers (Y or N). < 49 Enclose negative numbers in parentheses (Y or N). < < 27+Enclose negative numbers in < 21 parentheses (Y or N). < 58 Print a percent sign (%) to the right of numbers (Y or N). < < 31+Print a percent sign (%) to the < 26 right of numbers (Y or N). < 62+P = hide cells on printer only, S = hide cells on screen only, < 59 B = hide cells on printer and screen, N = don't hide cells. < 35+P=hide on printer, S=hide on screen 32 B=printer & screen, N=don't hide < 59+F = protect formulas, V = protect values, T = protect text, < 60 N = protect non-blank cells, A = protect all cells in range < 35+F = formulas, V = values, T = text, 34 N = non-blank cells, A = all cells< 65+F = unprotect formulas, V = unprotect values, T = unprotect text, < 64 N = unprotect non-blank cells, A = unprotect all cells in range < 35+F = formulas, V = values, T = text, 34 N = non-blank cells, A = all cells< 42 Display zeros as blanks (spaces) (Y or N). < < 33 Display zeros as blanks (Y or N). < < 41 Enter the page offset (left-margin size). < < 21+Enter the page offset < 19 (left-margin size). < 69 End of page. Press any key to print next page. (ESC to cancel.) < < 35+End of page. Press any key to print 33 next page. (ESC to cancel.) < 43 PRINTING . . . (Press ESC to cancel). < < 14+PRINTING . . . < 28 (Press ESC to cancel). < 17 Go to coordinate: < < 17 Go to coordinate: < < 27 Delete Row, Column or File? < < 27 Delete Row, Column or File? < < 31 Enter row number to be deleted. < < 31 Enter row number to be deleted. < < 34 Enter column letter to be deleted. < < 34 Enter column letter to be deleted.< < 21 Insert Row or Column? < < 21 Insert Row or Column? < < 54 Enter line number. New line will be inserted above it. < < 32+Enter line number. New line will < 21 be inserted above it. < 67 Enter column letter. New column will be inserted to the left of it. < < 31+Enter column letter. New column < 35 will be inserted to the left of it. 50+Printer is not responding. Take corrective action. < 22 Press ENTER to retry. < 26+Printer is not responding. < 22 Press ENTER to retry. < 16 Printer or Disk. < < 16 Printer or Disk. < < 57+Width, Height, Layout, Color, Matrix, Keys, Printer, Save < < 33+Width,Height,Layout,Color,Matrix, < 17 Keys,Printer,Save < 74+Enter screen width in characters (40 to 132). (Note: IBM PC maximum is 80)< 51 Do not exceed the physical limits of your hardware. < 31+Enter screen width (40 to 132). < 35 Do not exceed hardware limitations. 55+Enter number of display lines on your screen (7 to 32). < 51 Do not exceed the physical limits of your hardware. < 32+Enter number of lines (7 to 32). < 35 Do not exceed hardware limitations. 51+Select screen layout: DME, DEM, MDE, MED, EDM, EMD. < 56 (D is display area, M is message area, E is entry line). < 32+Layout: DME,DEM,MDE,MED,EDM,EMD. < 35 D=display, M=message, E=entry line. 51+Border, Display, Message, Entry, Cursor, Protected, < 31 1Bargraph, 2Bargraph, 3Bargraph < 35+Border,Display,Message,Entry,Cursor 35 Protected,1Bargraph,2Bargraph,3Barg 67+Press B to advance background color, F to advance foreground color. < 48 When you find the colors you want, press ENTER. < 35+B=next background,F=next foreground 21 Press ENTER to exit. < 41 Enter the number of copies to be printed. < < 32+Enter the number of copies to be < 08 printed. < 71+Enter the number of blank lines to be printed as a margin at the top of < 10 each page. < 34+Enter the number of blank lines to< 35 be printed at the top of each page. 55+Enter the top line to be printed as a report heading. < 59 (Report heading lines are printed at the top of each page.) < 35+Enter the top line to be printed as 17 a report heading. < 50 Enter the bottom line of the report heading range. < < 35+Enter the bottom line of the report 14 heading range. < 73+Options: D=double space, S=setup, P=pause, C=contents, M=Multiple copies, < 66 B=border, O=offset, T=Top margin, H=Heading lines, F=Footing lines < 35+Dblspace,Setup,Pause,Mult,Bdr,Cont, 34 Border,Offset,Topmgn,Hding,Footing< 75+Enter the name of the .PRO file. The current system options will be written 70 to the file. (If the .PRO extension is not entered, it will be added.) < 32 Enter the name of the .PRO file. < < 53+Enter the top line to be printed as a report footing. < 62 (Report footing lines are printed at the bottom of each page.) < 35+Enter the top line to be printed as 17 a report footing. < 50 Enter the bottom line of the report footing range. < < 35+Enter the bottom line of the report 14 footing range. < 73+One or more cells on this line are protected. The line cannot be deleted. < 24 Press ENTER to continue. < 34+Cells on this line are protected. < 29 Cannot be deleted. Press ENTER. < 68+One or more cells in this column are protected. The column cannot be < 33 deleted. Press ENTER to continue. < 35+Cells in this column are protected. 30 Cannot be deleted. Press ENTER. < 27 Column sort or Row sort? < < 27 Column sort or Row sort? < < 64 Column letter to be sorted (or range of cells if partial column) < < 30+Column letter to be sorted (or < 32 range of cells if partial column < 58 Row number to be sorted (or range of cells if partial row) < < 23+Row number to be sorted < 34 (or range of cells if partial row)< 24 Ascending or Descending? < < 24 Ascending or Descending? < 20 < 55 Second column letter to be sorted (press ENTER if none) < < 33+Second column letter to be sorted < 24 (press ENTER if none) < 53 Second line number to be sorted (press ENTER if none) < < 31+Second line number to be sorted < 24 (press ENTER if none) < 54 Third column letter to be sorted (press ENTER if none) < < 32+Third column letter to be sorted < 24 (press ENTER if none) < 33 Processing. Please stand by . . . < < 33 Processing. Please stand by . . . < < 70+Warning - memory was filled before the spreadsheet could be completely < 59 loaded. Some data may be missing. Press ENTER to continue. < 34+Warning - memory was filled before< 32 file was finished. Press ENTER. < 52 Third line number to be sorted (press ENTER if none) < < 30+Third line number to be sorted < 24 (press ENTER if none) < 36 Horizontal, Vertical, Both, or None. < < 35 Horizontal, Vertical, Both, or None < 29 Enter column width (0 to 75). < < 29 Enter column width (0 to 75). < < 59+Enter range to be blanked; or enter ALL to blank all cells; < 72 or enter VALUES to blank all values, but leave text and formulas intact. < 26+Enter range to be blanked, < 17 or ALL or VALUES. < 24 Enter cell to be edited. < < 24 Enter cell to be edited. < < 46 Enter range to be printed (or ENTER for all). < < 25+Enter range to be printed < < 43 Epson, Proprinter, Okidata, Toshiba or MPI. < < 35+Epson, Proprinter, Okidata, Toshiba 07 or MPI. < 68 There is data in the last row or column. Insertion is not permitted. < < 32+There is data in the last row or < 35 column. Insertion is not permitted. < < < < 31 The disk is full. Press ENTER. < < 31 The disk is full. Press ENTER. < < 68+Disk input error: the file being read is too short. Data is missing. < 13 Press ENTER. < 32+Disk input error: the file being < 32 read is too short. Press ENTER. < 70+The file name specified is not a valid name for this operating system. < 13 Press ENTER. < 32+The file name specified is not a < 25 valid name. Press ENTER. < 75+The file specification is invalid, or there are too many files on the disk. 12 Press ENTER. < 33+File specification is invalid, or < 35 too many files on disk. Press ENTER 42 The disk is write-protected. Press ENTER. < < 28+The disk is write-protected. < 13 Press ENTER. < < < < 28 File not found. Press ENTER. < < 28 File not found. Press ENTER. < < 68+There is no END marker on this file. Part of your spreadsheet may be < 37 missing. Press ENTER to continue. < 32+No END marker on file. Some data < 29 may be missing. Press ENTER. < 47+Format of IF function is IF(expr1,expr2,expr3). < 44 Examples: IF(A5>0,A5*100,0) IF(A5,E5,,) < 32+Format is IF(expr1,expr2,expr3). < 27 Example: IF(A5>0,A5*100,0) < 72+First operand of IF function is not valid. It may be a formula, a value, < 69 or two formulas/values separated by an operator: = < > <> <= >= < 35+First operand of IF function is not 16 a valid formula. < 72+Second operand of IF function is not valid. It may be a formula, a value < 20 or a cell reference. < 32+Second operand of IF function is < 29 not a valid formula or value. < 71+Third operand of IF function is not valid. It may be a formula, a value < 20 or a cell reference. < 35+Third operand of IF function is not 25 a valid formula or value. < 28 Out of memory. Press ENTER. < < 28 Out of memory. Press ENTER. < < 47+Enter C to get data from a CALC spreadsheet. < 44 Enter F to get data from a FILE database. < 27+C - data from CALC file. < 31 F - data from FILE database. < 57 Enter the name of the CALC spreadsheet to be accessed. < < 29+Enter the name of the CALC < 27 spreadsheet to be accessed. < 26+Enter the cell to be read. < 12 Example: A1 < 26+Enter the cell to be read. < 12 Example: A1 < 67+Warning - The specified cell has no data. Press ENTER to continue. < < 35+Warning - The specified cell has no 31 data. Press ENTER to continue. < 29 Stand by. Search in progress. < < 29 Stand by. Search in progress. < < 47+Enter the name of the database to be accessed. < 47 Examples: CUSTFILE C:PRICES A:TAXTABLE < 33+Enter the name of the database to < 12 be accessed. < 30 This database cannot be found. < < 30 This database cannot be found. < < 19+Field to search? < 75 (Enter field name, or press TAB/BACKTAB to rotate through the field names.) 34+Field to search? (Enter field name< 30 or use TAB/BACKTAB to rotate.) < 39 This field name is not in the database. < < 29+This field name is not in the < 09 database. < 12+Look for? < < 12+Look for? < < 74+If there is more than one record which matches this search data, which one< 41 should be used? (Enter 1 to 999, or ALL.) < 33+If more than one match, which one < 35 should be used? (1 to 999, or ALL.) 18+Field to retrieve? < 75 (Enter field name, or press TAB/BACKTAB to rotate through the field names.) 31+Field to retrieve? (Enter field < 35 name or use TAB/BACKTAB to rotate.) 39 This field name is not in the database. < < 29+This field name is not in the < 09 database. < 71+You specified ALL on the previous parameter, but ALL is only valid with < 75 numeric fields. The first occurence will be used. Press ENTER to continue.< 30+ALL is only valid with numeric < 33 fields. Will use 1. Press ENTER. < 64+Warning - no matching record was found. Cell will be left empty. < 25 Press ENTER to continue. < 35+Warning - no matching record found. 30 Cell left empty. Press ENTER. < 69+Memory is full. CALC is optimizing memory usage to make more room. < 75 Please stand by. Note: Calculations will now be slower on this spreadsheet. 34+Memory is full. Optimizing to make< 27 more room. Please stand by. < 50 Which Smart Key to define? (Press ESCAPE to exit.) < < 26+Which Smart Key to define? < 23 (Press ESCAPE to exit.) < 73+Warning - Changing the spreadsheet matrix size will cause the spreadsheet < 54 area to be cleared. Do you want to continue? (Y or N). < 31+Changing matrix size clears the < 34 spreadsheet area. Continue? Y or N< 72+Enter the number of columns (1 to 255). Note: columns times lines cannot < 73 exceed 16384, so a large number of columns will reduce the maximum lines. < 27+Enter the number of columns < 11 (1 to 255). < 75+Enter the number of lines. The maximum number you may enter is shown as the 08 default. < 35+Enter the number of lines. The max- 29 imum is shown as the default. < 69+The specified .PRO file was not found. Enter another profile name, or < 24 press ESC to exit. < 34+Specified .PRO file not found. Try< 28 again, or press ESC to exit. < 70+The displayed profile line is not valid. See the User Manual for valid < 73 profile formats. Correct the line shown, or press ESC to bypass it. < 33+Displayed profile line not valid. < 34 Change it, or press ESC to bypass.< 72+This sort is too large for available memory. Try sorting one column at a < 48 time. See User Guide for more info. Press ENTER. < 34+Sort too large for avl memory. See< 33 User Guide for info. Press ENTER. <