Oliver Brinzing schrieb:
Hi,just recieved an excel file with a formula like this: =DATUM($G$1;MONAT(A$3);((ZELLE("ZEILE";A4))-3)) OO displays Err:502, cause the argument "Zeile" should be "row" ... is it possible to fix the import or localize the arguments ?
Instead of using ZELLE("ZEILE";A4) one could use ZEILE(A4). That works in Calc and Excel.
There will always be problems with these dumb localized arguments and other stuff (e.g. add-in function names) in Excel. An English Excel does not understand the German function names as well and shows an error, while all localized Excel versions understand the English names. It has been decided that OOo only supports the English names. Of course one could think about extending this, but that would be a lot of effort for low benefit...
Daniel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
