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
Excel has the callsign to call the function with @ and =, why can't Calc have @ and = to indicate functions too?
Created attachment 178766 [details] An illustrative photo of the feature that can be implemented if you find it interesting - UI/UX An illustrative photo of the feature that can be implemented if you find it interesting(feature name: you can indicate @ to call functions in LibreOffice Calc), illustrative photo(ui/ux - user interface/user experience)
Created attachment 178767 [details] 2 ui-ux use case 1. Here illustrates the steps I reported 2. As you can see the image when I put @ I can select the functions I need
1. The @ symbol does not replace the = symbol for functions. 2. The @ symbol or the = symbol are used to call functions. 3. Add the @ symbol as excel provides this same option to indicate functions. It would be a great user experience to have this in the calc. 4. This bug I report is a feature request.
This idea, this bug is related to this other bug, idea: https://bugs.documentfoundation.org/show_bug.cgi?id=142214
the @ symbol serves to autocomplete functions
### about Luckysheet allows you to insert the = symbol on any line to call the function. In the example, here I request that it would be both = and @. #### reference https://github.com/mengshukeji/Luckysheet ### img https://i.ibb.co/B4MQvMy/demo.png
Created attachment 179121 [details] Luckysheet_demo_request
#### notes I'm not promoting Luckysheet. I'm just quoting Luckysheet which has the features I would find interesting if LibreOffice had.
What makes the at sign so special for you? The equal sign is quite common (except one example) and @ usually refers to a function and apparently a "defined name" in Excel.
The need is unclear, resolving for now. Feel free to reopen with a more elaborated explanation why equal needs to be variable.