To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101621 Issue #|101621 Summary|convert_add missing/misleading conversions Component|Spreadsheet Version|1.0.0 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|peterroots
------- Additional comments from [email protected] Thu May 7 06:29:19 +0000 2009 ------- I have been looking at the convert_add function in calc. It has conversions for gallons, pints, fluid ounces, quarts and bushels which are all the US variants of these units. There is no mention in the help files that US gallons, for example, are what the 'gal' term refers to in the formula. There is no way of using convert_add to convert imperial units to anything else. This seems a sad lack and is also misleading as people trying to use the function are not warned that they are getting results from US units Also rather confusingly the help files imply that convert rather than convert_add should yield conversions based on ISO standards rather than excel. This is not the case as convert is for currency conversion. --------------------------------------------------------------------- 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]
