Установка: App Store 
Стоимость: $9,99
Mariner Calc поддерживает следующие функции:
-Math functions (24)
ABS, CEILING, COMBIN, CONVERT, EVEN, EXP, FACT, FLOOR, INT, LN, LOG, LOG10, MOD, ODD, POWER, PRODUCT, RAND, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SQRT, SUM, SUMIF, TRUNC
-Finance Functions (18)
ANNUITY, COMPOUND, DB, DDB, FV, IPMT, IRR, ISPMT, MIRR, NPER, NPV, PMT, PPMT, PV, RATE, SLN, SYD, VDB
-Trig functions (17)
ACOS, ACOSH, ASIN, ASINH, ATAN, ATAN2, ATANH, COS, COSH, COT, DEGREES, PI, RADIANS, SIN, SINH, TAN, TANH
-Statistics functions (13)
AVERAGE, COUNT, COUNTA, COUNTBLANK, COUNTIF, GAMMALN, MAX, MEDIAN, MIN, PERMUT, RANK, STDEV, VAR
-Lookup Functions (14)
ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS, HLOOKUP, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, ROW, ROWS, VLOOKUP
-Logic Functions (6)
AND, FALSE, IF, NOT, OR, TRUE
-Date functions (15)
ADDTIME, DATE, DATEVALUE, DAY, DAYS360, HOUR, MINUTE, MONTH, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, YEAR
-Text functions (24)
CHAR, CLEAN, CODE, CONCATENATE, DOLLAR, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TRIM, UPPER, VALUE, YEN
-Info Functions (14)
CELL, CELLRC, ERROR, ISBLANK, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, N, NA, TYPE
-Fixed most international issues.
-Fixed the MATCH function to not compare 0 to an empty cell as TRUE.
-Fixed HLOOKUP and VLOOKUP functions to not compare 0 to an empty cell as TRUE.
-Updated the INDEX function to include the optional parameters row_num, and column_num
i.e. INDEX(reference,row_num,column_num,area_num).
-Fixed some formula import errors from Numbers exported .xls files.
-Fixed the opening of .xls files exported from Microsoft Access (Microsoft Jet Engine).
-Fixed unary + operator i.e. +(-1)) is still -1.
-Fixed webpage long filename display.
-Fixed some server file transfer bugs.
-Fixed shrinking column values (new files created on iPhone).
-Fixed time display in year 1900 documents.
-Improved format import substantially.
-Fixed a bug with shared column formulas.
-Fixed bug with cell addresses.
-Fixed word wrap drawing bug.
-Added a preference tracking if the app shut down properly, opens the tutorial file if there was a crash.
-Fixed the sorting of the file list.
-Fixed an issue that could cause some files to transfer but not appear in the list (Uppercase extensions).
-Added a preference tracking if the app shut down properly, opens the tutorial file if there was a crash.
-Updated compare methods to mimic Excel, COUNTIF, LOOKUP, HLOOKUP, VLOOKUP, MATCH etc. compare text is case insensitive ie «x»=»X» is true. Note: use the EXACT function is you want a case sensitive comparison.
-Removed Calc’s special text error, #TVALUE!
-Fixed an issue where compare code was not returning BOOL value type. ie =A=B returns true, false. Note: Match function does not yet handle the Wildcard characters as Excel does. If match_type is 0 and lookup_value is text, lookup_value can contain the wildcard characters asterisk (*) and question mark (?). An asterisk matches any sequence of characters; a question mark matches any single character.
Mariner Write, Mariner, WinJournal, Montage, and Desktop
Poet are registered trademarks of Mariner Software, Inc.
StoryMill, Contour, Mariner Paperless are pending
registration. All other trademarks are the property of their
respective owners.
Понравилась программа? Вы можете помочь нам! Кликайте на баннер и жмите :-)) !
Оставьте комментарий или два
Пожалуйста, зарегистрируйтесь для комментирования.
Свежие комментарии