Joe Fall wrote:
I had a problem with the rate() function in a spreadsheet that I
originally designed in Excel but am now using in OpenOffice Calc
(version 2.1). The Excel syntax is
"rate(nper,pmt,pv,[fv],[type],[guess])". If you omit the pmt value in
Excel (e.g. "rate(12,,-254,328)"), Excel will assume the pmt is zero and
calculate the rate. When opened in Calc, the resulting formula is
"rate(12;;-254;328)" which results in "Err:511". A global search &
replace that searches for ";;" and replaces it with ";0;" will fix the
formula, but it would be nice if Calc automatically converted the
formula, replacing missing variables with a zero.
It is not simply replacing all missing parameters with zero, Excel
defines various different default values for all functions. There is
already work in progress to fix this, please see issue
http://qa.openoffice.org/issues/show_bug.cgi?id=3879
especially the attached document that shows the different default values
for the sheet functions.
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
