On Saturday 25 March 2006 15:11, Paul Wright wrote: > Thanks to Johnny Anderson and Joe Conner. I thought that there was a cut > and paste solution but could not remember it. and, now I know how to > prevent the fraction problem. But I am still stonkered as to the design. > What kind of logic would do rounding on the denominator of a fraction?
The logic that says that each cell has a value which is kept internally in a manner that is independent of the formatting for the user. When the user selects fraction formatting, they can say how many places are required in the denominator and the result is then displayed with the best rational approximation using no more than the precision specified. The cell could later be re-formatted to a real number, but the actual value of the cell will remain unchanged. -- Andy Pepperdine On this mailing list help is provided by volunteers. Please subscribe to the mailing list to see all the replies to a query, and reply only to the mailing list at [EMAIL PROTECTED] For FAQ, userguide, see: http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
