Hi M., On Wed, Jun 08, 2005 at 18:30:02 +0200, M. Fioretti wrote:
> (the ">" quoted text is mine, the unquoted answers are from KOffice > programmer) > > > You are absolutely right, sorry, I had not realized this: may I ask > > again the same questions about _this_ issue: > > > > Where is this documented? Examples? Specs? > > Last time I checked OASIS does not specify standard formula names yet. I doubt that OASIS would ever do, as the OpenDocument file format is about structure and how to represent content, not about content itself. Note that the actual formula text is written using its own namespace, like, for example, table:formula="oooc:=[$Sheet1.$A$1]" > Note 1: Excel allows localized function name, e.g. SUM in German version > becomes SUMME. This must be investigated as well for translation purpose > (otherwise the translation might not be sync with Excel version in that > particular language). IMHO this is minor issue and can be tackled later on. Calc stores only English function names in its file format, which in general are identical to those found in an English Excel version. Localized function names are only displayed in the UI. There are a few functions that don't have equivalents in Excel, of course also for those the English function names are used. > Note 2: Some functions are defined as "add in", Excel needs external > module to run this function. Even though there are 3rd party add-in > modules, I think we can first concentrate on standard/builtin add-in > provided by Microsoft Office (e.g. Analysis Toolpak). Also for the Analysis AddIn Calc stores the English function names. The same for any other AddIn. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
