[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Formulas: "," and ";" as function parameter separators
I'm trying to unify the various formula formats (text:formula, text:condition, table:formula, draw:formula, and anim:formula) into a single format. For the most part this is really easy, they're _almost_ the same. But I've immediately noticed one inconsistency: function parameter separators. Both draw:formula and anim:formula use comma (",") as the separator. On the other hand, OOo's table:formula internally uses semicolon (";") as the function separator. Semicolon has the advantage of working regardless of locale, but comma is the more traditional parameter separator. There are at least 3 options for unifying these: * Change the OpenDocument specification to use ";" as function param separators everywhere (e.g., change draw:formula and anim:formula). * Having the unified formula syntax accept both. This means nothing needs to be changed now in the spec. This also means that the text-as-displayed may be different in many locales from what's sent, which might be confusing and does add a burden to simple implementations. Consistency wouldn't be required in data, since both characters would work, and that might be a problem. This approach means that numbers MUST be sent using locale "C" (something that happens anyway, but that is an unfortunate side-effect). * Require everyone use "," as the function parameter separator. This would require changing OpenOffice's reading of spreadsheets, etc., to accept this. Thoughts? Anyone have a preference? If this could be worked out, I think we end up eliminating a bunch of different formula formats & winnowing it down to one main one. The notion of switching to ";" everywhere is appealing to me, and if not that, switching to "," everywhere. --- David A. Wheeler
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]