[prev in list] [next in list] [prev in thread] [next in thread]
List: koffice-devel
Subject: Re: Please help expand OpenDocument to fully specify formulas -
From: Casper Boemann <cbr () boemann ! dk>
Date: 2005-10-16 16:52:34
Message-ID: 200510161852.34931.cbr () boemann ! dk
[Download RAW message or body]
On Sunday 16 October 2005 18:40, Inge Wallin wrote:
> On Sunday 16 October 2005 17.30, Boudewijn Rempt wrote:
> > On Sunday 16 October 2005 03:35, David A. Wheeler wrote:
> > > http://lists.sourceforge.net/lists/listinfo/openformula-discuss
> >
> > I think KOffice really should pick up on this. I've subscribed to the
> > mailing list, but I'm not a spreadsheet guru. Ariya? Tomas? You're the
> > guru's here :-).
>
> If we want real interoperability, this is one of the most important things
> for KOffice right now.
The attached file lists the functions in kspread as of today. I'll convert it
into a spreadsheet and start the comparison to excel.
After ten functions or so I'll post it, so comments can be made and OOo and
gnumeric folks can start to do their part.
I don't promise to do everything, but lets get the ball rolling.
--
best regards / venlig hilsen
Casper Boemann
["kspreadfuncs" (text/x-objcsrc)]
ARABIC", func_arabic);
CARX", func_carx);
CARY", func_cary);
DECSEX", func_decsex);
POLR", func_polr);
POLA", func_pola);
ROMAN", func_roman);
SEXDEC", func_sexdec);
ASCIITOCHAR", func_AsciiToChar);
CHARTOASCII", func_CharToAscii);
BOOL2INT", func_booltoint);
INT2BOOL", func_inttobool);
BOOL2STRING", func_ToString);
NUM2STRING", func_ToString);
STRING", func_ToString);
DAVERAGE", func_daverage);
DCOUNT", func_dcount);
DCOUNTA", func_dcounta);
DGET", func_dget);
DMAX", func_dmax);
DMIN", func_dmin);
DPRODUCT", func_dproduct);
DSTDEV", func_dstdev);
DSTDEVP", func_dstdevp);
DSUM", func_dsum);
DVAR", func_dvar);
DVARP", func_dvarp);
GETPIVOTDATA", func_getpivotdata); // partially Excel-compatible
CURRENTDATE", func_currentDate);
CURRENTDATETIME", func_currentDateTime);
CURRENTTIME", func_currentTime);
DATE", func_date);
DATEVALUE", func_datevalue);
DAY", func_day);
DAYNAME", func_dayname);
DAYOFYEAR", func_dayOfYear);
DAYS", func_days);
DAYS360", func_days360);
DAYSINMONTH", func_daysInMonth);
DAYSINYEAR", func_daysInYear);
EASTERSUNDAY", func_easterSunday);
EDATE", func_edate);
EOMONTH", func_eomonth);
HOUR", func_hour);
HOURS", func_hour); // same as HOUR
ISLEAPYEAR", func_isLeapYear);
ISOWEEKNUM", func_isoWeekNum);
MINUTE", func_minute);
MINUTES", func_minute); // same as MINUTE
MONTH", func_month);
MONTHNAME", func_monthname);
MONTHS", func_months);
NOW", func_currentDateTime);
SECOND", func_second);
SECONDS", func_second); // same as SECOND
TIME", func_time);
TIMEVALUE", func_timevalue);
TODAY", func_currentDate);
WEEKDAY", func_weekday);
WEEKS", func_weeks);
WEEKSINYEAR", func_weeksInYear);
YEAR", func_year);
YEARS", func_years);
BASE", func_base); // KSpread-specific, like in Quattro-Pro
BESSELI", func_besseli);
BESSELJ", func_besselj);
BESSELK", func_besselk);
BESSELY", func_bessely);
BIN2DEC", func_bin2dec);
BIN2OCT", func_bin2oct);
BIN2HEX", func_bin2hex);
COMPLEX", func_complex);
CONVERT", func_convert);
DEC2HEX", func_dec2hex);
DEC2BIN", func_dec2bin);
DEC2OCT", func_dec2oct);
DELTA", func_delta);
ERF", func_erf);
ERFC", func_erfc);
GESTEP", func_gestep);
HEX2BIN", func_hex2bin);
HEX2DEC", func_hex2dec);
HEX2OCT", func_hex2oct);
IMABS", func_imabs);
IMAGINARY", func_complex_imag);
IMARGUMENT", func_imargument);
IMCONJUGATE", func_imconjugate);
IMCOS", func_imcos);
IMDIV", func_imdiv);
IMEXP", func_imexp);
IMLN", func_imln);
IMPOWER", func_impower);
IMPRODUCT", func_improduct);
IMREAL", func_complex_real);
IMSIN", func_imsin);
IMSQRT", func_imsqrt);
IMSUB", func_imsub);
IMSUM", func_imsum);
OCT2BIN", func_oct2bin);
OCT2DEC", func_oct2dec);
OCT2HEX", func_oct2hex);
ACCRINT", func_accrint);
ACCRINTM", func_accrintm);
COMPOUND", func_compound);
CONTINUOUS", func_continuous);
COUPNUM", func_coupnum);
DB", func_db);
DDB", func_ddb);
DISC", func_disc);
DOLLARDE", func_dollarde);
DOLLARFR", func_dollarfr);
DURATION", func_duration);
EFFECT", func_effective);
EFFECTIVE", func_effective);
EURO", func_euro); // KSpread-specific, Gnumeric-compatible
FV", func_fv);
FV_ANNUITY", func_fv_annuity);
INTRATE", func_intrate);
IPMT", func_ipmt);
ISPMT", func_ispmt);
LEVEL_COUPON", func_level_coupon);
NOMINAL", func_nominal);
NPER", func_nper);
PMT", func_pmt);
PPMT", func_ppmt);
PV", func_pv);
PV_ANNUITY", func_pv_annuity);
RECEIVED", func_received);
SLN", func_sln);
SYD", func_syd);
TBILLEQ", func_tbilleq);
TBILLPRICE", func_tbillprice);
TBILLYIELD", func_tbillyield);
ZERO_COUPON", func_zero_coupon);
FILENAME", func_filename);
INFO", func_info);
ISBLANK", func_isblank);
ISDATE", func_isdate);
ISEVEN", func_iseven);
ISLOGICAL", func_islogical);
ISNONTEXT", func_isnottext);
ISNOTTEXT", func_isnottext);
ISNUM", func_isnum);
ISNUMBER", func_isnum);
ISODD", func_isodd);
ISREF", func_isref);
ISTEXT", func_istext);
ISTIME", func_istime);
N", func_n);
TYPE", func_type);
FALSE", func_false);
TRUE", func_true);
NOT", func_not);
AND", func_and);
NAND", func_nand);
NOR", func_nor);
OR", func_or);
XOR", func_xor);
IF", func_if);
MULTIPLEOPERATIONS", func_multipleOP);
ABS", func_abs);
CEIL", func_ceil);
CEILING", func_ceiling);
CUR", func_cur);
EPS", func_eps);
EVEN", func_even);
EXP", func_exp);
FACT", func_fact);
FACTDOUBLE", func_factdouble);
FIB", func_fib); // KSpread-specific, like Quattro-Pro's FIB
FLOOR", func_floor);
INT", func_int);
INV", func_inv);
LN", func_ln);
LOG", func_log10);
LOG2", func_log2);
LOG10", func_log10); // same as LOG
LOGN", func_logn);
MOD", func_mod);
MROUND", func_mround);
MULTINOMIAL", func_multinomial);
ODD", func_odd);
POW", func_pow);
POWER", func_pow);
QUOTIENT", func_quotient);
RAND", func_rand);
RANDBERNOULLI", func_randbernoulli);
RANDBETWEEN", func_randbetween);
RANDBINOM", func_randbinom);
RANDEXP", func_randexp);
RANDNEGBINOM", func_randnegbinom);
RANDNORM", func_randnorm);
RANDPOISSON", func_randpoisson);
ROOTN", func_rootn);
ROUND", func_round);
ROUNDDOWN", func_rounddown);
ROUNDUP", func_roundup);
SIGN", func_sign);
SQRT", func_sqrt);
SQRTPI", func_sqrtpi);
TRUNC", func_trunc);
COUNT", func_count);
COUNTA", func_counta);
COUNTBLANK", func_countblank);
COUNTIF", func_countif);
DIV", func_div);
G_PRODUCT", func_kproduct); // Gnumeric compatibility
GCD", func_gcd);
KPRODUCT", func_kproduct);
LCM", func_lcm);
MAX", func_max);
MAXA", func_maxa);
MDETERM", func_mdeterm);
MIN", func_min);
MINA", func_mina);
MMULT", func_mmult);
MULTIPLY", func_product); // same as PRODUCT
PRODUCT", func_product);
SUM", func_sum);
SUMA", func_suma);
SUBTOTAL", func_subtotal);
SUMIF", func_sumif);
SUMSQ", func_sumsq);
ADDRESS", func_address);
AREAS", func_areas);
CHOOSE", func_choose);
COLUMN", func_column);
COLUMNS", func_columns);
INDEX", func_index);
INDIRECT", func_indirect);
LOOKUP", func_lookup);
ROW", func_row);
ROWS", func_rows);
AVEDEV", func_avedev);
AVERAGE", func_average);
AVERAGEA", func_averagea);
BETADIST", func_betadist);
BINO", func_bino);
CHIDIST", func_chidist);
COMBIN", func_combin);
CONFIDENCE", func_confidence);
CORREL", func_correl_pop);
COVAR", func_covar);
DEVSQ", func_devsq);
DEVSQA", func_devsqa);
EXPONDIST", func_expondist);
FDIST", func_fdist);
FISHER", func_fisher);
FISHERINV", func_fisherinv);
GAMMADIST", func_gammadist);
GAMMALN", func_gammaln);
GAUSS", func_gauss);
GEOMEAN", func_geomean);
HARMEAN", func_harmean);
HYPGEOMDIST", func_hypgeomdist);
INVBINO", func_bino); // same as BINO, for 1.4 compat
KURT", func_kurtosis_est);
KURTP", func_kurtosis_pop);
LARGE", func_large);
LOGINV", func_loginv);
LOGNORMDIST", func_lognormdist);
MEDIAN", func_median);
MODE", func_mode);
NEGBINOMDIST", func_negbinomdist);
NORMDIST", func_normdist);
NORMINV", func_norminv);
NORMSDIST", func_stdnormdist);
NORMSINV", func_normsinv);
PEARSON", func_correl_pop);
PERMUT", func_arrang);
PHI", func_phi);
POISSON", func_poisson);
SKEW", func_skew_est);
SKEWP", func_skew_pop);
SMALL", func_small);
STANDARDIZE", func_standardize);
STDEV", func_stddev);
STDEVA", func_stddeva);
STDEVP", func_stddevp);
STDEVPA", func_stddevpa);
SUM2XMY", func_sumxmy2);
SUMPRODUCT", func_sumproduct);
SUMX2PY2", func_sumx2py2);
SUMX2MY2", func_sumx2my2);
TDIST", func_tdist);
VARIANCE", func_variance);
VAR", func_variance);
VARP", func_variancep);
VARA", func_variancea);
VARPA", func_variancepa);
WEIBULL", func_weibull);
CHAR", func_char);
CLEAN", func_clean);
CODE", func_code);
LEN", func_len);
LOWER", func_lower);
PROPER", func_proper);
ROT", func_rot);
SLEEK", func_sleek);
T", func_t);
TOGGLE", func_toggle);
TRIM", func_trim);
UPPER", func_upper);
VALUE", func_value);
COMPARE", func_compare);
CONCATENATE", func_concatenate);
DOLLAR", func_dollar);
EXACT", func_exact);
FIND", func_find);
FIXED", func_fixed);
LEFT", func_left);
MID", func_mid);
REGEXP", func_regexp);
REGEXPRE", func_regexpre);
REPLACE", func_replace);
REPT", func_rept);
RIGHT", func_right);
SEARCH", func_search);
SUBSTITUTE", func_substitute);
TEXT", func_text);
ACOS", func_acos);
ACOSH", func_acosh);
ACOT", func_acot);
ASIN", func_asin);
ASINH", func_asinh);
ATAN", func_atan);
ATAN2", func_atan2);
ATANH", func_atanh);
COS", func_cos);
COSH", func_cosh);
DEGREES",func_degrees);
RADIANS",func_radians);
SIN", func_sin);
SINH", func_sinh);
TAN", func_tan);
TANH", func_tanh);
PI", func_pi);
_______________________________________________
koffice-devel mailing list
koffice-devel@kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic