https://bugs.documentfoundation.org/show_bug.cgi?id=147880
Bug ID: 147880
Summary: You can indicate @ to call functions in LibreOffice
Calc
Product: LibreOffice
Version: 7.3.1.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
You can indicate @ to call functions in LibreOffice Calc
Steps to Reproduce:
1. You select any Calc line and put @
2. After entering the at sign, Calc displays a list of available functions for
you to use
3. With this list in hand, you select the function you want
Actual Results:
1. Both @ and = are indicative of functions, with these symbols @ or =
2. you can call functions to be executed in Calc
Expected Results:
1. A good example I can offer here is this:
@FREQUENCY, @GROWTH, @LINEST, @LOGEST, @MDETERM, @MINVERSE, @MMULT, @MUNIT,
@SUMPRODUCT, @SUMX2MY2, @SUMX2PY2, @SUMXMY2, @TRANSPOSE, @TREND
@COMPLEX, @IMABS, @IMAGINARY, @IMPOWER, @IMARGUMENT, @IMCOS, @IMCOSH, @IMCOT,
@IMCSC, @IMCSCH, @IMDIV, @IMEXP, @IMCONJUGATE, @IMLN, @IMLOG10, @IMLOG2,
@IMPRODUCT, @IMREAL, @IMSEC, @IMSECH, @IMSIN, @IMSINH, @IMSQRT, @IMSUB, @IMSUM,
@IMTAN, @DCOUNT, @DCOUNTA, @DGET, @DMAX, @DMIN, @DAVERAGE, @DPRODUCT, @DSTDEV,
@DSTDEVP, @DSUM, @DVAR, @DVARP, @TODAY, @NOW, @YEAR, @MONTH, @DAY, @WEEKDAY,
@HOUR, @MINUTE, @SECOND, @DATE, @DATEVALUE, @TIME, @TIMEVALUE, @EOMONTH,
@EDATE, @WORKDAY, @NETWORKDAYS, @DAYS, @DAYS360, @DAYSINMONTH, @DAYSINYEAR,
@WEEKS, @WEEKSINYEAR, @WEEKNUM, @WEEKNUM_ADD, @MONTHS, @YEARS, @ISLEAPYEAR,
@EASTERSUNDAY, @YEARFRAC, @AMORDEGRC, @AMORLINC, @DB, @DDB, @SLN, @SYD, @VDB,
@CUMIPMT, @CUMIPMT_ADD, @CUMPRINC, @CUMPRINC_ADD, @FV, @FVSCHEDULE, @IPMT,
@IRR, @ISPMT, @MIRR, @NPER, @NPV, @PMT, @PPMT, @PV, @RATE, @RRI, @XIRR, @XNPV,
@ACCRINT, @ACCRINTM, @DISC, @DURATION, @DURATION_ADD, @EFFECTIVE, @EFFECT_ADD,
@INTRATE, @MDURATION, @NOMINAL, @NOMINAL_ADD, @ODDFPRICE, @ODDFYIELD,
@ODDLPRICE, @ODDLYIELD, @PRICE, @PRICEDISC, @PRICEMAT, @RECEIVED, @TBILLEQ,
@TBILLPRICE, @TBILLYIELD, @YIELD, @YIELDDISC, @YIELDMAT, @COUPDAYBS, @COUPDAYS,
@COUPDAYSNC, @COUPNCD, @COUPNUM, @COUPPCD, @DOLLARDE, @DOLLARFR, @CELL,
@CURRENT, @FORMULA, @ISBLANK, @ISERR, @ISERROR, @ISEVEN, @ISEVEN_ADD,
@ISFORMULA, @ISLOGICAL, @ISNA, @ISNONTEXT, @ISNUMBER, @ISODD, @ISODD_ADD,
@ISREF, @ISTEXT, @N, @NA, @TYPE, @AND, @FALSE, @IF, @NOT, @OR, @TRUE, @XOR,
@COS, @SIN, @TAN, @COT, @ACOS, @ACOT, @ASIN, @ATAN, @ATAN2, @DEGREES, @RADIANS,
@PI, @COSH, @SINH, @TANH, @COTH, @ACOSH, @ACOTH, @ASINH, @ATANH, @CSC, @CSCH,
@SEC, @SECH, @TRUNC, @ROUND, @ROUNDDOWN, @ROUNDUP, @CEILING, @FLOOR, @EVEN,
@ODD, @MROUND, @INT, @QUOTIENT, @MOD, @EXP, @POWER, @LOG, @LN, @LOG10, @ABS,
@COMBIN, @COMBINA, @CONVERT, @CONVERT_ADD, @COUNTBLANK, @COUNTIF, @DELTA, @ERF,
@ERFC, @FACT, @FACTDOUBLE, @GCD, @GCD_ADD, @GESTEP, @ISEVEN, @ISODD, @LCM,
@LCM_ADD, @MULTINOMIAL, @PRODUCT, @RAND, @RANDBETWEEN, @SERIESSUM, @SIGN,
@SQRT, @SQRTPI, @SUBTOTAL, @SUM, @SUMIF, @SUMSQ
@BESSELI, @BESSELJ, @BESSELK, @BESSELY, @BIN2DEC, @BIN2HEX, @BIN2OCT, @DEC2BIN,
@DEC2HEX, @DEC2OCT, @HEX2BIN, @HEX2DEC, @HEX2OCT, @OCT2BIN, @OCT2DEC, @OCT2HEX,
@ARABIC, @BAHTTEXT, @DECIMAL, @ROMAN, @ADDRESS, @CHOOSE, @HLOOKUP, @INDEX,
@INDIRECT, @LOOKUP, @MATCH, @OFFSET, @VLOOKUP
@AREAS, @COLUMN, @COLUMNS, @ERRORTYPE, @INFO, @ROW, @ROWS, @SHEET, @SHEETS,
@DDE, @HYPERLINK, @STYLE, @AVEDEV, @AVERAGE, @AVERAGEA, @COUNT, @COUNTA,
@GEOMEAN, @HARMEAN, @MEDIAN, @MODE, @TRIMMEAN, @DEVSQ, @KURT, @SKEW, @STDEV,
@STDEVA, @STDEVP, @STDEVPA, @VAR, @VARA, @VARP, @VARPA
@B, @BETADIST, @BETAINV, @BINOMDIST, @CHIDIST, @CHISQDIST, @CHIINV, @CHISQINV,
@CHITEST, @CONFIDENCE, @CRITBINOM, @EXPONDIST, @FINV, @FISHER, @FISHERINV,
@FDIST, @FTEST, @GAMMA, @GAMMAINV, @GAMMALN, @GAMMADIST, @GAUSS, @HYPGEOMDIST,
@LOGINV, @LOGNORMDIST, @NEGBINOMDIST, @NORMINV, @NORMDIST, @NORMSINV,
@NORMSDIST, @PERMUT, @PERMUTATIONA, @PHI, @POISSON, @PROB, @STANDARDIZE,
@TDIST, @TINV, @TTEST, @WEIBULL, @ZTEST, @CORREL, @COVAR, @FORECAST,
@INTERCEPT, @PEARSON, @RSQ, @SLOPE, @STEYX, @LARGE, @MAX, @MAXA, @MIN, @MINA,
@PERCENTILE, @PERCENTRANK, @QUARTILE, @RANK, @SMALL, @BASE, @CHAR, @CLEAN,
@CODE, @CONCATENATE, @DOLLAR, @EXACT, @FIND, @FIXED, @LEFT, @LEN, @LOWER, @MID,
@PROPER, @REPLACE, @REPT, @RIGHT, @SEARCH, @SUBSTITUTE, @T, @TEXT, @TRIM,
@UPPER, @VALUE
2. All Calc functions are called with the @ or = now.
Reproducible: Always
User Profile Reset: No
Additional Info:
references:
-
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_alphabetically
--
You are receiving this mail because:
You are the assignee for the bug.
