To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930
------- Additional comments from [email protected] Thu Oct 21 06:48:21 +0000 2010 ------- I think you're over-complicating the issue. Reverting the string back to a number is not part of the formatting. Since nowhere does any of the format functions need to do this. The number is stored internally as a number, not a string - it's simply displayed as a formatted string. Other calculations are done on the number, not the string. The conversion back from a formatted string becomes irrelevant if we can get the formatting to work properly. It may become a separate issue which could (and should) be handled by a custom formula (as it is already). This may be useful in situations where data is read in from a text file or such. So please open another issue for this, so it can be fine-tuned on its own and maybe added as a built-in formula. About the SI and Eng being 2 separate issues, technically that is correct. Practically, there's no difference. If the formatting can be made to work with Eng, it would be a near instantaneous modification to generate the same thing for SI. In both cases most of the hard-work is already done. All that needs to happen is choosing the most efficient (and least re-write prone) algorithm of those already available, then incorporating it into the formatting functions as a patch to OOo - since an add-on is impossible for this. The last bit is where I'm struggling, the documentation is extremely confusing (at least to me) and there's no such examples (only examples of setting "custom" formats which are already available in the format dialog - not creating a new formatting type). If I can figure this out, or get someone to show me how / an example I'd be willing to fix it in my "free" time. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
