To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105726 Issue #|105726 Summary|multiplier in cell formatting for generating own forma |ts Component|Spreadsheet Version|current Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|spooch
------- Additional comments from [email protected] Thu Oct 8 12:19:07 +0000 2009 ------- The only ability to change a displayed number depending on its format is the "%" (*100). If we have the abilitynonav/scdocs/ddIssues_EnterModify.html#issue_type to multiply a number in the format definition, so as first impression would it be possible to generate promille (0/00), ie 0,025 with the formatting string ###*1000 "0/00" gets 250 0/00 (‰). So we could eliminate the generic %-Format as obsolete, too. Furthermore it would be possible converting a number seen as cm to inch, or, additionally adding very old (medieval times) formats like elle, pound or special british formats like "pint" :-) A simple case of use could be the different display of length in meters (>1m) and centimeters (<1m) --------------------------------------------------------------------- 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]
