--Boundary-00=_SVoUDlS9KrlIOzt
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

--Boundary-00=_SVoUDlS9KrlIOzt
Content-Type: text/x-objcsrc;
  charset="iso-8859-1";
  name="kspreadfuncs"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="kspreadfuncs"

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);
--Boundary-00=_SVoUDlS9KrlIOzt
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
koffice-devel mailing list
koffice-devel@kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel

--Boundary-00=_SVoUDlS9KrlIOzt--